Error Writing Bytes For Field FLD_LENGTH From Container AUDIT_COLL: Reverse Access Path = CICZADTN (Doc ID 2241193.1)

Last updated on JUNE 17, 2021

Applies to:

Symptoms

On :  4.2.0.3.0 version, DB; TEST

Cannot enable audit for CI_SCR_STEP table.
The following error occurs:

ERROR
-----------------------
Error writing bytes for field FLD_LENGTH from container AUDIT_COLL: reverse access path = CICZADTN.CIPZADTA


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enable Audit on Table CI_SCR_STEP [Admin - T - Table]
   i. Select Audit table as 'CI_AUDIT'
  ii. Select Audit Program Type as 'COBOL'
 iii. Select Audit Program Name as 'CIPZADTA'
  iv. Save.

2. Create a dummy Script [Say Service Script. Admin - S - Script+].

i. Provide mandatory details
ii. Make sure there is at least one step added in script with some dummy step [say "default $temp as '';"].
iii. Click Save.

3. Observe System is throwing error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Bundle/CMA import is not possible without the fix.
Go Live is in a week and a the later stages [in later three weeks ] this fix is very important for moving any changes to test/prod.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.