Checks after phase MAIN_NEWBAS/PARCONV_UPG_DS were negative!

[Former Member]

Hi team,

Im in process of upgrading Solution Manager 7.0 EHP 1 to Solution manager 7.1.Database is db2 10.5.

Execution phase is in progress for ABAP,JAVA execution phase completed successfully.

In ABAP execution phase at MAIN_NEWBAS/PARCONV_UPG_DS, system cannot create given index.

Please find below error:

**********************************************

2 EGT052XRequest: Create "Index /BI0/ACCMDDCLI00-KEY (DDIC/08.12.14/14:30)"

4 EGT281 sql:

4 EGT231      "CREATE UNIQUE INDEX '/BI0/ACCMDDCLI00KE' on '/BI0/"

4 EGT231      "('CCM_LSN',"

4 EGT231      "'CCMDMSYS',"

4 EGT231      "'CCM_COMP',"

4 EGT231      "'CCM_CMPT',"

4 EGT231      "'CCMENDAT',"

4 EGT231      "'CCMENTIM',"

4 EGT231      "'CCMTZONE',"

4 EGT231      "'CCMLRPR',"

4 EGT231      "'CCMLRID',"

4 EGT231      "'CCMSRID')"

4 EGT231      "ALLOW REVERSE SCANS"

2 ED0313 SQL0270N Function not supported (Reason code = "1"). SQLSTATE=42997

4 EDA093 "DDL time(___1):" "........12" milliseconds

2EEGT236 The SQL statement was not executed

2EEDI006 Index " " could not be created completely in the database

2EEGT082 "Index" "/BI0/ACCMDDCLI00-KEY" could not be created

2 EGT067 Request for "/BI0/ACCMDDCLI00" could not be executed

******************************************************

I successfully created the index from backend and continued the process but it throws error like 'INDEX already created'.

Came across one SAP note : 1346662 - Avoid index creation errors in 7.0x upgrades where steps are given to skip the index creation for MSSQL,Is teher any way to skip the index creation and proceed?

I have also checked TATAF table but it doesn contain any entry with table name "/BIO/ACCMDDCLI00"

Looking for assistance.

Thanks & Regards,

Vineet

[Former Member]

Hi team,

Error resolved by deleting the entry of the concerned table from SAP<SID>.TBATG table.

Continued....

Regards,

Vineet