Index problem during import phase

[Former Member]

Hi,

I have a
problem with my BW import on a new system.

During the import I get the follow error messages;

   First Error

     DB) ERROR: DDL statement failed

    (   CREATE BITMAP            INDEX "/BIC/FZPT_C02~010"
        ON "/BIC/FZPT_C02"        ("KEY_ZPT_C02P")        LOCAL        PCTFREE 10        INITRANS 002        TABLESPACE             PSAPSR3                      STORAGE (INITIAL     0000000016 K                 NEXT        0000002560 K                 MINEXTENTS            0000000001                 MAXEXTENTS  UNLIMITED                 PCTINCREASE 0000                 FREELISTS   001) PARALLEL )

          DbSlExecute: rc = 99

         (SQL error 14016)  error
          message returned by DbSl:

           ORA-14016: underlying table of a LOCAL
          partitioned index must be partitioned

           (DB) INFO: disconnected from DB

Second error

(DB) ERROR: DDL statement failed

(CREATE UNIQUE INDEX
"DYNPSOURCE~0" ON "DYNPSOURCE" ( "PROGNAME",
"DYNPNUMBER", "R3STATE" ) TABLESPACE PSAPSR3700 STORAGE
(INITIAL 0000000016K NEXT 0000000160K MINEXTENTS 0000000001 MAXEXTENTS
2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS PARALLEL 4 )

DbSlExecute: rc = 99

(SQL error 12801)  error message returned by DbSl:

ORA-12801: error signaled in parallel query server P001

ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

  (DB) INFO: disconnected from DB

Before I started the export I running program smigr_create_ddl.

How can I solve these errors?

Kind regards

Christiaan

[former_member188883 · Accepted solution]

Hi Wachtmeester,

You can stop the import now. Check at database level whether this index already exists.

If yes, you have 2 options

1) Drop the existing index and then resume the import phase.

2) Ignore this index creation step.

    Open import_properties file in the sapinst_instdir ( installation log folder).  change the status to ign and then proceed with import again.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Hi Guys,

Thank for your help. The import is finished now.

Ik skipt the status create indexes.

Kind Regards,

Christiaan

[former_member188883]

Hi Christian,

As the problem is resolved please close this thread.

Regards,

Deepak Kori

[Reagan]

Create the index as a non unique index

Regards

RB

[nirmal_konchada]

Hi,

Did u execute the SMIGR_CREATE_DDL program on the BW system before export?

Regards,

Nirmal

[former_member188883]

Hi Christian,

For other issue

(SQL error 12801)  error message returned by DbSl:
ORA-12801: error signaled in parallel query server P001
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
  (DB) INFO: disconnected from DB

Refer to solution in the thread https://scn.sap.com/thread/1450117

Hope this helps.

Regards,

Deepak Kori