11/25/2024 4:22:03 PM
|
|
slxdeveloper.com Community Forums |
|
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss SalesLogix synchronization and remote database management. View the code of conduct for posting guidelines.
|
|
|
|
6.2.4 - Sync Client Freezing
Posted: 06 Sep 06 9:23 AM
|
fiogf49gjkf0d Hello,
We have a client that is having problems with transactions freezing the sync client. 6.2.4 recently upgraded from 5.2.
SAGE support gave me a set of SQL statements to test the database, and the following test returned many results.
SELECT A2.TABLENAME, A2.FIELDNAME, A1.FIELDINDEX AS FIELDINDEX, Count(A1.FIELDINDEX) AS DUPLICATES FROM sysdba.SECTABLEDEFS AS A1 INNER JOIN sysdba.SECTABLEDEFS AS A2 ON A1.FIELDINDEX = A2.FIELDINDEX GROUP BY A1.FIELDINDEX, A2.TABLENAME, A2.FIELDNAME HAVING (((Count(A1.FIELDINDEX))>1)) ORDER BY A1.FIELDINDEX
Unfortunately, I don't know how to fix these errors and it appears that SAGE does not either. Does anyone here have any idea how to remove duplicate FIELDINDEXs?
Thank you, Justin Kuehlthau |
|
|
|
Re: 6.2.4 - Sync Client Freezing - UPDATE
Posted: 06 Sep 06 4:15 PM
|
fiogf49gjkf0d Hello,
RJLedger was kind enough to provide me with a solution to the above issue. Thanks again RJ!
So, here is the plan to resolve issues: 1. ASAP - All remote users SEND changes to server via sync. Making sure to disable download and apply changes options. a. After sending changes wait at least one hour then use remote desktop or the web to confirm changes have been made it to the server. b. After confirming changes, users use only remote desktop or the web until a new remote database is installed.
2. Friday Evening – (STOP SYNC and bring down all servers) a. Perform territory realignment with new security model to decrease the size of new remote databases. b. Fix the following issues: i. Rebuild indices. – Done. ii. Run Integrity Checker – Done. iii. Delete 6 bad references from SECTABLEDEFS. iv. Run fix on the duplicate SECTABLEDEFS.FIELDINDEX values. v. Run fix on SECTABLEDEFS.OFFSETS values.
c. Remove all old sync TEFS and databases. d. Cut new remote databases for all users.
3. Move databases to remote servers for user pickup.
4. Monday - Users pick up and install new databases.
Justin Kuehlthau |
|
|
|
Re: 6.2.4 - Sync Client Freezing - UPDATE
Posted: 26 Jan 07 11:29 AM
|
fiogf49gjkf0d Hello,
This was actually caused by bad TEF files created in the web client. Sage produced HF3 for SP5 to fix ths issue.
"SalesLogix v6.2.5 Hot Fix 3 addresses an issue in which remotes hang on bad Transaction Exchange File (TEF) after an activity is created in the Web Client. "
Thank you, Justin Kuehlthau |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|