Skip to Content
author's profile photo Former Member
Former Member

Error while updating SPAM SAPKD62023

Hi all,

i have problem when perform update on SPAM to version 23 with SAPKD62023.

error in phase: IMPORT_PROPER

reason for error: TP_STEP_FAILURE

return code: 0008

error message: OCS Package ALL, tp step "6", return code 0008

error log file:

Error -913-Row or object PAT05 in R3BP1DATA type *FILE i when executing ADD-FIELD of

Error in DLL statement for when executing ADD-FIELD of

No DLL commands found for activation of PAT05

System log:

Details

Transaction code ...... SA38

Program name .......... RDDMNTAB

Problem class ......... K SAP Web AS Problem

Development class ..... SBAC

Module name ........... dbds

Line .................. 691

Table name ............ -913

Field name ............ EXE

Hopefully you guys can help me on this ASAP..

im still junior basis and dont have any idea on how to solve this problem. Hope can guide me step by step to solve it... thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on May 01, 2007 at 09:38 PM

    Hello,

    I assume you're using iSeries as the operating system.

    The support package SAPKD62023 needs to change the table structure (add field) on table PAT05 but the SQL error 913 happened. This error usually means some other job is locking the table PAT05.

    You can try to repeat the import in SPAM again. If it fails again, log on to the AS/400 and use the command WRKOBJLCK on the table PAT05 in R3BP1DATA to fins if there's any job locking it (exclusive lock), if so, you can end the cooresponding job and start the import in SPAM.

    Regards,

    Joe

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 01, 2007 at 12:44 PM

    import the latest Patch of tp and R3trans

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2007 at 06:57 AM

    Hi,

    I also faced a similar problem recently. You can check the kernel level. What happens is that your kernel may be at some lower level that what is required. Just update it to the latest kernel available and then update your SPAM.

    This will solve your problem.

    You can also check the tp.exe and r3trans.exe file.

    do reward with suitable points as appreciation.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 03, 2007 at 01:54 AM

    Hi all,

    Sorry for the delay. Our country celebrates public holidays on 1st & 2nd May. Anyway, the SPAM update problem already solved. First of all, this morning after came to the office i tried the easiest way possible just to re-import the patch. Guess what, its success!! Maybe other user still doing some activities or transports in the production server and lock the particular objects. I'm still not very sure how its work but thanks guys. I will keep it as future reference.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2011 at 01:43 AM

    Hi,

    This is not intended to be a reply taking into account that this thread is really old. The point is I've found this thread because I faced the same problem today installing SAPKD64043 and I just want to point out what was the problem in my case with the idea to help someone else facing this problem.

    I tried several times to repeat the installation but nothing happened. Then, I've realized that the system daily online backup was running at that moment and the backup job was keeping a lock (type *SHRRD) on the object R3<SID>DATA. After the backup job finished, I tried again and then I was able to install the SPAM update sucesfully.

    I hope this can help somebody with the same issue.

    Cheers,

    Diego.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.