CA Client Automation

Engine job task health monitoring with remote database ?

  • 1.  Engine job task health monitoring with remote database ?

    Posted Feb 28, 2019 06:49 AM

    14.02 domain manager with remote SQL 2012 database has health monitoring enabled.

    e.g. caf monitoring works fine.

    But for all engine job task monitoring TRC_CF_HMAGENT_0.log shows errors:

     

    280219-11:31:24.0711722L|001708|00000f4c|hmagent |hmEngineAlertMod|HMEngineAlertHandler|001029|INFO | HMEngineAlertHandler::ReadEngineJobStatus Enter for AlertID=9, AlertName=Engine Job Alert - Collect, jobType=10, sysJobType=0, jobContent=''
    280219-11:31:24.0721147L|001708|00000f4c|hmagent |DbImpl_Ado |DbImpl_Ado.cpp |002311|NOTIFY | evalSQLInfo sqlstate: 08S01 native error: 0 0x0
    280219-11:31:24.0721536L|001708|00000f4c|hmagent |DbImpl_Ado |DbImpl_Ado.cpp |002489|WARNING| connect error 08S01
    280219-11:31:24.0722073L|001708|00000f4c|hmagent |CDb |DbImpl_Ado.cpp |002644|NOTIFY | Error Message: ADO Version 6.3 - COM Error: ErrorCode:-2147467259,WordErrorCode:0, Unspecified error, Communication link failure, Microsoft SQL Server Native Client 11.0, (null)
    280219-11:31:24.0722732L|001708|00000f4c|hmagent |AlertUtils |AlertUtils.cpp |000858|ERROR | AU_CreateRec: Creating recordset failed: sql=SELECT ca_engine.engine_uuid, ca_engine.label, NCJOBCFG.joname, NCJOBCFG.jobid, STATJOB.stdate, STATJOB.stcount, STATJOB.stqcount, STATJOB.stelapse, STATJOB.sttext, STATJOB.stflag FROM ca_engine, NCJOBCFG, STATJOB WHERE STATJOB.jobid = NCJOBCFG.jobid AND STATJOB.jdomid = NCJOBCFG.domainid AND STATJOB.status = 0 AND STATJOB.object_type = 3 AND STATJOB.jdomid = 1547474550 AND ( LOWER(ca_engine.host_name) = 'dmhost01.domain.loc' OR LOWER(ca_engine.host_name) = 'dmhost01' OR LOWER(ca_engine.host_name) = 'dmhost01' ) AND ca_engine.domain_uuid = 0x617BCF767D006647AB89C251EBC2FB59 AND NCJOBCFG.jotype in (10) AND STATJOB.object_uuid = ca_engine.engine_uuid AND ca_engine.engine_uuid in (SELECT LINKJOB.object_uuid FROM LINKJOB WHERE LINKJOB.jdomid = NCJOBCFG.domainid AND LINKJOB.jobid = NCJOBCFG.jobid AND LINKJOB.object_type = STATJOB.object_type AND LINKJOB.jdomid = NCJOBCFG.domainid AND LINKJOB.object_uuid = STATJOB.object_uuid), info=ADO Version 6.3 - COM Error: ErrorCode:-2147467259,WordErrorCode:0, Unspecified error, Communication link failure, Microsoft SQL Server Native Client 11.0, (null)

     

    Is there anything additional to be configured when there is a remote database ? It is working fine on a domain manager with a local database.

    Regards

    Claus