Collapse
Submit a Service Request
Contact Information for Technical Support
My Service Notifications
Error on insert with the Data Import Wizard
Answer ID 8174 |
Last Review Date 03/18/2019
Why do I receive the errors and sometimes receive multiple records on inserts through the Data Import Wizard?
Environment:
Oracle B2C Service Console
Issue:
We sometimes receive the error "There is an unclosed literal string" or "Unable to communicate with server" and sometimes receive multiple records on inserts through the Data Import Wizard?
Resolution:
If you see errors similar to these in the Error Log:
pair <c_id> is not visible looking for <FV_U> visibility...
Deadlock found when trying to get lock; try restarting transaction
...and are seeing multiple records being created during the data import process, this could be due to one of the following reasons:
- Data import processing limit too high.
To resolve this, set the DATA_IMPORT_BATCH_LIMIT configuration to a lower limit, for example 250.
A description of this configuration is as follows:
DATA_IMPORT_BATCH_LIMIT
Limits the number of contacts processed in a single batch when performing a Data Import. Maximum is 5000. Default is 1000.Please note that this is an interface specific configuration, and you can find it using the path: Configuration > Site Configuration > Configuration Settings > search by Key.
- Rules are not being suppressed.
If you are using a Custom Process Model (CPM) in the process, add Suppress Rules to the "save", as described here: Create/Update Options.
- If you are using a CPM within the business rule, consider moving it to within an Event Handler, as there is a possibility of a loop that is creating multiple records.