DB failover exception detailed description

20 views
Skip to first unread message

AdEasy.ru Dev

unread,
May 19, 2012, 3:04:04 AM5/19/12
to google-doubleclick...@googlegroups.com
Hello again, guys.

Just to let you know there's an exception description which includes database name and shard info returned to the client when DB failover is in progress. Not sure if it's intentional or not:


DFP Statistics RequestReport: Failed when collecting or processing statistics DFPInstance 4527558 for period CUSTOM_DATE with exception Google.Api.Ads.Dfp.Lib.DfpApiException: unable to connect to database 'ads' on shard index 38 (errcode=1227, sqlState=42000): failover in progress ---> System.Web.Services.Protocols.SoapHeaderException: unable to connect to database 'ads' on shard index 38 (errcode=1227, sqlState=42000): failover in progress at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Google.Api.Ads.Common.Lib.AdsSoapClient.MakeApiCall(String methodName, Object[] parameters) --- End of inner exception stack trace --- at Google.Api.Ads.Common.Lib.AdsSoapClient.MakeApiCall(String methodName, Object[] parameters) at Google.Api.Ads.Dfp.Lib.DfpSoapClient.MakeApiCall(String methodName, Object[] parameters) at Google.Api.Ads.Common.Lib.AdsSoapClient.Invoke(String methodName, Object[] parameters) at Google.Api.Ads.Dfp.v201203.ReportService.runReportJob(ReportJob reportJob) at Advertisement.Jobs.Statistics.Banners.Dfp.RunReportJob(ReportService reportService, DateRangeType period, Dimension[] dimensions) in d:\Dev\CCNet\Advertisement.Service.Prod\WorkingDirectory\Advertisement.Jobs\Statistics\Banners\Dfp.cs:line 550 at Advertisement.Jobs.Statistics.Banners.Dfp.RequestReport[TColumns](ReportService reportService, DateRangeType dateRangeType, Dimension[] dimensions, Func`4 reportRowParsingFunction, IEnumerable`1 columnsLocalizations) in d:\Dev\CCNet\Advertisement.Service.Prod\WorkingDirectory\Advertisement.Jobs\Statistics\Banners\Dfp.cs:line 355 at Advertisement.Jobs.Statistics.Banners.Dfp.CollectStatistics[TColumns](DfpInstance dfpInstance, Dimension[] dimensions, Func`4 reportRowParsingFunction, IEnumerable`1 columnsLocalizations) in d:\Dev\CCNet\Advertisement.Service.Prod\WorkingDirectory\Advertisement.Jobs\Statistics\Banners\Dfp.cs:line 326

DFP Advisor

unread,
May 21, 2012, 11:38:15 AM5/21/12
to google-doubleclick...@googlegroups.com
Hi,

Thanks for letting us know about that. I've filed a bug for this.

Thanks,
Adam Rogal, DFP API Team

Marijana Karin

unread,
May 21, 2012, 3:32:33 PM5/21/12
to google-doubleclick...@googlegroups.com
Reply all
Reply to author
Forward
0 new messages