Inventory File moving to Badlogs->Failure folder

[nagaeendra]

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

[ChrisG · Accepted solution]

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.

[ChrisG]

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?

[nagaeendra]

Hi @ChrisG

We are using 2019 R2

[nagaeendra]

Can help to direct us to the hotfix for 2019 R2 for this or share it please

[ChrisG · Accepted solution]

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.

[nagaeendra]

Hi @ChrisG,

This is not the issue, just verified we haven't hit 2,147,483,647. we haven't even reach half way mark. so does not seem to be this issue

[nagaeendra]

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 "

[Alpesh]

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.

[nagaeendra]

Hi @Alpesh,
Yes, we now tried that too, but it did not work for us, we see same error again after reseed.

[nagaeendra · Accepted solution]

Thanks @Alpesh, an custom script from Engineering/support helped us reseed and fix this issue