Got this one today during a deployment to sandbox:
[InternalApiError.UNEXPECTED_INTERNAL_API_ERROR @
java.lang.RuntimeException:
com.google.ads.common.workflow.payloadstore.PayloadStoreException:
Inserting row which already exists. Table: PayloadFragment, PK:
Key<[BulkMutateRequestPayloadBulkMutateJobId: 98159_part1:, -1] ==
'BulkMutateRequestPayloadBulkMutateJobId:
98159_part1:\000\177'>:PRIMARY_KEY:megastore=/megastore/global/
adwordsapi.bulkmutate-
sandbox,schema=PayloadStore,table=PayloadFragment,:PRIMARY_KEY:megastore=/
megastore/global/adwordsapi.bulkmutate-
sandbox,schema=PayloadStore,table=PayloadFragment,
at
com.google.ads.api.serviceimpls.job.bulkmutate.actions.MutateAction.storeRequestParts(MutateAction.java:
586)
at
com.google.ads.api.serviceimpls.job.bulkmutate.actions.MutateAction.commit(MutateAction.java:
554)
at com.google.ads.api.command.ActionInvoker
$ActionInvocationHandler$3.run(ActionInvoker.java:176)
at
com.google.tracing.LocalTraceSpanRunnable.run(LocalTraceSpanRunnable.java:
56)
at
com.google.tracing.LocalTraceSpanBuilder.run(LocalTraceSpanBuilder.java:
507)
at com.google.ads.api.command.ActionInvoker
$ActionInvocationHandler.invoke(ActionInvoker.java:171)
at $Proxy227.mutate(Unknown Source)
at sun.reflect.GeneratedMethodAccessor884.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:616)
at com.google.net.grubby.runtime.transport.stubby.ServerHandler
$ServerInvocationImpl.invokeActual(ServerHandler.java:120)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:200)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.serviceimpls.common.error.UncaughtGksExceptionInterceptor.intercept(UncaughtGksExceptionInterceptor.java:
82)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.stat.StatInterceptor.intercept(StatInterceptor.java:
140)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.clientterms.ClientTermsInterceptor.intercept(ClientTermsInterceptor.java:
173)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.header.RequestInfoInterceptor.intercept(RequestInfoInterceptor.java:
44)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.quota.QuotaInterceptor.intercept(QuotaInterceptor.java:
248)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.quotachecker.QuotaCheckerInterceptor.intercept(QuotaCheckerInterceptor.java:
35)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.services.common.metric.PerformanceMetricInterceptor.intercept(PerformanceMetricInterceptor.java:
105)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.sizelimit.SizeLimitInterceptor.intercept(SizeLimitInterceptor.java:
46)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.whitelist.WhitelistInterceptor.intercept(WhitelistInterceptor.java:
36)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.modules.request.authorization.AuthorizationInterceptor.intercept(AuthorizationInterceptor.java:
142)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.debug.EchoRequestInterceptor.intercept(EchoRequestInterceptor.java:
69)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.modules.pebl.CheckDeadlineInterceptor.intercept(CheckDeadlineInterceptor.java:
56)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at com.google.ads.api.modules.pebl.PeblInterceptor
$1.call(PeblInterceptor.java:138)
at com.google.ads.api.modules.pebl.PeblInterceptor
$1.call(PeblInterceptor.java:126)
at com.google.ads.api.modules.pebl.PeblUtils
$2.doWork(PeblUtils.java:134)
at com.google.ads.api.modules.pebl.PeblUtils
$2.doWork(PeblUtils.java:130)
at com.google.ads.pebl.PeblCallable
$CustomerWorkerCallable.call(PeblCallable.java:759)
at com.google.tracing.TraceContext
$TraceContextCallable.callInContext(TraceContext.java:661)
at com.google.tracing.TraceContext$TraceContextCallable
$1.call(TraceContext.java:667)
at com.google.tracing.TraceContext
$AbstractTraceContextCallback.callInInheritedContextNoUnref(TraceContext.java:
345)
at com.google.tracing.TraceContext
$AbstractTraceContextCallback.callInInheritedContext(TraceContext.java:
334)
at com.google.tracing.TraceContext
$TraceContextCallable.call(TraceContext.java:665)
at com.google.ads.pebl.PeblCallable.call(PeblCallable.java:
304)
at
com.google.ads.api.modules.pebl.PeblUtils.invokePeblCallable(PeblUtils.java:
140)
at
com.google.ads.api.modules.pebl.PeblInterceptor.invokeWithCustomer(PeblInterceptor.java:
142)
at
com.google.ads.api.modules.pebl.PeblInterceptor.intercept(PeblInterceptor.java:
85)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.server.serverimpls.PartialFailureInterceptor.intercept(PartialFailureInterceptor.java:
103)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.modules.request.authentication.AuthenticationInterceptor
$1.call(AuthenticationInterceptor.java:102)
at
com.google.ads.api.modules.request.authentication.AuthenticationInterceptor
$1.call(AuthenticationInterceptor.java:100)
at
com.google.ads.api.modules.request.authentication.AuthenticationImpl.authenticateRequest(AuthenticationImpl.java:
134)
at
com.google.ads.api.modules.request.authentication.AuthenticationInterceptor.intercept(AuthenticationInterceptor.java:
97)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.header.GrubbyResponseHeaderFillerInterceptor.intercept(GrubbyResponseHeaderFillerInterceptor.java:
48)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.header.ResponseHeaderCreatorInterceptor.intercept(ResponseHeaderCreatorInterceptor.java:
29)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.webapiversion.WebApiVersionInterceptor.intercept(WebApiVersionInterceptor.java:
40)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.server.serverimpls.StatsTrackerInterceptor.intercept(StatsTrackerInterceptor.java:
43)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at
com.google.ads.api.common.server.serverimpls.UnhandledExceptionInterceptor.intercept(UnhandledExceptionInterceptor.java:
36)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl
$2.call(InvocationImpl.java:188)
at
com.google.tracing.LocalTraceSpanCallable.call(LocalTraceSpanCallable.java:
67)
at
com.google.net.grubby.runtime.transport.stubby.InvocationImpl.invoke(InvocationImpl.java:
161)
at com.google.net.grubby.runtime.transport.stubby.ServerHandler
$ServerInvocationImpl.copyHeadersAndInvoke(ServerHandler.java:113)
at
com.google.net.grubby.runtime.transport.stubby.StubbyHandler.invoke(StubbyHandler.java:
108)
at $Proxy228.mutate(Unknown Source)
at sun.reflect.GeneratedMethodAccessor883.invoke(Unknown
Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
43)
at java.lang.reflect.Method.invoke(Method.java:616)
at com.google.ads.api.common.server.serverimpls.ServiceInvoker
$1.runInvokeCallback(ServiceInvoker.java:49)
at com.google.ads.api.common.server.serverimpls.ServiceInvoker
$2.execute(ServiceInvoker.java:131)
at com.google.ads.api.common.server.serverimpls.ServiceInvoker
$2.execute(ServiceInvoker.java:121)
at
com.google.ads.api.common.scoping.RequestScope.execute(RequestScope.java:
47)
at
com.google.ads.api.common.server.serverimpls.ServiceInvoker.invoke(ServiceInvoker.java:
121)
at $Proxy329.mutate(Unknown Source)
at
com.google.ads.api.services.job.bulkmutate.BulkMutateJobServiceProto
$BulkMutateJobService
$6.handleBlockingRequest(BulkMutateJobServiceProto.java)
at
com.google.ads.api.services.job.bulkmutate.BulkMutateJobServiceProto
$BulkMutateJobService
$6.handleBlockingRequest(BulkMutateJobServiceProto.java)
at
com.google.net.rpc.impl.BlockingApplicationHandler.handleRequest(BlockingApplicationHandler.java:
24)
at
com.google.net.rpc.impl.RpcUtil.runRpcInApplication(RpcUtil.java:398)
at com.google.net.rpc.impl.Server
$RpcTask.runInContext(Server.java:571)
at com.google.tracing.TraceContext$TraceContextRunnable
$1.run(TraceContext.java:448)
at
com.google.tracing.TraceContext.runInContext(TraceContext.java:688)
at com.google.tracing.TraceContext
$AbstractTraceContextCallback.runInInheritedContextNoUnref(TraceContext.java:
326)
at com.google.tracing.TraceContext
$AbstractTraceContextCallback.runInInheritedContext(TraceContext.java:
318)
at com.google.tracing.TraceContext
$TraceContextRunnable.run(TraceContext.java:446)
at
com.google.ads.api.common.server.serverimpls.ServiceExporterImpl
$VarzExecutor$1.run(ServiceExporterImpl.java:219)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:
1110)
at java.util.concurrent.ThreadPoolExecutor
$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
Caused by:
com.google.ads.common.workflow.payloadstore.PayloadStoreException:
Inserting row which already exists. Table: PayloadFragment, PK:
Key<[BulkMutateRequestPayloadBulkMutateJobId: 98159_part1:, -1] ==
'BulkMutateRequestPayloadBulkMutateJobId:
98159_part1:\000\177'>:PRIMARY_KEY:megastore=/megastore/global/
adwordsapi.bulkmutate-
sandbox,schema=PayloadStore,table=PayloadFragment,:PRIMARY_KEY:megastore=/
megastore/global/adwordsapi.bulkmutate-
sandbox,schema=PayloadStore,table=PayloadFragment,
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastoreExceptionMapper.map(MegastoreExceptionMapper.java:
50)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore.putFragment(MegastorePayloadStore.java:
376)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore
$$EnhancerByGuice$$e4ef4f3e.CGLIB$putFragment$4(<generated>)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore
$$EnhancerByGuice$$e4ef4f3e$$FastClassByGuice$
$424ac4f8.invoke(<generated>)
at
com.google.inject.internal.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:
228)
at com.google.inject.internal.InterceptorStackCallback
$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
at
com.google.common.stats.ExportableHistogramStatInterceptor.invoke(ExportableHistogramStatInterceptor.java:
63)
at com.google.inject.internal.InterceptorStackCallback
$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
at
com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:
44)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore
$$EnhancerByGuice$$e4ef4f3e.putFragment(<generated>)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore.put(MegastorePayloadStore.java:
239)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore
$$EnhancerByGuice$$e4ef4f3e.CGLIB$put$1(<generated>)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore
$$EnhancerByGuice$$e4ef4f3e$$FastClassByGuice$
$424ac4f8.invoke(<generated>)
at
com.google.inject.internal.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:
228)
at com.google.inject.internal.InterceptorStackCallback
$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
at
com.google.common.stats.ExportableHistogramStatInterceptor.invoke(ExportableHistogramStatInterceptor.java:
63)
at com.google.inject.internal.InterceptorStackCallback
$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:64)
at
com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:
44)
at
com.google.ads.common.workflow.payloadstore.impl.megastore.MegastorePayloadStore
$$EnhancerByGuice$$e4ef4f3e.put(<generated>)
at
com.google.ads.api.serviceimpls.job.bulkmutate.actions.MutateAction.storeRequestParts(MutateAction.java:
580)
... 115 more
]
On Jul 12, 2:48 pm, AdWords API Advisor <[email protected]>
wrote:
> Hi,
>
> It looks like there are some sporadic issue with these errors on the
> BulkMutateJobService. I'll bring this to the attention of the core
> engineering team, and in the mean time you should retry your requests
> after receiving this error as it may work the second time.
>
> Best,
> - Eric
>
> On Jul 10, 6:55 pm, ojak <[email protected]> wrote:
>
> > Honestly, I can't get it to fail with any regularity. I'll send the
> > same SOAP request twice, sometimes it works, sometimes it fails.
> > Exact same request...
>
> > On Jul 2, 2:42 pm, AdWords API Advisor <[email protected]>
> > wrote:
>
> > > Hi,
>
> > > Can you post the sanitized SOAP XML request and response that
> > > demonstrates the error?
>
> > > Best,
> > > - Eric Koleda, AdWords API Team
>
> > > On Jul 1, 2:43 pm, ojak <[email protected]> wrote:
>
> > > > Receiving InternalApiError.UNEXPECTED_INTERNAL_API_ERROR when
> > > > submitting a BulkMutateJob.
>
> > > > The API docs state is:
> > > > "Indicates that a server-side error has occured. InternalApiErrors
> > > > are generally not the result of an invalid request or message sent by
> > > > the client."
> > > > "REASON: UNEXPECTED_INTERNAL_API_ERROR: API encountered an
> > > > unexpected internal error."
>
> > > > Google team, any help?
>
>
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
