SUPPORT / SAMPLES & SAS NOTES
Problem Note 45989: Database error encountered during optimization
 |  |  |  |  |
When optimizing a plan in SAS® Regular Price Optimization, the following error might be generated:
ERROR: Failed to extract forecast.
In addition, a database error similar to the following is generated in the Stored Process Server log:
ERROR: CLI execute error: [IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected
token ")" was found following "8,-1,12989,-1,12990,". Expected tokens may include: "".
SQLSTATE=42601
The length of a string that contains information related to product relationship rules exceeds the string length. Optimization fails because of the incomplete query that is passed to the database.
This database error is encountered only in subsequent optimization runs. Because of this, the workaround is to make a copy of the plan and then optimize the copy of the plan.
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 | ||