Support Article
Error displays on importing data to data type
SA-102496
Summary
Error occurs when importing data to a data type using a CSV file with the 'Add or Update' option.
Error Messages
Exception occurred during data import pxW-851: java.lang.IllegalArgumentException: INativeSQLBuilder not initialized properly
Steps to Reproduce
- Open any data type in the Staging environment from Pega Designer Studio.
- Navigate to the Records Tab.
- Click the Import link.
- Select the Purpose as 'Add or Update'.
- Upload the a CSV File.
- Click Next > Start Validation.
Root Cause
The database PostgreSQL 9.x was upgraded to PostgreSQL 11.x. Post this, the Merge query support did not work.
Resolution
Apply HFix-59621.
Published April 1, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.