SQL agent does not store large report file

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation
• CA Automic Operations Manager
• CA Automic Oracle

Issue/Introduction

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: 'java.io.FileNotFoundException:C:\Automic\Automation.Platform\Agents\sql\bin\..\temp\OAACLYUQ.TXT (The system cannot find the file specified)'

Cause

Defect

Environment

Release : 12.3

Component : Agent JMX, Agent RA Core, Agent SAP, Agent SQL

Resolution

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

Component : Agent JMX, Agent RA Core, Agent SAP, Agent 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.