Checks after phase MAIN_NEWBAS/PARCONV_UPG were negative

[Former Member]

Hi Guys

I am held in this phase Checks after phase MAIN_NEWBAS/PARCONV_UPG were negative, what could be the solution

A Part of Log

2 EGT055XRequest: Delete and recreate "Index /B364/ECPFP_R01-P (DDIC/08.07.15/04:10)"

4 EGT281 sql:

4 EGT231      "DROP INDEX '/B364/ECPFP_R01~P'"

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

3WEDT510 Index "/B364/ECPFP_R01"-"P" completely contains the fields of index "020"

2 EDT502 Index "/B364/ECPFP_R01"-"P" must be created in the database

4 EDT520 Index "/B364/ECPFP_R01"-"P" was successfully activated

4 EGT281 sql:

4 EGT291   "CREATE UNIQUE INDEX '/B364/ECPFP_R01~P' ON""'/B364/ECPFP_R01'"" "" "

4 EGT231      "('KEY_CPFP_R01T',"

4 EGT231      "'KEY_CPFP_R011',"

4 EGT231      "'KEY_CPFP_R012',"

4 EGT231      "'KEY_CPFP_R013',"

4 EGT231      "'KEY_CPFP_R014',"

4 EGT231      "'KEY_CPFP_R015',"

4 EGT231      "'KEY_CPFP_R01U',"

4 EGT231      "'KEY_CPFP_R01P')"

4 EGT231      "PCTFREE 10"

4 EGT231      "INITRANS 002"

4 EGT231      "TABLESPACE PSAPSR3FACT"

4 EGT231      "NOCOMPRESS"

4 EGT231      "STORAGE (INITIAL 0000000000 K"

4 EGT231      "NEXT 0000000000 K"

4 EGT231      "MINEXTENTS 0000000000"

4 EGT231      "MAXEXTENTS 0000000000"

4 EGT231      "PCTINCREASE 0000"

4 EGT231      "FREELISTS 001)"

2 ED0314 ORA-02220: invalid MINEXTENTS storage option value

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

2EEGT236 The SQL statement was not executed

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

2EEGT082 "Index" "/B364/ECPFP_R01-P" could not be created

[Former Member · Accepted solution]

Guys thanks for your responses I have found the solution

First let me make it clear the note1570366_v1_sh.txt  file will works only in Linux environment, not for windows. (if anybody has experience please share it) I tried my best round about solutions with file but no use.

Finally after 2 days of struggle (working on this issue before posting in forum) below is the solution

First make sure you have taken full backup

Secondly execute SE14 then go DB Request menu and select Create with import

(this will display all the index entries which are unable to create and generate this message

"MAIN_NewBAS/PARCONV_UPG")

Select the entries and delete them and continue the phase.

Now my other phase are moving forward if everything goes fine i will let u now what are side effects.

Disclaimer: Neither SAP or ME are responsible for above solution, Did on demo system, who ever fallows try it on your own risk or consult SAP

Expert: Please suggest is this solution is a right way 

[Former Member]

Thanks Divyanshu  and Anand for early reply 

I have already gone through this notes but no luck

can explain how to execute the note1570366_v1_sh.txt in windows server

appreciated

[Former Member]

Answer,

Login with SIDADM and connect as sysdba ,then you should be able to perform this.

Regards

Anand

[Mofizur]

Hi Anwer,

I believe the process is well explained in the note.

To avoid the problem please make sure you have set _FIX_CONTROL = '8937971:ON' as adviced in the parameter note 1431798 and in the SAP Bundle Patch Readme.

But as you have already encountered the problem you need to adjust the values for min_extents and max_extents. Depending on the columns of the table / index there are different methods to do so.You have to follow below setps..

1) Download note1570366_v1_sh.txt to your database server (please transfer the shell script in ascii mode - not binary mode).

2) Create a new working directory and place the shell script there.

Then you have to rename the file and adjust the permissions of the file so you will be able to execute it:

mv note1570366_v1_sh.txt note1570366_v1.sh

chmod 755 note1570366*.sh

3) As the shell script is using some variables please check the header of the script and adjust them according to your needs (e.g. CUSTOMER_NAME, SID, TABOWN, CONN, invptrloc).

4) Running the shell script will only generate some sql files / shell scripts which you later on need to execute manually as adviced by the shell script.

The shell script will also generate update statements for SAP table DDSTORAGE ( PARNAME in INITIAL, NEXT, MINEXTENTS, MAXEXTENTS). Please check the generated file ddstorage_entries_with_0.txt before executing upd_ddstorage.sql carefully. If you have updated table DDSTORAGE please also check SAP note 666061 to make sure the changes will be taken into account by the SAP system.

Afterwards the problem should be solved.

Thanks,

Mofizur

[Former Member]

Hello Anwer,

If you have not set _FIX_CONTROL value '8937971:ON' when creating a table / an index you end up having NULL values for MIN_EXTENTS and MAX_EXTENTS.

As suggested in SAP note 1570366 - ORA-02220 during transport

have you verified all DB parameters are setup correctly before the upgrade.

Please check SAP note 1171650

Regards

Anand

[divyanshu_srivastava3]

Hi Anwer,

Have a look at below KBAs and see if that helps.

1891719 - Get ora-02220 error during upgarde PHASE MAIN_SWITCH/PARMVNT_XCNV when performing EHP upgr...

1536104 - ORA-02220: invalid MINEXTENTS storage option value

Regards,