Catalog sync fails on 5.5.6 with Normalize : Failed to execute [BDNA Analyze Sync]

[#1]

Summary

This article discusses how to resolve error in BDNA.log : Failed to execute [BDNA Analyze Sync].

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

For the above case :Load catalog to Analyze fails.

Error in BDNA.log : Failed to execute [BDNA Analyze Sync]

Error In UX.log:
ERROR NBI_TP_LOAD_SP
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'TMP_DIM_T_HARDWARE_V'.
Invalid object name 'TMP_DIM_T_SW_SUITE_V'.

Resolution

This issue has been fixed in our July , 2018 patch i.e patch 5.5.8

Workaround

Until the issue if fixed please use any 1 of the below two suggested workarounds:

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.

Once completed re-run catalog sync.

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.