SAP Articles

Symptom DBIF_RSQL_SQL_ERROR short dump in ST22 (exception CX_SY_OPEN_SQL_DB, form routine INSERT_ODS) "ORA-14400: inserted partition key does not map to any partition" The dump & error can occur when writing/inserting to PSA or F-fact tables or when DSO objects are activated. PSA loads fail. Unable to activate DSO requests. DSO activation fails. Activation job BI_ODS..... dumps Environment SAP NetWeaver 7.0 SAP enhancement package 1 for SAP NetWeaver 7.0 SAP enhancement package 2 for SAP NetWeaver 7.0 SAP NetWeaver 7.3 SAP enhancement package 1 for SAP NetWeaver 7.3 SAP NetWeaver 7.4 SAP Business Information Warehouse (SAP_BW) Reproducing the Issue Dump occuring during DSO activation: Run tcode RSA1  Find the problematic DSO & click manage Enter the activation log to view the returned error msg which will enable you to jump to tcode ST22 & view the related DBIF_RSQL_SQL_ERROR dump. Dump...

Symptom DBIF_RSQL_SQL_ERROR short dump in ST22 (exception CX_SY_OPEN_SQL_DB, form routine INSERT_ODS) "ORA-14400: inserted partition key does not map to any partition" The dump & error can occur when writing/inserting to PSA or F-fact tables or when DSO objects are activated. PSA loads fail. Unable to activate DSO requests. DSO activation fails. Activation job BI_ODS..... dumps Environment SAP NetWeaver 7.0 SAP enhancement package 1 for SAP NetWeaver 7.0 SAP enhancement package 2 for SAP NetWeaver 7.0 SAP NetWeaver 7.3 SAP enhancement package 1 for SAP NetWeaver 7.3 SAP NetWeaver 7.4 SAP Business Information Warehouse (SAP_BW) Reproducing the Issue Dump occuring during DSO activation: Run tcode RSA1  Find the problematic DSO & click manage Enter the activation log to view the returned error msg which will enable you to jump to tcode ST22 & view the related DBIF_RSQL_SQL_ERROR dump. Dump...

SAP Technical Settings Once this has been saved, the next step is to move on to maintaining the technical settings of the Table. Before creating the final Database table, SAP will need some more information about the table being created. Select 'Technical settings' via the toolbar above the table, through the 'Go to' menu, or with the shortcut CTRL+SHIFT+F9. Here, it is important to tell the system what Data class is to be used, so select the drop down button. There are five different options, with accompanying descriptions. For this table, select the first, labelled 'APPL0', and double-click it: For the 'Size category' field, again click the drop-down button. Here, you have to make an estimate as to the amount of data records which will be held within the table so that the system has some idea of how to create the tables in the underlying database. In this instance, it will be a relatively small amount of information, so select the...

SAP Data Domains Double-click the entry ('ZEENUM') in the Domain area, and agree to save the changes made. Now, the 'Create Object Directory Entry' window will re-appear and again it is important to save this development to the '$TMP' development class, via the 'save' or 'local object' button visible in this window. After doing this, a window will appear stating that the new Domain 'ZEENUM' does not exist. Choose 'Yes' to create the Domain, and in the window which appears, type into the 'Short text' box a description of the Domain. In this example, 'Employee Domain': The 'Definition' tab, which, as shown above, opens automatically. The first available field here is 'Data type', click inside the box and select the drop-down menu, and a number of generic data types already existing within the ABAP dictionary will appear. The 'NUMC' type is the one to be used here for the Emplo...