Problem Note 48915: dipcl_history_metrics task fails with "ERROR: The text expression length (65639) exceeds maximum length (65534)."
 |  |  |  |
When running the weekly batch job (di_job) in SAS® Markdown Optimization, the dipcl_history_metrics task might fail with the following error in the status log:
ERROR: The text expression length (65639) exceeds maximum length (65534). The text expression has been truncated to 65534
This issue occurs when there are a large number of active markdown plans in the system to process. The list of plan SKs becomes too long to store in a text string and subsequently exceeds the SAS macro variable length limit of 64K.
To work around this issue, you can perform one of the following:
- Reduce the number of active plans to be processed to 9361 or fewer.
- Disable the dipcl_history_metrics task in the weekly batch job. Disabling this task only affects the display of historical metrics in the Markdown Optimization user interface. History metrics are not available.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Markdown Optimization | 64-bit Enabled AIX | 3.2 | 4.3_M2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.2 | 4.3_M2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 3.2 | 4.3_M2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 3.2 | 4.3_M2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 3.2 | 4.3_M2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Windows Vista | 3.2 | 4.3_M2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 3.2 | 4.3_M2 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2015-10-20 11:09:45 |
| Date Created: | 2013-01-14 12:22:37 |