Insight import throws "Error! Import data mapped to OTA Label is empty"
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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.logyou'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.logfile in the summary of the import operation and focus on theemptyLabelEntriesvalue:
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