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
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.