Still having issues with publishing to Google Fusion Tables

Andrew_Faust · December 9, 2013, 10:04pm

I am running Aggregate v1.4 and have been trouble keeping Aggregate pushing
new records to Fusion Tables. If I recreate the publish links it works
for awhile then just stops.

Any ideas of what is going on?

Thanks
Andy

Mitch_S · December 9, 2013, 10:11pm

What errors are being reported in your logs?

Go to: https://appengine.google.com/

Select your AppSpot instance,
then click on Logs in the left sidebar,
And select 'Logs with minimum severity: Error'

The interesting errors will be under headings of
/gae/uploadSubmissionsTask
You may need to change 'Version' to 'background' to see anything (there can
entries for this under either Version: '1 (default)' or under 'background'

What errors do you see?

···

On Mon, Dec 9, 2013 at 2:04 PM, Andrew Faust wrote:

I am running Aggregate v1.4 and have been trouble keeping Aggregate
pushing new records to Fusion Tables. If I recreate the publish links it
works for awhile then just stops.

Any ideas of what is going on?

Thanks
Andy

--

Post: opendatakit@googlegroups.com
Unsubscribe: opendatakit+unsubscribe@googlegroups.com
Options: http://groups.google.com/group/opendatakit?hl=en

You received this message because you are subscribed to the Google Groups
"ODK Community" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

Andrew_Faust · December 10, 2013, 1:52pm

Sorry local install of ver 1.4

···

On Monday, December 9, 2013 4:11:54 PM UTC-6, Mitch Sundt wrote: > > What errors are being reported in your logs? > > Go to: https://appengine.google.com/ > > Select your AppSpot instance, > then click on Logs in the left sidebar, > And select 'Logs with minimum severity: Error' > > The interesting errors will be under headings of > /gae/uploadSubmissionsTask > You may need to change 'Version' to 'background' to see anything (there > can entries for this under either Version: '1 (default)' or under > 'background' > > What errors do you see? > > > > On Mon, Dec 9, 2013 at 2:04 PM, Andrew Faust <afa...@ncwrpc.org wrote: > >> I am running Aggregate v1.4 and have been trouble keeping Aggregate >> pushing new records to Fusion Tables. If I recreate the publish links it >> works for awhile then just stops. >> >> Any ideas of what is going on? >> >> Thanks >> Andy >> >> -- >> -- >> Post: opend...@googlegroups.com >> Unsubscribe: opendatakit...@googlegroups.com >> Options: http://groups.google.com/group/opendatakit?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "ODK Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to opendatakit...@googlegroups.com . >> For more options, visit https://groups.google.com/groups/opt_out. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >

Mitch_S · December 10, 2013, 7:08pm

Ah, OK. Are there any errors in your Tomcat log files? I.e., the files
under something like C:\Program Files\Apache Software Foundation\Tomcat
6.0\logs

Mitch

Andrew_Faust · December 10, 2013, 7:36pm

Dec 10, 2013 1:32:06 PM
org.opendatakit.aggregate.task.UploadSubmissionsWorkerImpl
uploadAllSubmissions
INFO: Upload invoked when operational status is ACTIVE
Dec 10, 2013 1:32:06 PM
org.opendatakit.aggregate.task.UploadSubmissionsWorkerImpl streamSubmissions
INFO: There are no submissions available for streaming
Dec 10, 2013 1:32:06 PM
org.opendatakit.common.persistence.engine.mysql.DatastoreImpl deleteEntity
INFO: Executing DELETE FROM odk_prod._task_lock WHERE _URI = ? with
key 344b472c-e559-45f3-9f9d-564531d38a8b by user
aggregate.opendatakit.org:web-service
RUNNING WATCHDOG TASK IN TOMCAT
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkTasks
INFO: ---------------------BEGIN Watchdog
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkStreaming
INFO: Checking streaming for Google FusionTables fsc:
uuid:c082ce07-8963-40c5-8c15-80fc789e6fb7
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: fetching new list of Forms
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: incoming- last Fetch: -30172 [S: -15 Eq: -30593 Fs: -172] futureMillis: 0
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: -fetched- last Fetch: 0 [S: -593 Eq: -30593 Fs: -593] futureMillis: -1
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: Eq-update last Fetch: 0 [S: -593 Eq: 0 Fs: -593] futureMillis: 0
requested: 0
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkStreaming
INFO: Checking streaming for Google Spreadsheet fsc:
uuid:9d516d1f-6b19-4a17-a4aa-ede9b7abf0e8
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
UPLOAD TASK IN TOMCAT
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkStreaming
INFO: Checking streaming for Google FusionTables fsc:
uuid:c8df1f75-5dc3-483e-8437-9669f191f452
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
UPLOAD TASK IN TOMCAT
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkStreaming
INFO: Checking streaming for Google Spreadsheet fsc:
uuid:f567d3b2-224c-4f94-a86c-fa92277526aa
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkStreaming
INFO: Checking streaming for Google Spreadsheet fsc:
uuid:2acae322-04d0-46eb-8f67-63636dd47e99
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
UPLOAD TASK IN TOMCAT
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkStreaming
INFO: Checking streaming for Google FusionTables fsc:
uuid:0721f18b-aada-4c5a-b41c-a316dcd8f8e6
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
UPLOAD TASK IN TOMCAT
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkStreaming
INFO: Checking streaming for Google FusionTables fsc:
uuid:eca9609f-ffaf-46f3-bc11-e62b6f4c2280
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkPersistentResults
INFO: Checking all persistent results
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkPersistentResults
INFO: Done checking persistent results
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkMiscTasks
INFO: Checking miscellaneous tasks
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkMiscTasks
INFO: Done checking miscellaneous tasks
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: incoming- last Fetch: -47 [S: -640 Eq: -47 Fs: -640] futureMillis: 30000
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: -fetched- last Fetch: 0 [S: -640 Eq: -640 Fs: -640] futureMillis: -1
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.util.BackendActionsTable
logValues
INFO: Fs-update last Fetch: 0 [S: -640 Eq: -640 Fs: 30000] futureMillis: 30000
requested: 30000
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.task.WatchdogWorkerImpl
checkTasks
INFO: ---------------------END Watchdog
EXITING WATCHDOG TASK IN TOMCAT
Dec 10, 2013 1:32:35 PM
org.opendatakit.aggregate.task.UploadSubmissionsWorkerImpl
uploadAllSubmissions
INFO: Beginning UPLOAD service: uuid:42ed06b2-9bbc-484d-8e3c-21d09ddcaf93
form STORMS042213
Dec 10, 2013 1:32:35 PM
org.opendatakit.aggregate.task.UploadSubmissionsWorkerImpl
uploadAllSubmissions
INFO: Beginning UPLOAD service: uuid:cd809b18-d181-43d9-b3ee-dbd2dea273a0
form STORMS042213
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms
Dec 10, 2013 1:32:35 PM
org.opendatakit.aggregate.task.UploadSubmissionsWorkerImpl
uploadAllSubmissions
INFO: Beginning UPLOAD service: uuid:22069c60-deff-4003-acac-f4540fa84f8a
form WHAM091212
Dec 10, 2013 1:32:35 PM org.opendatakit.aggregate.form.FormFactory
internalGetForms
INFO: FormCache: using cached list of Forms

Here is some of the logs...I emailed you the others.

Thanks again for looking at this.

···

On Tuesday, December 10, 2013 1:08:32 PM UTC-6, Mitch Sundt wrote: > > Ah, OK. Are there any errors in your Tomcat log files? I.e., the files > under something like C:\Program Files\Apache Software Foundation\Tomcat > 6.0\logs > > Mitch >