Summary

Symptoms

This issue would occur in the following case:

• If customer is on Patch 5.5.6
• Without running Normalize task, If a catalog sync was run and an incremental catalog was downloaded

Resolution

Workaround

1. Run a normalize task and then re-run catalog sync.
2. Run the following statements on BDNA_PUBLISH one at a time in the sequence provided.

exec NBI_CREATE_VIEW_SP 'TMP_DIM_T_HW_PROD_SUBSCRIBED_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_DIM_T_ALL_HW_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_HW_LIFECYCLE_CALC_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_DIM_T_HARDWARE_V', 'With Data', 20180614;

exec NBI_CREATE_VIEW_SP 'TMP_DIM_T_SW_PROD_SUBSCRIBED_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_DIM_N_IT_SW_PROD_TAG_MAP_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_SUITE_COMPONENT_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_FULL_SUITE_COMPONENT_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_FULL_SUITE_V', 'With Data', 20180614;
exec NBI_CREATE_VIEW_SP 'TMP_DIM_T_SW_SUITE_V', 'With Data', 20180614;

--Note: the statements above can be re-run multiple times in sequence.