Jump to content
Siva D

Is it possible to skip one particular table included in MirrorSync configuration?

Recommended Posts

I am getting an error while sync,
"Last sync failed: com.prosc.sync.AbortException: Failure while recording changes from FileMaker Server java.sql.SQLException: IO error: position 13016373"

Is it possible to skip this one particular table in MirrorSync sync to test the other tables?

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By neocodesoftware
      Goal - use MirrorSync with database hosted on FileMaker Cloud, using MirrorSync hosted on a Windows Server.
      Error - filemaker mirrorsync jdbc error cloud requires version 16.0 or later
      MirrorSync version 3.17
      FileMaker Cloud
      Steps to reproduce
      1. run mirrorsync
      2. create filemaker client to server config
      3. configure mirrorsync to use hosted version
      4. configure publishing engine / database server to use cloud
      5. put any database user, pass or name - it doesn't matter what you put - real or not real
      6. you will error -  filemaker mirrorsync jdbc error cloud requires version 16.0 or later

    • By Jason Mundok
      Is there a way to customize the language in the dialog box that appears after a successful sync when there's a new database version available?
      "There is a new database version available named 'x.xx'. Would you like to replace your current offline file with this version?"
    • By APMT Los Angeles
      I'm planning to use MirrorSync to sync my FM Webdirect database to a SQL Server, one-way sync. Basically, this is for reporting purposes. But in all of the 360 Works help docs, I don't see even one guide/screenshot/anything on how to setup the SQL Server. What information is required, how does MirrorSync authenticate to SQL Server, what specific permissions does it need, etc...  nothing at all.
      Has anyone done this who can provide some information? I work for a large organization and need to know how to setup this SQL Server before jumping into configuration. (Primarily authentication, we prefer windows authentication so will MirrorSync connect to SQL Server as the windows service account that is running the FM Server? Or does it need a SQL account? And what permissions are required?)
      Thank you! And 360 Works, please add this to your help docs!!
    • By 360Works

      How to Sync with FileMaker Cloud Using 360Works MirrorSync Today we want to let you know that it is completely possible to sync a FileMaker solution hosted on FileMaker Cloud! MirrorSync has been able to handle this task since the release of 3.1. The current version is 4.0 and it remains compatible with FileMaker Cloud.
      FileMaker Cloud leverages Amazon Web Services (AWS) to host your FileMaker solutions in the cloud. Many people are moving to the cloud to cut back on server maintenance time and money. Here at 360Works, we are big fans of AWS - we actually moved all of our hosting to AWS and couldn't be happier. (Jesse Barnum, president of 360Works, presented on the topic of deploying FileMaker Server with AWS at last year?s FileMaker Developers conference.)
      Getting started with MirrorSync for FileMaker Cloud is extremely simple: There's nothing to install and only a couple of steps to get up and running!
      Step 1: Host MirrorSync Elsewhere
      You will need to run MirrorSync on a separate computer from your FileMaker Server, because FileMaker Cloud does not allow the installation of 3rd party software other than plug-ins (MirrorSync is not a plug-in).

      Once you've launched your FileMaker Cloud instance, 360Works can host MirrorSync on a managed AWS server for just $29 a month. There are several other approved hosting providers willing to host MirrorSync as well (see documentation). Alternatively, knowledgeable Linux administrators can host on their own Linux instance with Amazon Web Services.
      Step 2: Enable xDBC
      Because there is no XML Web Publishing Engine with FileMaker Cloud, you must enable incoming access (to port 2399) on your FileMaker Cloud instance in order for MirrorSync to communicate with it using xDBC. You can do this in the AWS console, follow along with this short video:
      A Few Final Notes
      *You will want to reference our MirrorSync and FileMaker Cloud documentation for complete technical guidelines.
      *Users running regular FileMaker Server on a Mac or Windows computer can install MirrorSync 4 on their own server.
      *We've designed MirrorSync to be something that even a novice user can integrate, but we're standing by when you need more advanced help. If you just want your sync integration to be completed as quickly as possible, we're available to do the work for you directly at our hourly consulting rates. Fill out our message form for advanced help!
        Download MirrorSync 4  
    • By guit4eva
      Hi guys,
      I am trying to set up MirrorSync with a Data Separation Model setup and need a spot of help. I have the DATA file hosted on FMPHost.com, and a local copy of the UI. The documentation states that I must set up MirrorSync in the UI file, then copy that across to the DATA file. However, the setup window only gives me the option to select the DATA file. I'm a bit stuck now, could anyone shed some light on how to proceed?
      Thanks in advance!

Important Information

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