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$';
