My Oracle Support Banner

Audit Trail Causing ORA-01704: String Literal Too Long (Doc ID 1952692.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Siebel CRM - Version SIA [23030] and later
Information in this document applies to any platform.
**Checked for Relevance on 15 Nov 2016**


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.

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.

Siebel 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


By following these steps the issue can be reproduced:

1. Delete a record on the affected business component.




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

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