SAP Knowledge Base Article - Preview

2376326 - SMIGR_CREATE_DDL returning exception CX_SMIGR_PROGRAM_ERROR with ST22 dump - SAP ASE for BS

Symptom

  • You are migrating your BW or Solution Manager system from Oracle to SAP ASE.
  • Step "B. Preparation in the source system" from SAP Notes 2103871 - "SYB: Migrating SAP BW to SAP Adaptive Server Enterprise" was applied.
  • The report SMIGR_CREATE_DDL ends with ST22 dump:

Category ABAP programming error
Runtime Error UNCAUGHT_EXCEPTION
Exception CX_SMIGR_PROGRAM_ERROR
ABAP program CL_SMIGR_DDL_SYB ============= CP
Application component BC-DB
[...]

Trigger of the exception
     Program CL_SMIGR_DDL_SYB ============= CP
     Include CL_SMIGR_DDL_SYB ============= CM007
     Line 34
     Module Type (METHOD)
     Module name GET_DDL_ORA

  • That same ST22 dump can also be reported if you are doing a SUM ugprade while migrating from Oracle to ASE.
    The SAPupTroubleTicket.log will report this:

Summary of Error:
=================
- Module: MAIN_SHDRUN/Shadow System Operations: SPDD and Activation
- Phase Name: MAIN_SHDRUN/SUBMOD_MIG_SMIGR/RUN_SMIGRCREATEDDL_740
- Phase Log File: PHASE_RUN_SMIGRCREATEDDL_ORG.LOG
- Error Message: Last error code set:
Single errors (code <= 8) found in logfile 'PHASE_RUN_SMIGRCREATEDDL_ORG.ELG'

And the SAPupConsole.log and PHASE_RUN_SMIGRCREATEDDL_ORG.ELG reports this:

A3EERS_EXCEPTION 000 "An exception occurred" " " " " " "
A3EERS_UPG_TOOL 721 Task SMIGR_CREATE_DDL: Read long text for task documentation"SMIGR_CREATE_DDL"


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Business Warehouse - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

SMIGR_CREATE_DDL, UNCAUGHT_EXCEPTION, GET_DDL_ORA, CL_SMIGR_DDL_SYB, solman, GET_DDL_ORA , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , BW-SYS-DB-ORA , BW ORACLE , 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.