CSV Import Issue

[Tim Finch]

Hi All,

I have a csv extract of data from Service Now I am trying to import into JSM (CLoud)

The majority of the imports work, but on the problem issues I am getting the following error.

2023-06-13 10:20:02,829 ERROR - Unexpected failure occurred. Importer will stop immediately. Data may be in an unstable state: org.ofbiz.core.entity.GenericEntityException: while inserting. (Privacy-safe boxing of a org.ofbiz.core.entity.GenericDataSourceException): while inserting. (Privacy-safe boxing of a org.ofbiz.core.entity.GenericDataSourceException): Privacy-safe boxing of a org.ofbiz.core.entity.GenericDataSourceException: org.postgresql.util.PSQLException: SQLState=22001

Anyone seen this before and have any idea what is causing it? 

[Deepak Jain · Accepted solution]

The error is related to the data itself.

A specific field mapping between CSV and a project field of different data types is causing this.

Good approach could be trial and error. The CSV can be imported multiple times. One just have to map one field at a time. It should import successfully until getting to the field which is causing the exception.

Thanks !!

[Deepak Jain]

There may be multiple reason behind this issue. Data into CSV is not formatted correctly or size of data may be high.

So its important to identify the column which is creating the problem. 

[Tim Finch]

Thanks @Deepak Jain issue rectified :)