In our new environment a 14.0 SP2 CA ITCM,
We have two MDB :
D051 -->EM MDB
S051 --> DM MDB
I'll use the EM MDB as an exemple but we have the same errors on the DM.
Until we change the oracle connection from
in the Config.XML and config.properties, there was no connection possible with our Oracle environment.
In DSM Explorer,the default Software Content Download Job always finish in error:
in te CIC.LOG, you'll see:
2018-05-04 08:18:11,451 [CCMain] ERROR [com.ca.sccc.CCException] - java.sql.SQLSyntaxErrorException: ORA-00942: Table ou vue inexistante (table or view does not exist)
Now , I've launch RUN.BAT and 38000 signature appear in software definition, I think it's only the baseline who was upload in the MDB. For me it mean that the oracle connection seem to be working.
We've reinstall CIC via the setup in WindowsProductFiles_x86\CIC
- How do I know what table is missing ?
- Do we have to run the Default Software Content Download Job on both EM and DM ?
- What is chiefs Download/Upload Replication ?
- It seem to be deleting CA_link_sw_def from the DM (it has been running for 1h30 for 25% of the job)
anyone can help ?
Re-run the CIC installation using it's own/separate graphical installer...
..\WindowsProductFiles_x86\CIC\SetupCIC.exe (not setup.exe)
Using the graphical installer for the CIC, you will be able to test the connection to the Oracle database, before the installation proceeds.
It's possible that CIC install failed during the normal setup, and because it's silent/non-interactive, you don't get a chance to test the database connection or provide further configuration of the CIC utility. By calling it directly from the ITCM media, you can run the graphical installer to ensure it gets installed properly.