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.