Problem Note 40076: In SASĀ® Merchandise Planning, the migration script for upgrading from release 5.x to release 6.x is missing information
In SAS Merchandise Planning, the migration script for upgrading from release 5.x to release 6.x is missing information that is needed to populate the Display Name (which is VERSION_SHORT_NM in the MAXDATA.PLANVERSION table).
Note that because the UPDATE script exists in p_copy_planversion, the issue does not occur when you copy a planversion.
The following solution resolves this problem if you do not want to copy a planversion.
To circumvent this problem, run the following UPDATE script using SQL*Plus:
update maxdata.planversion
set version_short_nm=SUBSTR(name,1,10)
where version_short_nm IS NULL;
--commit;
Operating System and Release Information
SAS System | SAS Merchandise Assortment Planning | 64-bit Enabled AIX | 6.1.3 | 6.4 | 9.1 TS1M3 SP4 | 9.4 TS1M0 |
SAS System | SAS Merchandise Financial Planning and SAS Merchandise In-Season Management | 64-bit Enabled AIX | 6.1.3 | 6.4 | 9.1 TS1M3 SP4 | 9.4 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.
Run the following script using SQL*Plus:
UPDATE maxdata.planversion
SET version_short_nm=SUBSTR(name,1,10)
WHERE version_short_nm IS NULL;
--COMMIT;
Type: | Problem Note |
Priority: | high |
Date Modified: | 2011-04-13 11:11:46 |
Date Created: | 2010-06-22 12:07:06 |