U00003513 UCUDB: Not all HSTMT have been closed: Number = '1'

Products

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

Issue/Introduction

Below errors are received when performing  client copy in AWA.

20200303/094911.469 - Reset status of client.

20200303/094911.594 - U00003513 UCUDB: Not all HSTMT have been closed: Number = '1'

20200303/094911.625 - U00036127 Errors occurred while copying client. 

 

Cause

Identified as  a Bug

Environment

Release : 12.2

Component : ACTION BUILDER

Resolution

Workaround:
DB reorg will resolve the issue.
For doing DB reorg, please follow below documentation link
https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.2/AWA%20Guides/help.htm#Utilities/admin_AE_DB_Reorg.htm?Highlight=db%20reorg



Solution:

If DB reorg didn't help, kindly upgrade to the below fixed versions. Since, This error  is identified as BUG by R&D team and resolution is provided in below versions of AWA.

Automation.Engine 12.2.4, 
Automation.Engine 12.3.1, 
Automation.Engine 12.4.0,
 Automation.Engine 12.2.5, 
Automation.Engine 12.2.4 HF1

Additional Information

https://alm.automic.com/jira/browse/AE-21961