Problem Note 45717: Plan descriptions might be missing after a plan is updated using ETL
In SAS® High-Performance Markdown Optimization, plans that once had a value in the plan description might later be missing the plan description after they are updated through ETL.
This missing description occurs when a plan that was initially created through either ETL or the UI had a plan description, and that plan is subsequently updated via ETL. In the STG_MDO_IMPORT_PLAN table, ACTION_CD=6 is used to update an existing plan. During an update, a NULL value for a field in the STG_MDO_IMPORT_PLAN record is interpreted to mean "do not change" the value in the database. However, for the MDO_PLAN_DESC column, the value is always written to the database. When MDO_PLAN_DESC is NULL, any prior value in the database is overwritten and becomes NULL.
The workaround for this issue is to include the MDO_PLAN_DESC in any STG_MDO_IMPORT_PLAN records with ACTION_CD=6.
Operating System and Release Information
| SAS System | SAS High-Performance Markdown Optimization | Linux for x64 | 4.3_M1 | 5.2 | 9.2 TS2M3 | 9.3 TS1M0 |
*
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: | high |
| Date Modified: | 2012-02-21 09:47:59 |
| Date Created: | 2012-02-17 16:28:30 |
