Error Patch IMPORT_PROPER phase

[Former Member]

Dear support,

We were applying patches on Netweaver 2004s Oracle 10.2.0.2 Windows platform server. Basis patch 12 and it was successfull in Test mode , but during standard mode suddenly machine got restarted because of power problem.

Now database and SAP is up and running , but i am unable to proceed with any of transactions ( like SPAM ) as i get <b>syntax_error</b>. Patch is in IMPORT_PROPER phase so i cannot reset until i do some database work.

What i am just aware i need to check entries in PAT01 , PAT02 , PAT03 and TRBAT tables and delete entries from PAT01 there to reset the queue and run patch again.

I can login to database with user SAPSR3 and there are entries for Basis patch 12 in table PAT01.Can anyone tell me further actions and querry which need to be executed to delete entry in detail , as i am having one week old backup which is not usefull for me.Please let me know safest way out of this issue.

Please help me at earliest.

Best Regards,

AjitR

[Former Member]

Folks,

I have one more doubt , i can see transaction SPAM in IMPORT_POPER phase but unable to carry out Import queue operation suddenly it throws SYNTAX_ERROR

Even if i would be able to delete entries from table at database level how would i continue with SPAM patch application , as it throws SYNTAX_ERROR ?

Please take a note of this problem , looking forward for answers.

[former_member204746]

1. install a UPS on your server to avoid such power disruptions.

2. you took a backup of your system before applying support packs? Consider a restore

3. or open a case with SAP, they wil lrun a few TP commands to put back SPAM status in working order.

it is say too late to play around with PAT** tables, so not delete any entries from it

!

good luck.

[Former Member]

Eric,

But error is still in IMPORT_POPER phase , and i have seen many posts describing the same problem with solution to delete at database.

I will definitely open an OSS call now as per your comments.Should i update them

with all tables data ?

Thanks in advance.

[Former Member]

Hi,

You have deleted the entries in PAT* tables but still error is coming it seems that in the buffer the patch is still there.

Delete the patch from buffer and perform the import again.

To delete it follow the below command at OS level:

Goto -> usr\sap\trans\bin directory.

From here, run the following command,

1. usr\sap\trans\bin > tp pf=TP_DOMAIN_DEV.PFL showbuffer DEV

Then Run the following command too,

2. usr\sap\trans\bin > tp DELFROMBUFFER SAPKE50027 DEV U1 pf=TP_DOMAIN_DEV.PFL tag=spam –DCTC=0

After executing the commands the queue will delete, and you will start import again.

--

Praveen Merugu

[Former Member]

praveen ,

I havent deleted any entry from tables , please find below

SQL> select PATCH,STEPCOND,RET_CODE,MESSAGE from PAT01;

PATCH STE RET_CODE

-

---

--- -

---

MESSAGE

-

---

SAPKB70012 ?

SQL> SELECT * FROM PAT02;

no rows selected

SQL> SELECT COUNT(*) FROM PAT03;

COUNT(*)

-

---

33

SQL> SELECT COUNT(*) FROM PAT10;

COUNT(*)

-

---

1

SQL> SELECT PATCH,STATUS,IMPL_MANDT from PAT10;

PATCH STA IMPL_MAND

-

---

--- -

---

SAPKB70012 R 000

SQL> SELECT RETCODE,CLIENT,ARGUMENT FROM TRBAT;

RETCODE CLIENT ARGUMENT

-

---

-

---

-

---

F

logs are as below

Transport request ; SAPKB70012

SQL error 1089 accessing : ORA-01089 immediate shutdown in progress - no ope

Main import

Ended with Return code 12

could you throw some light on the same.

[Former Member]

As system got hanged i have taken restart of SAP and database.

Now it is showing Import_proper phase.

While logging onto the system , system throws error SYNTAX_ERROR and

below warning 'status LIVE of the user interface SAPLSRABAX_EXC

missing'.Then when we give /nspam we get initial screen and if we try

to Import the queue again

same error is thrown syntax_error.No optin available like Choose EXTRAS

in SPAM initial screen choose SETTINGS and choose IGNORE GENERATION

ERRORS and avoid this error.

[Former Member]

Hi,

Please do not delete the same from the SQL DB level. Delete the queue from SAP level.

Goto SE11>PAT01>Goto Contents

In PATCH Enter your Patch No which you want to delete.

If No.of entries are there.

Delete the same by debugging it. Take help of your ABAPER on how to debug it.

--

Praveen Merugu

[former_member204746]

what you guys are doing is dangerous.

I wish you luck...

[Former Member]

Praveen and Eric,

Solution is something different as below by which i solved problem and patch is successfully applied now.

Please check if you are lack of space or

there was a database problem at that time.

1.Pls make sure that you have NOT made any changes to import

buffer. try to use the command to verify

tp showbuffer <SID> tag=spam pf=<...transport profile>

2. check at OS level to see if there is any tp or R3trans still

running;if yes pls stop them.

3. The TRBAT and TRJOB tables should be empty.

4. Pls issue the following tp command to manully import

tp r3i <request> <SID> pf=<Name incl. Path to the transport profile>

tag=spam -Dclientcascade=yes -Drepeatonerror=8

The return code for this tp call must be 0 or 4. otherwise

pls send back this msg to SAP.

5. At this time you should be able to logon system as normal

and you MUST continue and finish the following steps after the

import in SPAM. check queue and confirm after spam finishes.

I just hope this will help for lot of SDN viewers to get step by step solution to solve

Import_proper stuck error.

Best Regards,

AjitR

[Former Member]

Thanks for all your support.

[former_member204746]

remember what I told you earlier:

1. open a case with SAP, they will run a few TP commands to put back SPAM status in working order.

2. do not play around with PAT** tables

Glad you fixed your problem.

[Former Member]

Eric,

Good to share , that this solution is provided to me by my friend who is in

SAP Malasiya. So not OSS but still from OSS.

Best Regards,

AjitR