Force a full Technopedia catalog sync

[#1]

A full Technopedia catalog sync is a synchronization process that performs a full catalog download instead of the incremental update normally done during a regular/delta catalog sync. This may be helpful, as sometimes updates are made that do not reflect in your catalogs. A full catalog sync will complete the update.

To force a full Technopedia catalog sync, follow the steps below.

1. In the BDNA database, run the following SQL:

update BDNA.dbo.TECHNOPEDIA_VERSIONS set PKG_ID=-1 where _src='TECHNOPEDIA';

2. Open the Technopedia page in the Admin Console application UI. The Technopedia page is indicated by the “T” symbol at the top of the Admin Console UI.

3. Select START CATALOG SYNC to begin the synchronization process.

After running the Technopedia catalog sync, the full catalog will be downloaded and synced with your system.

NOTE: As this is a full catalog sync, it will take longer to complete than a regular/delta catalog sync.

[jasonlu]

For me, running SQL Server 2019 and SQL Service Management Studio 18,
this command required double quotes around the "_src" in order to work.
So the command is:

update BDNA.dbo.TECHNOPEDIA_VERSIONS set PKG_ID=-1 where "_src" = 'TECHNOPEDIA';