Symptom
You are running program SMIGR_CREATE_DDL on an Oracle database and get the following type of errors, like:
Failed to create storage parameters for table: <TABLE_NAME>
OR
Error while creating DDSTORAGE entries for table <TABLE_NAME>
Furthermore in SM21 ORA-01455 errors are reported:
ORA-01455: converting column overflows integer datatype
You can also check if there are large numbers (>2147483647) in columns INSERTS, UPDATES, DELETES in table DBA_TAB_MODIFICATIONS for these tables.
SQL> select inserts, updates, deletes from DBA_TAB_MODIFICATIONS where table_name = '<TABLE_NAME>';
Read more...
Environment
SAP NetWeaver BW with Oracle database
Product
Keywords
system_copy system copy migration se38 BI0 BIC , KBA , BC-DB-ORA-SYS , Database Interface / DBMS , 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.
SAP Knowledge Base Article - Preview