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

Article Id: 196793

Status: Published

Updated On: 07-08-2020 00:19

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.