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.
Related Articles
Logging An InstallScript MSI Project 348Number of Views BeaconPolicy generation is re-setting disabled subnets to enabled despite have been disabled 3Number of Views Running build using Jenkins is failing with error code - 'exit -1073740791' 5Number of Views SSL fails when FNCI is setup on Two Configuration Mode 3Number of Views 'The taskId entered is not mapped to the project or report' When Using Download Reports API 13Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago