Error when trying to export Insight object schema

[Jacques]

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:

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!

[Fabian Lim]

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