dump "/SAPAPO/OM_TIME_GET" in t-cde //om13

[Former Member]

Hi All,

I have refreshed my SBX SCM/LC system with QAS SCM/LC and I am facing the following dump when accessing t-code

"//om13" ......

Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR

Date and Time 14.06.2010 03:33:15

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_TIME_GET "

Database error code........: 600

Triggering SQL statement...: "EXECUTE PROCEDURE "APS_TIME_GET""

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_TOOLS_BASIS" or "/SAPAPO/LOM_TOOLS_BASISU08"

"/SAPAPO/OM_TIME_GET"

[tibor_nagy · Accepted solution]

Hi Revanth,

Please use the recommendations provided in the SAP Note:1015489.

Regards,

Tibor

[Former Member · Accepted solution]

Hi Tibor,

Thanks for the SAP Note:1015489. according to this note I have dropped the Table APPSYSPARAM. and the LC is accessable from t-code //om13

command used to drop the table in LC :-

step 1 :-

dbmcli -d <LC Instanz> -n <LC Server> -u DBM,<Passwort> -uSQL sap<sid> ,<Passwort>

step 2:-

sql_execute DROP TABLE APPSYSPARAM

Thanks and Regards,

Revanth Kumar Kadali

[Former Member]

Hi Senthil,

Thanks for the quick reply..the OSS note u specified is not applicable for this error.... the t-code //om13 is working fine

in the QAS SCM/LC system and the same was refreshed with SBX SCM/LC ...

Dump is as follows ...

***

Database error text........: "POS(1) Work rolled back: tExcept 30708 in

APS_TIME_GET# "

Database error code........: 600

Triggering SQL statement...: "EXECUTE PROCEDURE "APS_TIME_GET""

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_TOOLS_BASIS" or "/SAPAPO/LOM_TOOLS_BASISU08"

/SAPAPO/OM_TIME_GET

[Former Member]

Hi Revanth,

Check SAP note 1064119 whether applicable for you

Regards

R. Senthil Mareeswaran.

[Former Member]

Hi,

In addition to above , please also check OSS note 1346337 ( /SAPAPO/OM13: Checking liveCache parameter).

Regards

Datta