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 ".

book

Article ID: 7202

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager

Issue/Introduction

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). 

<Please see attached file for image>

contnet 15 days old.jpg

 

Cause

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

Environment

ITCM 14.0 SQL 2012

Resolution

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

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKQHAA4" alt="Engine Showing job running OK.jpg" width="1439" height="586">

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' 

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKQIAA4" alt="Offlien import query shwoing true.jpg" width="912" height="522">

 

7. Change enableofflineimport to false by executing below query. 

 

update ca_cic_manager

set value='false'

where name='cic.misc.enableOfflineImport'

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKQKAA4" alt="update query to change to false.jpg" width="677" height="500">

 

 

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

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

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKQJAA4" alt="Offline Import query to change false.jpg" width="925" height="528">

 

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. 

 

 

Attachments

1558703266291000007202_sktwi1f5rjvs16q6i.jpeg get_app
1558703264588000007202_sktwi1f5rjvs16q6h.jpeg get_app
1558703262690000007202_sktwi1f5rjvs16q6g.jpeg get_app
1558703260718000007202_sktwi1f5rjvs16q6f.jpeg get_app
1558703258932000007202_sktwi1f5rjvs16q6e.jpeg get_app