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 = ?'
Unknown, it is an Oracle error and needs to be investigated by the Oracle Support.
Release : 12.3
Component : AUTOMATION ENGINE
Database: Oracle
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.