nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Deepak Jain

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 !!

All comments

Deepak Jain

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.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management