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

Data missing from Analyzer report but present in User Console search

Data missing from Analyzer report but present in User Console search

Symptoms:

1)The data (Software or hardware) can be searched using the User Console search box.

Example:

blalvani_0-1583870142604.png

 

2)However it is missing from Technopedia Software table in Analyzer reports

Example:

blalvani_1-1583870199201.png

 

Reason:

The last modified date of the data entry in question was earlier than the applications last catalog ETL date.

So ETL did not update this data in BDNA_PUBLISH : Analyzer tables

Catalog ETL is designed to load incremental/delta data from publish.

The incremental data is determined by the last modified date of catalog data and last ETL date.

In the beginning the last ETL date is set to 1969-12-31 --> This makes it load all data.

If there is some catalog data that is updated on an earlier than the current ETL, the data would be lost in Analyze.

 

Resolution:

1)To force a full ETL to load all data again, we can reset the last ETL date manually:
For SQL Server:
--USE BDNA_PUBLISH
UPDATE BDNA_A_PROPERTIES$ SET VALUE_DATE = '1969-12-31' WHERE VALUE_DATE IS NOT NULL

For Oracle DB:
UPDATE BDNA_A_PROPERTIES$ SET VALUE_DATE = TO_DATE('1969-12-31','YYYY-MM-DD') WHERE VALUE_DATE IS NOT NULL;

2)Rerun the Catalog Sync on the next day when there is new data available,
or
Run the following command on User Console server:
Analyze.exe /ETL=Catalog

Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Mar 10, 2020 03:05 PM
Updated by:
 
Contributors