Error during sync - Invisible Ascii 0

[UltimateTech]

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 call
SEVERE: 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]

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]

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 call
SEVERE: 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]

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]

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]

Yes, it would. We do not do any URLEncoding on primary keys during sync, and an ampersand is not a valid XML character.

[UltimateTech]

Ok thanks. I am going to have to rethink the way I generate my primary keys. I appreciate your help.