Jump to content
Sign in to follow this  
Gelan008

Filemaker error from server FileMaker primary keys must not begin with a 0

Recommended Posts

Hi everyone, i'm a newest user with MirrorSync. 

I could install MirrorSync without problems and get records in my local database, but i had a problem when i try to get records that has the first letter of primary key starts with "0", MirrorSync show the message:

"Error from server: java.sql.SQLException: FileMaker numeric primary keys must not begin with a 0. Either remove the zero padding, or switch the primary key field and all related foreign keys to text. First error: 01234567-DACC-8DE7-58DD-2ASSDE474DCA from table TableName" 

The field its auto-generate UUID of type text.

I try to find a way modified the script MirrorSync, but i dont know how to control this in the script, any solution for this? Thanks! 

Share this post


Link to post
Share on other sites

MirrorSync can handle 0 padding if you're using Developer Managed Keys and not MirrorSync Managed Keys, so for the tables that are using UUIDs, you need to change them to developer managed. The reason that the MirrorSync Managed Keys option can't handle 0s are because MirrorSync writes its internal sync data in SQL, and SQL can't handle 0 padding for primary keys. If you're using UUIDs, you should be using developer managed.

If you have multiple tables where some of them use serial numbers and some use UUIDs you need to change the Table Configuration Options when configuring the sync. You'll see a check box that says "Same settings for all tables." If you're have tables that use either serial keys or UUIDs, you will want to uncheck that and specify which table needs developer managed and which ones need MirrorSync managed.

  • Like 1

Share this post


Link to post
Share on other sites
On 1/25/2019 at 5:06 PM, ryan360Works said:

MirrorSync can handle 0 padding if you're using Developer Managed Keys and not MirrorSync Managed Keys, so for the tables that are using UUIDs, you need to change them to developer managed. The reason that the MirrorSync Managed Keys option can't handle 0s are because MirrorSync writes its internal sync data in SQL, and SQL can't handle 0 padding for primary keys. If you're using UUIDs, you should be using developer managed.

If you have multiple tables where some of them use serial numbers and some use UUIDs you need to change the Table Configuration Options when configuring the sync. You'll see a check box that says "Same settings for all tables." If you're have tables that use either serial keys or UUIDs, you will want to uncheck that and specify which table needs developer managed and which ones need MirrorSync managed.

Thanks! I will try it again 😉

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By 360Works
      Learn How to Easily Set Up MirrorSync!
      We are walking you through the simple setup of 360Works MirrorSync in just 10 minutes! In this video, you will learn helpful tips and tricks in the MirrorSync configuration with 360Works Support Lead, Ryan DeMaeyer.
      MirrorSync is an elegant synchronization product that can sync between any combination of FileMaker Pro, FileMaker Go, FileMaker Server, SQL database (MySQL, Oracle, SQL Server, or any database that supports JDBC), WordPress, Salesforce, Amazon DynamoDB, and Amazon RedShift.
      MirrorSync 6 was recently released. The new major version 6 ships with server-to-server sync improvements where developers can make changes easier, automatic file transfers between servers, automatic version updates between servers, safer syncs, better handling of large files, easy migration, no longer requires Java to be pre-installed, allows for unlimited tables, leverages new FileMaker features for faster container field syncs, and much more!
        Try or Buy MirrorSync   Stay updated with 360Works
       
    • By Prasad Khandagale
      We are happy to announce the launch of the next FM Quizilla – Our Flagship product for FileMaker developers to practice for the FileMaker Certification exam. FM Quizilla supports aspiring developers who wish to be FileMaker 18 Certified. LEARN – EXPERIENCE – PRACTICE giving FileMaker 18 certification exam on your phone or tablet.
       
      What FM Quizilla offers?
      Even as FileMaker is reborn as Claris International Inc. and assumed a new brand identity -- MetaSys Software continues to bring to you the latest version , with all the features you have come to expect !
      FM Quizilla has got a well-researched question bank along with questions related to FileMaker 18. Features like Practice test, Historical Analysis, Reviewing Answers, Tracking your progress will all continue to help you with learning and preparation for certification.
       
      How can the users gain more from this app?
      Users can download the trial version of the app and explore all the app features and a limited number of questions.
       
      Note: Those who purchased the previous version of the app – FM Quizillaa for FileMaker 17 and FileMaker 16 can continue to use it.
       
      Happy Learning!
       
      For more info. https://www.metasyssoftware.com/fm-quizilla
    • By 360Works
      Fireside FileMaker Podcast: 'Keeping it in Sync' featuring Jesse Barnum on MirrorSync and more!
      We have the perfect FileMaker podcast for your listening pleasure as you ease back into the office and start the new year!

      Fireside FileMaker is a podcast collaboration between John Mark Osborne and Michael Rocharde discussing FileMaker related topics in a friendly and informative space.

      Today, we wanted to share the 'Keeping it in Sync' episode of the podcast with you, featuring Jesse Barnum, President of 360Works, for a conversation on MirrorSync, plugins, FileMaker Cloud, Claris Connect and other interesting FileMaker subjects!
        LISTEN HERE   *Learn more about the NEW MirrorSync 6 and download here

      *Follow Fireside FileMaker on iTunes or Podbean
      Stay updated with 360Works
       
    • By everythingFileMaker
      Over a year ago, I started an ambitious project; to develop a FileMaker solution where everything happens on a single screen. It has been much more work than I had anticipated but 8 projects later, it has been defined and refined to the poiint where it is now bulletproof and will work for any solution for any industry.
      On January 3, 2020 I will be releasing NautilusFM to the community under an open source (BSD) license so that anybody and everybody can benefit and learn from it. The release includes a comprehensive ebook with step-by-step instructions and an example file to illustrate all of the techniques and methodologies used; that example file could easily be used as a basis for projects and contains the basis functionality required for every business
      NautilusFM is a framework, a methodology for development.  To read the background story
      www.nautilusfm.com
      NautilusFM is NOT a FileMaker solution although the example file is.
      To find out exactly what NautilusFM is
      http://www.nautilusfm.com/whatis/
      If you have a company or organization and want to find out how NautilusFM can benefit you
      http://www.nautilusfm.com/fororgs/
      To watch a quick tour of the NautilusFM example file
      http://www.nautilusfm.com/videos/
      To get a copy of the completely unlocked and open Example file, please fill out the simple request form
      http://www.nautilusfm.com/example/
      As soon as the file is ready, you'll receive a copy of it via email.
      I'm excited to share it with the community.
    • By 360Works
      360Works Case Study: Sightlines Group Integrates FileMaker and Salesforce using MirrorSync
       
      About Sightlines Group - Improving Organizational Systems and Processes
      Sightlines Group, founded by Chris Barber, works with foundations, community-based organizations, and global technology and banking firms by helping them develop custom software, and by designing and delivering leadership development programs. Sightlines Group works with technical teams or with entire organizations who need to build better relationships with their constituents, track outcomes, research their impact, and tell their story. Furthermore, they provide leadership development and coaching work, including the design and delivery of hundreds of courses to clients including HSBC Bank, Hitachi Vantara, and The Cities for Financial Empowerment Fund.

      FileMaker - The Flexible CRM
      Early on, Chris and his team developed some opinions about the role of customer relationship management (CRM) software, especially for foundations and nonprofits. “Often CRMs box people in and get in the way of adaptation,” says Chris Barber. Sightlines Group works most often with the FileMaker and Salesforce platforms to experience greater flexibility and scalability. FileMaker allows high flexibility, rapid prototyping, and rapid development. Salesforce allows out-of-the-box integration and enterprise scalability.
      The Use Case - Syncing Data Between FileMaker and Salesforce
      The CFE Fund (The Cities for Financial Empowerment Fund: cfefund.org) is a national foundation that helps cities integrate financial empowerment into local government services. Their organization chose the Salesforce platform for its Case Management system which supports Financial Counselors located in cities across the country. First, however, the CFE Fund needed to transform and migrate several years worth of data from a legacy system into Salesforce. Sightlines Group used FileMaker’s rapid development tools to extract data from the legacy system and transform it into Salesforce’s data model. Rather than using traditional migration tools, they reached out to 360Works to see if MirrorSync could allow them to “sync” the data into Salesforce rather than performing a tricky one-time migration. This would allow the migration to happen over time, since data could be migrated to Salesforce, then inspected, and then further transformed from FileMaker, and then synced again to Salesforce.
      The Solution - Using MirrorSync for FileMaker and Salesforce Integration
      Upon first using MirrorSync, Chris and his team at Sightlines Group were pleased to find that they could trust MirrorSync to work reliably under the hood. “MirrorSync worked very well in the background, it has a lot of logic built in. Anyone who has worked with sync, knows that is usually not the case,” recalled Chris. The Sightlines Group team was able to be an important contributor to the use of this Salesforce configuration in MirrorSync for other FileMaker developers by providing helpful experiences they had while working. Chris shared that he was grateful for ongoing efforts from the 360Works team in always taking feedback and turning it around for improvements.
      MirrorSync Provides Seamless Integration
      MirrorSync was able to significantly improve the speed and efficiency in their workflow while accessing data between FileMaker and Salesforce. “Now, we can do this in a snap. We’ll work in FileMaker and watch it sync, using MirrorSync, to Salesforce a moment later. MirrorSync has made a big impact on our work. It's allowed us to merge the best that Salesforce has to offer with the best that FileMaker has to offer," shares Chris. He is very pleased with their new tight integration between FileMaker and Salesforce, he enjoys being able to hook in a variety of web services and have the choice of having them hook to FileMaker or hook to Salesforce.

      Sightlines Group has configured their custom application for The CFE Fund to report back to FileMaker so they can take various actions based on the results in Salesforce, automatically. For example, they now have logic built in for posting to a Slack channel if there is any unexpected behavior within their application. It made their lives so much easier to receive clear information about what's happening back in FileMaker, without it feeling like a bulky add-on.
      MirrorSync Manages Keys
      The feature they enjoy the most is the way MirrorSync manages keys. “It automatically inserts, edits, and deletes child or parent records depending on your architecture. Salesforce keeps its own primary keys, so MirrorSync will take a new record in FileMaker, create a new record in Salesforce, get the Salesforce Id, and write that back to FileMaker, all automatically. If it did not work this way with managed keys, Salesforce would error out as Salesforce has strict key requirements,” reports Chris.
      Final Result: A Complete, Synchronized Custom Application
      MirrorSync is known amongst FileMaker developers to be an automated, customizable, and a fast-working tool. You can set it to sync just certain tables, fields, and records as needed - creating the most customizable synchronization solution. It even does bi-directional synchronization. It's a set-it-and-forget-it solution, and it's very fast. We can enter our data in FileMaker and 30 seconds later it propagates to Salesforce,” says Chris.
      Chris and his team at Sightlines Group are experts in innovation. They work with millions of records in a single solution for The CFE Fund. The technology they choose must be robust enough to handle financial data at a large scale, at all times. Using MirrorSync allowed them to continue building the best possible, most reliable technology solutions for their clientele. “MirrorSync was a lifesaver! We have been using it for about a year now syncing a few million records and 10 tables. It is nearly bulletproof, Chris reports. ”It allows us to get our hands into the data in ways you normally cannot when working with nonprofits. With MirrorSync being bulletproof, we don't have to worry about the syncing, we can step back and treat the application as one: Salesforce and FileMaker.”

      ---

      Contact 360Works for questions or a free 14-day trial of MirrorSync's FileMaker and Salesforce (SQL database) configuration at plugins@360works.com

      Visit the MirrorSync product page!
  • Who Viewed the Topic

×
×
  • Create New...

Important Information

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