Error when Syncing

Mods, Tips, Tricks, and Support for Zulu
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Sat Jan 07, 2012 2:56 pm
I have three calendars that seemed to publish okay
My datafile and zula are hosted at foxtail

I'm getting the following error.
Sat Jan 07 14:54:42 PST 2012: Sync failed: java.lang.NumberFormatException: For input string: " "

Test test configuration give me - For input string: " "

I setup a brand new test setup on a Win 7 desktop. Was able sync sample data and a older copy of our file that is hosted at Foxtail.

What happens if either of both the start and endates are blank. I made sure that they were all populated except for 4 dates in which there is a proposed event but not date set yet.


Thanks
Scott
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Mon Jan 09, 2012 8:43 am
Hi Scott,

Events with both dates empty are no problem and are just ignored. Events that have an end date with no start date will cause errors for Google and iCal.

java.lang.NumberFormatException: For input string: " "


Pretty sure this has something to do with using quotes in the actual data you're passing to Zulu, and that can cause issues with the queries. I'd look for quotes and see if you can substitute or remove them form the zulu data.

Let me know if that helps.
Jason
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Mon Jan 09, 2012 12:53 pm
I did not find any quotes in the data. Did notice that all of the uuid fields are blank as well as the ical data fields. There is note there that they get popluated by plugin. ( that may be old) Perhaps I erased them when doing a Google Reset instead of deleting zulu_uuid in the zulucalendarlist
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Mon Jan 09, 2012 1:43 pm
Hi Scott,

You are correct, those fields should be left for Zulu to populate. It's some kind of data issue that is throwing off the Java SQL query...hoping it was a quite as that's a common one. Are you able to run the publish script without any errors? That should pick up any data type issues (field vs number) which could also be the cause. Did a field type change between the older and newer copy?

Thanks!
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Mon Jan 09, 2012 2:17 pm
Yes, it does publish okay. I doubt that a field type changed. I would like to test with my "live" file but do not know how to get a copy of it since it is hosted at foxtail.

I'll see if foxtail can send me a copy of the file. I don't see a way that I can make a copy from the FM client.

I had read in the documentation about two fields that limit the number of ical records. I did see those in records. I think I started with Zulu when it brand new
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Mon Jan 09, 2012 2:45 pm
Hi Scott,

Thanks. Foxtail provides a dashboard that allows you to back-up and download your databases, I'd check with Angelo to make sure you have access to that.

hth,
Jason
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Tue Jan 10, 2012 5:43 pm
Jason,
I do have access but did not know how to download the file. I just got the file downloaded and will try syncying it on my test setup. I will let you know how it goes.

Thanks
Scott
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Wed Jan 11, 2012 8:44 am
I took my cleaned up my test data, only 9 straight forward records. On my test setup, not foxtail, I am getting this message when publishing.

http://64.151.86.220/zulu/publish?_vers ... 151.86.220

The LOCATION in the last line may be suspect, I'm using a location for a filter
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Wed Jan 11, 2012 9:14 am
Hi Scott,

If there publishing script made it this far, then the field types and mapping should be fine as they've passed the validation part of the script. I'm a bit suspicious of your IP address 64.151.86.220. Typically we would publish from within the network, so the IP would start with a 192. or 10. You may be hitting a firewall going through that public one. We have some steps for testing the server and connectivity here, under "Is It Your Server?"

http://www.seedcode.com/pmwiki/pmwiki.php?n=Zulu.Troubleshooting

Let me know if that helps!
Jason
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Wed Jan 11, 2012 12:20 pm
I had neglected to change the address in the script. My test of 18 records published and synced. The problem must like you said, something in the data. I'll have to figure out away what record(s) are causing the problem.

I'll post again if find anything interesting in the data.
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Thu Jan 12, 2012 8:21 am
Getting theses are the 1st on is when testing the configuration
Test configuration For input string: " "
When trying to sync
Thu Jan 12 07:36:53 PST 2012: Sync failed: java.lang.NumberFormatException: For input string: " "

The zulusampledata works fine. I took my test file down to 2 records. I'm using the same publish calendar script for both files. I eliminated any filters. I have is down to as basic as a I can

Thanks
Scott
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Thu Jan 12, 2012 9:02 am
Hi Scott,

What's the file name? Does it have spaces in it?

-J
Posts: 33
Joined: Sun Sep 26, 2010 12:46 am
PostPosted: Thu Jan 12, 2012 9:55 am
Peak7
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Thu Jan 12, 2012 10:03 am
Hmmm...

Can you send me a copy of the file to [email protected]? Please include the [Full Access] log-in info.

Thanks!
-Jason

Return to Zulu: iCal Server for FileMaker

Who is online

Users browsing this forum: No registered users and 3 guests

(855) SEEDCODE
[email protected]
Follow us: