If you are migrating to the Cluster Edition from Adaptive Server version 15.0.2, begin by downgrading from version 15.0.2 to version 15.0.1 ESD #3. During this downgrade, you must perform one additional downgrade step that is not reflected in the instructions for downgrading from Adaptive Server 15.0.2. Do this after downgrading to Adaptive Server 15.0.1, after following the "Basic downgrade steps" section of “Downgrading from Adaptive Server 15.0.2,”, but before performing any of the "Post-downgrade tasks".
The text of system message 13152 changed between version 15.0.1 and 15.0.2. Adaptive Server incorporates this message text into certain stored procedures as it compiles them, and the 15.0.2 text causes parsing errors during 15.0.1 procedure compilation. To assure successful migration to the Cluster Edition, you must change this message text before attempting to reinstall stored procedures in version 15.0.1.
To change this message back to its 15.0.1 form, log in to Adaptive Server with “sa_role” permissions, then do this:
-- permit direct updates to system catalogs select config_admin(1, 102, 1, 1, NULL, NULL) go
-- revise message 13152 text update master.dbo.sysmessages set description = "--" + description here error = 13152 and langid is null and substring(description,1,2) != "--" go
-- turn off direct updates to system catalogs select config_admin(1, 102, 0 1, NULL, NULL) go
