How to force a full Technopedia catalog sync

How to force a full Technopedia catalog sync

If you need to force a full Technopedia catalog sync please follow the steps below:

In the BDNA database run the following:

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

The next time you run a Technopedia catalog sync the full catalog will be downloaded and synced with your system. 

Please note as this is a full catalog sync this will take some time to complete. 

Labels (1)
Was this article helpful? Yes No
No ratings
Comments

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';

 

 

Version history
Last update:
‎Aug 08, 2019 03:45 AM
Updated by:
Contributors