Update of SAP_HR SAPKE60050

[Former Member]

Hi,

I have to update SAP_HR from SP Level 0029 to 0050. in ECC6

I have Updated

SAP_Basis from 13 to 18

SAP_ABA 13 to 18

PI_Basis 2005_1_700 15 to 18

SAP_AP 11 to 15

Kernel 700_236

When I am going to import stuck at DISASSEMBLE. phase

Slog

ERROR: RFC function TRINT_PROGRESS_INDICATOR error: SYSTEM_FAILURE

ERROR SAPKH60012

STOP MAIN IMPORT

ERROR: stopping on error 12 during MAIN IMPORT

HALT 20100329215223

ERROR: uncaught internal error: ORA-03114: not connected to ORACLE

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

STOP imp all

Please Help ....

Ankur

[Former Member · Accepted solution]

Please try the following steps -

1. set permission 777 in EPS and in folder

2. set permission 777 in .ATT and .PAT files

3. check archive log. it should not be full. ( i think it is not full but still check)

4. run database optimization statistics through DB13. once it will complete then start applying the patch

[Former Member · Accepted solution]

Dear Koushikda,

Thanks for your reply.

I have checked the free space 4Gb is available in oraarch directory.

Permission is not the problem as detailed earlier.

Regards

Ankur

[Former Member · Accepted solution]

Ankur I think you have tested with all the possibilities that the experts have suggested..Best approach would be raise a post to SAP regarding your problem.I think SAPKE60030 patch may be corrupt & that's why you are not able to proceed.As u have mentioned earlier in the thread that you have imported all other SAP components & not able to import only SAP_HR so better to discuss with SAP..

[former_member198270 · Accepted solution]

Hello Ankur, I am on same page with Joydeep - it would be good if you raise a message with SAP.

Regards, Amber S | ITL

[Former Member · Accepted solution]

Ankur all of us has given all the possible comments to resolve this issue but still no solution..I hope you rasied your comments to SAP.Please let us all know after SAP solved your issue.Best of luck..

[Former Member · Accepted solution]

Ankur you can try this if your problem is still not solved.

1.Please check the space of /usr/sap/trans/tmp.Try to give space to this directory as much as possible.

2.Check whether data & cofiles are generating for the package SAPKE60030.(Check in AL11)

After checking this run the import again through tcode spam.while performing import if you find any object locked then release that.

Best of luck.

[former_member198270 · Accepted solution]

Hello Ankur, It seems you were able to fix the support patch issue, good to see that. Could you share with us what you used as last resort and how was your problem resolved.

Thanks in Advance.

Regards, Amber S | ITL

[Former Member · Accepted solution]

Dear All,

Thanks for your valuable cooperation solving this update issue.

tp, R3trans and SAPCAR updated

removed all files from EPS/in

extracted all the HR patches

given more space in usr/sap/trans directory

Ran Check and update optimizer statistics

Cleaned up offline redolog files

Cleaned up usr/sap/trans/tmp

Cleaned up usr/sap/trans/log

and released all the unreleased HR related requests

Finally all the HR packages updated.

Thanks for all.

Ankur Biswas

[Former Member]

Ankur,

I would suggest you to look at the slog,alog and ulog under the trans directory for more details.

Beside i would check database alert log and the tablespace for errors.

Even the tp and R3trans with the lower release can cause such issue.

[Former Member]

Find the below link for info on ora-03114

http://ora-03114.ora-code.com/

Regards,

Dilip

[Former Member]

Hi Ankur,

With reference to ora- error that you found during dissemble phase i.e. ORA-03114: not connected to ORACLE.,

It might be possible it is a network issue - Refer to SNOTE - Note 534729 - Oracle errors due to network problems

Also , you may work with your DB admin to check the DB time out parameter values.

Regards,

Dilip

[Former Member]

Did you check this post?

[JPReyes]

STOP MAIN IMPORT
ERROR: stopping on error 12 during MAIN IMPORT

This error suggest that the dissasemble phase finished and the problem happen during the main import

Can you check the errors in SPAM and post them here?

Regards

Juan

[former_member198270]

Hello Ankur, Support pack process is getting stuck in Diassemble process. it means either the patch file is corrupted or there is permission issue with that file.

I would like you to download fresh file extract it and have that .PAT and .ATT in EPS/in.

Can you check and revert back ?

Regards, Amber S | ITL

[Former Member]

Hi Amber Can you please explain what you mean by permission issue??Ankur has already imported SAP_ABA,SAP_BASIS & so on..He did not find any permission issue so it would be great if you can explain the permission issue.

[former_member198270]

Sachin, Permission issue corresponds to this particular HR patch(.ATT and .PAT file)

Adiing to that particular patch can be corrupted due to which disassemble is not happening succesfully.

Diassemble does nothing but extracting that .PAT files into 2 components data file and cofiles

which are later used for patching the system internally by SPAM transaction.

In both the cases which i stated above 1.permission 2.corrupted patch - the diassemble will not happen as it was supposed to.

Revert if you still have doubts.

Regards, Amber S | ITL

Edited by: Amber S on Mar 30, 2010 10:12 AM

[Former Member]

Dear Amber

I have checked in os level and found cofile and data files are there. I am working on AIX/Oracle and permission 777 for sidadm:sapsys on data and cofiles.

see when I am imporing in background it is showing disassemble phase

But when trying through dialog it shows "tp user check ok" and continues ...........

Thanks.

Ankur

[Former Member]

Hi Amber,

One more thing 2076 MB out of 5000MB space available in trans.

Please let me know if there is a need of more free space to update sap_hr.

It always hangs in "tp user check ok" in frontend.

Thanks

Ankur

[former_member198270]

Hello Ankur, Did you tired the second option that is downloading the file fresh from service market place using download manager ? could you try and come back.

Also as you said you have already started that patching - say in background can you goto logs in SPAM tcode that will show you the stages which ahve already completed during sp implementation process. If it is stuck at dissamble process or error out , it means the component which is in process is having issues.

Regards, Amber S | ITL

[former_member198270]

no issues with space ankur

[Former Member]

Hi Ankur,

Hope you are applying the Support Pack through the user DDIC or a replica of DDIC. Also can you check the permissions of .ATT and .PAT files whether they have full permissions or not?

Have a look at this --

ERROR: uncaught internal error: ORA-03114: not connected to ORACLE

Verify the database connectivity using the command:

r3trans -d

Let us know the findings of the things mentioned.

Regards

Sourabh Majumdar

[Former Member]

Dear All,

I have downloaded Hr Packeges from Market Place again and tried to do the same again.

I have checked R3trans -d finishes with return code 0000.

Same problem persists.

Thanks

Ankur

[Former Member]

Can you paste the contents of latest SLOG as well as ALOG file? What are they showing this time?

Have you checked the permissions of .ATT and .PAT files?

Regards

Sourabh Majumdar

[Former Member]

Sourabh,

Import Queue in Dialog.

Spam Status

Import Phase DISASSEMBLE.

Action Log

Saving the current OCS Queue (30.03.2010, 14:00:30)

001: SAPKE60030 - Support Package for SAP_HR Release 600

Import of the current OCS Queue (30.03.2010, 14:00:37)

The import is done with the Standard scenario

The current OCS Queue consists of:

001: SAPKE60030

Import phase 'PROLOGUE' (30.03.2010, 14:00:40)

Import phase 'PROLOGUE' was successfully finished (30.03.2010, 14:00:40)

Import phase 'CHECK_REQUIREMENTS' (30.03.2010, 14:00:40)

Import phase 'CHECK_REQUIREMENTS' was successfully finished (30.03.2010, 14:00:40)

Import phase 'DISASSEMBLE' (30.03.2010, 14:00:40)

ALL TKD.ALL t 0000 20100330011632 DDIC sapdev - ALOG1013.SID

Regards

Ankur

[Former Member]

Where's the latest SLOG contents?

Have you checked the permissions of .ATT and .PAT files?

What about the reply of this?

Regards

Sourabh Majumdar

[Former Member]

Sourabh I think the permissions are already 666 but still Ankur please check the permissions :

SAPCAR -tvf "File name".

One thing I am not able to understand if Ankur has any problem with tp,space or any file permission how is it possible that he is able to import SAP_BASIS,SAP_ABA & so on??As per his thread he is getting the problem only when he is importing SAP_HR Packages..

[Former Member]

That's strange problem indeed Sachin. And for that reason only I am asking to check permissions for that particular .ATT and .PAT files of SAP_HR package..

Regards

Sourabh Majumdar

[former_member198270]

Hello Ankur, Here is some issue.

I checked the same patches in my ECC system - those patches are already applied.

I checked the patch SAP_HR - SAPKE60029, the prerequisite patches are - SAP_AP(SAPKNA7011) + SAP_BW(SAPKW70015) + SAP_HR(SAPKE60028) and are applied.

have you applied this component SAP_BW(SAPKW70015) ?

I trying to find out SAP note if this error comes in known problems with support packs.

Regards, Amber S | ITL

[Former Member]

Sachin,

Permission set

-rw-rw-rw- sidadm:sapsys CSN01*******.PAT

-rw-rw-rw- sidadm:sapsys CSN01*******.ATT.

drwxrwx--x sidadm:sapsys EPS

drwxrwxrwx sidadm:sapsys cofiles

drwxrwxrwx sidadm:sapsys data

drwxrwx--x sidadm:sapsys bin

drwxrwx--x sidadm:sapsys log

drwxrwx--x sidadm:sapsys tmp

any thing else........

Ankur

[Former Member]

Amber,

I have already updated SAP_BW from 15-20. I have checked the dependencies of HR pack and then updated the packs accordingly.

Current status of packs

SAPKD70037 SPAM/SAINT Update - Version 700/0037 Imported on 27.03.2010 at 20:25:41

SAPKA70018 ABA Support Package 18 for 7.00 Imported on 28.03.2010 at 06:16:19

SAPKB70018 Basis Support Package 18 for 7.00 Imported on 28.03.2010 at 01:20:16

SAPKIPYJ7I PI_BASIS 2005_1_700: patch 0018 Imported on 28.03.2010 at 05:29:18

SAPKW70020 BW Support Package 20 for 7.00 Imported on 28.03.2010 at 07:02:26

SAPKNA7015 SAP_AP 700: Support Package 0015 Imported on 28.03.2010 at 07:20:31

SAPKE60029 SP 29 for SAP_HR 6.00 Imported on 22.08.2008 at 18:28:53

Regards

Ankur

[Former Member]

Have you upgraded your kernel and SPAM to latest release before starting the support pack application?

Also upgrade r3trans and tp to latest version.

Regards

Sourabh Majumdar

[Former Member]

Dear All,

When I ma able to update other support packs then I am not able to update HR.

Is there any database dependencies. I ma useing Oracle 10.2.0.2.0.

Regards

Ankur