Missing "delete" message in DB unload log

Article Id: 84732

Status: Published

Updated On: 15-04-2018 08:03

Legacy Id: 000009203

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Error Message :
U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec

When running the DB Unload utility from the Automation Engine (AE) version 11.2.3 the log states 0 deletes were performed.

For example:

20160727/154249.282 - U00003523 UCUDB: Maximum time required for a DB call: '12:005.491.382'.
20160727/154249.297 - U00003522 UCUDB: Database closed. Total time for DB calls: '504:361.053.316' seconds.
20160727/154249.297 - U00003549 UCUDB: ' 953' 'OTHERS ' calls took '2:804.688.416' sec.
20160727/154249.297 - U00003549 UCUDB: ' 12' 'SELECT ' calls took '0:022.982.780' sec.
20160727/154249.297 - U00003549 UCUDB: ' 44281' 'EXECUTE ' calls took '494:970.737.831' sec.
20160727/154249.297 - U00003549 UCUDB: ' 0' 'UPDATE ' calls took '0:000.000.000' sec.
20160727/154249.297 - U00003549 UCUDB: ' 0' 'DELETE ' calls took '0:000.000.000' sec.
20160727/154249.297 - U00003549 UCUDB: ' 1' 'INSERT ' calls took '0:000.705.930' sec.
20160727/154249.297 - U00003549 UCUDB: ' 10607' 'READ ' calls took '0:677.299.834' sec.
20160727/154249.297 - U00003549 UCUDB: ' 45452' 'CLOSESTMT ' calls took '0:002.372.105' sec.
20160727/154249.297 - U00003549 UCUDB: ' 711' 'TRANSACT ' calls took '5:882.266.418' sec.

However, this behavior may be seen on other AE versions as well.

Cause:

Cause type:
By design
Root Cause: Deletes are done in bulk.

Environment:

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution:

The deletes are done in bulk => 20160727/154249.297 - U00003549 UCUDB: ' 44281' 'EXECUTE ' calls took '494:970.737.831' sec.
Therefore, this behavior is as designed.

Fix Status: No Fix

Additional Information:

Workaround :
N/A