IO Frame error again
27 views
Skip to first unread message
Ian Ray
Jan 3, 2012, 7:30:00 PM1/3/12
to google-secure-data-connector
SDC down.
Dawen Tan
Jan 3, 2012, 7:50:46 PM1/3/12
to googl...@googlegroups.com
It happened again, I don't know why Google could have this service so fragile. If you don't want to support this, just remove it so we could use another solution.
Dawen Tan
Web Developer
SADA Systems, Inc.
Consulting | Managed Services | Cloud Computing | App Development
866.997.0000 T
818.766.2400 P
818.766.0090 F
SADA Speaks - Company Blog
Follow Us On Twitter
Follow Us On Facebook
-----Original Message-----
From: googl...@googlegroups.com [mailto:googl...@googlegroups.com] On Behalf Of Ian Ray
Sent: Tuesday, January 03, 2012 4:30 PM
To: google-secure-data-connector
Subject: IO Frame error again
SDC down.
NOTICE: This e-mail and any files transmitted with it may contain confidential information, and are intended solely for the use of the individual or entity to whom they are addressed. Any retransmission, dissemination or other use of the information by persons other than the intended recipient or entity is prohibited. If you receive this e-mail in error please contact the sender by return e-mail and delete the material from your system. Thank you.
Eric Pollmann
Jan 3, 2012, 8:44:37 PM1/3/12
to googl...@googlegroups.com
Hi Dawen,
Thank you for letting us know. This was a brief outage caused by an unplanned maintenance event. We have resolved the issue, and do not expect a future recurrence of this exact issue.
You may wish to try not disconnecting / reconnecting your agent every 15 minutes as it increases the likelihood that your agent will be impacted by any irregularity in the entire serving pipeline, whereas if it is up running in a stable state, it will be less likely to be affected by problems with the connection initiation phase, for example. Hope this helps.
Thanks,
-Eric
--
You received this message because you are subscribed to the Google Groups "enterprise-data-questions" group.
To post to this group, send email to enterprise-d...@google.com.
To unsubscribe from this group, send email to enterprise-data-qu...@google.com.
For more options, visit this group at http://groups.google.com/a/google.com/group/enterprise-data-questions/?hl=en.
Dawen Tan
Jan 3, 2012, 9:09:12 PM1/3/12
to googl...@googlegroups.com
I will try to apply your suggestion for a little while, 2 c how stable it is going 2 b.
Dawen Tan
|
|
Ian Ray
Jan 4, 2012, 11:33:41 AM1/4/12
to google-secure-data-connector
Dawen, I have found it useful to ongoing monitor the "tail data-
connector-agent/log/agent.log" with a cron job to see when specific
disconnection messages (or no messages) occur. To test for
disconnection, I simply set a trigger to make the system attempt to
receive data and look for closed connections to exit without taking
action. I also set a value send an email and to not try to
reestablish a connection if the reconnection doesn't work.
For static spreadsheets that use the sdc, I use an "importRange"
functions to repopulate from a single spreadsheet cell which can then
be altered with the Google Spreadsheets API upon establishing a
connection after a connection loss.
I have toyed with populating data directly via the Google Spreadsheets
API itself, but have found it not as versatile for large data sets as
SDC so far which is the main reason for continuing to use SDC despite
the errors.
When I first used SDC, I had a cron job blindly establish a connection
every hour which caused more failures. I found debugging the log to be
more stable than reconnecting. I hope this helps.
On Jan 3, 6:09 pm, Dawen Tan <dawen....@sadasystems.com> wrote:
> I will try to apply your suggestion for a little while, 2 c how stable it is going 2 b.
>
> Dawen Tan
> Web Developer
> SADA Systems, Inc.
> Consulting | Managed Services | Cloud Computing | App Development
> [cid:image001....@01CCCA42.CBE708F0]<http://www.sadasystems.com/>
> [cid:image002....@01CCCA42.CBE708F0]<http://go.sadasystems.com/facebook>
>
> http://www.sadasystems.com
>
> [cid:image003....@01CCCA42.CBE708F0]<http://go.sadasystems.com/facebook>
>
> SADA Speaks - Company Blog<http://blog.sadasystems.com/>
>
> [cid:image004....@01CCCA42.CBE708F0]<http://twitter.com/SADASystems>
>
> Follow Us On Twitter<http://twitter.com/SADASystems>
>
> [cid:image005....@01CCCA42.CBE708F0]<http://go.sadasystems.com/facebook>
>
> Follow Us On Facebook<http://go.sadasystems.com/facebook>
>
> [cid:image006....@01CCCA42.CBE708F0]<http://hosting.sadasystems.com/email_sigs/>
> 818.766.2400<tel:818.766.2400> P
> 818.766.0090<tel:818.766.0090> F
> To unsubscribe from this group, send email to enterprise-data-questions+unsubscr...@google.com<mailto:enterprise-data-questions%2Bunsubscr...@google.com>.
> For more options, visit this group athttp://groups.google.com/a/google.com/group/enterprise-data-questions....
> 3KViewDownload
>
> image002.gif
> < 1KViewDownload
>
> image003.gif
> < 1KViewDownload
>
> image004.gif
> < 1KViewDownload
>
> image005.gif
> < 1KViewDownload
>
> image006.gif
> 16KViewDownload
connector-agent/log/agent.log" with a cron job to see when specific
disconnection messages (or no messages) occur. To test for
disconnection, I simply set a trigger to make the system attempt to
receive data and look for closed connections to exit without taking
action. I also set a value send an email and to not try to
reestablish a connection if the reconnection doesn't work.
For static spreadsheets that use the sdc, I use an "importRange"
functions to repopulate from a single spreadsheet cell which can then
be altered with the Google Spreadsheets API upon establishing a
connection after a connection loss.
I have toyed with populating data directly via the Google Spreadsheets
API itself, but have found it not as versatile for large data sets as
SDC so far which is the main reason for continuing to use SDC despite
the errors.
When I first used SDC, I had a cron job blindly establish a connection
every hour which caused more failures. I found debugging the log to be
more stable than reconnecting. I hope this helps.
On Jan 3, 6:09 pm, Dawen Tan <dawen....@sadasystems.com> wrote:
> I will try to apply your suggestion for a little while, 2 c how stable it is going 2 b.
>
> Dawen Tan
> Web Developer
> SADA Systems, Inc.
> Consulting | Managed Services | Cloud Computing | App Development
> [cid:image002....@01CCCA42.CBE708F0]<http://go.sadasystems.com/facebook>
>
> http://www.sadasystems.com
>
> [cid:image003....@01CCCA42.CBE708F0]<http://go.sadasystems.com/facebook>
>
> SADA Speaks - Company Blog<http://blog.sadasystems.com/>
>
> [cid:image004....@01CCCA42.CBE708F0]<http://twitter.com/SADASystems>
>
> Follow Us On Twitter<http://twitter.com/SADASystems>
>
> [cid:image005....@01CCCA42.CBE708F0]<http://go.sadasystems.com/facebook>
>
> Follow Us On Facebook<http://go.sadasystems.com/facebook>
>
> [cid:image006....@01CCCA42.CBE708F0]<http://hosting.sadasystems.com/email_sigs/>
>
> From: googl...@googlegroups.com [mailto:googl...@googlegroups.com] On Behalf Of Eric Pollmann
> Sent: Tuesday, January 03, 2012 5:45 PM
> To: googl...@googlegroups.com
> Subject: Re: [enterprise-data-questions] RE: IO Frame error again
>
> Hi Dawen,
>
> Thank you for letting us know. This was a brief outage caused by an unplanned maintenance event. We have resolved the issue, and do not expect a future recurrence of this exact issue.
>
> You may wish to try not disconnecting / reconnecting your agent every 15 minutes as it increases the likelihood that your agent will be impacted by any irregularity in the entire serving pipeline, whereas if it is up running in a stable state, it will be less likely to be affected by problems with the connection initiation phase, for example. Hope this helps.
>
> Thanks,
> -Eric
>
> From: googl...@googlegroups.com [mailto:googl...@googlegroups.com] On Behalf Of Eric Pollmann
> Sent: Tuesday, January 03, 2012 5:45 PM
> To: googl...@googlegroups.com
> Subject: Re: [enterprise-data-questions] RE: IO Frame error again
>
> Hi Dawen,
>
> Thank you for letting us know. This was a brief outage caused by an unplanned maintenance event. We have resolved the issue, and do not expect a future recurrence of this exact issue.
>
> You may wish to try not disconnecting / reconnecting your agent every 15 minutes as it increases the likelihood that your agent will be impacted by any irregularity in the entire serving pipeline, whereas if it is up running in a stable state, it will be less likely to be affected by problems with the connection initiation phase, for example. Hope this helps.
>
> Thanks,
> -Eric
>
> On Tue, Jan 3, 2012 at 4:50 PM, Dawen Tan <dawen....@sadasystems.com<mailto:dawen....@sadasystems.com>> wrote:
> It happened again, I don't know why Google could have this service so fragile. If you don't want to support this, just remove it so we could use another solution.
>
> Dawen Tan
> Web Developer
> SADA Systems, Inc.
> Consulting | Managed Services | Cloud Computing | App Development
>
> 866.997.0000<tel:866.997.0000> T
> It happened again, I don't know why Google could have this service so fragile. If you don't want to support this, just remove it so we could use another solution.
>
> Dawen Tan
> Web Developer
> SADA Systems, Inc.
> Consulting | Managed Services | Cloud Computing | App Development
>
> 818.766.2400<tel:818.766.2400> P
> 818.766.0090<tel:818.766.0090> F
>
> http://www.sadasystems.com
>
> SADA Speaks - Company Blog
>
> Follow Us On Twitter
>
> Follow Us On Facebook
>
>
>
>
>
>
>
> -----Original Message-----
> From: googl...@googlegroups.com<mailto:googl...@googlegroups.com> [mailto:googl...@googlegroups.com<mailto:googl...@googlegroups.com>] On Behalf Of Ian Ray
> Sent: Tuesday, January 03, 2012 4:30 PM
> To: google-secure-data-connector
> Subject: IO Frame error again
>
> SDC down.
>
> NOTICE: This e-mail and any files transmitted with it may contain confidential information, and are intended solely for the use of the individual or entity to whom they are addressed. Any retransmission, dissemination or other use of the information by persons other than the intended recipient or entity is prohibited. If you receive this e-mail in error please contact the sender by return e-mail and delete the material from your system. Thank you.
>
> --
> You received this message because you are subscribed to the Google Groups "enterprise-data-questions" group.
> To post to this group, send email to enterprise-data-questi...@google.com<mailto:enterprise-data-questi...@google.com>.
> http://www.sadasystems.com
>
> SADA Speaks - Company Blog
>
> Follow Us On Twitter
>
> Follow Us On Facebook
>
>
>
>
>
>
>
> -----Original Message-----
> From: googl...@googlegroups.com<mailto:googl...@googlegroups.com> [mailto:googl...@googlegroups.com<mailto:googl...@googlegroups.com>] On Behalf Of Ian Ray
> Sent: Tuesday, January 03, 2012 4:30 PM
> To: google-secure-data-connector
> Subject: IO Frame error again
>
> SDC down.
>
> NOTICE: This e-mail and any files transmitted with it may contain confidential information, and are intended solely for the use of the individual or entity to whom they are addressed. Any retransmission, dissemination or other use of the information by persons other than the intended recipient or entity is prohibited. If you receive this e-mail in error please contact the sender by return e-mail and delete the material from your system. Thank you.
>
> --
> You received this message because you are subscribed to the Google Groups "enterprise-data-questions" group.
> To unsubscribe from this group, send email to enterprise-data-questions+unsubscr...@google.com<mailto:enterprise-data-questions%2Bunsubscr...@google.com>.
> For more options, visit this group athttp://groups.google.com/a/google.com/group/enterprise-data-questions....
>
> ________________________________
> NOTICE: This e-mail and any files transmitted with it may contain confidential information, and are intended solely for the use of the individual or entity to whom they are addressed. Any retransmission, dissemination or other use of the information by persons other than the intended recipient or entity is prohibited. If you receive this e-mail in error please contact the sender by return e-mail and delete the material from your system. Thank you.
>
>
>
> image001.gif
> ________________________________
> NOTICE: This e-mail and any files transmitted with it may contain confidential information, and are intended solely for the use of the individual or entity to whom they are addressed. Any retransmission, dissemination or other use of the information by persons other than the intended recipient or entity is prohibited. If you receive this e-mail in error please contact the sender by return e-mail and delete the material from your system. Thank you.
>
>
>
> 3KViewDownload
>
> image002.gif
> < 1KViewDownload
>
> image003.gif
> < 1KViewDownload
>
> image004.gif
> < 1KViewDownload
>
> image005.gif
> < 1KViewDownload
>
> image006.gif
> 16KViewDownload
Dawen Tan
Jan 4, 2012, 6:31:23 PM1/4/12
to googl...@googlegroups.com
Good idea. It was also my plan but I haven't find a chance to duel with this matter. Thanks a lot Ian.
Dawen Tan
Web Developer
SADA Systems, Inc.
Consulting | Managed Services | Cloud Computing | App Development
866.997.0000 T
818.766.2400 P
818.766.0090 F
Reply all
Reply to author
Forward
0 new messages