SAP Knowledge Base Article - Preview

2417829 - SMIGR_CREATE_DDL fails with "According ODS object has no active version"

Symptom

Running SMIGR_CREATE_DDL to export a MS SQL Server database, with target as MS SQL Server, it fails with the following errors:

     /BI0/ARSPL_AST00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_PLC00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_HST00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_SEL00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_CST00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_PSS00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_AGS00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_LCK00
According ODS object has no active version. DDL generation has been skipped for that table.
     /BI0/ARSPL_SPS00
According ODS object has no active version. DDL generation has been skipped for that table.

         No *.SQL files generated due to error above!

Due to these error messages, no SQL files are generated.


Read more...

Environment

  • SAP systems based on SAP NetWeaver;
  • Microsoft SQL Server 2008 and higher;

Product

SAP NetWeaver all versions

Keywords

ODS, DSO, BW, SMIGR CREATE DDL, failing, /BI0/ARSPL_PLC00, /BI0/ARSPL_CST00, /BI0/ARSPL_PSS00, /BI0/ARSPL_AGS00, /BI0/ARSPL_LCK00, /BI0/ARSPL_SPS00, /BI0/ARSPL_HST00, /BI0/ARSPL_SEL00, /BI0/ARSPL_AST00, RSPL_PLC, RSPL_CST, RSPL_PSS, RSPL_AGS, RSPL_LCK, RSPL_SPS, RSPL_HST, RSPL_SEL, RSPL_AST, , KBA , BW-SYS-DB-MSS , BW on Microsoft SQL Server , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.