Installing the Cumulative Fix 2 Pack (CF2) using the Common Installer on a Service Desk Manager (SDM) running on Oracle, the setupmdb step fails to complete.
The install_hsrvdesk.log file generated by the proceeding shows messages as follows:
12-04,16:45:52 DEBUG - error occurred during batching: ORA-01921: role name 'REGADMIN' conflicts with another user or role name
12-04,16:45:52 INFO - REGADMIN.xml is added to the retry queue.
12-04,16:45:52 INFO - MDBTools_0303I - Processing role: AMS_GROUP.xml timestamp: 2008-04-22T09:17:01+0000
12-04,16:45:52 INFO - MDBTools_0306I - SQL text:
12-04,16:45:52 INFO - CREATE ROLE AMS_GROUP
Update sql failed:
CREATE ROLE AMS_GROUP
The problem is usually seen in environments running SDM with MDB on Oracle.
In this specific case, the problem occurred on SDM 14.1, but may occur to other SDM releases running on Oracle.
setupmdb -DBVENDOR=oracle -JRE_DIR=C:\PROGRA~2\CA\SC\JRE\1.7.0_10
-DBNAME=ORCL -DBUSER=sys -DBPASSWORD=sys
setupmdb.bat may need to be run by adding the "–DBPORT" option to
provide the correct port number for some SQL server installations
if the default port is changed or a named instance of SQL Server
is used. Run setupmdb.bat -help to list all options.
A Patch log file created in the same directory that setupmdb.bat
There is no uninstall mechanism for this patch.
To restore DB to Pre-patch status use the relevant database
restore utility. Should the patch install fail the transactions
within the current patch sql script will be rolled back. Patches
containing multiple sql scripts will commit those scripts that
apply successfully. Where a sql script fails within a multi-script
patch that script will be rolled back and patch application
terminated. Scripts already committed will not be rolled back.
The folder JRE_DIR=C:\PROGRA~2\CA\SC\JRE\1.7.0_10 may not exist
when the MDB is on a remote standalone database server.
If it does not exist, please copy the JRE folder we deliver from
the SDM server to the database server before running the setupmdb
If JAVA is installed on a 64 bit machine then 1(f) step will be:
setupmdb -DBVENDOR=mssql -JRE_DIR=C:\PROGRA~2\CA\SC\JRE\1.7.0_10…
If JAVA is installed on a 32 bit machine then 1(f) step will be:
setupmdb -DBVENDOR=mssql -JRE_DIR=C:\PROGRA~1\CA\SC\JRE\1.7.0_10…
Note: The above is an example when installed on drive C. If the JRE was installed
on a drive other than C, please modify accordingly.
Refer to the file below for the list of Roles which failed to be created: