AnsweredAssumed Answered

2147483647 number occurs with GRloader

Question asked by MeteshKeshav1307450 on Apr 21, 2016
Latest reply on Jun 8, 2016 by marcelocmotta

Hi this only happens with Excel and Grloader, if the field number is higher then 2147483647 for example you put 99999999999999299 it will always default to the number 2147483647

if you place a character in the field then it works correctly

 

if I load the files using .XML files then grloader process this correctly

so the issue looks like it to deal with how the excel file is handing these.

 

I have read around and it says to try using .CSV

have tried to copy or format the cells

 

we are using R12.6 and get this error

ca_owned_resource.csv

grCSVrdr9000 Fatal Error - unable to determine object types being imported

Outcomes