AnsweredAssumed Answered

Failed while storing output: NetSuite Query

Question asked by vfalk on Aug 15, 2017
Latest reply on Jun 13, 2018 by aeboyer115963

All,

 

I am experiencing a problem when querying my client's NetSuite account to check if a Customer is created. In the same map, we create the customer (successfully) and then Query NetSuite by Phone, Email, and Stage. When I try executing this, I can an error saying "Nested Connector Call Returning More than 1 Document". However, I can clearly see in my NetSuite instance there is only 1 customer with that combination. 

 

Any ideas what I may be doing wrong? I've tried debugging for a few hours but thought I would ask the community if anyone has seen this.

 

The error response in logs for the mapping shape is as follows:

 

com.boomi.transform.TransformException: [Function: Create Customer Map Function 2, Connector Call (Step 13)]: Failed while storing output
at com.boomi.transform.function.FunctionImpl.execute(FunctionImpl.java:342)
at com.boomi.transform.FunctionFiller.executeFunctionLoop(FunctionFiller.java:89)
at com.boomi.transform.FunctionFiller.fillFunctionsLinear(FunctionFiller.java:134)
at com.boomi.transform.FunctionFiller.fillFunctions(FunctionFiller.java:116)
at com.boomi.transform.TransformEngineImpl.fillFunctions(TransformEngineImpl.java:336)
at com.boomi.transform.TransformEngineImpl.performMap(TransformEngineImpl.java:128)
at com.boomi.transform.TransformEngineImpl.performMap(TransformEngineImpl.java:96)
at com.boomi.transform.TransformEngineImpl.performMap(TransformEngineImpl.java:59)
at com.boomi.process.shape.MapShape.execute(MapShape.java:408)
at com.boomi.process.graph.ProcessShape.executeShape(ProcessShape.java:558)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:488)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.execute(ProcessGraph.java:307)
at com.boomi.process.ProcessExecution.call(ProcessExecution.java:811)
at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:935)
at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:61)
at com.boomi.util.concurrent.CancellableFutureTask.run(CancellableFutureTask.java:160)
at com.boomi.execution.NestedExecutionForker$NestedSynchronousExecutionFuture.runSynchronous(NestedExecutionForker.java:203)
at com.boomi.execution.NestedExecutionForker$NestedSynchronousExecutionFuture.get(NestedExecutionForker.java:171)
at com.boomi.execution.NestedExecutionForker$NestedSynchronousExecutionFuture.get(NestedExecutionForker.java:150)
at com.boomi.execution.ExecutionTask.getChildResult(ExecutionTask.java:1307)
at com.boomi.execution.ExecutionTask.getChildResult(ExecutionTask.java:1293)
at com.boomi.process.shape.ChildInvokerShape.getChildResult(ChildInvokerShape.java:41)
at com.boomi.process.shape.BaseProcessCallShape.baseExecuteSubProcess(BaseProcessCallShape.java:248)
at com.boomi.process.shape.BaseProcessCallShape.baseExecutePassthroughSubProcess(BaseProcessCallShape.java:214)
at com.boomi.process.shape.ProcessCallShape.executePassthroughSubProcess(ProcessCallShape.java:202)
at com.boomi.process.shape.ProcessCallShape.execute(ProcessCallShape.java:125)
at com.boomi.process.graph.ProcessShape.executeShape(ProcessShape.java:558)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:488)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.executeShape(ProcessGraph.java:509)
at com.boomi.process.graph.ProcessGraph.executeNextShapes(ProcessGraph.java:572)
at com.boomi.process.graph.ProcessGraph.execute(ProcessGraph.java:307)
at com.boomi.process.ProcessExecution.call(ProcessExecution.java:811)
at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:935)
at com.boomi.execution.ExecutionTask.call(ExecutionTask.java:61)
at com.boomi.util.concurrent.CancellableFutureTask.run(CancellableFutureTask.java:160)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.boomi.connector.ConnectorException: Failed while storing output
at com.boomi.connector.generic.DataTracker.addResult(DataTracker.java:306)
at com.boomi.connector.generic.DataTracker.addPartialResult(DataTracker.java:201)
at com.boomi.connector.generic.GenericResponse.addPartialResult(GenericResponse.java:53)
at com.boomi.connector.api.ResponseUtil.addPartialSuccess(ResponseUtil.java:263)
at com.boomi.connector.netsuite.sdk.NetsuiteQueryOperation.handle(NetsuiteQueryOperation.java:318)
at com.boomi.connector.netsuite.sdk.NetsuiteQueryOperation.executeQuery(NetsuiteQueryOperation.java:178)
at com.boomi.connector.util.BaseQueryOperation.execute(BaseQueryOperation.java:36)
at com.boomi.connector.generic.GenericConnectorAction.invoke(GenericConnectorAction.java:172)
at com.boomi.connector.base.BaseConnectorAction.invokeBase(BaseConnectorAction.java:366)
at com.boomi.connector.base.BaseConnectorAction.invoke(BaseConnectorAction.java:333)
at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.boomi.util.ClassUtil$InvokerWithClassLoader.invoke(ClassUtil.java:369)
at com.sun.proxy.$Proxy34.invoke(Unknown Source)
at com.boomi.function.connector.ConnectorCall$Invoker.invoke(ConnectorCall.java:173)
at com.boomi.function.connector.ConnectorCall.executeImpl(ConnectorCall.java:104)
at com.boomi.transform.function.FunctionExecution.execute(FunctionExecution.java:294)
at com.boomi.transform.function.FunctionExecutorImpl.executeFunctionExecution(FunctionExecutorImpl.java:17)
at com.boomi.transform.function.FunctionImpl.executeStep(FunctionImpl.java:431)
at com.boomi.transform.function.FunctionImpl.execute(FunctionImpl.java:337)
... 55 more
Caused by: com.boomi.store.DataStoreException: Nested connector call returned more than 1 document.
at com.boomi.function.connector.ConnectorCall$ConnectorCallDocCountLimiter.failWrite(ConnectorCall.java:242)
at com.boomi.store.impl.DocCountLimiter.allowStoreWrite(DocCountLimiter.java:57)
at com.boomi.store.impl.WriteStoreImpl.storeImpl(WriteStoreImpl.java:290)
at com.boomi.store.impl.WriteStoreImpl.store(WriteStoreImpl.java:245)
at com.boomi.connector.generic.DataTracker.addResult(DataTracker.java:298)

 

 

Thank you everyone! 

 

Vince

Outcomes