intannh
Active participant

Reconciliation fails with error after upgrade to FNMS 2019 R1: "Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Could not find stored procedure"

Jump to solution

Hi, 

We just completed the upgrade from FNMS 2018 R2 to FNMS 2019 R1. However, post upgrade the reconciliation process encountered an error with message Error: Exception has been thrown by the target of an invocation. Addition to that, unable to access few pages from web UI i.e. All Inventory page with Error ID: f73d4b45-4db3-4b4e-9d81-c487eabf27a9

Has anyone encountered this before?

 

Thank you.

 

Regards,

Intan

0 Kudos
1 Solution
intannh
Active participant

We managed to solve this. As you pointed out, the cause was the compliance db wasn't properly migrated.

Resolution:

  1. Verify CMSchemaVersion should be 13.2 unless it wasn't properly migrated
  2. Because it wasn't properly migrated, we had to remove cm-migr1310-MigrateSAPRoleConsumptionBulkCopy.sql lines from ComplianceMigration.xml as this cause an error (customer no longer use SAP)
  3. Remove SAP related sql's from cm-migr1310-migpost.sql 
  4. Rerun mgsDatabaseUpdate.exe for compliance db
  5. Verify the CMSchemaVersion = 13.2
  6. Reconfigure the system

FNMS is working fine now. Thank you.

View solution in original post

3 Replies
mfranz
Trusted advisor

Hi Intan,

Does this error occur repeatedly?

Reading the log it looks like the actual reconcile has not begun yet. Instead it is the ManageSoft reader that fails. You could check the reader and find the exact step failing (around "ProcessCSPMetadataJsonBlob").

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos
ChrisG
Community Manager Community Manager
Community Manager

The "Could not find stored procedure" message in the import log is the key one to look at here:

2019-07-19 11:42:23,592 [ERROR]     System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Could not find stored procedure 'ImportedComputerForCSPMetadataGetAllByComplianceConnectionIDCloudServiceProvider'.

This suggests that there is a mismatch between the version of the database schema and the version of the installed FlexNet components: the ImportedComputerForCSPMetadataGetAllByComplianceConnectionIDCloudServiceProvider stored procedure that was added in the 2019 R1 release has not been configured in the database [yet]. Is it possible that the database upgrade and installation steps for the 2019 R1 release have not been successfully executed yet?

(Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)
intannh
Active participant

We managed to solve this. As you pointed out, the cause was the compliance db wasn't properly migrated.

Resolution:

  1. Verify CMSchemaVersion should be 13.2 unless it wasn't properly migrated
  2. Because it wasn't properly migrated, we had to remove cm-migr1310-MigrateSAPRoleConsumptionBulkCopy.sql lines from ComplianceMigration.xml as this cause an error (customer no longer use SAP)
  3. Remove SAP related sql's from cm-migr1310-migpost.sql 
  4. Rerun mgsDatabaseUpdate.exe for compliance db
  5. Verify the CMSchemaVersion = 13.2
  6. Reconfigure the system

FNMS is working fine now. Thank you.

View solution in original post