Unable to determine object type being imported in grloader

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

Getting the following error when using GRLoader to rename the resource_name by using the UUID as the identifier, as seen in the grloader.log

09/28 15:47:04.017 INFO grSpreadSheetRdr 514 grSpreadSheetRdr7000 read column heading(0) = id
09/28 15:47:04.017 INFO grSpreadSheetRdr 514 grSpreadSheetRdr7000 read column heading(1) = name
09/28 15:47:04.017 INFO grSpreadSheetRdr 514 grSpreadSheetRdr7000 read column heading(2) = tran_chg_ref_num
09/28 15:47:04.017 ERROR grTransaction 351 grTransaction400 Unable to determine object type being imported
09/28 15:47:04.017 ERROR grTransaction 358 grTransaction410 id - (id)
09/28 15:47:04.017 ERROR grTransaction 358 grTransaction410 name - (name)
09/28 15:47:04.017 ERROR grTransaction 358 grTransaction410 tran_chg_ref_num - (tran_chg_ref_num)
09/28 15:47:04.017 INFO GRLoader 306 grSpreadSheetRdr9000 Fatal Error - unable to determine object types being imported

Environment

Release:  17.3 or higher
Component: CA Service Desk Manager

Cause

The objecttype is required in the command if the input file does not contain the class or family information.

Resolution

In the command add: "-ad objecttype=ci"

So it's like:

grloader -u -p -s http://[SDMSERVER]: -i xxxxx.xlsx -ad objecttype=ci -a