on 08-31-2012 8:07 AM
Hi people.
I'm installing PI 7.3 EHP1 on Windows 2008 Server R2 and Oracle 11.2.0.3.
The setup wizard in the phase of execution, fails at the step "Import ABAP" during the following index creation step:
DbSl Trace: ORA-01452 occurred at SQL stmt (parse error offset=38)
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "IWREFERENC~0" ON "IWREFERENC" ( "ID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016K NEXT 0000000160K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS )
DbSlExecute: rc = 99
(SQL error 1452)
error message returned by DbSl:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
(DB) INFO: disconnected from DB
Unfortunately, I haven't expertise in Oracle and I'm in trouble for this.
I tried to drop the index hoping that restarting the step it could be recreate but seems that the index doesn't exist
SQL> DROP INDEX "IWREFERENC~0";
DROP INDEX "IWREFERENC~0"
*
ERROR at line 1:
ORA-01418: specified index does not exist
I tried too recreate the index like reported into the log but my inexperience doesn't help me.
SQL> (CREATE UNIQUE INDEX "IWREFERENC~0" ON "IWREFERENC" ( "ID" ) TABLESPACE PSAPSR3 STORAGE (INITIAL 0000000016K NEXT 0000000160K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) NOLOGGING COMPUTE STATISTICS );
ERROR at line 1:
ORA-00928: missing SELECT keyword
My question is, is this a SQL problem or I wrong something setuping the installation?
In any case, could you help me?
Thanks a lot and ciao
Nicola
better reinstall the whole process (recommended).
But if you want to continue then search the table content 'IWREFERENC' for the same key on field ID. compare the record and decide it by yourself which record will be deleted. then retry your installation. It should let you proceed.
SAPSR3.IWREFERENC --> fiedl ID --> backup and delete duplicated records from it. ( not recommended)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nicola,
Its always better to start the installation again by terminating the present one.
Even though the error is fixed you might face further issue while proceeding further.
Please download the dump again and start from scratch.
Regards,
Sandeep Singh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Nicola,
i guess the SAP note 23237 could help here (though it rather complicated)
The second option is to try the installation process from scratch...
Best regards and good luck.
Ilya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nicola,
Did the installation terminate at any point and was restarted? Cause of termination being something like a power outage ..
Regards.
Ruchit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.