Error in the phase IMPORT_PROPER while applying support packages

[Former Member]

Dear All,

I am on ECC 6.0(ABAP+JAVA) SR2, SUSE Linux 10 SP1, DB2.

I have successfully applied the kernel patch and started applying the support packages, i have successfully completed applying the ABAP, Basis, BW, HR and other related patches, but i am not sure why i am stuck at the import_proper phase when applying the SAP_APPL patches (SAPKH60008 and SAPKH60009 both in the same queue) and my tp log is as follows

========================================================================================================

START imp all SCD 20081229080538 DDIC sealcpro 20081229080537

INFO: event SAP_IMPORT_START triggered successfully

INFO TBATG CONVERSION OF SCD N not needed DDIC sealcpro 20081229080537

START tp_getprots SCD P 20081229080539 DDIC sealcpro 20081229080537

2EETP000 sap_dext called with msgnr "1":

2EETP000 db call info

2EETP000 function: db_setget

2EETP000 fcode: RT_SETB (65535)

2EETP000 tabname: TRBAT

2EETP000 len (char): 0

2EETP000 key:

2EETP000 retcode: 1

1AETP000 exit in function texitnow

ERROR: EXIT(16) -> process ID is: 5319

STOP imp all SCD 0016 20081229080602 DDIC sealcpro 20081229080537

=========================================================================================================

And also when i look at the Support package import logs they show that

TEST IMPORT

Import ABAP Dictionary Objects and

ABAP Dictionary Activation phases ended with return code 4

But i dont think this can give any problem.

I have tried to import from the phase where it stopped, but all of a sudden i get disconnected from SAP and get an error message saying that NO CONNECTION TO THE DATABASE, then when i check for the processes for dw and db2 there are process already running.

I had to start SAP and only then i was able to connect to the SERVER again.

Can you please help me on this..

For any more information plz let me know

Thanks and regards

Hunky

[hemanth2]

HI,

As this is a tp command, you do not need to put "./" or "sh" before it.

Yours will be this:

tp R3I SAPKH60008 SCD pf=<path of your tp profile> -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8 -Dsourcesystems= tag=SPAM

Before this do a "check tp tool" from STMS.

regards,

hemanth

[Former Member]

Dear Hemanth,

Thank you very much for your reply,

I have tried resetting the queue using SE37 but it is not possible to reset the queue in the import_proper phase, so i tried using your last suggestion by running the below command

./tp SCD pf=/usr/sap/trans/bin/TP_DOMAIN_SCD.PFL -Dclientcascade=yes -Dstoperror=8 -Drepeatonerror=8 -Dsourcesystem=SCD tag=SPAM

But this is giving me the below error..

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0205

tp finished with return code: 205

meaning:

parameter %s is unknown

I am sure i am typing the wrong command, can you plz suggest me, my SID = SCD.

And my few other observations are that after deleting the import request from the STMS_IMPORT queue i am not able to start the import from the SPAM and the following is the error that i am getting

Command : TMS_MGR_READ_TP_SYSLOG

Service: Transport Service

Function: TMS_TP_READ_LOGFILE

Message OPEN_FAILED

Could not open log file /usr/sap/trans/log/SLOG0901.SCD

When i check this at the OS level i dont see the SLOG in that location, and what do i do now.. please suggest

I am sure i will award the points

Thanks in advance

Awaiting for your replies

Regards

Hunky

[hemanth2]

Hi,

I guess thereason for the error is that some changes have been made to the ABAP repository and when SPAM is triggered, the dump occurs again. There is nothing much to do here.

Try this:

1) resetting SPAM status-> SE37->SPAM_RESET_STATUS

IV_FORCE=X

IV_TOOL=SPAM

IV_WITH_POPUP=X

If still issue persists:

2) delete the entries from /usr/sap/trans/EPS/in and then reload the files again from front end.

3) If still issue persists: (This should be used as the last resort-if restore is the only other option)

Run the below command

tp R3I <name of the Sc> <SID> pf=/usr/sap/trans70/bin/TP_DOMAIN_70.PFL -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8 -Dsourcesystems= tag=SPAM

Regards,

hemanth

[Former Member]

Dear Balaji,

Thank you very much for the reply...

I deleted the import request in the STMS and wi ran the RDDIMPDP and RDDMNTAB reports and restart the SPAM, but this time the SPAM immediately stopped, but i am still connected to the system and the error which i got earlier (database connection error ) is now not occuring.

But otherwise also i noticed that i get the following ABAP Dump while this error is triggering

===================================================================

DBIF_REPO_INTERNAL_ERROR

Internal error when accessing program "CX_SY_OPEN_SQL_DB=============CP ".

An unspecified internal error occurred in the SAP-internal

database interface.

For further analysis the SAP system log should be examined

(transaction SM21).

Check the entries in the developer trace of the relevant work process

(transaction ST11).

Attempted to access component "LOAD" of program

"CX_SY_OPEN_SQL_DB=============CP ".

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_REPO_INTERNAL_ERROR" " "

"SAPLSTPA" or " "

==========================================================================

Based on this error i searched few notes and got the below results 309583 and 132383 but these are not for my release.

So i request you to kindly help me on this as i am running out of time in delivering my server.

Waiting for all the valuble replies

Thank you in advance

Regards

Hunky

[Former Member]

Hi,

Please delete the Import in the STMS, and execute the necessary reports and restart the SPAM