GRLOADER convert string incorreclty to value 2147483647

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

In the load of ICs with GRLoader in which an attribute has a number with more than 10 characters, a buffer-overflow occurs and the field is populated with the constant 2147483647.

Environment

Service Desk Manager 17.x

Cause

If the cell from xlsx has a format different from Text, the numeric values are converted to a unknown string and it produces a value: 2147483647

Resolution

Change the excel cell format to Text, and it will convert correctly.