Applies to:Siebel Tools - Version 22.214.171.124  to 8.2.2 SIA [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 126.96.36.199 
Database: Microsoft SQL Server 2000 SP4
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Microsoft Windows 2003 Server SP1
This document was previously published as Siebel SR 38-3531059381.
*** Checked for Relevance on 14-NOV-2013 ***
SymptomsWe have a requirement to use the import object for importing records into a custom table. But there seems to be a restriction of 2000 records allowed, beyond which we receive this error:
"The maximum number of records allowed for each import operation is 2000. Please break your import file into multiple files containing fewer than 2000 records or use Siebel Interface Manager.(SBL-UIF-00212) "
Please advice if there is any way we can overcome this limit.
CauseThe customer had configured an Import Object using Siebel Tools to import data using Client-side import in Siebel application (via the applet-level menu import functionality).
Client side import is documented in the Bookshelf 8.1: Configuring Siebel Business Applications > Configuring Tables, Business Components, Links, and Business Objects > Customizing a Business Component Field > Configuring Client-Side Import to Update a Business Component Field
NOTE: In the standard Siebel repository the BC 'Contact' is configured as an Import Object with fields defined as Import Field child objects. In standard Siebel application client-side import is available in "Contacts" screen.
The customer received the following error when importing data:
- - -
The maximum number of records allowed for each import operation is 2000. Please break your import file into multiple files containing fewer than 2000 records or use Siebel Interface Manager.(SBL-UIF-00212).
- - -
The behavior observed when trying to import more than 2000 records is expected and cannot be changed. This behavior is documented in the Bookshelf 8.1: Siebel Fundamentals > Sharing Information > Importing Data
You can import a maximum of 2000 records at one time.
If you need to import more than 2000 records at one time the suggestion is to use Siebel Enterprise Integration Manager (EIM). Currently, there is no workaround for this.
Bug 10515045 - "Maximum upload capability for the Import Functionality" has been already logged as an enhancment request with no ETA.
This is Sekhar, have experience in Siebel CRM for 6 years...
i would like to give SIebel CRM And SIEBEL EAI Online Training and tech support.
if you need any help please contact me @ email@example.com