Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Initial Sync Error

UltimateTech
in MirrorSync by 360Works

Featured Replies

Hi All,

 

I'm having an issue during initial sync of my database.

 

When I try to sync, i get the following error:

 

 

Error from server: java.lang.IllegalStateException: There is an error with node Server node FileMaker_Server/Sync_Main; it is not returning sorted records for the initial sync. For example, CAFÉ SPICE338B8F7FE88-0B59-EE49-96B8-84CFB9FABB8F12/09/2013 appears in the list before Caffissimo3897C5E890D-1B91-0C43-A413-885B1EF90BE525/10/2013

 

I am at a loss as to why this is happening or how to fix it. I have tried downloading a new DB file, and also tried to reconfigure the actual MirrorSync settings but I am still having the same issue.

 

Can someone please help?

 

Lloyd

  • Author

I have now updated the MirrorSync installation to version 2, but am now getting a different error!!

Error from server: java.sql.SQLDataException: data exception: string data, right truncation;  table: HUBDATA column: NODEID

Also, under the "Internal" tab, I found the following information under "Webserver Response"

<html><head></head><body><!--Let([$command="error";$$sessionId="1:44:18x91112285014241933823";$serverError="java.sql.SQLDataException: data exception: string data, right truncation; table: HUBDATA column: NODEID";$authenticationFailed=0];True)--></body></html>

Any help would be greatly appreciated.

 

Lloyd

Hi Lloyd,

 

It looks like you're using special characters in your primary keys, and that might be causing some difficulties in parsing the data. Could you please navigate to the MirrorSync page in your browser and click "Report a bug"? This will send us a full log file that might help us better understand what's going on.

 

Thank you,

Sarah Mulligan

Marketing Coordinator

360Works

  • 2 weeks later...

In addition, if you decide to upgrade to MirrorSync 2, we no longer sort the primary keys during the initial sync, so that's another way to solve the problem.

Create an account or sign in to comment

https://fmforums.com/topic/90671-initial-sync-error/
Go to topic listing

Similar Content

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.