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
      MirrorSync 6: Update, Beta Test,
      and Release Information
      MirrorSync 6 Update
      At 360Works we strive to provide the best quality software and to keep FileMaker Developers well-informed with updates to our products. MirrorSync 6 is making tremendous progress, however it is not yet ready for purchase. At this time, all of the new features have been implemented and we are moving into the quality assurance phase of our development.

      As a reminder, MirrorSync 6 is all about the FileMaker Developer! It makes it much quicker and easier to configure sync in a new solution, but what you will love most is that with MirrorSync 6 there is nothing to re-configure when your solution changes (for client-to-server sync, as well as server-to-server). Additional new features:
      Automated deployment and version management for server-to-server syncs Now uses the Data API (instead of XML or xDBC) All new MirrorSync script, re-written to support new features in FileMaker 17 and later Unlimited tables Leverages new FileMaker features for much faster container field syncs Public Beta Test
      As we continue to work on the quality assurance of MirrorSync 6, we will open a public beta test. MirrorSync 6 beta testers will be a part of an exclusive opportunity as one of the first people to see and experience the new features with a 60 day trial license provided by 360Works. If you would like to be included in this beta tester opportunity, please email support@360works.com. Be sure to let us know what type of configuration you will be syncing, and how many devices you need (if you are doing client-to-server syncs). Spots are limited and will be selected on a first-come, first-served basis.
      Anticipated Release
      We are thrilled to be providing MirrorSync 6 and partnering with the FileMaker community in testing. We foresee the remainder of our quality assurance process to occur over the next few weeks. This means we are anticipating an official release date for MirrorSync 6 by the end of October. As always, we appreciate your continued support and involvement with 360Works products.
      Information on Known Issues
      Known issues - will be resolved in final release:
      There are issues with time zones when the offline device, MirrorSync, and the server are not all in the same time zone. Add an email notification when a server-to-server version update occurs Importing and exporting configurations does not work Client-to-server syncs set to share the same password used in the configuration are still prompted for a password on first sync. Known issues - may or may not be resolved in final release:
      MirrorSync 6 is not backwards compatible with MirrorSync 5, which means you won't be able to sync existing MirrorSync 5 offline copies with MirrorSync 6. Configuration client does not work on Mac OS X with Open JDK installed. Use Java 8 or paid Oracle Java instead. If that's not an option, do the configuration with Windows (via RDP).  
      Stay updated with 360Works
      #360Works
    • By everythingFileMaker
      https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-2/
      This is Part 2 of a 2 part (90 minute) amazing conversation with Rick Kalman, Director of Product Management for FileMaker, and Robert Holsey, Senior Product Manager for FileMaker. Rick and Robert talk about, among other things, Claris Connect, the benefits of acquisition instead of strategic partnerships, save as XML, responsive layouts, Apple's influence, live database development, moving to a web first strategy and changes to the relationship graph. We are very honored that they took so much of their time to talk with us candidly and openly.
      Part 1 was released last Wednesday and has had over 700 downloads. Thanks to all for listening.  Steven Blackwell tweeted that it was an 'Exceptionally significant PodCast' and that 'All #FileMaker developers should listen.' 
      https://firesidefilemaker.podbean.com/e/a-conversation-with-claris-part-1/
      Follow us on iTunes 
      https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes
      Follow us on Podbean
      https://firesidefilemaker.podbean.com
      or find us on YouTube by searching for Fireside FileMaker
      ~

    • By everythingFileMaker
      Welcome Back Claris - Episode #7
      At the FileMaker Developer Conference last week, FileMaker, Inc. announced they had changed their name to Claris International and purchased Stamplay. This is a bit of déjà vu for anyone who remembers MacWrite, MacPaint and Claris Corporation. It’s a blast from the past that’s been modernized. We’ll share our thoughts on the announcement and even speculate as to what the future holds. Come join us for this exciting new era for FileMaker.
      https://firesidefilemaker.podbean.com/e/welcome-back-claris/
      P.S. This is our 7th episode.  The podcast has already had well over 1600 downloads in just under 3 weeks, so a huge thank you to all of our listeners.  It's getting some great reviews and we would love to hear your thoughts and comments.
      New episodes will be released every Wednesday.  Coming up:
      KISS (Keep it simple stupid)
      FileMaker Certification
      Favorites & Features
      P.P.S. If all goes to plan, a very special episode will be released on August 19.  Stay tuned
      Follow us on iTunes 
      https://podcasts.apple.com/us/podcast/fireside-filemaker/id1473715087?mt=2&app=itunes
    • By everythingFileMaker
      Since launching Fireside FileMaker just over a week ago, we've had well over 1000 downloads so thanks to all.  Today, we released a new podcast 'Understanding the Development Process' https://firesidefilemaker.podbean.com/e/understanding-the-development-process/
    • By HOnza
      The 24U's latest FileMaker plug-in now allows for mobile custom apps to securely process credit card payments on the go.
      Prague, CZ -- June 28, 2019 -- 24U Software has released Gonector 1.2.2, a new version of the latest FileMaker plug-in designed specifically for mobile custom apps running on iPads and iPhones. The new version adds direct support for mobile payment terminals from Infinite Peripherals and Ingenico, making it possible to seamlessly integrate credit card payments processing directly to the custom app developed with the FileMaker platform.

      About payment terminals
      Accepting credit card payments on the go has strict security requirements,  which are even not the same on the east and west sides of the Atlantic ocean. Common approach is that the mobile sales person is equipped with a stand-alone payment terminal, so whatever amount they need to charge needs to be manually entered on the terminal's keyboard.
      If the source of the data about the sale is a custom app running on an iPhone or iPad, the most convenient way to implement the payment process is to integrate the payment terminal directly with the app, so that the sales person does not have to re-type the payment amount to the terminal. The application also securely receives confirmation or denial of the payment, so it immediately and reliably knows, whether the payment was successful.
      The payment terminal takes care of reading encrypted data from the customer's credit card. In Europe it also takes care of directly processing the payment transaction online with the credit card issuer. In North America the payment terminal can just provide the encrypted data to the custom app, which then uses payment processing service, such as Stripe, to actually process the payment transaction.
       
      About Gonector
      Gonector is a FileMaker plug-in that allows a native application for iPhone or iPad to communicate directly with mobile hardware devices. Being able to interact with professional mobile devices enables you to use the FileMaker platform to create a POS, Inventory and lots of other heavy-duty mobile business apps with friendly, fast, and reliable user interface.
      The plug-in already supports mobile receipt printers, RFID readers, barcode scanners, digital weighing scales, and even NFC reading built into iPhone 7 or newer, which does not require any additional hardware to work.
      Since the mobile processing differs between North America and Europe, 24U has chosen one popular brand of payment terminals for each continent, Infinite Peripherals for North America, and Ingenico for Europe, and added support for their devices to the Gonector plug-in to allow such seamless integration for custom apps developed using the FileMaker platform.
       
      Availability and Pricing of Gonector
      Licenses for Gonector start at US$499 per app deployed to up to 20 users.
      License for Payment Terminals Edition of Gonector is available for US$7999 and includes implementation support for one type of payment terminal.
       
      More information: https://www.24usoftware.com/gonector
      Buy: https://www.24uSoftware.com/gonector#buy
       
      About 24U Software
      With a team of full-time testers, web, plug-in, Mac, Windows, Linux, iOS, and Android native app developers, and FileMaker certified developers, led by the FileMaker DevCon 2015 Developer Cup champion, 24U excels in taking care of existing FileMaker solutions, optimizing their performance, identifying and resolving potential issues and liabilities, improving reliability, stability and scalability, integrating them with other systems including various hardware devices, and extending them beyond expectation.
      As a platinum member of the FileMaker Business Alliance, we help global businesses around the world to maintain sustainable growth by working with their in-house developers or completely taking care of the maintenance and development of their business solutions.
       
      Customer contact:
      HOnza Koudelka
      Software Division Manager, 24U s.r.o.
      sales@24usoftware.com
      http://www.24usoftware.com
       
      Press Contact:
      pr@24uSoftware.com
       
      ###
       
      (c)2019 24U s.r.o. All rights reserved. 24U, 24U Software, and Gonector are trademarks of 24U s.r.o. FileMaker is a trademark of FileMaker, Inc., registered in the U.S. and other countries. All other trademarks are the property of their respective owners. Pricing and availability are subject to change without notice.
×
×
  • Create New...

Important Information

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