Scheduled Report Job Engine Tasks failing with error 7

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

One or more scheduled report jobs linked to an Engine are in status ERROR with following status comments :

Reporter Job Failed. Reporter returned:7

 

Capture1.JPG

 

In DSM\logs\TRC_REPORTER_*.log following error could be found :

 

ERROR  | Error calling Reporter interface [#7]

 

 

Cause:

This error could occur if the link between the Reporter Engine job and scheduled report is lost in database.

 

The engine jobs are stored in SQL table ncjobcfg and scheduled report in table rpauto.

For Engine Reporter job, the column jocont of table ncjobcfg contains the Scheuled Report object id.

If this column contains 0, the error "Error calling Reporter interface [#7]" occurs.

 

Example :

With Microsoft SQL Server Management Studio, execute following SQL request to check all Scheduled Report Engine jobs :

 

use mdb

SELECT n.jobid, n.joname, a.objid, a.objname, n.jocont 

FROM ncjobcfg n, rpauto a

WHERE n.jotype=31 AND n.jobid=a.schobjid

 

In this example "Reporter Job - Asset or User Report [3]" is correct as objid 615 is present in jocont column.

But "Reporter Job - Asset or User Report [2]" is not correct because jocont contains the string 0 (instead 614) :

 

Capture2.JPG

 

All Scheduled Report Engine jobs with jocont=0 are not correct.

 

 

Resolution:

Solution 1

In DSM Reporter, under Scheduled Reports, delete and create again the scheduled reports linked to the wrong Report job (where jocont='0').

 

or

 

Solution 2

1- Stop caf on ITCM DOMAIN :

caf stop

 

2- Execute following SQL Query with Microsoft SQL Server Management Studio in order to repair the Engine jobs in database :

use mdb

UPDATE ncjobcfg 

SET jocont=LTRIM(STR(a.objid)) 

FROM ncjobcfg n, rpauto a 

WHERE n.jotype=31 AND n.jobid=a.schobjid AND n.jocont like '0%' 

 

3- Start caf

caf start