CA Service Management

  • 1.  2147483647 number occurs with GRloader

    Posted Apr 21, 2016 06:09 PM

    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



  • 2.  Re: 2147483647 number occurs with GRloader

    Posted Apr 25, 2016 01:17 AM

    I thought I've seen that number before and lo and behold, so I had. You're hitting the maximum a 32-bit signed integer can be. If you know you can punch it in the system through some methods then my guess it's one of the intermediate steps that doesn't play nice and is a 32-bit program. If you can break it down to more granular level you might be able to pinpoint the culprit and maybe have a base for a support case then.



  • 3.  Re: 2147483647 number occurs with GRloader

    Posted Apr 25, 2016 08:16 PM

    Hi Yes it is an integer bit issue, where when grloader converts the Excel file it see these as a max number, this is a problem as we load these into R12 and we are not aware of this until it has been identified and leads to missing data as this is starting to occur on for example serial numbers and another other number values.

     

    Lower numbers are fine, but any that exceed 2147483647 get put as 2147483647, haven't been able to excel to handle these correctly.



  • 4.  Re: 2147483647 number occurs with GRloader

    Posted Apr 26, 2016 01:41 AM

    The values larger than max integer, are they really numbers or are they strings that just happens to consist of numbers? Try if changing the cell's format would help with this, change it to be text and see what happens.



  • 5.  Re: 2147483647 number occurs with GRloader

    Posted Jun 08, 2016 08:14 AM

    Try use '99999999999 in Excel