RE: Checks after phase MAIN_NEWBAS/PARCONV_UPG were negative

      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

      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…

      User Rating: Be the first one !
      TOPCONSULTANT Doctor Asked on November 28, 2016 in netweaver as.
      Add Comment
      1 Answers

        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

        Add Comment

        Your Answer

        By posting your answer, you agree to the privacy policy and terms of service.