cancel
Showing results for 
Search instead for 
Did you mean: 

getting shot dump while executing T-code after system refresh in APO server

Former Member
0 Kudos

Hi ALL,
we have completed system Refresh & post - Activities now we are testing my system, while test mode my APO consultant facing an error,

while testing he tried different T-Codes and he received runtime error “DBIF_DSQL2_SQL_ERROR”.

The liveCache is NOT working and giving runtime errors.

Regards but when i cheked consistancy checck connection is ok

(livecache monitor and connectivity and server test connection)

can u please reply why iam facing this shot dumps

dump

Runtime Errors         DBIF_DSQL2_SQL_ERROR
Exception              CX_SY_NATIVE_SQL_ERROR
Date and Time          04/20/2012 19:08:30

Short text
     An SQL error occurred when executing Native SQL.

What happened?
     The error 600 occurred in the current database connection "LCA"

What can you do?
     Note down which actions and inputs caused the error.


     To process the problem further, contact you SAP system
     administrator.

     Using Transaction ST22 for ABAP Dump Analysis, you can look
     at and manage termination messages, and you can also
     keep them for a long time.

How to correct the error
    Database error text........: "POS(1) Work rolled back: tExcept 30708 in
     APS_PLEN_RERS_"
    Database error code........: 600
    Triggering SQL statement...: "EXECUTE PROCEDURE "APS_PLEN_RERS_GET_ALL""
    Internal call code.........: "[DBDS/NEW DSQL]"
    Please check the entries in the system log (Transaction SM21).

    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_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"
    "/SAPAPO/SAPLOM_CORE" or "/SAPAPO/LOM_COREU17"
    "/SAPAPO/OM_PLEN_RERS_GET_ALL"

    If you cannot solve the problem yourself and want to send an error

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member229109
Active Contributor
0 Kudos

Hello,

the solution is written in the  SAP Note No. 1015489.

Please follow all recommended steps given in the note:

886103    System Landscape Copy for SAP SCM

when you run the system copy next time.

Regards, Natalia Khlopina

hemanth2
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear swathi,


Hope you are doing good.

check the link below that deals with this: https://wiki.wdf.sap.corp/wiki/display/lcapps/Error+-28814

It seems this crash is LiveCache is caused by resource limitations for this. Please refer to note 628131 and check the OS settings. In addition, refer to note 719652 and check the parameters settings.

833216 - Parameter values as of liveCache Versions 7.5, 7.6 and 7.7

Thank you and have a nice day :).

_____________
Kind Regards,
Hemanth

former_member189725
Active Contributor
0 Kudos

Did you copy the liveCache system as well ?

Can you increase the following Live Cache parameters

cache_size

oms_heap_limit

Restart the LiveCache after that.

Regards

Ratnajit