Clarity Client Automation

Expand all | Collapse all

CIC error with oracle connection

Jump to Best Answer
  • 1.  CIC error with oracle connection

    Posted 05-04-2018 09:33 AM

    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.

    Attachment(s)

    zip
    CIC.log.zip   8K 1 version
    zip
    CIC_Util.log.zip   378B 1 version
    zip
    Wrapper.log.zip   361B 1 version


  • 2.  Re: CIC error with oracle connection
    Best Answer

    Posted 05-07-2018 10:27 AM

    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.