cancel
Showing results for 
Search instead for 
Did you mean: 

erp2004 sr1 install.....

ravi_raman2
Active Contributor
0 Kudos

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........

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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 )

ravi_raman2
Active Contributor
0 Kudos

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>&nbsp;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

ravi_raman2
Active Contributor
0 Kudos

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>&nbsp;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

0 Kudos

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.

ravi_raman2
Active Contributor
0 Kudos

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....

ravi_raman2
Active Contributor
0 Kudos

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

ravi_raman2
Active Contributor
0 Kudos

Guyz,

Thank you all for the support the issue has been resolved....

Regards

Ravi

Former Member
0 Kudos

Hello Ravi,

We are having the same problem. Could you tell us how you solved the problem?

Thanks. BR

ravi_raman2
Active Contributor
0 Kudos

Hi Francisco..

Is the problem still there.......

Ravi

Answers (1)

Answers (1)

Former Member
0 Kudos

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