SAP Knowledge Base Article - Preview

3698900 - SUM upgrade fails with ASE Error SQL18571 - SAP ASE

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

SAP ERP 6.0

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.