Symptom
- SUM Solution Manager Upgrade fails in phase "MAIN_SHDIMP/SUBMOD_SHD2_RUN/XPRAS_SHD_AIMMERGE" with:
Executing SQL script '../var/ADJ_XPRAS_SHD_AIMMERGE.TSQL'.
Connecting to database 'syb'.
Date & Time: 20180625132722
SQL: if exists ( select 1 from sysobjects where name = 'DDMTF~' and type = 'U' and
SQL: uid = user_id('SAPSR3') ) BEGIN exec
SQL: sp_chgattribute 'DDMTF~', 'concurrency_opt_threshold', -1
SQL: UPDATE INDEX STATISTICS [DDMTF~] EXEC sp_recompile [DDMTF~]
SQL: END if exists ( select 1 from sysobjects where name = 'D010NC~'
SQL: and type = 'U' and uid = user_id('SAPSR3') ) BEGIN
SQL: exec sp_chgattribute 'D010NC~', 'concurrency_opt_threshold', -1
SQL: UPDATE INDEX STATISTICS [D010NC~] EXEC sp_recompile [D010NC~]
SQL: END
Date & Time: 20180625132723
Error message: DBSL error 99 (db code 0):
[ASE Error SQL18573][SAP][ASE ODBC
Driver][Adaptive Server Enterprise]Failed to update attribute
'concurrency_opt_threshold' for object 'DDMTF~'.
exit code: "20"
Rollback. - Last error code set:
Unable to update statistics for tables DDMTF~ and D010NC~
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 Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2
Keywords
SQL18573, 18573 , 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.