GoFileRoom uses lookup lists to store client information efficiently so that it's available when you need it. The GoFileRoom LookUpList Sync utility enables you to synchronize GoFileRoom lookup lists with time and billing applications that use a SQL database, such as Practice CS. The utility reads data (client name and ID, vendor information, etc.) from the time and billing application on a scheduled basis and creates a list with that information. GoFileRoom uses this list to define the information to automatically build the list of clients, vendors, or other types of records, so you don't need to manually create those records.

If the utility is configured incorrectly, you will receive an email message from gfrsupport@thomsonreuters.com when errors occur. To specify the email addresses for the recipients who should receive the error emails, contact GoFileRoom Support.

The key to resolving most Lookup List sync errors is to determine when the problem started. In addition to email messages, the utility creates log files that record activity. You can check the log files to help you figure out the problem.

1. In Windows Explorer, browse to the one of the following locations on the computer where the Lookup List Sync utility is installed.
   • 64-bit operating system: C:\Program Files (x86)\GoFileRoom\GFRLookupListSync\Log
   • 32 bit operating system: C:\Program Files\GoFileRoom\GFRLookupListSync\Log
2. Open a recent log and look for entries that are similar to the errors in the email messages.
3. From that point, look for the last time there is an entry such as "Interval complete" or "Successfully uploaded". This will help you pinpoint a time that this last worked correctly.

   This will often correlate with a network change, such as server migration, group policy change, firewall change, or other network setup change. You do not necessarily need to revert the network changes, but this information will make it much easier to determine what you do need to reconfigure to allow the Lookup List Sync utility to work properly.

Error messages

The email you receive from gfrsupport@thomsonreuters.com may include one of the following error messages.

(100) System.Exception: System.Exception: Exception decrypting. Decryption failed...

You may see this message if the GFRLookUpListSync.ini was copied from one computer to another when migrating the service.

Solution: See Error: (100) System Exception: Exception decrypting. Decryption failed. Key not valid for the full error message and details.

(100) System Exception: Add failed. Duplicate key value supplied...

You may see this error when the Lookup List Sync contains multiple list queries with identical information.

Solution: See Error: (100) System Exception: Add failed. Duplicate key value supplied for the full error message and details.

(123) Process Failed. GFR Error Code:-1 Message:Error logging into GFR

You may see this error when the Lookup List Sync service successfully queried the time & billing application, but it encountered a problem when sending the results to GoFileRoom.

Solution: See Error: (123) Process Failed for details.

(301) Error sending list xml. System.Runtime.InteropServices.COMException (0x800C0005)...

You may see this error when you run the GoFileRoom Lookup List Sync service.

Solution: See Error: (301) Error sending list xml for the full error message and details.

(399) Error in ProcessClientSync. System.Data.Odbc.OdbcException...

You may see this multiple times per day, with a secondary error number embedded in the error message itself. Show me.

You may also notice the Lookup List Sync is not working properly and find this error in the log files described above.

• [08001] SQL Server does not exist or access denied...

  Solution: See Error: (399 [08001]) Error in ProcessClientSync. System.Data.Odbc.OdbcException... SQL Server does not exist or access denied... for the full error message and details.

• [42000] Cannot open database requested in login '<gfr_login>'...

  Solution: See Error: (399 [42000]) Error in ProcessClientSync. System.Data.Odbc.OdbcException... Cannot open database requested in login... for the full error message and details.

• [HY000] ODBC--connection to 'GFR_DB_Lookup' failed...

  Solution: See Error: (399 [HY000] Error in ProcessClientSync. System.Data.Odbc.OdbcException... ODBC--connection to 'GFR_DB_Lookup' failed... for the full error message and details.

• [HYT00] Connection login timed out. at GFR_LookuplistSync.Database.Execute...

  Solution: See Error: (399 [HYT00] Error in ProcessClientSync. System.Data.Odbc.OdbcException... Connection login timed out. at GFR_LookuplistSync.Database.Execute... for the full error message and details.

Was this article helpful?

Yes No

Submit