The case portal access issue has been resolved. Please see the latest update here.

Project report generation is failing on FNCI instance with MSSQL

Project report generation is failing on FNCI instance with MSSQL

Summary

On project report generation, a Null pointer exception is thrown and report generation fails for a migrated project when using a Windows and SQL Server instance.

Symptoms

This issue occurs on the migrated instances with SQL Server for existing projects. Post migration to 2019 R1 from an earlier release, for an existing project, on report generation for an existing project post , File not found error is thrown on clicking on “View”.

Cause

As part of 2019 R1 release, some tables were altered to add a few columns with default values.

For MSSQL, the default values were only added for new entries and not for existing entries. In MySQL, default values are set for every entries respectively.

Workaround

Execute the following queries on the database:

UPDATE PSE_INVENTORY_GROUPS SET ENCRYPTED_= 2 WHERE ENCRYPTED_ IS NULL;
UPDATE PSE_INVENTORY_GROUPS SET PART_OF_PRODUCT_= 2 WHERE PART_OF_PRODUCT_ IS NULL;
UPDATE PSE_INVENTORY_GROUPS SET DISTRIBUTION_TYPE_= 0 WHERE DISTRIBUTION_TYPE_ IS NULL;
UPDATE PSE_INVENTORY_GROUPS SET LINKING_= 0 WHERE LINKING_ IS NULL;
UPDATE PSE_INVENTORY_GROUPS_AUD SET ENCRYPTED_= 2 WHERE ENCRYPTED_ IS NULL;
UPDATE PSE_INVENTORY_GROUPS_AUD SET PART_OF_PRODUCT_= 2 WHERE PART_OF_PRODUCT_ IS NULL;
UPDATE PSE_INVENTORY_GROUPS_AUD SET DISTRIBUTION_TYPE_= 0 WHERE DISTRIBUTION_TYPE_ IS NULL;
UPDATE PSE_INVENTORY_GROUPS_AUD SET LINKING_= 0 WHERE LINKING_ IS NULL;

Version Fix Target

A fix is targeted in the FlexNet Code Insight 2019 R2 release.

Was this article helpful? Yes No
No ratings
Version history
Revision #:
2 of 2
Last update:
‎Jun 04, 2019 05:37 PM
Updated by:
 
Contributors