on 10-04-2007 4:47 PM
Hi,
any pointers here...
this is a MCOD install, the first instance has been installed perfectly, for the second instance the Central instance has been installed , problems arise when installing the database instance for the second instance, this is the third time i am trying to install it.....
Error in sapinst_dev.log..
****************************************************
FO 2007-10-03 17:52:41 [synxccuren.cpp:716]
CSyCurrentProcessEnvironmentImpl::setUser()
lib=iamodload module=CR3ldStep
Switched to user: prdadm.
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
INFO 2007-10-03 17:52:42 [syxxccuren.hpp:347]
CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(iastring)
lib=iamodload module=CR3ldStep
Working directory changed to C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB.
ERROR 2007-10-03 17:52:42 [iaxxbdbld.cpp:936]
CR3ldStep::startR3ldProcesses lib=iamodload module=CR3ldStep
MSC-01015 Process finished with error(s), check log file C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/SAPSDIC.log
********************************************************************************
Error msg in sapsdic.log
********************************************************************************
(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
Syslog: k xxx : rscpexcc 11
(rscpsumg) Please look also into "C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/SAPSDIC001.xml".
Syslog: k CQ3 : UMGSETTING& rscpexcc 12
(DB) ERROR: DDL statement failed
(CREATE TABLE "/SDF/PAT03" ( "PATCH" VARCHAR2(60) DEFAULT ' ' NOT NULL , "SHORT_TEXT" VARCHAR2(180) DEFAULT ' ' NOT NULL , "STATUS" VARCHAR2(3) DEFAULT ' ' NOT NULL , "DELIV_DATE" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "DELIV_TIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "RESPONSIBL" VARCHAR2(36) DEFAULT ' ' NOT NULL , "IMPLE_DATE" VARCHAR2(24) DEFAULT '00000000' NOT NULL , "IMPLE_TIME" VARCHAR2(18) DEFAULT '000000' NOT NULL , "L_IMPL_REL" VARCHAR2(12) DEFAULT ' ' NOT NULL , "CONFLICTS" VARCHAR2(3) DEFAULT ' ' NOT NULL , "CONFIRMED" VARCHAR2(3) DEFAULT ' ' NOT NULL , "BACKUP" VARCHAR2(60) DEFAULT ' ' NOT NULL , "FROM_REL" VARCHAR2(12) DEFAULT ' ' NOT NULL , "TO_REL" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OS" VARCHAR2(30) DEFAULT ' ' NOT NULL , "DB" VARCHAR2(30) DEFAULT ' ' NOT NULL , "PATCH_TYPE" VARCHAR2(9) DEFAULT ' ' NOT NULL , "ANCESTOR" VARCHAR2(60) DEFAULT ' ' NOT NULL , "STRICT_SEQ" VARCHAR2(3) DEFAULT ' ' NOT NULL , "NO_GEN" VARCHAR2(3) DEFAULT ' ' NOT NULL , "SPAMFIX" VARCHAR2(3) DEFAULT ' ' NOT NULL , "ADDON_ID" VARCHAR2(30) DEFAULT ' ' NOT NULL , "ADDON_REL" VARCHAR2(36) DEFAULT ' ' NOT NULL , "IGN_CONFLI" VARCHAR2(3) DEFAULT ' ' NOT NULL , "AP_ANCEST" VARCHAR2(60) DEFAULT ' ' NOT NULL , "EPSFILSIZ" VARCHAR2(12) DEFAULT ' ' NOT NULL , "HI_ANCEST" VARCHAR2(6) DEFAULT ' ' NOT NULL , "COMP_REL" VARCHAR2(30) DEFAULT ' ' NOT NULL , "COMPONENT" VARCHAR2(90) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPPRD STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
<b> DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
</b>(DB) INFO: disconnected from DB
Can anyone help with this...........or point me in the right direction........
Lets take a look at the error, that you already marked inbold:
CREATE TABLE "/SDF/PAT03"
....
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
SAPINST tries to create a table but the table already exist.
Options
1) as this is the 3rd time you try to install it could be that you have "leftovers" from previous installations
2) as this is is MCOD, perhaps you choosed the wrong schema and it is trying to create the tables on the already existing schema ( not sure if this is checked by sapinst )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Fidel,
Yes after looking at the error, i figured if the table already exists then we can ignore the error..so i set the flag to continue on error...
the sap Installer is stupid, it should check and then continue...it doesent..after i set the installer to continue on error it continued for a lot longer..half a day..this is where it failed again
***********************************************
INSTALL LOG
***********************************************
TRACE [iaxxbdbld.cpp:997]
CR3ldStep::startR3ldProcesses lib=iamodload module=CR3ldStepTST_FINISHED: 2
ERROR 2007-10-04 14:27:07 [iaxxbdbld.cpp:1001]
CR3ldStep::startR3ldProcesses lib=iamodload module=CR3ldStepMSC-01015 Process finished with error(s), check log file C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/SAPSSEXC.log
TRACE [iaxxejsbas.hpp:270]
<b> EJS_Base::dispatchFunctionCall() JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined
</b>TRACE [iaxxcwalker.cpp:301]
CDomWalker::processStep()
<html><head></head><body><p>An error occurred while processing service <b>SAP ERP 2004 SR1> ABAP System> Oracle> Unicode> Database Instance Installation</b>. You may now</p><ul> <li> press 'Retry' to repeat the current step.</li> <li>press the 'View Log' button to get more information about the error.</li> <li>stop the task and continue with it later.</li> <li>reset your input for the current task. In this case, SAPinst will permanently remove all installation files from the installation directory. This gives you the opportunity to restart from scratch.</li></ul><p>Log files are written to <b>C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB</b>.</p></body></html>
TRACE [iaxxgenimp.cpp:845]
showDialog() waiting for an answer from gui
TRACE [iaxxcsihlp.hpp:301]
main()
An error occurred during the installation of component SAP ERP 2004 SR1> ABAP System> Oracle> Unicode> Database Instance Installation. Press the log view button to get extended error information or press OK to terminate the installation. Log files are written to SAP ERP 2004 SR1> ABAP System> Oracle> Unicode> Database Instance Installation.
TRACE [iaxxgenimp.cpp:845]
showDialog() waiting for an answer from gui
***********************************************************
SAPSSEXC.log
***********************************************************
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOTYPEPLS~0" ON "SEOTYPEPLS" ( "CLSNAME", "TYPEGROUP", "VERSION" ) TABLESPACE PSAPPRD640 STORAGE (INITIAL 3095641 NEXT 0000000160K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(DB) ERROR: DDL statement failed
(CREATE TABLE "SPROXDAT" ( "OBJECT" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "OBJECT1" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME1" VARCHAR2(90) DEFAULT ' ' NOT NULL , "OBJECT2" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME2" VARCHAR2(90) DEFAULT ' ' NOT NULL , "INACTIVE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "OBJECT_R" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME_R" VARCHAR2(90) DEFAULT ' ' NOT NULL , "ID" CLOB , "IFR_TYPE" VARCHAR2(90) DEFAULT ' ' NOT NULL , "IFR_NAME" VARCHAR2(300) DEFAULT ' ' NOT NULL , "IFR_TEXT" VARCHAR2(300) DEFAULT ' ' NOT NULL , "IFR_TAGTYP" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IFR_MAXOCC" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_OPTNL" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IFR_DEFLT" CLOB , "IFR_QUALIF" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IFR_XSDTYP" VARCHAR2(90) DEFAULT ' ' NOT NULL , "IFR_LENGTH" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_MAXLEN" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_PATTRN" VARCHAR2(60) DEFAULT ' ' NOT NULL , "IFR_PREC" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_SCALE" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_FAULT" VARCHAR2(3) DEFAULT ' ' NOT NULL , "R3_TYPE" VARCHAR2(12) DEFAULT ' ' NOT NULL , "R3_NAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "R3_TEXT" VARCHAR2(180) DEFAULT ' ' NOT NULL , "R3_DATATYP" VARCHAR2(12) DEFAULT ' ' NOT NULL , "R3_LENGTH" VARCHAR2(18) DEFAULT '000000' NOT NULL , "R3_DECIMAL" VARCHAR2(18) DEFAULT '000000' NOT NULL , "R3_REFTO" VARCHAR2(3) DEFAULT ' ' NOT NULL , "R3_INCLUDE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "R3_SEQNUM" VARCHAR2(18) DEFAULT '000000' NOT NULL , "CATEGORY" VARCHAR2(90) DEFAULT ' ' NOT NULL , "DIRECTION" VARCHAR2(3) DEFAULT ' ' NOT NULL , "INSTANCE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "SYNCHRON" VARCHAR2(3) DEFAULT ' ' NOT NULL , "KEY_PARAM" VARCHAR2(3) DEFAULT ' ' NOT NULL , "PROBLEMS" VARCHAR2(60) DEFAULT ' ' NOT NULL , "WARNINGS" VARCHAR2(60) DEFAULT ' ' NOT NULL , "PROBL_INF" VARCHAR2(30) DEFAULT ' ' NOT NULL , "FURTHERDATA" CLOB ) TABLESPACE PSAPPRD640 LOB ("ID", "IFR_DEFLT", "FURTHERDATA") STORE AS (CACHE) STORAGE (INITIAL 6931583 NEXT 0000010240K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(IMP) INFO: import of SPROXDAT completed (15272 rows) #20071004142037
(DB) INFO: SPROXDAT~0 created #20071004142038
(DB) INFO: SPROXDAT~REF created #20071004142038
(DB) INFO: SPROXHDR created #20071004142043
(IMP) INFO: import of SPROXHDR completed (3830 rows) #20071004142049
ANY ONE HERE FROM SAP WHO CAN HELP, WHO REALLY KNOW WHAT THEY ARE DOING
Regards
Ravi
Fidel,
Yes after looking at the error, i figured if the table already exists then we can ignore the error..so i set the flag to continue on error...
the <b>sap Installer is stupid</b>, it should check and then continue...it doesent..after i set the installer to continue on error it continued for a lot longer..half a day..this is where it failed again
***********************************************
INSTALL LOG
***********************************************
TRACE [iaxxbdbld.cpp:997]
CR3ldStep::startR3ldProcesses lib=iamodload module=CR3ldStepTST_FINISHED: 2
ERROR 2007-10-04 14:27:07 [iaxxbdbld.cpp:1001]
CR3ldStep::startR3ldProcesses lib=iamodload module=CR3ldStepMSC-01015 Process finished with error(s), check log file C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB/SAPSSEXC.log
TRACE [iaxxejsbas.hpp:270]
<b> EJS_Base::dispatchFunctionCall() JS Callback has thrown std::ESAPinstException: ESAPinstException: error text undefined
</b>TRACE [iaxxcwalker.cpp:301]
CDomWalker::processStep()
<html><head></head><body><p>An error occurred while processing service <b>SAP ERP 2004 SR1> ABAP System> Oracle> Unicode> Database Instance Installation</b>. You may now</p><ul> <li> press 'Retry' to repeat the current step.</li> <li>press the 'View Log' button to get more information about the error.</li> <li>stop the task and continue with it later.</li> <li>reset your input for the current task. In this case, SAPinst will permanently remove all installation files from the installation directory. This gives you the opportunity to restart from scratch.</li></ul><p>Log files are written to <b>C:\Program Files\sapinst_instdir\ECC04SR1\WEBAS_ABAP_ORA_UC\DB</b>.</p></body></html>
TRACE [iaxxgenimp.cpp:845]
showDialog() waiting for an answer from gui
TRACE [iaxxcsihlp.hpp:301]
main()
An error occurred during the installation of component SAP ERP 2004 SR1> ABAP System> Oracle> Unicode> Database Instance Installation. Press the log view button to get extended error information or press OK to terminate the installation. Log files are written to SAP ERP 2004 SR1> ABAP System> Oracle> Unicode> Database Instance Installation.
TRACE [iaxxgenimp.cpp:845]
showDialog() waiting for an answer from gui
***********************************************************
SAPSSEXC.log
***********************************************************
(DB) ERROR: DDL statement failed
(CREATE UNIQUE INDEX "SEOTYPEPLS~0" ON "SEOTYPEPLS" ( "CLSNAME", "TYPEGROUP", "VERSION" ) TABLESPACE PSAPPRD640 STORAGE (INITIAL 3095641 NEXT 0000000160K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
<b>ORA-00955: name is already used by an existing object
(DB) ERROR: DDL statement failed</b>
(CREATE TABLE "SPROXDAT" ( "OBJECT" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "OBJECT1" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME1" VARCHAR2(90) DEFAULT ' ' NOT NULL , "OBJECT2" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME2" VARCHAR2(90) DEFAULT ' ' NOT NULL , "INACTIVE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "OBJECT_R" VARCHAR2(12) DEFAULT ' ' NOT NULL , "OBJ_NAME_R" VARCHAR2(90) DEFAULT ' ' NOT NULL , "ID" CLOB , "IFR_TYPE" VARCHAR2(90) DEFAULT ' ' NOT NULL , "IFR_NAME" VARCHAR2(300) DEFAULT ' ' NOT NULL , "IFR_TEXT" VARCHAR2(300) DEFAULT ' ' NOT NULL , "IFR_TAGTYP" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IFR_MAXOCC" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_OPTNL" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IFR_DEFLT" CLOB , "IFR_QUALIF" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IFR_XSDTYP" VARCHAR2(90) DEFAULT ' ' NOT NULL , "IFR_LENGTH" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_MAXLEN" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_PATTRN" VARCHAR2(60) DEFAULT ' ' NOT NULL , "IFR_PREC" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_SCALE" NUMBER(10) DEFAULT 0 NOT NULL , "IFR_FAULT" VARCHAR2(3) DEFAULT ' ' NOT NULL , "R3_TYPE" VARCHAR2(12) DEFAULT ' ' NOT NULL , "R3_NAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "R3_TEXT" VARCHAR2(180) DEFAULT ' ' NOT NULL , "R3_DATATYP" VARCHAR2(12) DEFAULT ' ' NOT NULL , "R3_LENGTH" VARCHAR2(18) DEFAULT '000000' NOT NULL , "R3_DECIMAL" VARCHAR2(18) DEFAULT '000000' NOT NULL , "R3_REFTO" VARCHAR2(3) DEFAULT ' ' NOT NULL , "R3_INCLUDE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "R3_SEQNUM" VARCHAR2(18) DEFAULT '000000' NOT NULL , "CATEGORY" VARCHAR2(90) DEFAULT ' ' NOT NULL , "DIRECTION" VARCHAR2(3) DEFAULT ' ' NOT NULL , "INSTANCE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "SYNCHRON" VARCHAR2(3) DEFAULT ' ' NOT NULL , "KEY_PARAM" VARCHAR2(3) DEFAULT ' ' NOT NULL , "PROBLEMS" VARCHAR2(60) DEFAULT ' ' NOT NULL , "WARNINGS" VARCHAR2(60) DEFAULT ' ' NOT NULL , "PROBL_INF" VARCHAR2(30) DEFAULT ' ' NOT NULL , "FURTHERDATA" CLOB ) TABLESPACE PSAPPRD640 LOB ("ID", "IFR_DEFLT", "FURTHERDATA") STORE AS (CACHE) STORAGE (INITIAL 6931583 NEXT 0000010240K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(IMP) INFO: import of SPROXDAT completed (15272 rows) #20071004142037
(DB) INFO: SPROXDAT~0 created #20071004142038
(DB) INFO: SPROXDAT~REF created #20071004142038
(DB) INFO: SPROXHDR created #20071004142043
(IMP) INFO: import of SPROXHDR completed (3830 rows) #20071004142049
***************************************************************************************************
ANY ONE HERE FROM SAP WHO CAN HELP, WHO REALLY KNOW WHAT THEY ARE DOING
Regards
Ravi
Hi,
> ANY ONE HERE FROM SAP WHO CAN HELP, WHO REALLY KNOW WHAT THEY ARE DOING
- You should not "shout"
- To address SAP, please open a message on the SAP Service Marketplace, here people ( SAP and not SAP ) helps in a volunteer basis, no obligation, so it is nice to be nice.
"sap instaler is stupid", I do not agree on this at all.
SAPInst expect that you perform an installation on an empty schema ( because that is the <b>normal</b> thing to do ) SAPinst does not expect that <b>you </b>aborted the installation, left some things and started again.
An then you hit the <b>same error </b> again:
<b>ORA-00955: name is already used by an existing object (DB) ERROR: DDL statement failed </b>
As this is an MCOD, I have to assume that this table is from the "failed" schema.
As it seems that you are "stepping on the same stone twice" what you should abort the installation and clean up all leftovers ( including dropping the failed schema ) and start again from scratch
If there are tables (plural) created from your last failed attempt, it will fail for each of the tables.
Fidel,
Its nice to be nice, i concur...i was just frustrated...no one is able to point me in the right direction...
As for the ORA-00955...i changed the installer to continue_on_error and it went past all of these errors...
As with reference to your statement....that i should drop the failed schema....can you point me to some steps for the same..................................and yes the sap installer is stupid it should detect that the tables are already there and then validate that status is ok then continue..thats expected behaviour from such a highly evolved installer..wouldent you say so, your statement indicates that this is a basic installer.
Like i said all help is appreciated....
Fidel,
Changing the stop_on_error to continue_on_error and this actually went past the previous problems....questions is what now ?
Can some one help ??
(CREATE TABLE "RSDMTPN_SRV_PAR" ( "SERVICE_ID" VARCHAR2(90) DEFAULT ' ' NOT NULL , "NAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "PARAM_TYPE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "DATA_TYPE" VARCHAR2(12) DEFAULT ' ' NOT NULL , "FIELD_LENGTH" VARCHAR2(9) DEFAULT '000' NOT NULL , "MANDATORY" VARCHAR2(3) DEFAULT ' ' NOT NULL , "DEFAULT_VALUE" CLOB , "HAS_INTERVALS" VARCHAR2(3) DEFAULT ' ' NOT NULL , "IS_TABLE" VARCHAR2(3) DEFAULT ' ' NOT NULL , "DATA_TYPE_NAME" VARCHAR2(90) DEFAULT ' ' NOT NULL , "DECIMALS" VARCHAR2(18) DEFAULT '000000' NOT NULL , "CONTENT_TYPE" VARCHAR2(9) DEFAULT ' ' NOT NULL ) TABLESPACE PSAPPRD LOB ("DEFAULT_VALUE") STORE AS (CACHE) STORAGE (INITIAL 16384 NEXT 0000000040K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )
DbSlExecute: rc = 102
(SQL error 955)
error message returned by DbSl:
ORA-00955: name is already used by an existing object
(IMP) INFO: import of RSDMTPN_SRV_PAR completed (95 rows) #20071004124519
to check which schema users already have a table, do this:
cmd> sqlplus "/ as sysdba"
SQL>
<b>select owner, table_name from dba_tables where table_name = '"/SDF/PAT03"</b>
OWNER TABLE_NAME
------------------------------ ------------------------------
SAPR3 /SDF/PAT03
Regards Michael
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.