Aggregate being Refused Connection By Postgres

Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

Tumaini,

I haven't seen that before. Is Postgres running on the same machine as
Aggregate? Are you still getting this error or did the error
disappear?

As a quick fix try restarting Postgres and Aggregate to unwedge things
if they still won't communicated.

Cheers,
Waylon

··· On Fri, Jun 15, 2012 at 7:16 AM, Tumaini Kilimba wrote: > Dear all, > I spent this morning submitting data from 24 tablets to the Aggregate server > via the wireless network. I then manually uploaded data from the > odk/instances folder that I had saved a few days ago on my desktop. This > worked for approximately 50 submissions, after which the Aggregate server > would not let me upload any more, giving me "an unexpected error has > occured" kind of vague error. Looking at the Tomcat logs as well as the > postgres logs I get the message > > "SEVERE: Error in trying to obtain a connection. Retrying in 7000ms > org.postgresql.util.PSQLException: FATAL: remaining connection slots are > reserved for non-replication superuser connections". > > Has anyone faced a similar problem before? > > Thanks in advance, > Tumaini > > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en

Hi everyone,

I'm just wondering if you encountered same experience/can suggest possible solutions:

I tried the "manually upload data" of ODK aggregate. All data entries have been uploaded except for photos.

I can say that this is just a problem of using "manual uploading" since when I upload directly from the device to ODK Aggregate via Internet, the photos will be also uploaded.

Thanks in advance.

Raffy

··· On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote: > Dear all, > I spent this morning submitting data from 24 tablets to the Aggregate server via the wireless network. I then manually uploaded data from the odk/instances folder that I had saved a few days ago on my desktop. This worked for approximately 50 submissions, after which the Aggregate server would not let me upload any more, giving me "an unexpected error has occured" kind of vague error. Looking at the Tomcat logs as well as the postgres logs I get the message > > > "SEVERE: Error in trying to obtain a connection. Retrying in 7000ms org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections". > > > Has anyone faced a similar problem before? > > > Thanks in advance, > Tumaini

Hello Waylon,
Postgres IS running on the same machine as Aggregate, I have also tried
restarting the postgres service, the tomcat service and even restarting the
physical machine...

Thanks,
Tumaini

··· On Fri, Jun 15, 2012 at 7:36 PM, W. Brunette wrote:

Tumaini,

I haven't seen that before. Is Postgres running on the same machine as
Aggregate? Are you still getting this error or did the error
disappear?

As a quick fix try restarting Postgres and Aggregate to unwedge things
if they still won't communicated.

Cheers,
Waylon

On Fri, Jun 15, 2012 at 7:16 AM, Tumaini Kilimba tkilimba@ihi.or.tz wrote:

Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server
via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

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

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

Hi Raffy,

Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.

You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Thu, Feb 4, 2016 at 10:33 AM, rivera.raffy@gmail.com wrote:

Hi everyone,

I'm just wondering if you encountered same experience/can suggest possible solutions:

I tried the "manually upload data" of ODK aggregate. All data entries have been uploaded except for photos.

I can say that this is just a problem of using "manual uploading" since when I upload directly from the device to ODK Aggregate via Internet, the photos will be also uploaded.

Thanks in advance.

Raffy

On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:

Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate server via the wireless network. I then manually uploaded data from the odk/instances folder that I had saved a few days ago on my desktop. This worked for approximately 50 submissions, after which the Aggregate server would not let me upload any more, giving me "an unexpected error has occured" kind of vague error. Looking at the Tomcat logs as well as the postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms org.postgresql.util.PSQLException: FATAL: remaining connection slots are reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

--

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/d/optout.

Hi

Postgres IS running on the same machine as Aggregate, I have also tried
restarting the postgres service, the tomcat service and even restarting the
physical machine...

Try increasing max_connections (integer) if your machine will allow
that and restart postgres. Whenever the number of active concurrent
connections is at least max_connections minus
superuser_reserved_connections (default 3), new connections will be
accepted only for superusers, and no new replication connections will
be accepted.

Regards

··· -- http://ianlawrence.info

OK, though am still puzzled as to why I have 97 concurrent connections to
my Postgres database (max_conections - superuser_reserved_connections =100

  • 3=97), when the only thing that should be accessing postgres as the ODK
    Aggregate application, and I would have thought thats just ONE connection,
    where are the other 96 coming from?

Thanks,
Tumaini

··· On Saturday, June 16, 2012 5:31:54 PM UTC+3, Ian Lawrence wrote: > > Hi > > > > Postgres IS running on the same machine as Aggregate, I have also tried > > restarting the postgres service, the tomcat service and even restarting > the > > physical machine... > > Try increasing max_connections (integer) if your machine will allow > that and restart postgres. Whenever the number of active concurrent > connections is at least max_connections minus > superuser_reserved_connections (default 3), new connections will be > accepted only for superusers, and no new replication connections will > be accepted. > > Regards > > -- > http://ianlawrence.info >

Thanks Yaw.

What I did was I transferred first the files to the local drive and then
manually upload the files from hard drive to ODK Aggregate.

Raffy

··· On Sun, Feb 14, 2016 at 3:32 PM, Yaw Anokwa wrote:

Hi Raffy,

Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.

You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Thu, Feb 4, 2016 at 10:33 AM, rivera.raffy@gmail.com wrote:

Hi everyone,

I'm just wondering if you encountered same experience/can suggest
possible solutions:

I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.

I can say that this is just a problem of using "manual uploading" since
when I upload directly from the device to ODK Aggregate via Internet, the
photos will be also uploaded.

Thanks in advance.

Raffy

On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:

Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Database connections take time to establish, so the server maintains a pool
of established connections and should be using connections from that pool
to interact with the database and then releasing them back into the pool
after it is done. Depending upon the rate at which you're doing this, the
server will grow or shrink this pool.

Your database connections seem as if they are not be being released back
into this pool. I'm not familiar with all the configuration settings in
this area of the code (it could be that you have a very large JVM defined
under Tomcat, and the releases might be tied to garbage collection cycles).
The software uses BoneCP for the connection pool and Spring JDBC for the
connection management. There are undoubtedly configuration settings for
each of these that can tweak the way connections are managed.

Mitch

··· On Mon, Jun 18, 2012 at 10:35 PM, Tumaini Kilimba wrote:

OK, though am still puzzled as to why I have 97 concurrent connections to
my Postgres database (max_conections - superuser_reserved_connections =100

  • 3=97), when the only thing that should be accessing postgres as the ODK
    Aggregate application, and I would have thought thats just ONE connection,
    where are the other 96 coming from?

Thanks,
Tumaini

On Saturday, June 16, 2012 5:31:54 PM UTC+3, Ian Lawrence wrote:

Hi

Postgres IS running on the same machine as Aggregate, I have also tried
restarting the postgres service, the tomcat service and even restarting
the
physical machine...

Try increasing max_connections (integer) if your machine will allow
that and restart postgres. Whenever the number of active concurrent
connections is at least max_connections minus
superuser_reserved_connections (default 3), new connections will be
accepted only for superusers, and no new replication connections will
be accepted.

Regards

--
http://ianlawrence.info

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

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

Hi Raffy,

Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Mon, Feb 15, 2016 at 8:22 AM, Rafael Rivera rivera.raffy@gmail.com wrote:

Thanks Yaw.

What I did was I transferred first the files to the local drive and then
manually upload the files from hard drive to ODK Aggregate.

Raffy

On Sun, Feb 14, 2016 at 3:32 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Raffy,

Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.

You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Thu, Feb 4, 2016 at 10:33 AM, rivera.raffy@gmail.com wrote:

Hi everyone,

I'm just wondering if you encountered same experience/can suggest
possible solutions:

I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.

I can say that this is just a problem of using "manual uploading" since
when I upload directly from the device to ODK Aggregate via Internet, the
photos will be also uploaded.

Thanks in advance.

Raffy

On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:

Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from the
odk/instances folder that I had saved a few days ago on my desktop. This
worked for approximately 50 submissions, after which the Aggregate server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as the
postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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/d/optout.

Hi Yaw,

We are using Aggregate since we connected it to a server. Thanks.

Raffy

··· On Mon, Feb 15, 2016 at 3:53 PM, Yaw Anokwa wrote:

Hi Raffy,

Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Mon, Feb 15, 2016 at 8:22 AM, Rafael Rivera rivera.raffy@gmail.com wrote:

Thanks Yaw.

What I did was I transferred first the files to the local drive and then
manually upload the files from hard drive to ODK Aggregate.

Raffy

On Sun, Feb 14, 2016 at 3:32 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Raffy,

Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.

You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Thu, Feb 4, 2016 at 10:33 AM, rivera.raffy@gmail.com wrote:

Hi everyone,

I'm just wondering if you encountered same experience/can suggest
possible solutions:

I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.

I can say that this is just a problem of using "manual uploading"
since
when I upload directly from the device to ODK Aggregate via Internet,
the
photos will be also uploaded.

Thanks in advance.

Raffy

On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:

Dear all,
I spent this morning submitting data from 24 tablets to the Aggregate
server via the wireless network. I then manually uploaded data from
the
odk/instances folder that I had saved a few days ago on my desktop.
This
worked for approximately 50 submissions, after which the Aggregate
server
would not let me upload any more, giving me "an unexpected error has
occured" kind of vague error. Looking at the Tomcat logs as well as
the
postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots
are
reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Raffy,

Try pulling forms from the phone using Briefcase and then push them to
the server that way.

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Mon, Feb 15, 2016 at 10:43 AM, Rafael Rivera rivera.raffy@gmail.com wrote:

Hi Yaw,

We are using Aggregate since we connected it to a server. Thanks.

Raffy

On Mon, Feb 15, 2016 at 3:53 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Raffy,

Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Mon, Feb 15, 2016 at 8:22 AM, Rafael Rivera rivera.raffy@gmail.com wrote:

Thanks Yaw.

What I did was I transferred first the files to the local drive and then
manually upload the files from hard drive to ODK Aggregate.

Raffy

On Sun, Feb 14, 2016 at 3:32 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Raffy,

Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.

You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Thu, Feb 4, 2016 at 10:33 AM, rivera.raffy@gmail.com wrote:

Hi everyone,

I'm just wondering if you encountered same experience/can suggest
possible solutions:

I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.

I can say that this is just a problem of using "manual uploading"
since
when I upload directly from the device to ODK Aggregate via Internet,
the
photos will be also uploaded.

Thanks in advance.

Raffy

On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:

Dear all,
I spent this morning submitting data from 24 tablets to the
Aggregate
server via the wireless network. I then manually uploaded data from
the
odk/instances folder that I had saved a few days ago on my desktop.
This
worked for approximately 50 submissions, after which the Aggregate
server
would not let me upload any more, giving me "an unexpected error
has
occured" kind of vague error. Looking at the Tomcat logs as well as
the
postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots
are
reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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/d/optout.

Hi Yaw,

I tried it. Iam using Android v4 device. It works. Thanks.

Raffy

··· Sent from my iPhone

On 15 Feb 2016, at 17:36, Yaw Anokwa yanokwa@nafundi.com wrote:

Raffy,

Try pulling forms from the phone using Briefcase and then push them to
the server that way.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Mon, Feb 15, 2016 at 10:43 AM, Rafael Rivera rivera.raffy@gmail.com wrote:
Hi Yaw,

We are using Aggregate since we connected it to a server. Thanks.

Raffy

On Mon, Feb 15, 2016 at 3:53 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Raffy,

Did you do the upload with Briefcase or did you go to Aggregate and do
a manual upload? Try both and look at your logs.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Mon, Feb 15, 2016 at 8:22 AM, Rafael Rivera rivera.raffy@gmail.com wrote:

Thanks Yaw.

What I did was I transferred first the files to the local drive and then
manually upload the files from hard drive to ODK Aggregate.

Raffy

On Sun, Feb 14, 2016 at 3:32 PM, Yaw Anokwa yanokwa@nafundi.com wrote:

Hi Raffy,

Try looking at the logs to see if that gives you clues. Try a few two
question (one text, one picture then a one text, one short sound)
forms.

You can also try pulling forms from the phone using Briefcase and then
push them to the server that way.

Yaw

Need ODK consultants? Nafundi provides form design, server setup,
in-field training, and software development for ODK. Go to
https://nafundi.com to get started.

On Thu, Feb 4, 2016 at 10:33 AM, rivera.raffy@gmail.com wrote:
Hi everyone,

I'm just wondering if you encountered same experience/can suggest
possible solutions:

I tried the "manually upload data" of ODK aggregate. All data entries
have been uploaded except for photos.

I can say that this is just a problem of using "manual uploading"
since
when I upload directly from the device to ODK Aggregate via Internet,
the
photos will be also uploaded.

Thanks in advance.

Raffy

On Friday, June 15, 2012 at 10:16:44 PM UTC+8, Tumaini Kilimba wrote:
Dear all,
I spent this morning submitting data from 24 tablets to the
Aggregate
server via the wireless network. I then manually uploaded data from
the
odk/instances folder that I had saved a few days ago on my desktop.
This
worked for approximately 50 submissions, after which the Aggregate
server
would not let me upload any more, giving me "an unexpected error
has
occured" kind of vague error. Looking at the Tomcat logs as well as
the
postgres logs I get the message

"SEVERE: Error in trying to obtain a connection. Retrying in 7000ms
org.postgresql.util.PSQLException: FATAL: remaining connection slots
are
reserved for non-replication superuser connections".

Has anyone faced a similar problem before?

Thanks in advance,
Tumaini

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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/d/optout.

--

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 a topic in the
Google Groups "ODK Community" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

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/d/optout.

--

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 a topic in the Google Groups "ODK Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/opendatakit/qTA_BMEiE2I/unsubscribe.
To unsubscribe from this group and all its topics, send an email to opendatakit+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.