ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

SQL agent does not store large report file


Article ID: 141256


Updated On:


CA Automic Workload Automation - Automation Engine


The database agent ends a large job report with U00029007 Not all blocks (Limit '120') have been transferred from file 'C:\Automic\Automation.Platform\Agents\sql\bin\..\temp\OAACLYUT.TXT'.
Click on last report --> Directory --> the report is shown  "On Agent" --> C:\Automic\....\OAACLYUUQ.TXT, but it is not stored as a file:
An I/O error occurred: '\Automic\Automation.Platform\Agents\sql\bin\..\temp\OAACLYUQ.TXT (The system cannot find the file specified)'




Release : 12.3

Component : Agent JMXAgent RA CoreAgent SAPAgent SQL


Update to a fix version listed below or a newer version if available.

Component : Agent JMXAgent RA CoreAgent SAPAgent SQL

Fix Versions:
Automation.Engine 12.3.2 - Available

Automation.Engine 12.3.1 HF3 - Available


Public short description EN:
Job reports of java agents are deleted if report exceeds maximum block size

Public description EN:
An issue has been solved, where, when the error message 29007 occurred (maximum block size exceeds) during the execution of a job that run on a java based agent, the report file was deleted on the agent machine and could not be fully viewed.