SAP Knowledge Base Article - Preview

2674914 - SUM upgrade fails in phase "MAIN_SHDIMP/SUBMOD_SHD2_RUN/XPRAS_SHD_AIMMERGE" with error SQL18573 for SAP ASE for BS

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.