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 , SAP Business Suite on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.