DBIF_DSQL2_SQL_ERROR -error 600 occurred in the current database connection

[Former Member]

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

[lbreddemann]

Hi Nisch,

as a SAP customer open a support message for this problem.

best regards,

Lars

[Former Member]

Thanks All,

This was resolved by inceasing resources on livecache database. (cache_size, oms_heap_limit).

Users did not experience this error on production instance.

Cheers,

Nisch

[Former Member]

Hi,

might be problem is related to heap memory of the liveCache

check following notes

Note 1126394 - Planning version copy: DBIF_DSQL2_SQL_ERROR

Note 1231812 - Program termination when you use rpt /SAPAPO/VS_DLV_DELETE

regards,

kaushal