Errors ORA-01461 and SBL-DBC-00111 When Inserting Data into the IIR IDS_UPD_SYNC_NSA Table via External Business Component
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 126.96.36.199 SIA  and later
Information in this document applies to any platform.
Siebel 188.8.131.52 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:
 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)
 ORA-01461: can bind a LONG value only for insert into a LONG column
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms