Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Error when trying to export Insight object schema

Hello,

I'm trying to export an object schema with objects and when starting the export I get the following error trace in insight_objectschema_export.log:

2021-12-17 09:51:44,129 [https-openssl-nio-443-exec-249] | Resource: Export object schema to server, in data:com.riadalabs.jira.plugins.insight.channel.web.api.rest.model.imports.schema.ExportObjectSchemaInEntry@473bec7f[fileName=Schema-Export.zip,objectSchemaId=9,objectSchemaName=Insight Schema,includeObjects=true,totalObjectsInExport=16142]
2021-12-17 09:51:44,926 [https-openssl-nio-443-exec-249] | Start getting not-taken export zip file name: Schema-Export.zip
2021-12-17 09:51:44,926 [https-openssl-nio-443-exec-249] | Done getting not-taken export zip, use provided file name: Schema-Export.zip
2021-12-17 09:51:44,926 [https-openssl-nio-443-exec-249] | Start exporting schema with objects to server in new thread, object schema id: 9
2021-12-17 09:51:44,941 [https-openssl-nio-443-exec-249] | Started exporting schema with objects in new thread, object schema id: 9 to file: Schema-Export.zip
2021-12-17 09:51:44,941 [https-openssl-nio-443-exec-249] | Resource: Started Export object schema (with objects), id: 9
2021-12-17 09:51:45,004 [Thread-273167] | Start exporting schema for object schema id: 9
2021-12-17 09:51:45,348 [Thread-273167] | Number of Reference types to export: 23
2021-12-17 09:51:45,363 [Thread-273167] | Number of Status types to export: 11
2021-12-17 09:51:45,848 [Thread-273167] | Number of Icons to export: 213
2021-12-17 09:51:46,847 [Thread-273167] | Done exporting schema for object schema id: 9
2021-12-17 09:51:46,847 [Thread-273167] | Start exporting details, object schema id: 9
2021-12-17 09:51:46,866 [Thread-273167] | Done exporting details, object schema id: 9
2021-12-17 09:51:46,866 [Thread-273167] | Start exporting all data for object schema id: 9
2021-12-17 09:51:46,879 [Thread-273167] | Export objects for object type id: 344
2021-12-17 09:51:46,879 [Thread-273167] | Exported 0 objects for IQL: objectTypeId IN ("344") AND objectTypeId = 344
2021-12-17 09:51:46,879 [Thread-273167] | Done exporting objects for object type: Level 3, schema id: 9
2021-12-17 09:51:46,895 [Thread-273167] | Export objects for object type id: 233
2021-12-17 09:51:46,895 [Thread-273167] | Error when exporting object schema and objects, object schema id: 9, Error: columns to write should not be empty on line 1
java.lang.IllegalArgumentException: columns to write should not be empty on line 1
at org.supercsv.io.AbstractCsvWriter.writeRow(AbstractCsvWriter.java:182)
at org.supercsv.io.AbstractCsvWriter.writeHeader(AbstractCsvWriter.java:228)
at com.riadalabs.jira.plugins.insight.services.imports.ObjectExportServiceImpl.writeHeader(ObjectExportServiceImpl.java:157)
at com.riadalabs.jira.plugins.insight.services.imports.ObjectExportServiceImpl.exportObjects(ObjectExportServiceImpl.java:130)
at com.riadalabs.jira.plugins.insight.services.imports.schema.ObjectSchemaExportServiceImpl.exportData(ObjectSchemaExportServiceImpl.java:383)
at com.riadalabs.jira.plugins.insight.services.imports.schema.ObjectSchemaExportServiceImpl.exportSchemaToServerAsync(ObjectSchemaExportServiceImpl.java:250)
at com.riadalabs.jira.plugins.insight.services.imports.schema.ObjectSchemaExportServiceImpl.lambda$exportSchemaWithObjectsToServer$0(ObjectSchemaExportServiceImpl.java:206)
at java.lang.Thread.run(Thread.java:748)
2021-12-17 09:51:46,895 [Thread-273167] | Insight log directory: E:\JIRA\log
2021-12-17 09:51:46,941 [Thread-273167] | Done exporting object schema and objects, object schema id: 9

As you can see there is an error mentioning something about empty columns:

2021-12-17 09:51:46,895 [Thread-273167] | Error when exporting object schema and objects, object schema id: 9, Error: columns to write should not be empty on line 1
java.lang.IllegalArgumentException: columns to write should not be empty on line 1

The Insight interface shows the following error:

Insight Export Error.png

I understand there must be some data integrity error in the Insight data structure, but I'm not sure where to start to try and resolve this.

Anyone has a suggestion on how to resolve this?

Thanks!

1 answer

0 votes
Fabian Lim Community Leader Dec 25, 2021

HI @Jacques

I recommend you open a ticket with atlassian support so that they can look at this issue. 

I suspect there is an empty row in your file that is causing it to break on line 1.

Regards

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

Next level incident management in Jira Service Management

Hello Atlassian Community! We’re thrilled to announce some exciting changes to incident management in Jira Service Management Cloud, in order to give your teams extra muscle during incidents, and ...

1,735 views 21 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you