Database error 600 at EXE

[Former Member]

hi,    

After copy livecache using backup/restore, I try to excute livecache transcation, but there is a dump.

Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception            CX_SY_NATIVE_SQL_ERROR

In dev_w*, it's said:

...

C  Now I'm connected to SAP DB

C  01: dga115-LT6, since=20130107130032, ABAP= /SAPAPO/SAPLOM_CORE (6598)

B  Connection 1 opened (DBSL handle 1)

C  *** ERROR =>   execute() of C_0001, #rec=0, rc=1, rcSQL=600 (POS(1) Work rolled back: tExcept 30708 in SIM_SIMSESS

ION)

[dbsdbsql.cpp 1715]

C  *** ERROR => EXECUTE on connection 1, rc=600 (POS(1) Work rolled back: tExcept 30708 in SIM_SIMSESSION)

[dbdssdb.cpp  2173]

C  sc_p=0x114a7d7e8,no=1,idc_p=(nil),con=1,act=1,slen=49,smax=256,#vars=0,stmt=0x114e12570,table=   "SIM_SIMSESSION_G

ET_ACTIVE"

C  CALL USER."SIM_SIMSESSION_GET_ACTIVE" ( ?, ?, ? );

C  *** ERROR => dbdssdb: SQL Error 600, Message: POS(1) Work rolled back: tExcept 30708 in SIM_SIMSESSION

[dbdssdb.cpp  2408]

B  ***LOG BY2=> sql error 600        performing EXE        [dbds#2 @ 364] [dbds    0364 ]

B  ***LOG BY0=> POS(1) Work rolled back: tExcept 30708 in SIM_SIMSESSION [dbds#2 @ 364] [dbds    0364 ]

A  TH VERBOSE LEVEL FULL

...

In the trace file lcapo_com_trace_01.txt,

x0ea53c23      >>>>>>> end of stack backtrace <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

0x0ea53c23     

0x0ea53c23     

0x0ea53c23      log@20130107-133031  planversion = NULL_GUID

0x0ea53c23                           client =   

0x0ea53c23                                                                                        (dialog)

0x0ea53c23     

0x0ea53c23     

0x0ea53c23     

0x0ea53c23      ######## #!!# tExcept exception in SIM_SIMSESSION_GET_ACTIVE ##############

0x0ea53c23      # COM build 70017.2 CL 423530 (7.0_REL) on AIX RS6000 5.1

0x0ea53c23          Fatal COM internal tExcept exception:

0x0ea53c23       ~< 30708 Application system name mismatch [cbs_tracercontrol-COMBase+Release.cpp: 1254] >~

0x0ea53c23          no. = 30708

0x0ea53c23      stack EMPTY, max stack usage in session: 0 (calls)

0x0ea53c23      CS[end] >>>>>>> end of callstack <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

0x0ea53c23     

0x0ea53c23     

0x0ea53c23      [incident] 0Laz8G00000000042hJXSm

0x0ea53c23     

0x0ea53c23      log@20130107-133031  planversion = NULL_GUID

0x0ea53c23                           client =   

0x0ea53c23                                                                                        (dialog)

0x0ea53c23      SIM_SIMSESSION_GET_ACTIVE: omsTerminate will be triggered:

0x0ea53c23       tExcept 30708 in SIM_SIMSESSION_GET_ACTIVE

0x0ea53c23       ERROR 30708 in SIM_SIMSESSION_GET_ACTIVE: SessionGlobals::isMarkedForTerminate(h) is true!!!

0x0ea53c23      stack EMPTY, max stack usage in session: 2 (calls), 9660 (bytes)

0x0ea53c23      CS[end] >>>>>>> end of callstack <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

0x0ea53c23     

0x0ea53c23     

----- Last Line Written ----- Cycle:0

Would you have any good idea?

Thanks a lot

Lily

[Former Member]

Hi Lili,

I hope below link helps you to you resolve the error.

http://scn.sap.com/thread/990308

Best Regards,

Ganesh

[former_member229109]

Hello Ganesh,

the SAP note 1015489 has the solution for the reported in this thread issue!

Regards, NK

[former_member229109]

Hello,

1.

Issue reported in this thread:

After copy livecache using backup/restore, I try to excute livecache transcation, but there is a dump with error - tExcept 30708 in SIM_SIMSESSION...

=>

the SAP note 1015489 recommended.

Or create the SAP message and get SAP support.

2.

http://scn.sap.com/thread/990308 will not help the originaly reported in this thread issue.

As this thread discussed "

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

     SAPTS_AGGMULT""

Regards, Natalia Khlopina

[former_member229109]

Hello Lily,

check the SAP note 1015489 for solution.

Regards, Natalia Khlopina