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

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

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

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.
Labels (2)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Oct 17, 2018 08:59 PM
Updated by: