Solved: Installation problem with Solution Manager 4.0 on ...

Former Member · ‎06-01-2007

Hello,

I'm receving the following error message while running SAPinst on step 11 Create Database:

ERROR 2007-05-31 23:20:32

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-955 for defaultdest

OLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2007-05-31 23:20:32

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2007-05-31 23:20:32

FCO-00011 The step runCatprocSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql was executed with status ERROR .

I've read the log file referenced above and did not find any additional details.

I'll post the entire log below as well:

INFO 2007-05-31 15:05:44

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.4.xml'.

INFO 2007-05-31 15:05:45

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/inifile.5.xml'.

INFO 2007-05-31 15:05:52

Execute step

Component W2K_ServicePack_Check|ind|ind|ind|ind

Preprocess of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_First_Steps|ind|ind|ind|ind|0|0|W2K_ServicePack_Check|ind|ind|ind|ind|2|0.

INFO 2007-05-31 15:06:11

Copied file 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/keydb.xml' to 'C:/Program Files/sapinst_instdir/SOLMAN/SYSTEM/ORA/CENTRAL/AS/keydb.3.xml'.

INFO 2007-05-31 15:06:11

Execute step runCatprocSql of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0.

INFO 2007-05-31 15:06:16

Removing file C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\ora_query3_tmp0_1.sql.

INFO 2007-05-31 15:06:16

Creating file C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\ora_query3_tmp0_1.sql.

INFO 2007-05-31 15:06:18

Switched to user: sm1adm.

INFO 2007-05-31 15:06:18

Working directory changed to C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS.

INFO 2007-05-31 15:07:03

Switched to user: sm1adm.

INFO 2007-05-31 15:07:06

Working directory changed to C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS.

ERROR 2007-05-31 15:21:34

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-955 for defaultdest

SQL> Rem bnainani 11/29/00 - specify compatible=8.0 for create_queue_table

SQL> Rem liwong 10/20/00 - add def$_destination.flag

SQL> Rem bnainani 11/15/00 - specify compatible=8.0 for queue table

SQL> Rem narora 09/13/00 - add comment on new def$_destination columns

SQL> Rem liwong 09/01/00 - add master w/o quiesce: fixes

SQL> Rem liwong 07/12/00 - add total_prop_time_lat

SQL> Rem liwong 06/29/00 - add total_txn_count, total_prop_time

SQL> Rem liwong 05/17/00 - add_master_db w/o quiesce

SQL> Rem jstamos 05/17/00 - add_master_db w/o quiesce

SQL> Rem elu 01/24/00 - add column apply_init to def$_destination

SQL> Rem alakshmi 12/02/99 - Bug 979398: Before-row insert trigger on

SQL> Rem def$_propagator

SQL> Rem wesmith 10/31/98 - change shape of table def$_pushed_transactions

SQL> Rem jnath 02/23/98 - bug 601972: split anonymous pl/sql blocks

SQL> Rem wesmith 01/21/98 - create def$_pushed_transactions table for

SQL> Rem server-side RepAPI

SQL> Rem nbhatt 07/27/97 - change create_queuetable -> create_queue_table

SQL> Rem nbhatt 04/21/97 - change 'TRACKING' in CREATE_QUEUE to 'DEPENDENCY

SQL> Rem nbhatt 04/21/97 - change syntax of create_queue

SQL> Rem liwong 04/16/97 - Alter view system.AQ$DEF$_AQ{CALL,ERROR}

SQL> Rem liwong 04/11/97 - Fixing defaultdest_primary typo

SQL> Rem jstamos 04/10/97 - remove unneeded indexes

SQL> Rem nbhatt 04/08/97 - change create_qtable to create_queuetable

SQL> Rem jstamos 04/04/97 - tighter AQ integration

SQL> Rem liwong 04/02/97 - Add schema_name, package_name in def$_calldest

SQL> Rem ato 03/31/97 - create_qtable interface change

SQL> Rem liwong 03/25/97 - remove batch_no from def$_tranorder

SQL> Rem liwong 02/24/97 - pctversion --> 0 for def$_aqcall, def$_aqerror

SQL> Rem liwong 02/22/97 - Remove dropping view aq$def$_aqcall

SQL> Rem ademers 02/07/97 - Remove constraint def$_calldest_call

SQL> Rem liwong 01/11/97 - drop and create aq$def$_aqcall (temporary)

SQL> Rem liwong 01/10/97 - Alter view aq$def$_aqcall

SQL> Rem liwong 01/07/97 - Alter default value for batch_no

SQL> Rem jstamos 12/23/96 - change temp$nclob col

SQL> Rem jstamos 11/21/96 - nchar support

SQL> Rem sjain 11/11/96 - Remove dummy buffer # comment

SQL> Rem asgoel 11/05/96 - Disable misc_tracking in def$_aqerror

SQL> Rem sjain 11/06/96 - deferror changes

SQL> Rem vkrishna 10/28/96 - change STORED IN to STORE AS for lob

SQL> Rem sjain 10/02/96 - Aq conversion

SQL> Rem sbalaram 09/24/96 - ARPC performance - add foreign key index

SQL> Rem jstamos 09/06/96 - rename temp$lob and temporarily change nclob

SQL> Rem sjain 09/03/96 - AQ converson

SQL> Rem ademers 08/02/96 - queue_batch default in def_destination

SQL> Rem ademers 07/29/96 - queue_batch default in def_call

SQL> Rem ademers 07/29/96 - queue_batch default

SQL> Rem jstamos 07/24/96 - add system.temp$lob

SQL> Rem sbalaram 07/22/96 - create def$_aqcall and def$_aqerror tables

SQL> Rem jstamos 06/12/96 - LOB support for deferred RPCs

SQL> Rem ldoo 06/28/96 - Comment out queue_table from def_tranorder

SQL> Rem ademers 05/30/96 - create def_origin

SQL> Rem ademers 05/28/96 - fix def_destination col names

SQL> Rem ldoo 05/09/96 - New security model

SQL> Rem sjain 05/01/96 - add seq col to def_destination

SQL> Rem ademers 04/29/96 - add batch_no, dep_scn to def_call

SQL> Rem jstamos 12/04/95 - 324303: use index to avoid sorting the queue

SQL> Rem jstamos 08/17/95 - code review changes

SQL> Rem jstamos 08/16/95 - add comments to tables

SQL> Rem wmaimone 01/04/96 - 7.3 merge

SQL> Rem hasun 01/31/95 - Modify tables. SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2007-05-31 15:21:34

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2007-05-31 15:21:34

FCO-00011 The step runCatprocSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql was executed with status ERROR .

INFO 2007-05-31 23:06:17

An error occured and the user decided to retry the current step: "|NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql".

INFO 2007-05-31 23:06:18

Removing file C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\ora_query3_tmp0_1.sql.

INFO 2007-05-31 23:06:18

Creating file C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS\ora_query3_tmp0_1.sql.

INFO 2007-05-31 23:06:18

Switched to user: sm1adm.

INFO 2007-05-31 23:06:18

Working directory changed to C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS.

INFO 2007-05-31 23:06:20

Switched to user: sm1adm.

INFO 2007-05-31 23:06:20

Working directory changed to C:\Program Files\sapinst_instdir\SOLMAN\SYSTEM\ORA\CENTRAL\AS.

ERROR 2007-05-31 23:20:32

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-955 for defaultdest

SQL> Rem bnainani 11/29/00 - specify compatible=8.0 for create_queue_table

SQL> Rem liwong 10/20/00 - add def$_destination.flag

SQL> Rem bnainani 11/15/00 - specify compatible=8.0 for queue table

SQL> Rem narora 09/13/00 - add comment on new def$_destination columns

SQL> Rem liwong 09/01/00 - add master w/o quiesce: fixes

SQL> Rem liwong 07/12/00 - add total_prop_time_lat

SQL> Rem liwong 06/29/00 - add total_txn_count, total_prop_time

SQL> Rem liwong 05/17/00 - add_master_db w/o quiesce

SQL> Rem jstamos 05/17/00 - add_master_db w/o quiesce

SQL> Rem elu 01/24/00 - add column apply_init to def$_destination

SQL> Rem alakshmi 12/02/99 - Bug 979398: Before-row insert trigger on

SQL> Rem def$_propagator

SQL> Rem wesmith 10/31/98 - change shape of table def$_pushed_transactions

SQL> Rem jnath 02/23/98 - bug 601972: split anonymous pl/sql blocks

SQL> Rem wesmith 01/21/98 - create def$_pushed_transactions table for

SQL> Rem server-side RepAPI

SQL> Rem nbhatt 07/27/97 - change create_queuetable -> create_queue_table

SQL> Rem nbhatt 04/21/97 - change 'TRACKING' in CREATE_QUEUE to 'DEPENDENCY

SQL> Rem nbhatt 04/21/97 - change syntax of create_queue

SQL> Rem liwong 04/16/97 - Alter view system.AQ$DEF$_AQ{CALL,ERROR}

SQL> Rem liwong 04/11/97 - Fixing defaultdest_primary typo

SQL> Rem jstamos 04/10/97 - remove unneeded indexes

SQL> Rem nbhatt 04/08/97 - change create_qtable to create_queuetable

SQL> Rem jstamos 04/04/97 - tighter AQ integration

SQL> Rem liwong 04/02/97 - Add schema_name, package_name in def$_calldest

SQL> Rem ato 03/31/97 - create_qtable interface change

SQL> Rem liwong 03/25/97 - remove batch_no from def$_tranorder

SQL> Rem liwong 02/24/97 - pctversion --> 0 for def$_aqcall, def$_aqerror

SQL> Rem liwong 02/22/97 - Remove dropping view aq$def$_aqcall

SQL> Rem ademers 02/07/97 - Remove constraint def$_calldest_call

SQL> Rem liwong 01/11/97 - drop and create aq$def$_aqcall (temporary)

SQL> Rem liwong 01/10/97 - Alter view aq$def$_aqcall

SQL> Rem liwong 01/07/97 - Alter default value for batch_no

SQL> Rem jstamos 12/23/96 - change temp$nclob col

SQL> Rem jstamos 11/21/96 - nchar support

SQL> Rem sjain 11/11/96 - Remove dummy buffer # comment

SQL> Rem asgoel 11/05/96 - Disable misc_tracking in def$_aqerror

SQL> Rem sjain 11/06/96 - deferror changes

SQL> Rem vkrishna 10/28/96 - change STORED IN to STORE AS for lob

SQL> Rem sjain 10/02/96 - Aq conversion

SQL> Rem sbalaram 09/24/96 - ARPC performance - add foreign key index

SQL> Rem jstamos 09/06/96 - rename temp$lob and temporarily change nclob

SQL> Rem sjain 09/03/96 - AQ converson

SQL> Rem ademers 08/02/96 - queue_batch default in def_destination

SQL> Rem ademers 07/29/96 - queue_batch default in def_call

SQL> Rem ademers 07/29/96 - queue_batch default

SQL> Rem jstamos 07/24/96 - add system.temp$lob

SQL> Rem sbalaram 07/22/96 - create def$_aqcall and def$_aqerror tables

SQL> Rem jstamos 06/12/96 - LOB support for deferred RPCs

SQL> Rem ldoo 06/28/96 - Comment out queue_table from def_tranorder

SQL> Rem ademers 05/30/96 - create def_origin

SQL> Rem ademers 05/28/96 - fix def_destination col names

SQL> Rem ldoo 05/09/96 - New security model

SQL> Rem sjain 05/01/96 - add seq col to def_destination

SQL> Rem ademers 04/29/96 - add batch_no, dep_scn to def_call

SQL> Rem jstamos 12/04/95 - 324303: use index to avoid sorting the queue

SQL> Rem jstamos 08/17/95 - code review changes

SQL> Rem jstamos 08/16/95 - add comments to tables

SQL> Rem wmaimone 01/04/96 - 7.3 merge

SQL> Rem hasun 01/31/95 - Modify tables. SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ERROR 2007-05-31 23:20:32

MUT-03025 Caught ESAPinstException in Modulecall: ESAPinstException: error text undefined.

ERROR 2007-05-31 23:20:32

FCO-00011 The step runCatprocSql with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|runCatprocSql was executed with status ERROR .

Thanks in advnace for your help,

Glen

Former Member · ‎06-11-2007

It seems that the problem resulted from an incorrect patch level on Oracle 10.2. I ran the installatio without any patches and made it thru this phase.

Former Member · ‎06-05-2007

Hi Ragu,

I tried both of your suggestions, but got the same message again. Any other possibilities?

Thanks,

Glen

raguraman_c · ‎06-04-2007

Hi,

The problem seem to be, its trying to create the same table again and hence the oracle error ORA-995.

First try restarting the installation. If doesn't work, clean up and start from the beginning.

Hope this solves your problem.

Feel free to revert back.

--Ragu

Installation problem with Solution Manager 4.0 on Windows 2003/Oracle 10.2

Accepted Solutions (1)

Accepted Solutions (1)

Answers (2)

Answers (2)

Re: HTTP Receiver adapter with Dynamic value in UR...

How to create a rolling forecast in SAC? I have an...

In SAP Hana Cloud, do packages exist as database o...

Re: Mass Update a Zfield in Std Table with Split &...

Re: Change BW Query Initial Variable Input at runt...