Default software content download job is running successfully with OK status but system status messages on domain manager still showing message " Software Contents are XX days old ".

Document ID : KB000007202
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Default software content download job is running successfully with OK status but system status messages on domain manager ITCM Explorer still showing  " Software Contents are XX days old " status.(As shown in below screenshot). 

contnet 15 days old.jpg

 

Environment:
ITCM 14.0 SQL 2012
Cause:

The system status message is dependent on CIC job . The message will not go away due to some configuration issues at CIC side. 

Resolution:

1. Check if " Default Software Content download job " showing OK status in System Engine task list. 

Engine Showing job running OK.jpg

2. Check CIC.log from C:\Program Files (x86)\CA\SC\CIC\logs and see if it run with OK status. 

 

2017-06-13 13:52:52,017 [CCMain] INFO  [com.ca.sccc.CCMain] - 

2017-06-13 13:52:52,017 [CCMain] INFO  [com.ca.sccc.CCMain] - CIC initial configuration completed

2017-06-13 13:52:52,017 [CCMain] INFO  [com.ca.sccc.CCMain] - 

2017-06-13 13:52:52,017 [CCMain] INFO  [com.ca.sccc.CCMain] - ****** CIC cycle: 1 started ********* [CIC version: 14.0.0000.0199 (I201603151749D)]

2017-06-13 13:52:52,017 [CCMain] INFO  [com.ca.sccc.CCMain] -  

2017-06-13 13:52:52,017 [CCMain] INFO  [com.ca.sccc.CCMain] - Cycle 1 completed with status: OK. Elapsed time 1 minutes.

2017-06-13 13:52:52,017 [CCMain] INFO  [com.ca.sccc.CCMain] - CIC completed normally

 

3. Check config.xml has correct SQL server name and application registration. (Location of config.xml file C:\Program Files (x86)\CA\SC\CIC\conf)

For Example : 

<MDB_properties_by_domain>

    <domain>

      <domainName>DC-CL-EM</domainName>

      <mdbConn>jdbc:sqlserver://DC-CL-EM\CLEMDB:1433</mdbConn>

      <mdbName>mdb</mdbName>

      <mdbPassword>aW2yAr/ZENaBvfAMshjYFg==</mdbPassword>

      <mdbUser>cicuser</mdbUser>

      <className>com.microsoft.sqlserver.jdbc.SQLServerDriver</className>

      <validationQuery/>

      <maxIdleSessions>-1</maxIdleSessions>

      <maxPoolSessions>10</maxPoolSessions>

      <evictIdleTime>600000</evictIdleTime>

      <evictInterval>60000</evictInterval>

    </domain>

  </MDB_properties_by_domain>

  <content_server_connection_properties>

    <url>130.200.94.30</url>

    <unitId>c4ccc82f-4146-03e7-b61a-a974e7852c1e</unitId>

    <proxyName>10.20.113.6</proxyName>

    <proxyPort>9123</proxyPort>

    <proxyUser>emsadmin</proxyUser>

    <proxyPassword>leHDCkeo6RnH3BHRmmuy8w==</proxyPassword>

    <useHttps>true</useHttps>

    <iTechSponsorPort>443</iTechSponsorPort>

    <connectIntervalMinutes>1440</connectIntervalMinutes>

    <minimumRetryMinutes>5</minimumRetryMinutes>

    <httpclientLogLevel>ERROR</httpclientLogLevel>

    <fipsmode>on</fipsmode>

  </content_server_connection_properties>

  <applications>

    <DSM>

      <id>B1B13849-08D1-4DA6-91EA-2D278E5F00CC</id>

      <licenseKey>PMDSM-00000-00000-00001</licenseKey>

      <MDBRole>ca_itrm_group</MDBRole>

    </DSM>

 

  <UPM><id>682DCD15-5C94-4321-842D-E3944D3CA000</id><licenseKey>PMUPM-00000-00000-00001</licenseKey><MDBRole>ca_itrm_group</MDBRole></UPM></applications>

4. Execute the below query on mdb . It will give the result of software content download job last executed. 

SELECT dateadd( ss, last_message_number + datediff(ss,getutcdate(),getdate()), convert(datetime,'19700101'))

FROM ca_acme_checkpoint

WHERE message_version_number=1001 and message_type_uuid=0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF

 

5. Check config.xml <various_control_properties> section. If domain manager has internet connection for downloading the software definitions . Below both setting should be False. 

Example : In below lines you can see offlineimport setting in True . This is the reason for system status message not getting updated even-though the engine job is OK status.  

<various_control_properties>

    <enableOfflineExport>false</enableOfflineExport>

 

    <enableOfflineImport>true</enableOfflineImport>

6. Execute the below query to confirm if enableofflineimport is set to true . 

select * from ca_cic_manager where name='cic.misc.enableOfflineImport' 

Offlien import query shwoing true.jpg

 

7. Change enableofflineimport to false by executing below query. 

 

update ca_cic_manager

set value='false'

where name='cic.misc.enableOfflineImport'

update query to change to false.jpg

 

 

8. Run the below query again to confirm if enableofflineimport is changed to false. 

select * from ca_cic_manager where name='cic.misc.enableOfflineImport' 

Offline Import query to change false.jpg

 

9 . Now run the Default software content download job again and see if System Status message is not getting appeared on successful completion with OK status.