Due to hardware failure I've moved SLX to a new server. I have updated the "Offices" in Admin to point to the new shares at \\NEWSERVER\\SalesLogix_Live\Documents, but when I attach a document to a contact in the client, it's still putting it on \\OLDSERVER\SalesLogix_Live\Documents.

One problem I have is that this is an old system that's been unmanaged for some time, and I have two "offices" in the list and three sync servers. We only have one location really, and don't use remote clients.

Where are my clients getting the document location from?

thanks,

M

Look in Admin - go to Systems, bring up the office - you will see the paths listed, change - should be done.

That's the weird thing - that's where in a past life as SLX admin I've made these sorts of changes.

I have:

2CLY, Remote=Yes, SyncServer=UF6C, Attachment Path=\\NEWSERVER\SalesLogix_Live\Documents, Library Path=\\NEWSERVER\SalesLogix_Live\Library
0EVK, Remote=No, SyncServer=0EVK, Attachment Path=\\NEWSERVER\SalesLogix_Live\Documents, Library Path=\\NEWSERVER\SalesLogix_Live\Library

If you are sure you don't use remotes anymore then disable sync entirely:

UPDATE sysdba.SYSTEMINFO SET PRIMARYSERVER = 'NOSYNCSERVER' WHERE SYSTEMINFOID = 'PRIMARY'
go
UPDATE sysdba.BRANCHOPTIONS SET SITECODE = 'NOSYNCSERVER'
go
UPDATE sysdba.SITEOPTIONS SET HOSTSERVER = 'NOSYNCSERVER' WHERE HOSTSERVER IS NOT NULL
go

(ignore any errors reported with above)

Then, in Admin, remove the syncserver license (& any other remote offices etc) then, also in Admin, make sure the paths point to right place.

Ah, this is interesting - when I look in BRANCHOPTIONS I have three records, and one of them has the settings the clients are getting, but it doesn't show in Admin. It looks like the related ADDRESS record was deleted. I linked the record to a valid address, and now it shows in Admin.

I will remove all the sync settings though, we have no remotes.

You will - the main office plus 2 remote offices that are no longer in use. These will be removed once you remove the licenses (or manually via the scripts).

Right now, new documents are going into C:\Programdata\SalesLogix\Sync\Documents instead of to the server.

Here's what I currently have:

SYSTEMINFO
SYSTEMINFOID DBTYPE PRIMARYSERVER SITECODE PINGSERVER
PRIMARY      1      NOSYNCSERVER  6UJ9     SALESLOGIX

 

BRANCHOPTIONS
SITECODE ATTACHMENTPATH                         SALESLIBRARYPATH
0EVK     [empty]
2CLY     [empty]
UF6C     \\SalesLogix\SalesLogix_Live\Documents \\SalesLogix\SalesLogix_Live\Documents

SYNCSERVER
SITECODE MAINSERVER SERVERPATH
0EVK     0EVK       \\SalesLogix\SalesLogix_Live\Documents 
2CLY     2CLY       \\SalesLogix\SalesLogix_Live\Documents 
FWDD     0EVK       [empty]
UF6C     UF6C       \\SalesLogix\SalesLogix_Live\Documents 

OK, run the script sent. Then go to license and remove the syncserver + remote office licenses. This should clear up branchoptions and leave you with one. If not, make sure the sitecode is matching that of the main office and delete the 2 others you don't need. Then set the paths.

Genuis. Thank you!

The multiple branchoptions records were causing a problem with the update, and even after deleting the licenses there were several records in both BRANCHOPTIONS and SYNCSERVER. I removed those (backed up, etc) as they seem to be relics of some past hackery.

Clients appear to be working now.

thanks again,

M