Errors when attempting to use "pdm_userload" to load records into CA Service Desk Manager without UUIDs.

Document ID : KB000025062
Last Modified Date : 13/08/2018
Show Technical Document Details
Issue:

When trying to use the "pdm_userload" function/command to load contact records within CA Service Desk Manager (CA SDM), or any other records for that matter, where the unique identifier is a UUID value, from an outside source file that is formatted correctly, but does not have UUID values present, receive an error: 

pdm_userload: ca_contact: no numeric or :logical key.
Error: cannot create mapping for table.

 

Environment:
CA Service Desk Manager 12.9, 14.1, 17.x
Windows, Unix and Linux
 
Resolution:

Do not use the pdm_userload command, but instead use the "-i" switch with the pdm_load command.

The command "pdm_load -i -f <input_file>" will insert the records and create UUIDs on record insert, thus resolving the problem and allowing the records to load.

Additional Information:

Using the pdm_deref utility to create a properly formatted load file

How to create and use a load file