Performing Solution Manager SP stack upgrade on ASE Database using SUM
In the execution phase i.e. in the Downtime phase, the upgrade process stops during phase PARCONV_UPG_DS in module
“Conversion, Main Import, XPRAs with error message Unhandled mode flags found, check ‘PARCONV.LOG’ for details”
Login to the system and enter tx code st22 to view the error message.
Error Text of Database: “[ASE Error SQL207][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Invalid column name ‘TYPE’.#”
Apply the OSS note 2242937
The procedure is descibed below
For unlock the Shadow system, type and execute the following commands :
Log in with a user other than DDIC user in client 000 and call transaction SE38
Type the report name SDB2FSYB in field Program.
Select Source Code.
On the menu path, Go to Edit –> Modification Operation–> Switch off assistant or take help from ABAPER.
Search for FORM tabstorage_dbs_get, code line “IF l_sybvers >= co_vers_idx_compression.” in the editor.
In the EXEC SQL SELECT statement change “t1.TYPE” to “t1.type”.
Save and activate your change. After activation completed, then check syntax error.
Lock the shadow system again as follows:
Type and execute the following commands :
Retry and finish your upgrade.