Remedy - Server - Data Import Client Tool version 9.1.03 does not import any data and returns the error "Cannot import, exception occurred while importing java.lang.NullPointerException or Error Record 1: null"

Knowledge Article

Article Number

000315529

Old Article Number

000138905

Article Type

Solutions to a Product Problem

Title

Remedy - Server - Data Import Client Tool version 9.1.03 does not import any data and returns the error "Cannot import, exception occurred while importing java.lang.NullPointerException or Error Record 1: null"

Summary

This article details how to resolve the error "Cannot import, exception occurred while importing java.lang.NullPointerException or Error Record 1: null" that is seen when importing data with the Data Import Tool

Product

Remedy AR System Server

Component

Remedy AR System Server

Applies to

AR System 9.1 SP3

Problem

When importing data into any form via the Data Import Tool, the following error is seen on screen:
Import completed in 0 seconds. 0 records were imported to <form name>; 0 Records were not.

The dataimport.log file will show the following:
[Fri Jun 23 00:33:37.664] INFO - Attempting import from source form AR System Email Messages to destination form AR System Email Messages on server Server-Name-Here
[Fri Jun 23 00:33:38.127] ERROR - Cannot import, exception occured while importing C:\Users\Administrator\Desktop\DataToBeImported.arx : java.lang.NullPointerException
java.lang.NullPointerException
    at com.bmc.arsys.api.ProxyJRpc.ARMergeEntry(ProxyJRpc.java:1363)
    at com.bmc.arsys.api.ARServerUser.mergeEntry(ARServerUser.java:4495)
    at com.bmc.arsys.api.ARServerUser.mergeEntry(ARServerUser.java:4428)
    at com.bmc.arsys.apiext.data.BaseImporter.importEntry(BaseImporter.java:673)
    at com.bmc.arsys.apiext.data.BaseImporter.bulkImportEntry(BaseImporter.java:1370)
    at com.bmc.arsys.apiext.data.BaseImporter$1.handleEvent(BaseImporter.java:410)
    at com.bmc.arsys.apiext.data.Parser.fireEvent(Parser.java:46)
    at com.bmc.arsys.apiext.data.arx.ARXParser.parseFile(ARXParser.java:658)
    at com.bmc.arsys.apiext.data.arx.ARXImporter.processFile(ARXImporter.java:26)
    at com.bmc.arsys.apiext.data.arx.ARXImporter.startImport(ARXImporter.java:34)
    at com.bmc.arsys.apiext.data.BaseImporter.call(BaseImporter.java:266)
    at com.bmc.arsys.apiext.data.BaseImporter.call(BaseImporter.java:40)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Cause

The ''TCD-Specific-Port' parameter in the ar.conf/cfg file has been set to use a specific port, however a new 'ARServerUser' object is created during the import process which ignores this parameter. Relates to defect SW00531485

Solution

This knowledge article may contain information that does not apply to version 21.05 or later which runs in a container environment. Please refer to Article Number 000385088 for more information about troubleshooting BMC products in containers.

To resolve this issue, apply the latest hotfix for AR System Server version 9.1.03.
The hotfix can be downloaded from BMC's FTP site "ftp://ftp.bmc.com/pub/ARRecommendedFixes/Server/"

Attachment(s):

Hotfix.zip