Project report generation is failing on FNCI instance with MSSQL

Yes

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.

Project report generation is failing on FNCI instance with MSSQL