This issue only happens to the environment which the current technopedia version is on 2020-11-12 or old than 2020-11-12
Symptoms:
1. When browsing 'Multipass' product, you will see its DejaCode Open Source Compliance data in techopedia detail page, but the DejaCode data will not be available in analyze report.
2. The below sql query will return nothing (let's take product - 'Multipass' as example)
SELECT * FROM TMP_CAT_DEJACODE_OPENSRC_SW_INIT WHERE CAT_SW_PRODUCT_ID=1030639492;
Solution:
The workaround for this case is to manually run below SQL statement in BDNA_PUBLISH database:
execute CREATE_CAT_MAT_VIEW_PROC @p_task_id = 0, @p_table_name ='CAT_DEJACODE_OPENSRC_SW' ,@p_m_table_name ='TMP_CAT_DEJACODE_OPENSRC_SW_INIT'; UPDATE BDNA_A_PROPERTIES$ SET VALUE_DATE='1969-12-31' WHERE VALUE_DATE IS NOT NULL AND PROPERTY = 'DIM_T_OPENSRC_SW$.LAST_MODIFIED_DATE'; EXECUTE NBI_CREATE_VIEW_SP 'TMP_DIM_T_SW_PROD_SUBSCRIBED_V','With Data', '9999'; EXECUTE NBI_CREATE_VIEW_SP 'TMP_DIM_T_OSS_V','With Data', '9999'; execute NBI_DIM_T_LOAD_TABLE_SP 'DIM_T_OPENSRC_SW$';
Was this helpful?
Related Articles
Clean old data from Analyze Reports 5Number of Views Data missing from Analyzer report but present in User Console search 8Number of Views Icons are missing from "Reports" page 5Number of Views IBM PVU License Consumption report doesn't list the agent as the source if another source is newer, even if the other sour… 4Number of Views Aggregation showing completed in ?Aggregation Status report?, but actually data is not aggregated properly 6Number of Views
Revenera Assistant
Online
Hi, I am Reva - Ask me anything.
Updates
No new updates
Chat
Home
Updates
/**/
Thanks for the feedback!
Your feedback has been saved.Rate this response:
1
2
3
4
5
Add Additional feedback ( Optional )
0/240
English
English
Language changed successfully
Something went wrong
Email sent successfully
Something went wrong
Case create successfully
Are you sure you want to cancel
the case creation?
Please select a product to submit the case.
Please select a product version to submit the case.
0/255
Upload Attachment
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
Are you sure you want to cancel the case creation?
Case closed successfully
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
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. | |
File Upload
Maximum file
size allowed is 3 MB.
File type
not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files
(.csv) Speadsheets (.xlsx, .xls)
© 2026 Flexera Software. All Rights Reserved.
Case id: 00001065
Activity: Status change: 2 hours ago