UltimateTech Posted July 21, 2014 Posted July 21, 2014 Hi all, I am getting an error tat I cannot seem to get past. The error string that comes up is: Jul 21, 2014 6:41:23 PM com.prosc.mirror.config.server.SyncServer$4 callSEVERE: Sync between icompli.tesg.local / iCOMPLI Auditor_Tenancy Lite V7 (FileMaker Server) and Michael's iPad's Go_iPad 13.0.4( username 'michael krogh', running Go_iPad 13.0.4 on 192.168.40.114, ping time: 267 ms, machine name: 'Michael's iPad' )Last sync failed: java.lang.RuntimeException: java.sql.SQLException: There is an invalid character in FileMaker on layout Sync_Main. Last text received was [iNSERT COMMA SEPERATED VALUES OF KEYS HERE] There is an invisible ASCII 0 at the end of this text which needs to be fixed. Please find this record, remove the invisible character, and try the sync again. I have been through the text and I cannot find any issues, spaces or extraneous characters. Anyone have any ideas?
ggt667 Posted July 21, 2014 Posted July 21, 2014 Try this procedure inside the field in question: Select All Copy Select All Paste Undo For the Mac that would be( For windows there would be CTRL? ): CMD + A CMD + C CMD + A CMD + V CMD + Z Problem still there?
UltimateTech Posted July 21, 2014 Author Posted July 21, 2014 i dont knw which field is causing the drama. It gives me a list of about 700 unique identifiers. See Below: Jul 21, 2014 9:06:29 PM com.prosc.mirror.config.server.SyncServer$4 callSEVERE: Sync between icompli.tesg.local / iCOMPLI Auditor_Tenancy Lite V7 (FileMaker Server) and Theos iPad's Go_iPad 13.0.4( username 'theo naidoo', running Go_iPad 13.0.4 on 192.168.40.113, ping time: 143 ms, machine name: 'Theos iPad' )Last sync failed: java.lang.RuntimeException: java.sql.SQLException: There is an invalid character in FileMaker on layout Sync_Main. Last text received was ["BAYVIEW BULKY GOODS CENTRE - WARRAWONG708BB323C8A-B797-0C42-A53F-81DC957E4E2219/02/2014","JB WOLLONGONG7149542DEC0-D4CF-A748-92E2-35FD4E4BCFE419/02/2014","WESTFIELD CHATSWOOD7101479867E-0E6E-FC42-A9BD-3E485F6705E919/02/2014","WORLD SQUARE715F24475DA-334C-6E42-8DD6-569BE5F1AA1B19/02/2014","WESTFIELD SYDNEY7139A9EEA4E-171B-4D42-80A2-17ED36F8907819/02/2014","WESTFIELD PARRAMATTA712CBD90F32-174B-864B-8715-CAFEB8E92D9C19/02/2014","PORT MACQUARIE69894AAA7EB-EAF4-9742-A866-C6AD7B3DE95D19/02/2014","JB Hi - Fi MELROSE PLAZA7575E25FEAE-D2C1-724C-9E95-464BE8CBA35619/02/2014","COLONNADES Shopping Centre7533A4DE7CB-0EA9-804B-A9E0-5797C812F3AD19/02/2014","Factorie1527DE3D5C47-A8EE-3F4B-8836-E5B60B56975624/02/2014","Cotton On 1527A3DB516D-AA9F-904B-B569-4425CC2FFBE224/02/2014","Nike 15275BE72C6E-EEA9-1741-8328-3A70F632968B24/02/2014","Glue Store1527AC50F3F1-A61A-9347-BEE4-66F7112E0DB524/02/2014","Mink 1527C98B0C07-8A82-7F40-AF24-6D77B85D436B24/02/2014","67824/02/2014","Rubi Shoes15279C54BC1A-1263-4408-9D27-B2D1625A1D1224/02/2014","Cotton On Body 1527058688D4-D642-BD44-9436-A6BD593BAC9B24/02/2014","Rebel Sport152735572462-F824-5041-9155-799E2EA23E6C25/02/2014","ProfessioNail15275B1E76FF-44ED-2646-BA0D-6B10DCA119D825/02/2014","Bikini Island15271A53673F-5D0D-DD41-84C2-13C64E45830425/02/2014","Pulp15276CBAEF00-C4F4-4749-8BC7-CD67FA42CBBE25/02/2014","Review152783DA1F2F-AC16-D641-BC14-CEA838BF671725/02/2014","Bardot1527E38A48A2-3179-BC48-9BDF-2C90BAEF5CC825/02/2014","Lovisa 1527A0143DC3-286C-0546-8FD4-361D51D545F625/02/2014","Wanted 1527914C57D5-3CD1-9A4E-B333-DA69D942610925/02/2014","Sheike 1527F42BF26D-2274-0B4A-A99E-873B49C7C9BB25/02/2014","Peter Alexander152723FDE882-026F-2444-9297-9D14FC10CC3225/02/2014","T21527846C15CF-A2A7-FD4E-A31A-4F679FA6743625/02/2014","Cue1527D3436FFB-4617-6949-BD94-E76E10BBB99925/02/2014","Country Road15277EC8DB1E-CA61-D14D-9BAA-0CA0399974F325/02/2014","Wittner15277332D685-033F-4338-9786-576667A5AFF325/02/2014","Table Eight152700A49FF2-80A3-1448-A8A4-B3D73B0208CB25/02/2014","OPSM15274CF5BB63-4C02-2841-9794-1C8763F19F0125/02/2014","Ella Bache1527EC1CBE18-C973-AB45-94B0-0CF7D5DDAA0425/02/2014","Cotton On Kids1527BF25DF61-99B2-344E-8A21-BEC57D036D5225/02/2014","Kidstuff1527928CDDB1-FC8C-BD45-8C4D-A5FC6FB3242525/02/2014","Tree Child 15270F3081B8-E239-7A4D-BA48-9273BB6AF7BB25/02/2014","Golden Beauty & Nails 15278B796D2C-5ED6-7842-BE6A-335D7B9AE14325/02/2014","Ziera 152759F87A52-0B7E-C741-BA5A-CB021791458C25/02/2014","Just Teezn 152701DDA0E3-10CE-C440-BF27-6EC342D22C8A25/02/2014","Hot Property1527DD539B42-34EA-4DA2-ABE1-0727C3F77D6F25/02/2014","Zelows 1527D55B676D-CDAF-8B4F-AAD7-6E36E59B34F625/02/2014","student flights1527A25615B8-D0C0-40B1-B0CE-D2B3572B204C25/02/2014","Ally Fashion152781E77876-7A90-AC47-A12A-318226946F3725/02/2014","Tangled Hair 1527A5C25153-5B90-C540-A677-5D31587C6BDD25/02/2014","Escape Travel 15279B63BF69-D388-5C49-9E12-F97D094009AB25/02/2014","Hunter United1527D9AFFAFD-48C8-E745-BE60-BCB2FCE6ADB725/02/2014","mirage152743B80BA9-131E-407E-B31F-980587E4E1BB25/02/2014","Pets Domain 1527DD2F6320-E5D8-D54B-B261-5EF90E092EFF25/02/2014","Nextra Express 1527AFEF92D3-1FCF-8248-9437-FE8E73B07B5325/02/2014","helloworld1527F6E47531-8574-4C3C-A4B9-FA9413A8AF0825/02/2014","Flight Centre152726E31FE5-D24F-9A4F-8D08-C43974A90D5925/02/2014","Looksmart Alterations 1527FA096E64-72A9-E245-9917-BB5B7074A79925/02/2014","Telstra1527E7E4DDB8-D195-2741-BFE2-80904DE77BD425/02/2014","Virgin Mobile 1527F5B193CC-6A67-FD4A-991E-0E0BAC67C73325/02/2014","ABC Shop1527332CD0D9-3C18-8743-84FE-8B12500E5F6825/02/2014","Red Threads 1527A461ABCC-7990-8646-AE01-99101744EF0525/02/2014","Australian Geographic152782DEF2B6-6C2A-D541-ACF7-1A439058558825/02/2014","City Beach Australia 15270A0A3645-E4E6-DE49-BC49-4288E5A0930A25/02/2014","Lonsdale 1527AA6991CC-A09E-B447-AA08-472E6DA365D625/02/2014","Industrie152754908C39-D8B3-4182-9EA9-792B02F285C425/02/2014","RDX152741D812D0-8C72-B24C-8A93-CB9F5AA37F9226/02/2014","Foxx Foe15276239D4DD-A3EF-E046-BA08-1DA120F1037E26/02/2014","YD152734029CD3-D005-8842-B21C-0D946751D1C026/02/2014","Forcast15277CBA284A-AE87-5D45-8314-7DB815224A1F26/02/2014","Typo1527DC4C71FC-0DA8-A84F-BAEF-81B609A370A126/02/2014","Silver Castle 15275301E2F3-F76A-2448-86AB-877D6EB44E8926/02/2014","Naked Art1527544E74CE-C800-1C45-9729-1850B6EC707926/02/2014","ts 14+ & Virtu1527D8F3C248-4AB8-0D49-B5D2-00495A08533326/02/2014","Zu 15276B7FC849-F20B-AB4F-9B74-27BF8374345C26/02/2014","Nine West1527679C2710-D86B-E34C-81F6-84D0CAFA543126/02/2014","Ella Rouge Beauty 1527749680FF-A974-3147-AEF0-6B3E79C3F05826/02/2014","Matthews Jewellers1527CF2DE45D-B960-7E44-9231-AD994C28152526/02/2014","Apple Shop1527765E3318-8F28-9F43-AAD5-35CDD2C457B826/02/2014","honey Birdette152720B8C86C-74B5-4183-835A-6E6D74AE026526/02/2014","Seduce1527F16CA83E-A6C8-414F-95D2-D3F3A9A7361826/02/2014","Witchery 15273F14A50D-C50E-714C-A6BF-5830CF9B532E26/02/2014","Blue Illusion 1527E1459F51-F7EA-564E-930F-BE233EE0ED3326/02/2014","Queenspark15279DAC1BAF-71C7-3E41-A294-C31BA9DC9E2826/02/2014","Jeans West 1527A3F70221-40D8-7B4D-88CE-D96F0DCA29FA26/02/2014","Wax Central 15278691BF58-E3C9-3F49-8BCE-449CB42148AD26/02/2014","Jumbo Kids wear15276025B9AB-75FA-A345-AD9A-043AEADA7C6726/02/2014","Pumpkin Patch 152777F1A8DA-4F01-E446-8D86-717DE68CDA9826/02/2014","Betts Kids152710637389-E973-8F42-87B7-AB9D3B964AA226/02/2014","Blue Sky Kids Land1527D15E7A3E-1A55-D549-8D4B-AB9DAB12D62826/02/2014","Jacqui-E1527A81FCD4A-6043-44F9-90CB-5D25709D629526/02/2014","Katies 15271C7F6FFA-9138-0544-8DF0-4EA2BBCEB3F526/02/2014","Jeep 152751188A64-62E6-8048-BEE8-B310CAD3817526/02/2014","Dusk1527AA073B8E-C02F-7348-95BA-231E37CBE1C526/02/2014","The Suit Shop 1527503A1FB6-4B14-534D-AD30-FE101955BC2926/02/2014","Dymocks1527C0D9EC35-8C77-224B-B5E7-DD8C50EC7B9F26/02/2014","FILA1527150226D4-8CC1-1548-9EC2-A57F29D1802427/02/2014","Ice 1527BA7014BC-0280-104E-8C9C-1D19C04F700327/02/2014","Tree of Life1527B10309F0-6317-A94F-A3C2-19420534AC8027/02/2014","Foot Locker1527B37A6E14-DAD8-254A-8971-07570F97141727/02/2014","Temt15275EACCE09-52EE-EE42-8767-D645E47025AA27/02/2014","Tightrope1303B5C5BF46-CA43-4849-8BB5-942734DF141527/02/2014","Club Lime 1303DEA53CDC-F668-ED48-AC9E-8B32CD9F8CB427/02/2014","Club Lime 1303DEA53CDC-F668-ED48-AC9E-8B32CD9F8CB428/02/2014","Timezone 152771E247CB-94D1-D443-B048-F881B6EA629628/02/2014","Dollar King1527C0695BC9-D73A-DE45-9FF5-7C4B814FBD6528/02/2014","Just Cuts 15274C54B083-AA43-E04F-9A52-891148DCD06D28/02/2014","Shoes & Sox1527D7B2070F-1D24-1F4A-AF95-40C9D1118A5828/02/2014","1001 Optometrist 15277D601F89-8F17-0349-B388-77384E6BAB0328/02/2014","Dolce1527F4AAAF2B-3B9C-C540-9E89-422139587EFF28/02/2014","Shavershop15278DA280CA-8D90-674A-B0B1-18FE34A7536D28/02/2014","JB HI -FI BALLARAT7651AE60CBF-40E1-3244-ACE2-D4F452A844BA28/02/2014","Wax It1304CFF44063-DAC0-4449-A454-22D8B6CF1B356/03/2014","Medicare1304CB60794E-C95A-1746-9EA9-A3CD3C81FAE66/03/2014","Post Shop1304965C678B-6FEB-A749-A015-DAD157D0D0136/03/2014","Bakers Delight1304738CDD4A-B756-784E-952B-DF13A74A1B976/03/2014","Front Runner Learning (vacant)1306C9301143-35A3-764C-A4AC-48D74E4BEFC612/03/2014","Forestway Dental (vacant)13068FF1AE3A-B00E-6A46-B4CC-20EDFE1F37AF12/03/2014","Curves130688607CF9-FDBA-E443-9A96-443A09C4693F12/03/2014","Kidspot1306A440B3D9-96DD-F945-AD3F-6BA4A14479B412/03/2014","Forestway Family Psychology13062DB20EBF-C696-1C4E-B4D9-EE91AED9247112/03/2014","Roaming Bird13068132D72F-0BAC-F644-AD57-0770B6A6116612/03/2014","Forestway Pharmacy1306ED999BA1-1B74-B84E-8F7F-C9D947C0CBAD12/03/2014","Forestway Drycleaners1306FDC1C0BF-D7DB-0B4E-9828-DE761C94996312/03/2014","Westpac1306E44069D7-EB71-A446-8711-7FCC886D0D9712/03/2014","McDonalds130698A53960-56A1-B74B-B4F1-EF605FE76B2212/03/2014","Mandarin Massage130685A223F8-C8FE-1843-8D1A-8F2D256EA4D912/03/2014","Oz Nails130683BAFF02-0629-914E-8541-6548030BEEA012/03/2014","Jourdan1306A1C6D598-BEB8-604A-9C74-2B319C25A06412/03/2014","Connect Hearing1306E2A6E1CA-5B47-B44B-B742-00582B8324BB12/03/2014","OPSM130682A21398-CC4A-3F44-9447-875DFC803A9612/03/2014","The Real Macaw Petstore13069C9ADDAE-97F9-8A48-8399-0004D66C8FB612/03/2014","Escape Travel1306F751AEDE-BF99-C14A-80D0-FB109AC7CC2212/03/2014","Flirtation1306D3A365B2-DBEC-B045-A88B-FE9241E0C7BD12/03/2014","Johns Hairdresser13062355285A-0034-E144-B8A5-A8906C72386E12/03/2014","Sushi Bar1306603F832C-1283-0743-B06F-5A23F1BE587012/03/2014","Forest News1306C033660B-CC77-4F47-B743-7399BD85D05E12/03/2014","Cappuccino King1306FB93C5FE-8379-144A-93A2-43D59DDFC94E12/03/2014","Flower Hut1306352171E0-9187-5A4F-A705-18B0F120CDBA12/03/2014","Ginseng Healthfood1306AA6AF0E6-BED0-8948-8D1A-9363AED0F1BB12/03/2014","Forestway Optometrist13066FB3C22C-9A6A-574C-8E5D-831A8BC751ED12/03/2014","Dragonfly Pure Hair13062114398B-6F9D-9B4E-AFCC-091DE953070812/03/2014","ANZ Bank1306BF1C82C4-0967-7344-8432-7632095829F912/03/2014","McIntosh's Patisserie13067799C3E2-1753-6D47-80D2-0612CE4BAABA12/03/2014","St George Bank13067FDC81FD-C518-CB48-8187-2496E07485B912/03/2014","Flight Centre1306EC8A1010-55C3-A34A-8102-21240E80122412/03/2014","Forest Providore1306E72E37FF-1C49-6D49-8F32-F43CE77465F012/03/2014","RTA1306784D0EFB-9641-E348-ADD4-0A1A283FBB1312/03/2014","Blends Cafe1306191026E6-4BDB-D140-B52B-6AD533E0452212/03/2014","130612/03/2014","Vina Bakehouse 1306239C6AFA-57EF-2F48-9D58-0D0A1801018312/03/2014","Subway1306ECE7CFD3-F27B-084D-9899-0348276D00B512/03/2014","Big Fish Australia13060F0E6D77-07A2-E54F-B1BE-61AFF1B4EA7312/03/2014","Deans Short Cuts13064E091BA0-637C-7D4A-A40B-B2A78A81823F12/03/2014","Thai Mania1306260B637D-558A-AB43-875B-81291A6F7C6E12/03/2014","Gloria Jeans130695A2072E-2848-074D-9DC5-EEF3A5F6901B12/03/2014","Commonwealth Bank1306ECF69E4C-652C-FA4F-A59D-43609FED727412/03/2014","Everyday Carwash13068080FCAF-E424-D044-A93C-E3C892EC5A7A12/03/2014","Australia Post1306ADC9E3F9-DA0F-ED46-BAA0-C33005AEB52D12/03/2014","Wax It1304CFF44063-DAC0-4449-A454-22D8B6CF1B3512/03/2014","Smokemart #21304E6B0D316-0A17-B94E-AE0A-A2E6722B16B512/03/2014","Medicare1304CB60794E-C95A-1746-9EA9-A3CD3C81FAE612/03/2014","Post Shop1304965C678B-6FEB-A749-A015-DAD157D0D01313/03/2014","Bakers Delight1304738CDD4A-B756-784E-952B-DF13A74A1B9713/03/2014","Shaver Shop130454E42435-BDD4-B746-A701-59AA8D7D59C013/03/2014","Police Credit Union130414484328-CE06-9449-8300-873C47F7C90113/03/2014","Body Bar1304FA01179F-7386-D74D-9D1C-0EA4A243F38C13/03/2014","Beauty Queen13049595029D-448E-F041-8412-B5EF44513DBC13/03/2014","King of Knives13045E8912E2-0BDA-B747-A55C-BA4BBCC6D09A13/03/2014","Goldsmith13048103738F-6F43-4B49-B9E1-5F074C7D8BEB13/03/2014","Rockmans13047BEBE624-AE7F-8B42-808C-94EF7690681513/03/2014","Suzanne Grae1304BCBB03F2-28B7-AF4C-A804-FFC3C29020B513/03/2014","Goldmark130461978810-EBBC-434D-8E0D-90CF4E5C7ECC13/03/2014","Bread13040961C6EF-B6AF-1742-8E1F-D0F1E443790B13/03/2014","Dick Smith1304BD410B0A-E329-3F44-80AD-243961227BD913/03/2014","Prouds130438CF3F7F-BCE9-1344-826E-0DCED2725E9113/03/2014","Croc Sotck & Barra1304B217289B-440E-9044-BDE0-66C5A41B8C6113/03/2014","Airflex1304ABFFD36F-F490-4E4A-AB21-29531FA60FA113/03/2014","Betts for Her130441DA6487-C1C9-7742-A521-CF655FABAB5B13/03/2014","Forever New1304ED93BF13-351E-0642-9C5A-40E587A0A7C113/03/2014","Universal Store1304E50BA386-761B-8940-9E68-F52A7BD1D18E13/03/2014","City Beach130475858E85-0574-2A48-A5F5-1C355BE073F813/03/2014","Dotti13045276302E-FAE7-904D-BEDD-FE6D4F7EC63113/03/2014","Connor130471B73906-4667-C242-91CF-D58C26BD47DD14/03/2014","Bardot1304E0772F21-5FC7-AA46-8100-BFDA468ADF6114/03/2014","CUE1304B1186DD8-D6DF-9F4A-8040-D0AED44249A614/03/2014","Smiggle130407B97353-E933-AE46-B055-F5673AC14F9E14/03/2014","The Body Shop13040461FFD1-FC28-3F4A-A66D-3E93AE81633E14/03/2014","Police Station13047FF3FAE0-E811-7340-9463-1DA852C076DB14/03/2014","OPSM13047F869F68-3CD6-3647-9A41-D5B440D7B50914/03/2014","Telstra T1304B3BB1FC1-3FF6-864A-9177-82962DD9040F14/03/2014","Sussan1304D4954491-43A8-E543-9651-338EA32AC9C114/03/2014","Escape Travel13046ABCEFA8-F57F-264C-8D78-AA2A9BFBE30114/03/2014","Yes Optus1304A869C5E8-4A4C-384B-BA3B-10F1FD01F02C14/03/2014","Spendless Shoes1304095A7663-C4F3-1F4D-9D22-B2C071C3EEC514/03/2014","Sportsco130405935900-4FAE-C042-A5E6-7D6B3257E40414/03/2014","J]. There is an invisible ASCII 0 at the end of this text which needs to be fixed. Please find this record, remove the invisible character, and try the sync again. how would I know which one is causing the issue?
Jesse Barnum Posted July 21, 2014 Posted July 21, 2014 Those are all of the primary keys by creation order. The last successful one was "Sportsco130405935900-4FAE-C042-A5E6-7D6B3257E40414/03/2014", so do this: * Find that record by primary key * Show all records * Go to the next one in the found set * Check the primary key for that record to see if it contains invisible characters, using a text editor like Text Wrangler / BBEdit that can show invisible characters.
UltimateTech Posted July 22, 2014 Author Posted July 22, 2014 Hi Jesse, The only character in the next primary key that may be an issue is an ampersand i.e.: J&V1304EA7846D4-3B02-2248-83D4-CD768A7C5EF714/03/2014 Would that cause an issue?
Jesse Barnum Posted July 24, 2014 Posted July 24, 2014 Yes, it would. We do not do any URLEncoding on primary keys during sync, and an ampersand is not a valid XML character.
UltimateTech Posted July 29, 2014 Author Posted July 29, 2014 Ok thanks. I am going to have to rethink the way I generate my primary keys. I appreciate your help.
Recommended Posts
This topic is 4037 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now