[AWA] utility ucybdbun is closed suddenlly

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When executing the AWA utility ucybdbun, it is closing by itselft without any message.
The log show normal progress until some particular objects

Environment

Release:
Component: AAUTWI

Cause

Investigation:

• Enable tracing (database = 4) and execute the DBUnload utility
• Reading the ucybdbun_trace_00.txt, we founded that the unload break in the object 3316388.

<Please see attached file for image>

• Executing an query statement in the DB to the respective object (table ovw) à we did not see anything special at first point.

<Please see attached file for image>

• We proceed to delete this variable from ARA and run again the unload Process. However, the error appear in another variable. At this point, it was identified that the variable xml were the error.
• Making some statements in the DB (table ovw), it was founded 29 registers which supposed to be NULL, but they weren’t. (same case as step 2). It was exported these registers to another table and a rawtohex function was applied. The column ovw_valuex, contains values which were causing an error in the unload process.
• We delete the variables from the Objects and finally the unload process run without interruptions.

Resolution

The utility ucybdbun was closing due to the xml values stored in the database.
A workaround solution was founded by removing the variables from the transport objects