Audit Trail Causing ORA-01704: String Literal Too Long
(Doc ID 1952692.1)
Last updated on NOVEMBER 22, 2019
Applies to:
Siebel CRM - Version 8.2.2.4 SIA [23030] and laterInformation in this document applies to any platform.
**Checked for Relevance on 15 Nov 2016**
Symptoms
Customer Statement:
--------------------
A custom business component contains a significant number of custom fields. Audit Trail is enabled for this custom business component, including auditing delete operations.
The business component is also a child BC of another BC, and the Link between the two has the Cascade Delete property set to Delete.
Issue:
Given a parent record with one or more child records, then when deleting a record from the parent BC, Audit Trail fails to audit the Delete action for the child BC. The database raises an ORA-01704 message.
What works:
When inactivating some of the custom fields, the error messages do not occur anymore.
Environment:
--------------------
Siebel 8.2.2.4 SIA [23030] on IBM AIX 7.1 on POWER Systems (64-bit) & Oracle DB
Error Messages:
--------------------
SBL-DBC-00111: An error has occurred writing to a record.
SBL-DAT-00236: An error has occurred while deleting the record.
SBL-BPR-00100: This error is returned when the workflow/task is executing the Siebel Operation business service.
SBL-BPR-00187: Error updating business component at step 'Delete'.
ORA-01704: string literal too long
Steps:
--------------------
By following these steps the issue can be reproduced:
1. Delete a record on the affected business component.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |