Some users may have issues creating a community account. For more information, please click here.

DejaCode Open Source Compliance data is missing from Analyze Report but shows up in Technopedia detail page

DejaCode Open Source Compliance data is missing from Analyze Report but shows up in Technopedia detail page

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;

tpOpenSourceData.png

AnalyzeReportOpenSourceData.png

 

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$';
Labels (3)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Dec 01, 2020 04:07 PM
Updated by:
 
Contributors