Skip to main content
Kofax

Jobs suspending due to "Cannot save the Reporting data to Staging DB" error

Article # 3039349 - Page views: 121

Issue

Jobs are suspending in various nodes with the following error:

Cannot save the Reporting data to Staging DB.

 

Here is an example from a Transformation activity:

2021-11-23 01:12:02.497 0x19FA27E14BFA11ECA7E80022484CD0AE Execution of activity IP_DC_Extraction_Composite in job 19FA27E14BFA11ECA7E80022484CD0AE on Kofax Transformation Server - servername
was aborted due to the following error(s): Cannot save the Reporting data to Staging DB. 

 

Cause

1. One known issue that can cause this issue is if the Reporting System task is timing out due to a redundant query in this background process.  This software defect is submitted under:  TFS Bug ID: 1728820 - Redundant query causing the reporting system task to timeout

2. Another cause can be wrong DB connection string in the TS Config:

"C:\Program Files\Kofax\TotalAgility\Transformation Server\Kofax.CEBPM.CPUServer.ServiceHost.exe.config"

 

Solution

For 1.) : A workaround to this issue, would be to add the following environment variable on the Reporting server.  After change is made, restart the Reporting service.

MaxMQ2StagingIterationsNum = 10

MaxMQ2StagingIterationsNum.jpg

The official fix for this issue is included in:

  • 7.8.0.14 and higher
  • 7.9.0.9 and higher
  • 7.10.0.1 and higher

For 2.) Update the DB connection string in the Transformation Server Config file to point to the correct database.

Restart the Transformation Server after the update

Level of Complexity 

Moderate

 

Applies to  

Product Version Build Environment Hardware
KTA 7.10      
KTA 7.9      
KTA 7.8        

References

Add any references to other internal or external articles

 

Article # 3039349
  • Was this article helpful?