Problem Note 49289: Load_STG2DM_Rpp_Plan generates error: "ORA-01400: cannot insert NULL
into ("DI_DM"."RPP_VENDOR_DEAL"."VENDOR_SK")"
The SAS® Promotion Optimization Load_STG2DM_Rpp_plan job might generate the following error in the Load_STG2DM_Rpp_plan.log file:
ERROR: ERROR: ERROR: ERROR: ORACLE execute error: ORA-01400: cannot insert NULL into ("DI_DM"."RPP_VENDOR_DEAL"."VENDOR_SK").
With the occurrence of the above ERROR, the error limit of 1 set by the ERRLIMIT= option has been reached.
ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost).
Total rows processed: <n> Rows failed : <n>
ROLLBACK has been issued(Any Rows processed after the last COMMIT are lost).
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE APPEND used (Total process time):
real time 0.76 seconds
cpu time 0.12 seconds
NOTE: The SAS System stopped processing this step because of errors.
This error occurs because one or more of the input records in the DIDM_STG.STG_RPP_PLAN file has an invalid value for VENDOR_ID. An invalid VENDOR_ID is one where the VENDOR_ID does not exist in the DI_DM.VENDOR table.
Please contact SAS Technical Support for assistance with this issue.
A fix for this issue is planned for a future software release.
Operating System and Release Information
| SAS System | SAS Promotion Optimization | Linux for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 5.2 | 5.2_M2 | 9.3 TS1M1 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2013-02-27 14:49:40 |
| Date Created: | 2013-02-27 13:38:22 |