Skip to Content
0
Former Member
Aug 04, 2008 at 02:10 AM

DBIF_DSQL2_SQL_ERROR -error 600 occurred in the current database connection

710 Views

Hello All,

We are running SCM 5.0 on Wintel, livecache version is 7.6 (KERNEL 7.6.02 BUILD 014-123-152-175).

The following short dumps are logged on the test instance. Consistancy checks of livecache have been successful.

Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR

Short text

An SQL error occurred when executing Native SQL.

What happened?

The error 600 occurred in the current database connection "LCA".

How to correct the error

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

SAPTS_AGGMULT"

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

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

Internal call code.........: "[DBDS/NEW DSQL]"

Please check the entries in the system log (Transaction SM21).

C Mon Aug 04 11:45:07 2008

C *** ERROR => execute() of C_0752, #rec=0, rc=1, rcSQL=600 (POS(1) Work rolled back: BAD_ALLOCATION in SAPTS_AGGMULT)

[dbsdbsql.cpp 1570]

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

[dbdssdb.cpp 2173]

C sc_p=000000002ABF1DD0,no=752,idc_p=0000000000000000,con=1,act=1,slen=64,smax=256,#vars=0,stmt=000000002B007A30,table= SAP

C CALL USER.SAPTS_AGGMULT_TIMESERIES ( ?, ?, ?, ?, ?, ?, ?, ?, ? );

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

[dbdssdb.cpp 2403]

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

B ***LOG BY0=> POS(1) Work rolled back: BAD_ALLOCATION in SAPTS_AGGMULT [dbds#1 @ 364] [dbds 0364 ]

A TH VERBOSE LEVEL FULL

All assistance will be useful.

Best Regards,

Nisch