Symptoms:
1)The data (Software or hardware) can be searched using the User Console search box.
Example:
2)However it is missing from Technopedia Software table in Analyzer reports
Example:
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
