SUM - PARCONV_UPG - Index P creation Fail

Former Member · ‎02-10-2014

Good Day,

I am currently trying to upgrade our BW 730 to 731. During the PARCONV_UPG, SUM is unable to create the P index. I have attempted to create the index in SAP, but the indicate that the SQL script is missing a column. I have executed. I have executed the SQL manually, but the SUM delete/tries to activate it. Subsequently repeating the invalid SQL script. Please advise how make the system execute the correct SQL statement

The SUM/SE14/report RADCVBTC script is:

CREATE UNIQUE INDEX "/BI0/E0BWTC_C06~P" on "/BI0/E0BWTC_C06" ("KEY_0BWTC_C06T", "KEY_0BWTC_C061", "KEY_0BWTC_C062", "KEY_0BWTC_C063", "KEY_0BWTC_C06P") CLUSTER ALLOW REVERSE SCANS

CREATE UNIQUE INDEX "/BI0/E0BWTC_C07~P" on "/BI0/E0BWTC_C07" ("KEY_0BWTC_C07T", "KEY_0BWTC_C071", "KEY_0BWTC_C072", "KEY_0BWTC_C073", "KEY_0BWTC_C07P") CLUSTER ALLOW REVERSE SCANS

CREATE UNIQUE INDEX "/BI0/E0PA_C01~P" on "/BI0/E0PA_C01" ("KEY_0PA_C01T", "KEY_0PA_C011", "KEY_0PA_C012", "KEY_0PA_C013", "KEY_0PA_C014", "KEY_0PA_C015", "KEY_0PA_C016", "KEY_0PA_C017", "KEY_0PA_C018", "KEY_0PA_C01P") CLUSTER ALLOW REVERSE SCANS

CREATE UNIQUE INDEX "/BIC/E100336~P" on "/BIC/E100336" ("KEY_100336T", "KEY_1003361", "KEY_1003362", "KEY_1003363", "KEY_1003364", "KEY_1003365", "KEY_1003366", "KEY_1003367", "KEY_1003368", "KEY_1003369", "KEY_100336A", "KEY_C_CPMC03XU", "KEY_100336P") CLUSTER ALLOW REVERSE SCANS

CREATE UNIQUE INDEX "/BIC/EMPA_C01~P" on "/BIC/EMPA_C01" ("KEY_MPA_C01T", "KEY_MPA_C011", "KEY_MPA_C012", "KEY_MPA_C013", "KEY_MPA_C014", "KEY_MPA_C015", "KEY_MPA_C016", "KEY_MPA_C017", "KEY_MPA_C018", "KEY_MPA_C01P") CLUSTER ALLOW REVERSE SCANS

The script should look like, Note RED text:

CREATE UNIQUE INDEX "/BI0/E0BWTC_C06~P" on "/BI0/E0BWTC_C06" ("KEY_0BWTC_C06T", "KEY_0BWTC_C061", "KEY_0BWTC_C062", "KEY_0BWTC_C063", "KEY_0BWTC_C06U") CLUSTER ALLOW REVERSE SCANS