Errors ORA-01461 and SBL-DBC-00111 When Inserting Data into the IIR IDS_UPD_SYNC_NSA Table via External Business Component (Doc ID 1498267.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.4 SIA [21225] and later
Information in this document applies to any platform.

Symptoms

Siebel 8.1.1.4 or higher (after applying ACRs 437 and 475) is being used.  The 'DQ Sync Services' user property 'Account Record Length' or 'Contact Record Length' has been modified to 2046 or higher characters to accommodate more characters for particular fields or extend for new fields for matching.  When inserting/modifying an Account or Contact the following errors are seen:

ERROR
-----------------------
[1] An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)
[2] ORA-01461: can bind a LONG value only for insert into a LONG column


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Set up Siebel and ODQ (IIR) for data matching using the DQ Sync Services business service to insert data directly into the IDS_UPD_SYNC_NSA table
2. Alter the DQ Sync Services Business Service and SiebelDQ.sdf file with additional fields/character lengths so that the total length for Accounts or Contacts is more than 2045 (e.g. Account Record Length or Contact Record Length is more than or equal to 2046 characters).
3. Create a new Account or Contact in Siebel and save it.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms