[AWA] utility ucybdbun is closed suddenlly

book

Article ID: 130407

calendar_today

Updated On:

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

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>

User-added 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>

User-added 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.

Environment

Release:
Component: AAUTWI

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

Attachments

1558687992420000130407_sktwi1f5rjvs16fg6.jpeg get_app
1558687989319000130407_sktwi1f5rjvs16fg5.png get_app