DB-Archive ends with error 'ORA-03146: Invalid buffer length for TTC field'

Products

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

Issue/Introduction

Suddenly (it was running fine before), the DB Archive (ucybdbar) Job fails with the error below:

U00003592 UCUDB - Status: '' NativeError: '3146' Msg: 'ORA-03146: Invalid buffer length for TTC field'
U00003594 UCUDB-Ret: '3590' Opcode: 'SLUC' SQL-Stmnt: 'SELECT * FROM AH WHERE AH_IDNR = ?'

 

Cause

Unknown, it is an Oracle error and needs to be investigated by the Oracle Support.

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Database: Oracle

Resolution

After some research the issue is not related to One Automation but to either the Oracle Client or the Oracle Database.

See here:

https://www.oraexcel.com/oracle-12cR1-ORA-03146/lang-en

Please contact Oracle Support to get a definitive solution for it.



On this case, the issue could not be reproduced at will, relaunching the same DB Archive command with the same retention parameters would work most the time.