Problem Note 44808: Optimization fails with database error
 |  |  |  |  |
When running SAS® Regular Price Optimization, you might see the following error during optimization:
ERROR: During insert: [IBM][CLI Driver][DB2/AIX64] SQL0407N Assignment of a NULL value to a NOT NULL column "TBSPACEID=2, TABLEID=196, COLNO=13" is not allowed. SQLSTATE=23502 ERROR: ROLLBACK issued due to errors for data set DI_T_DBC.RPO_PLAN_MEMBER_RESULT_KPI.DATA. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. NOTE: The SAS System stopped processing this step because of errors.
This error occurs when the global setting USE_COST_BASED_ACCT is set to 1 and there are products within the scope of the plan (i.e., either original plan members, related items or items added due to cross-effects) that have a base forecast of 0 for all stores within the price zone. This condition causes a margin percent value to be missing, which then violates a database constraint.
The work around for this issue is to change the global setting USE_COST_BASED_ACCT to 0.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Regular Price Optimization | Microsoft Windows Server 2003 Datacenter Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2_M1 | 4.2_M2 | 9.2 TS2M3 | 9.2 TS2M3 | ||
A fix for this issue for SAS Merchandise Intelligence 4.2_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D81.html#44808| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2011-11-10 09:02:24 |
| Date Created: | 2011-11-07 12:01:49 |