Hi All,
Has anybody has come across this error while importing ndi file, this is happening for a set of device irrespective of OS, while rest works fine.
" System.InvalidOperationException: The given value of type Int64 from the data source cannot be converted to type int of the specified target column. ---> System.OverflowException: Failed to convert parameter value from a Int64 to a Int32. ---> System.OverflowException: Value was either too large or too small for an Int32 "
Attached full error message in the attachement.
But when same set of ndi files are imported into our test envirnoment which is almost identical, it goes fine with out any error.
We are on 2019 R2 and 2014 SQL server
āJul 29, 2021 05:17 AM
The only fix I'm aware of for IOJ-2091541 is in the 2020 R1 or later releases sorry - I am not sure that any analysis has been done previously to consider what would be involved in hotfixing or working around this problem in earlier releases.
If you are not planning an upgrade to a current release at this time, you would need to work with Flexera Support to confirm whether this is indeed the issue affecting your environment and discuss options.
āJul 29, 2021 06:23 AM
āAug 11, 2021 12:23 AM
This error looks like it may be related to the following known issue that is shown as resolved in the 2020 R1 release:
MASTER ISSUE NUMBER | COMPONENT/S | SUMMARY |
---|---|---|
IOJ-2091541 | Database, Inventory, Uploaded file importers |
Inventory NDI files fail to import when the SoftwareFile_MT.SoftwareFileID database identity column exceeds 2,147,483,647 |
Are you using a version of FlexNet Manager Suite from 2019 or earlier? And does the SoftwareFile_MT.SoftwareFileID column in your inventory database contain values larger than 2,147,483,647?
āJul 29, 2021 06:06 AM - edited āJul 29, 2021 07:07 AM
Hi @ChrisG
We are using 2019 R2
āJul 29, 2021 06:12 AM
āJul 29, 2021 06:16 AM
The only fix I'm aware of for IOJ-2091541 is in the 2020 R1 or later releases sorry - I am not sure that any analysis has been done previously to consider what would be involved in hotfixing or working around this problem in earlier releases.
If you are not planning an upgrade to a current release at this time, you would need to work with Flexera Support to confirm whether this is indeed the issue affecting your environment and discuss options.
āJul 29, 2021 06:23 AM
āJul 29, 2021 06:29 AM
Also this seem to be coming up predominantly in for all of the failed to import files,
" System.InvalidOperationException: The given value of type Int64 from the data source cannot be converted to type int of the specified target column.
---> System.OverflowException: Failed to convert parameter value from a Int64 to a Int32.
---> System.OverflowException: Value was either too large or too small for an Int32 "
āJul 29, 2021 10:52 PM
Hi @nagaeendra: Based on your comment that the max SoftwareFileID is less than half the max value of the Identity column, you should try to reseed the Identity value for the SoftwareFile table. I see you have a case with Support on this topic and they will give you the SQL to reseed the SoftwareFile table.
āJul 30, 2021 12:16 PM
āAug 02, 2021 12:04 AM
āAug 11, 2021 12:23 AM