Skip to Content

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’.#”

Solution:

Apply the OSS note 2242937

The procedure is descibed below

 

Switch to <sid>adm account.

Go to <SUM_DIR>\abap\var\.
For unlock the Shadow system, type and execute the following commands :
tp unlocksys <SID> pf= SHADOW.TPP
tp unlock_eu <SID> pf= SHADOW.TPP

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.
Choose Change.

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:

Go  to <SUM_DIR>\abap\var\.
Type and execute the following commands :
tp locksys <SID> pf= SHADOW.TPP
tp lock_eu <SID> pf= SHADOW.TPP

Retry and finish your upgrade.

 

 

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply