Workgroup Synchronization Commence Corporation Workgroup Synchronization u u

Workgroup Synchronization Commence Corporation

Workgroup Synchronization u u u Basics Changes between 3. x and 4. 0/2000/RM Details of Synchronization DATA. INI settings that affect synchronization Troubleshooting General steps u Examples u

The Basics u Commence keeps track of the changes SYNCLOG. PIM u DATA. INI u u DATA. INI has pointers into synclog. pim that say what has and has not synchronized. Changes copied to files u u SYNCLOG. PIM lists all the changes in order 0001006 b. UP Example of a file name: 1 st 4 digits are a seq. Number, last are the Workgroup ID Files are exchanged between the Clients and Server Shared LAN Directory u E-Mail u FTP Site u

Typical Workgroup Commence Server PC Client A Client C Client B

Typical Workgroup Commence Server PC Client A Client C Client B Changes are made to the client database on Client A

Typical Workgroup Commence Server PC Client A Client C Client B Changes are copied to the Server database via synchronization files (packets)

Typical Workgroup Commence Server PC Client A Client C Client B Server copies all changes it received and communicates them to the other client databases via synchronization files

Changes between 3. x and 4. 0/2000/RM Version 3. x Version 4. 0/2000/RM ¨ Pointer into SYNCLOG. PIM maintained by ‘local’ into SYNCLOG. PIM maintained by ‘remote’ ¨ If sync packet lost/bad, data will be re-sent ¨ DATA. INI only refers ¨ DATA. INI refers to to ‘local’ and ‘remote’

DATA. INI ¨ Commence 3. x ¨ Backup#=<Name>; <WID>; <Local> • <Name> - User ID the of the user associated with the backup line. • <WID> - Workgroup ID (in decimal), can be determined by selecting Help-System Information. Workgroup Information (in Hex). Each client has a unique number. • <Local> - A number. Represents a pointer into the SYNCLOG. PIM file of the next change to synchronize out. All numbers should be in the same range.

DATA. INI ¨ Commence 4. 0/2000/RM ¨ Backup#=<Name>; <WID>; <Local>; <Remote>; <Status> • <Name> - Same as 3. x. • <WID> - Same as 3. x, except the number is displayed in Hex. • <Local> - A number. Represents a pointer into the SYNCLOG. PIM file of the next change to synchronize out. All numbers should be in the same range.

DATA. INI ¨ Commence 4. 0/2000/RM ¨ Backup#=<Name>; <WID>; <Local>; <Remote>; <Status> • <Remote> - A number. Represents a pointer into the SYNCLOG. PIM file of the ‘remote’ of the next change to synchronize out. It also represents the last changes that the ‘local’ received successfully. • <Status> - Current synchronization status, i. e. sending a sync file or receiving one.

Client Synchronization - General

Server Synchronization-General

Client Sync Out Process A

Server Sync In Process C

Server Sync Out Process D

Client Sync In Process B

DATA. INI Settings The following settings affect workgroups and workgroup synchronization: [Other Options] Message. Log. Update=# (in sec. default=10) Message. Log. Min=# (in KB, when active. log reaches max, it is truncated to this value) Message. Log. Max=# (in KB, the maximum the active. log file can reach before truncating, default=64)

DATA. INI Settings [Workgroup] Enable=# (possible values: 0 or blank standalone database 1 remote database 2 base database 3 client database 4 server database Note: Do NOT change these numbers manually!) Server=TRUE/FALSE

DATA. INI Settings Shared. DBID=# (The ID of the database. All clients of this database must have the same ID. Note: Do NOT change this number manually!) Num. Entries=# (The number of backup lines, including the lines for remote databases. ) Remote. Count=# (The number of remote databases)

DATA. INI Settings Max. Packets=# (Only valid at server. The maximum number of sync packets the server will process in one sync interval. Default=50, valid values=1 -32, 000. If set to 0, will not synchronize. Sync. Valid=list of valid backup line numbers. (When a client is registered or removed, this line is updated. Typically, this line is edited if a SYNCLOG. PIM file is very large. )

DATA. INI Settings Backup#=<Name>; <WID>; <Local>; <Remote>; < Status> ¨ ¨ ¨ Name and WID are the User ID and the Workgroup ID of the user the backup line is for. <Local> is the pointer into the local SYNCLOG. PIM file. It points to the next change that needs to synchronize out. <Remote> is the pointer into the remote SYNCLOG. PIM file. It points to the location where the local database last successfully synced in.

DATA. INI Settings Backup#=<Name>; <WID>; <Local>; <Remote>; <Status> ¨ <Status> a number that shows the current sync status. • -1 An error occurred when converting from the 3. x format to 4. 0/2000/RM • 0 Only used when convert from 3. x to 4. 0/2000/RM • 1 No activity. • 2 Local is sending a sync file to the remote • 3 Local is receiving a sync file from the remote • 4 Local is waiting for a response from the remote • 5 Local is reading/processing a sync file from the remote • 6 Local is writing a sync file for the remote

Syncing Tidbits Server will only sync out in response to a request from the client. ¨ The Server will NEVER accept a complete sync from a client. ¨ Sync packets are created every sync interval, even if no changes occurred. ¨

Syncing Tidbits ¨ Data/Definitions sync out/in a particular order: ¨ Sync • • • In: Administration Files Categories Items Connection Definitions Connection Data Detail Forms Color Codes Letter Templates Views Desktops Agents

Syncing Tidbits ¨ Data/Definitions sync out/in a particular order: ¨ Sync • • • Out (Complete): Administration Files Categories Connection Definitions Items Connection Data Detail Forms Color Codes Letter Templates Views Desktops Agents

Syncing Tidbits ¨ Data/Definitions sync out/in a particular order: ¨ Sync • • • Out (Incremental): Administration Files Items Connection Data Categories Connection Definitions Detail Forms Color Codes Letter Templates Views Desktops Agents

Troubleshooting Basic Process: 1. Check the ATIVE. LOG or Message Log for errors. 2. Make sure you are looking at the right place. The Message Log may say the error occurred at the server or at the client. 3. Determine what process was occurring when the error occurred (syncing out/in at the client/server).

Troubleshooting Basic Process: 4. If you can determine the process, locate it on the flowchart. Any possible errors here? 5. If still not sure, gather more information by turning on trace • /trace=2 for full details 6. Recreate the problem and look at the log file.

Troubleshooting Basic Process: 7. Check the Technical Notes on Admineng (TN 4310) and Commence Internal Status (TN 3312) errors. It’s a learning process.

Troubleshooting Common problem: Shrinking sync log file. (UINFO-WG-2345) Solution: Remove any unused clients, check and fix data. ini.

Troublshooting [Workgroup] Enable=4 Sync. Valid=1 2 3 4 Backup 1=user 1; 0 X 6501; 34567; 456; 1 Backup 2=user 1; 0 X 6601; 0; 0; 1 Backup 3=user 1; 0 X 6701; 34500; 234; 1 Backup 4=user 1; 0 X 6801; 2000; 1 ¨ Edit Sync. Valid= and remove 2, 4

Troubleshooting ¨ ¨ ¨ CLIROLE. CPP: 207: 15. 07. 97: 19: 16: Commence internal status information - (ERR-DENG-2301) CLIROLE. CPP: 959: 15. 07. 97: 19: 16: Contact your administrator: This client failed while syncing in from the server. Check the Message Log for information about the problem. Auto -syncing will be disabled until the problem is resolved. (TECHWG) CLIROLE. CPP: 692: 15. 07. 97: 19: 16: Contact your administrator: This server failed while syncing out to the client. Check the Message Log for information about the problem. Auto -syncing will be disabled until the problem is resolved. (TECHWG) These messages don’t mean anything without the previous portions of the Message Log or ACTIVE. LOG. They just say that there was some problem.

Troubleshooting-Example 1 15. 07. 97: 19: 16: Copying In Connection: Contact Log Created by Employees (UINFO-WG) 15. 07. 97: 19: 16: Leaving Sync. In. Complete. (UINFO-WG) 15. 07. 97: 19: 16: Leaving Sync. In. (UINFO-WG) 15. 07. 97: 19: 16: Auto-sync error: Unknown error. Please call Tech Support. (UINFO-WG-2022) CLIROLE. CPP: 959: 15. 07. 97: 19: 16: Contact your administrator: This client failed while syncing in from the server. Check the Message Log for information about the problem. Auto-syncing will be disabled until the problem is resolved. (TECH-WG) CLIROLE. CPP: 608: 15. 07. 97: 19: 16: Commence internal status information - (ERR-DENG-2301) CLIROLE. CPP: 692: 15. 07. 97: 19: 16: Contact your administrator: This client failed while syncing out to the server. Check the Message Log for information about the problem. Auto-syncing will be disabled until the problem is resolved. (TECH-WG) CLIROLE. CPP: 207: 15. 07. 97: 19: 16: Commence internal status information - (ERR-DENG-2301)

Troubleshooting-Example 2 4/07/97: 10: 24: Copying Out Connection Data: Help Desk Call Allocated To Person (UINFO-WG) vardata. c: 2094: 4/07/97: 10: 27: Commence internal status information (ERR-DENG-2301) 4/07/97: 10: 27: Leaving Sync. Out. Complete. (UINFO-WG) 4/07/97: 10: 27: Auto-sync error: Ðgfgf. ZgfzgÇBüÿgzgzgÇBM (UINFO-WG 2022) 4/07/97: 10: 27: Compressing sync data. (UINFO-WG) 4/07/97: 10: 27: Sending sync command. (UINFO-WG) 4/07/97: 10: 27: Receiving sync data. (UINFO-WG) 4/07/97: 10: 27: Entering Sync. Out. (UINFO-WG) 4/07/97: 10: 27: Leaving Sync. Out. (UINFO-WG) 4/07/97: 10: 27: Auto-sync out for: BG (UINFO-WG) ¨ Result: Bad connection data.

Troubleshooting-Example 2 xfershar. c: 893: Copying Out Connection Data: Printing Job Has Status Print Job Status (UINFO-WG) xfershar. c: 893: Copying Out Connection Data: Help Desk Call Relates to Resource (UINFO-WG) vardata. c: 2094: Commence internal status information - (ERR-DENG-2301) xferout 2. c: 550: Commence internal status information (errorno=29) - (INT-DENG 2019) xferout 2. c: 775: Bad return (INT-IMPORT-2261) sync. c: 925: Commence internal status information - (INT-WG-2301) sync. c: 970: Leaving Sync. Out. Complete. (UINFO-WG) syncconn. c: 648: Auto-sync error: f. Rè? ìfÐgfgf. ZgfzgÇBüÿgzgzgÇBM (UINFO-WG 2022) syncconn. c: 649: Sync. Out failed in Scan. Files. (INT-WG) syncconn. c: 1511: Compressing sync data. (UINFO-WG) syncconn. c: 1526: Sending sync command. (UINFO-WG) ¨ Result: Bad connection data.

Troubleshooting-Example 3 asimp. c: 1582: 06/07/1997: 3: 27 PM: Record 1, Field 6 of file C: WINDOWSTEMP~SLX 215 ACLS 00002. DBF does not map to a field, and Commence cannot continue importing. (TECH-IMPORT-2305) ¨ Result: Category definitions are not the same.

Troubleshooting-Example 4 Copying Out Category: Person(UNINFO-WG) Copying Out View: People (UINFO-WG) Leaving Sync. Out. (UINFO-WG) Auto-Sync out for: Sue (UINFO-WG) Compressing sync data (UNIFO-WG) Sending sync data (UINFO-WG) syncconn. c: 708: ADMINENG. DLL encountered an error: 25, 0, 0 x 73, 1424 ¨ Result: Syncing with removed user

Troubleshooting-Example 5 shar. c: 893: Copying Out Letter Template: Expenses (UINFO-WG) s. c: 72: Commence internal status information (errorno=10) (INT-DENG 2019) s. c: 72: Commence internal status information (errorno=12) (INT-DENG 2019) ¨ Result: Problems with letter templates.

Troubleshooting-Example 6 syncconn. c: 1290: Compressing sync data (UINFO-WG) syncconn. c: 1290: Sending sync data (UINFO-WG) syncconn. c: 1962: ADMINENG. DLL encountered an error: 7, 16430, 0 x. BA, 1472, (000100 ba. dwn). (ERR-WG-2339) ¨ Result: Network permissions not properly set.

Troubleshooting-Example 7 syncconn. c: 1962: ADMINENG. DLL encountered an error: 32, 15, 0 x 3, 4562, (). (ERR-WG-2339) ¨ Result: Problem logging into mail program.

Troubleshooting-Example 8 XFERSHAR. cpp: 1101: 6/10/97: 12: 02 PM: Copying In Category: Product Service (UINFO-WG) DISKIO. cpp: 987: 6/10/97: 12: 02 PM: Open: objects. pi. W, FH = 26 (PERFIO-2190) DISKIO. cpp: 987: 6/10/97: 12: 02 PM: Open: thid. pim, FH = 26 (PERF-IO 2190) SYNCTHID. cpp: 423: 6/10/97: 12: 02 PM: Commence internal status information (errorno=29) - (INT-DENG-2019) SYNCTHID. cpp: 102: 6/10/97: 12: 02 PM: Commence internal status information - (INT-WG-2301) ¨ Result: Bad internal IDs. Must send data to Technical Support.

Commence Corporation