Wednesday, July 27, 2011

Support Pack implementation in Dialog Mode

SP implementation in Dialog Mode will never time out. It doesn't depend upon the parameter rdisp/max_wprun_time.Even if it runs for 15 hours or more continuously.

start JSPM with changed EPS location

You may start JSPM with different EPS/in directory than default. There are two methods

1. You may set the parameter DIR_EPS_ROOT in DEFAULT.PFL and point the same to the directory you want.

2. You may start the JSPM with parameter :

./go '-config=/JSPM/inbox=/usr/sap/trans_rep/SPR7/P3'

The JSPM session will start with the current parameter only. It will point to the path given in above parameter and will upload the patches from the same path.

Sunday, July 10, 2011

R3trans used for System Refresh activity

R3tans command can be very handy for System Refresh as we can take export of tables relevant to RFCs, Partner profiles, tRFC ports and distribution models :

command for export

R3trans -w exp.log AE1_export.ctl

example of AE1_export.ctl


export
client=100
file='expAE1100_tables.dmp'
select * from edipoa
select * from edipod
select * from ediport
select * from edp12
select * from edp13
select * from edp21
select * from edpp1
select * from filename
select * from filetext
select * from kcdrm
select * from kcdrs
select * from kcdsm
select * from t462a
select * from tbd00
select * from tbd00t
select * from tbd05
select * from tbd06
select * from tbd30
select * from tbda2
select * from tbdlt
select * from tede2
select * from vari
select * from varid
select * from varit
select * from TBLSYSDEST
select * from TVARVC
select * from CIF_IMOD
select * from TBLSYSDEST
select * from EDPPV
select * from EDPVW
select * from TBDBR
select * from TBDBRF
select * from edpar
select * from edpi1
select * from edmat
select * from edmms
select * from edpo1
select * from edpo3
select * from ediphone
select * from EDPST
select * from EDIPO2
select * from EDIPOACODPAG
select * from EDIPOF
select * from EDIPOI
select * from EDIPOX
select * from EDIPOXH
select * from EDIPOXU

export
file='expAE1_tables.dmp'
select * from crep
select * from crep_http
select * from crepdescr
select * from dbsnp
select * from devaccess
select * from e070l
select * from edbas
select * from edbast
select * from edcim
select * from edcimt
select * from edimsg
select * from edimsgt
select * from edma
select * from edmsg
select * from edview
select * from edviewt
select * from filenameci
select * from filetextci
select * from moni
select * from ndisystems
select * from osmon
select * from pahi
select * from prgn_cust
select * from rslogsysmap
select * from rzllitab
select * from ssf_pse_h
select * from ssf_pse_d
select * from t000
select * from t002
select * from t002t
select * from tbdls
select * from tbdlst
select * from tdevc
select * from tedst
select * from tedtt
select * from toaar
select * from tpfet
select * from tpfht
select * from edipo
select * from crep_rfc
select * from btcomset
select * from STRUSTCERT
select * from STRUSTSSL
select * from STRUSTSSLT
select * from tmsqlastwl
select * from tmsqnotes
select * from tmsqwl
select * from tmsqwlf
select * from HTTPURLLOC
select * from rspor_t_portal 
select * from EDPO_QUEUE



export
file='expAE1RFC_tables.dmp'
select * from RFC2SOAPS
select * from RFCADPTATTR
select * from RFCADPTRCVLOG
select * from RFCADPTSNDLOG
select * from RFCATTRIB
select * from RFCCHECK
select * from RFCCMC
select * from RFCDES
select * from RFCDESSECU
select * from RFCGO
select * from RFCLIST
select * from RFCSTXTAB
select * from RFCSYSACL
select * from RFCTRUST
select * from RFCTSTLOG
select * from RFCTSTTAB
select * from RFCTYPE
select * from RFCTA
select * from RFCDOC


After system refresh, we need to import the above exported tables. While importing we need to reverse the process :

command

R3trans -w imp.log AE1_import.ctl


example of AE1_import.ctl

remove
client=100
select * from edipoa
select * from edipod
select * from ediport
select * from edp12
select * from edp13
select * from edp21
select * from edpp1
select * from filename
select * from filetext
select * from kcdrm
select * from kcdrs
select * from kcdsm
select * from t462a
select * from tbd00
select * from tbd00t
select * from tbd05
select * from tbd06
select * from tbd30
select * from tbda2
select * from tbdlt
select * from tede2
select * from vari
select * from varid
select * from varit
select * from TBLSYSDEST
select * from TVARVC
select * from CIF_IMOD
select * from TBLSYSDEST
select * from EDPPV
select * from EDPVW
select * from TBDBR
select * from TBDBRF
select * from edpar
select * from edpi1
select * from edmat
select * from edmms
select * from edpo1
select * from edpo3
select * from ediphone
select * from EDPST
select * from EDIPO2
select * from EDIPOACODPAG
select * from EDIPOF
select * from EDIPOI
select * from EDIPOX
select * from EDIPOXH
select * from EDIPOXU

import
client=100
file='expAE1100_tables.dmp'

remove
select * from crep
select * from crep_http
select * from crepdescr
select * from dbsnp
select * from devaccess
select * from e070l
select * from edbas
select * from edbast
select * from edcim
select * from edcimt
select * from edimsg
select * from edimsgt
select * from edma
select * from edmsg
select * from edview
select * from edviewt
select * from filenameci
select * from filetextci
select * from moni
select * from ndisystems
select * from osmon
select * from pahi
select * from prgn_cust
select * from rslogsysmap
select * from rzllitab
select * from ssf_pse_h
select * from ssf_pse_d
select * from t000
select * from t002
select * from t002t
select * from tbdls
select * from tbdlst
select * from tdevc
select * from tedst
select * from tedtt
select * from toaar
select * from tpfet
select * from tpfht
select * from edipo
select * from crep_rfc
select * from btcomset
select * from STRUSTCERT
select * from STRUSTSSL
select * from STRUSTSSLT
select * from tmsqlastwl
select * from tmsqnotes
select * from tmsqwl
select * from tmsqwlf
select * from HTTPURLLOC
select * from rspor_t_portal 
select * from EDPO_QUEUE

import
file='expAE1_tables.dmp'


remove
select * from RFC2SOAPS
select * from RFCADPTATTR
select * from RFCADPTRCVLOG
select * from RFCADPTSNDLOG
select * from RFCATTRIB
select * from RFCCHECK
select * from RFCCMC
select * from RFCDES
select * from RFCDESSECU
select * from RFCGO
select * from RFCLIST
select * from RFCSTXTAB
select * from RFCSYSACL
select * from RFCTRUST
select * from RFCTSTLOG
select * from RFCTSTTAB
select * from RFCTYPE
select * from RFCTA
select * from RFCDOC

import
file='expAE1RFC_tables.dmp'

Table export import with R3trans directly from OS level

For exporting the tables:

command :

R3trans -w exp.log exp.ctl

example of exp.ctl:

export

client = 200

file = '/usr/sap/trans/data/export.dat'

select * from COEP

select * from BSIS
select * from ACCTCR
select * from COEP
select * from BALDAT
select * from MLIT
select * from MLPP
select * from MSEG
select * from MSTA
select * from NAST

select * from ONR0

select * from S033

select * from S700
select * from FAGLFLEXA
select * from CKIS
select * from KEKO




For importing the same table(s)

command :

R3trans -w imp.log imp.ctl

example of imp.ctl file :

import

file = '/usr/sap/trans/data/export.dat'

client = 200

Saturday, July 2, 2011

Problems faced in Language Installation

There are 3 major parts of Language Installation

1) First Import the Language Package in 000 SMLT

2) Import the language part of all old Support packages in 000 client

3) Supplement the language in each client

We majorly faced the problem in step 2, where first we searched the location for all old support packages with

find . | grep "KGPHD*"

command

Secondly, as we were using A port, we started the import of language part of support package and logged off, this happens only in Dialog :) so the R3trans will work as the control is with SMLT import language part of support packages. This is not the case when we import the language "Import package" because it will show that the control has been transferred to R3trans in Action log.

Another issue we faced, there was import issue return code (16) while doing Import of language part of support package SAPK-603DFINSAPAPPL, actually this support package didn't exist in the system, this is a sub support package, we can find this using SE16 table PAT13:

the solution was in below link :

http://forums.sdn.sap.com/thread.jspa?threadID=1881224

quoting the solution:

"please check table PAT13 in SE16; you'll see that these packages are listed in column SEC_NAME. Please refer to the main package that it belongs to on the PATCH column - this is the main package file that you should look for in SAP MarketPlace and unpack in EPS/in. Then you can repeat the process, it'll find the missing Meta-Commandfiles and continue w/o problems.

By the way, please check note #1508122, it might be that you have the incorrect language package installed on your system. This note explain in details how to check and install the correct language package on your system."

Friday, July 1, 2011

Use find command in Unix to find the required files

During language installation, one of the step is "Importing of Language part of support packages after language installation".

It requires all the old support packages to be present in EPS/in (default) directory. But there were many support packages missing. Downloading was not the option as it required approval from Solution Manager and we don't have access for the same.

So, the only option left was to search where is the location of the missing support packages not present in /usr/sap/trans/EPS/in directory. Actually we were looking for CAR files.

The command that came handy was

find . | grep "KGPHD*"

we were in location /usr/sap/trans/EPS and we gave this command

ultimately we were able to locate the missing support packages in directory /usr/sap/trans/EPS/languages_stack_01_17