Insight import throws "Error! Import data mapped to OTA Label is empty"

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

 

Summary


This issue was seen in case of a CSV import. However, the concept can apply to other import types as well.

 During a CSV import, insight-import.log throws this error Error! Import data mapped to OTA Label is empty for...

Environment

This is a configuration issue. Any Insight Versions can be affected.

Diagnosis

There are multiple ways of diagnosing this issue:

  • In the insight-import.log you'd see errors such as the below:
2021-07-06 03:40:11,044 [insight-InsightImportThreadGroup-worker-thread-2] | Error! Import data mapped to OTA Label is empty for com.riadalabs.jira.plugins.insight.services.imports.common.external.model.InternalDataEntry@5e1e8d4c[dataEntry=\{DataLocator \[locator=device/name]=[REDACTED], DataLocator [locator=package/name]=[], DataLocator [locator=package/first_installation]=[], DataLocator [locator=package/version]=[REDACTED]},importSourceOTId=13] which is importing to object type id 61
2021-07-06 03:40:10,932 [insight-InsightImportThreadGroup-worker-thread-3] | Error! Import data mapped to OTA Label is empty for com.riadalabs.jira.plugins.insight.services.imports.common.external.model.InternalDataEntry@2d356ed4[dataEntry=\{DataLocator \[locator=device/name]=[REDACTED], DataLocator [locator=package/name]=[], DataLocator [locator=package/first_installation]=[], DataLocator [locator=package/version]=[REDACTED]},importSourceOTId=13] which is importing to object type id 61
2021-07-06 03:40:10,641 [insight-InsightImportThreadGroup-worker-thread-0] | Error! Import data mapped to OTA Label is empty for com.riadalabs.jira.plugins.insight.services.imports.common.external.model.InternalDataEntry@b10afa6[dataEntry=\{DataLocator \[locator=device/name]=[REDACTED], DataLocator [locator=package/name]=[], DataLocator [locator=package/first_installation]=[], DataLocator [locator=package/version]=[REDACTED]},importSourceOTId=13] which is importing to object type id 61
  • In the "Process results" tab check the last import result Details and focus on Objects with no label in external source:

  • Also, the same can be verified from the insight-import.log file in the summary of the import operation and focus on the emptyLabelEntries value:
2021-08-04 20:15:16,013 [insight-InsightThreadGroup-worker-thread-8] | com.riadalabs.jira.plugins.insight.services.imports.common.ImportResult@3d1a5767[
  status=FINISHED
  started=Wed Aug 04 20:14:04 IST 2021
  ended=Wed Aug 04 20:15:15 IST 2021
  executedType=MANUAL
  executedAsUserKey=JIRAUSER10000
  objectSchemaId=3
  numberOfWorkers=12
  importSourceId=3
  populatedObjectTypes=[Application, Application]
  moduleKey=rlabs-import-type-csv
  moduleVersion=1
  updateReferencesTimeInMs=0
  onlyExecutedForObjectTypeIds=[]
  result=OK
  infoMessage=<null>
  errorMessages=<null>
  ObjectTypes : objectTypeResultMap={47=com.riadalabs.jira.plugins.insight.services.imports.common.ImportResult$ObjectTypeResult@26ee33fe[
  objectTypeName=Application
  objectTypeId=47
  objectsUpdated=0
  objectsCreated=1964
  objectsIdentical=0
  entriesInSource=58110
  objectsFilteredWithIQL=0
  duplicateEntries=55001
  emptyLabelEntries=1145
  emptyExternalIdEntries=0
  objectsMissingUpdated=0
  objectsMissingDeleted=0
  errorMessages=<null>
  readExternalDataTimeInMs=580
  mapExternalDataTimeInMs=0
  iqlFilteringDataTimeInMs=0
  decidingActionsTimeInMs=9
  writeInsightDataTimeInMs=819815
  postFunctionTimeInMs=2
  executionTimeInMs=820406
  objectsWithUpdatedReferences=0
]}
]

Cause

Check the import configuration which is throwing this error and take note of the "Data Locator" + Label attribute combination:

The error can mean either of the two possibilities:

  • In the Import configuration, we have selected a "Data Locator" (label)column which does not exist in the source CSV file
  • Or, the "Data Locator" (label)column exists in the source but there are empty values in some rows for the label column

Since the label attribute and its value has to exist in the source file in order to successfully import the objects, we throw this error in the logs letting the user know that we have certain rows where the import module found the OTA (Object Type Attribute) label to be empty and hence it can't be imported.

Solution

  • If the "Data Locator" (label)column itself is missing from the source, please add the column and the corresponding values in the source
  • If the "Data Locator" (label)column exists in the source but there are empty values in some rows for the label column then:
    • Either, remove those rows with empty label column values
    • Or, add the corresponding values in those rows and make sure no rows has empty datalocator label 

Last modified on Aug 4, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.