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 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 ONE Support launchpad (Login required).

Search for additional results

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