SAP Knowledge Base Article - Preview

3152119 - Error 1204 when enable metrics capture is ON or statement has some space - SAP ASE

Symptom

The following statement hit on error 1204 when parameter "enable metrics capture" is enabled:

=====

insert into tempdb..tmp01
select
col01
, sum ( X_I )
, sum ( Y_V )
, sum ( X_V )
, sum ( Y_I )
, sum ( ZZ_V )
, ( sum ( SALDO ) - ( ( ( 0.5*sign ( sum (ZZ_V ) -sum ( X_I ) ) +0.5 ) * sum ( X_I ) ) + ( ( 0.5*sign ( sum ( X_I ) -sum ( ZZ_V ) ) +0.5 ) * sum ( ZZ_V ) ) ) )
, sum ( SALDO )
, 1
from
tempdb..tmp01
group by
col01

======

This query would not cause problem if space is removed between "1":

======

insert into tempdb..tmp01
select
col01
, sum ( X_I )
, sum ( Y_V )
, sum ( X_V )
, sum ( Y_I )
, sum ( ZZ_V )
, ( sum ( SALDO ) - ( ( ( 0.5*sign ( sum (ZZ_V ) -sum ( X_I ) ) +0.5 ) * sum ( X_I ) ) + ( ( 0.5*sign ( sum ( X_I ) -sum ( ZZ_V ) ) +0.5 ) * sum ( ZZ_V ) ) ) )
, sum ( SALDO )
,1
from
tempdb..tmp01
group by
col01

======

Memory dump indicates many locks on table "sysqueryplans".


Read more...

Environment

SAP Adaptive Server Enterprise 16.0 SP04

Product

SAP Adaptive Server Enterprise 16.0

Keywords

error 1204 out of locks parameter enable metrics capture space sysqueryplans 826208 CR 826208 CR 826208 CR# 826208 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.