Hi,
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
<mdbConn>jdbc:oracle:thin:@chiefs.Domain:1521:d051</mdbConn>
to
<mdbConn>jdbc:oracle:thin:@chiefs.Domain:1521/d051</mdbConn>
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 ?
Thank
Rémy D.