Symptom
SUM upgrade fails with ASE Error SQL18571
ETQ399 Executing SQL script '../var/ADJ_XPRAS_SHD_AIMMERGE.TSQL'.
2 ETQ399 Connecting to database 'syb'.
4 ETQ010 Date & Time: xxxxxxxxx
3 ETQ398 SQL: if exists ( select 1 from sysobjects where name = 'DDMTF~' and type = 'U' and
3 ETQ398XSQL: uid = user_id('SAPSR3') ) BEGIN exec
3 ETQ398XSQL: sp_chgattribute 'DDMTF~', 'concurrency_opt_threshold', -1
3 ETQ398XSQL: UPDATE INDEX STATISTICS [DDMTF~] EXEC sp_recompile [DDMTF~]
3 ETQ398XSQL: END if exists ( select 1 from sysobjects where name = 'D010NC~'
3 ETQ398XSQL: and type = 'U' and uid = user_id('SAPSR3') ) BEGIN
3 ETQ398XSQL: exec sp_chgattribute 'D010NC~', 'concurrency_opt_threshold', -1
3 ETQ398XSQL: UPDATE INDEX STATISTICS [D010NC~] EXEC sp_recompile [D010NC~]
3 ETQ398XSQL: END
1EETQ008 Error message: DBSL error 99 (db code 18571):
1EETQ009X[ASE Error SQL18571]The attribute 'concurrency_opt_threshold' is not
1EETQ009Xapplicable to tables with allpages lock scheme.
1EETQ003 exit code: "20"
4 ETQ399 Rollback.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Solution Manager (SOLMAN) 7.x
Product
Keywords
ASE Error SQL18571, lock scheme, allpages, datarows, concurrency_opt_threshold , DBSL error 99 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
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.
SAP Knowledge Base Article - Preview