No Sync Server license still creating queue files
(The following steps apply to MSSQL databases)
People have reported that they removed the Sync Server License from their environment but queue files were still being created. These steps should prevent that from happening:
1. Back up your database
2. Shutdown all SalesLogix Services
3. Run the following statements on the SalesLogix database
o UPDATE sysdba.SYSTEMINFO SET PRIMARYSERVER = 'NOSYNCSERVER'
WHERE SYSTEMINFOID = 'PRIMARY' /* This replaces the existing SyncServer
sitecode with NOSYNCSERVER */
o UPDATE sysdba.BRANCHOPTIONS SET SITECODE = 'NOSYNCSERVER' /*
This updates the BranchOptions table to replace the SyncServer sitecode with
o UPDATE sysdba.SITEOPTIONS SET HOSTSERVER = 'NOSYNCSERVER'
WHERE HOSTSERVER IS NOT NULL /* This will update each user in the
database to use NOSYNCSERVER instead of the SyncServer sitecode*/
o UPDATE SYSDBA.SYNCSERVER SET SERVERPATH = NULL /* This will
update the logging path for the SyncServer to be NULL. Library and Documentspaths will stay intact. */
4. Restart the SalesLogix Server.
5. Ensure the desired SalesLogix services have restarted.
Queue files should no longer be generated.
If you should have any questions and or concerns please call into the Sage SalesLogix support desk. 1-800-643-6400.
Guest Blog by Hugo Vasquez- Technical Account Specialist