I installed the new (in 3.2) Tableau extension, installed and configured the dependancies as per instructions in the node description (Tableau SDK and Visual Basic Redistributable), and tried to create an extract. My repeated attempts throw the same error:
ERROR Tableau Writer (TDE) 0:8 Execute failed: Timeout
- IPC_NamedPipe::Select(WaitForMultipleObjects)
Does anyone have any tips on how to diagnose this further?
Thank you.
Difficult. Which version of the SDK is it?
Can you extract the relevant lines from the knime.log file and post them here?
Also, Tableau itself writes some log files. You can control the location of those files using environment variables, see bottom of this page. The files are called TableauSDKExtract.log and TableauSDKServer.log.
It's interesting to note that it runs into a timeout although you just want to write a file.
Thank you for looking into this.
I'm using C-Java-64Bit-9-3-3 SDK.
Tableau SDK log had just one line:
2016-07-18 12:27:39.488 (6092): pid=8824----------------------------------
KNIME log in DEBUG mode showed the follownig (as related to the node):
2016-07-18 12:27:36,396 : DEBUG : main : WorkflowRootEditPart : : : part: NodeContainerEditPart( Tableau Writer (TDE) 0:8 (CONFIGURED) )
2016-07-18 12:27:36,402 : DEBUG : main : ConnectionContainerEditPart : : : refreshing visuals for: STD[0:6(1) -> 0:8( 1)]
2016-07-18 12:27:36,406 : DEBUG : main : ConnectionContainerEditPart : : : modelling info: null
2016-07-18 12:27:39,218 : DEBUG : main : ExecuteAction : : : Creating execution job for 1 node(s)...
2016-07-18 12:27:39,225 : DEBUG : main : NodeContainer : : : Setting dirty flag on Tableau Writer (TDE) 0:8
2016-07-18 12:27:39,230 : DEBUG : main : NodeContainer : : : Setting dirty flag on Geocoding tests 0
2016-07-18 12:27:39,236 : DEBUG : main : NodeContainer : : : Tableau Writer (TDE) 0:8 has new state: CONFIGURED_MARKEDFOREXEC
2016-07-18 12:27:39,237 : DEBUG : KNIME-Workflow-Notifier : WorkflowEditor : : : Workflow event triggered: WorkflowEvent [type=WORKFLOW_DIRTY;node=0;old=null;new=null;timestamp=18/07/2016 12:27:39 PM]
2016-07-18 12:27:39,246 : DEBUG : main : NodeContainer : : : Tableau Writer (TDE) 0:8 has new state: CONFIGURED_QUEUED
2016-07-18 12:27:39,255 : DEBUG : main : NodeContainer : : : Geocoding tests 0 has new state: EXECUTING
2016-07-18 12:27:39,261 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer : : : ROOT has new state: EXECUTING
2016-07-18 12:27:39,261 : DEBUG : KNIME-Worker-2 : WorkflowManager : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 doBeforePreExecution
2016-07-18 12:27:39,271 : DEBUG : KNIME-Worker-2 : NodeContainer : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 has new state: PREEXECUTE
2016-07-18 12:27:39,305 : DEBUG : KNIME-Worker-2 : WorkflowManager : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 doBeforeExecution
2016-07-18 12:27:39,310 : DEBUG : KNIME-Worker-2 : NodeContainer : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 has new state: EXECUTING
2016-07-18 12:27:39,318 : DEBUG : KNIME-Worker-2 : WorkflowFileStoreHandlerRepository : Tableau Writer (TDE) : 0:8 : Adding handler 8a350ab8-f0ee-444e-be6d-c3ff4641cccb (Tableau Writer (TDE) 0:8: <no directory>) - 1 in total
2016-07-18 12:27:39,323 : DEBUG : KNIME-Worker-2 : LocalNodeExecutionJob : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 Start execute
2016-07-18 12:28:09,507 : DEBUG : KNIME-Worker-2 : Tableau Writer (TDE) : Tableau Writer (TDE) : 0:8 : reset
2016-07-18 12:28:09,514 : ERROR : KNIME-Worker-2 : Tableau Writer (TDE) : Tableau Writer (TDE) : 0:8 : Execute failed: Timeout
- IPC_NamedPipe::Select(WaitForMultipleObjects)
2016-07-18 12:28:09,519 : DEBUG : KNIME-Worker-2 : Tableau Writer (TDE) : Tableau Writer (TDE) : 0:8 : Execute failed: Timeout
- IPC_NamedPipe::Select(WaitForMultipleObjects)
com.tableausoftware.TableauException: Timeout
- IPC_NamedPipe::Select(WaitForMultipleObjects)
at com.tableausoftware.extract.Extract.<init>(Unknown Source)
at org.knime.ext.tableau.TableauTableWriter.<init>(TableauTableWriter.java:97)
at org.knime.ext.tableau.TableauTableWriter.create(TableauTableWriter.java:126)
at org.knime.ext.tableau.tdewrite.TableauDENodeModel.execute(TableauDENodeModel.java:109)
at org.knime.core.node.NodeModel.execute(NodeModel.java:732)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:566)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1146)
at org.knime.core.node.Node.execute(Node.java:933)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:556)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95)
at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:179)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:110)
at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:328)
at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:204)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
2016-07-18 12:28:09,528 : DEBUG : KNIME-Worker-2 : WorkflowManager : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 doBeforePostExecution
2016-07-18 12:28:09,539 : DEBUG : KNIME-Worker-2 : NodeContainer : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 has new state: POSTEXECUTE
2016-07-18 12:28:09,547 : DEBUG : KNIME-Worker-2 : WorkflowManager : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 doAfterExecute - failure
2016-07-18 12:28:09,555 : DEBUG : KNIME-Worker-2 : Tableau Writer (TDE) : Tableau Writer (TDE) : 0:8 : reset
2016-07-18 12:28:09,563 : DEBUG : KNIME-Worker-2 : Tableau Writer (TDE) : Tableau Writer (TDE) : 0:8 : clean output ports.
2016-07-18 12:28:09,570 : DEBUG : KNIME-Worker-2 : WorkflowFileStoreHandlerRepository : Tableau Writer (TDE) : 0:8 : Removing handler 8a350ab8-f0ee-444e-be6d-c3ff4641cccb (Tableau Writer (TDE) 0:8: <no directory>) - 0 remaining
2016-07-18 12:28:09,579 : DEBUG : KNIME-Worker-2 : NodeContainer : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 has new state: IDLE
2016-07-18 12:28:09,590 : DEBUG : KNIME-Worker-2 : Tableau Writer (TDE) : Tableau Writer (TDE) : 0:8 : Configure succeeded. (Tableau Writer (TDE))
2016-07-18 12:28:09,598 : DEBUG : KNIME-Worker-2 : NodeContainer : Tableau Writer (TDE) : 0:8 : Tableau Writer (TDE) 0:8 has new state: CONFIGURED
2016-07-18 12:28:09,606 : DEBUG : KNIME-Worker-2 : NodeContainer : Tableau Writer (TDE) : 0:8 : Geocoding tests 0 has new state: CONFIGURED
2016-07-18 12:28:09,614 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer : : : ROOT has new state: IDLE
2016-07-18 12:28:13,436 : DEBUG : main : NodeContainerEditPart : : : Tableau Writer (TDE) 0:8 (CONFIGURED)
We have had few people internally using version 9-3-3 and it always worked for them.
The error originates somewhere in the Tableau code so that's out of KNIME's control. Does it also fail if you give it a rather small table to write?
I think the next step would be to reach out to the Tableau forum. The closest I could find that relates to 'your' error message is this. But their solution (upgrade to a newer version) doesn't seem to cut it.
I tested it with quite a small table, under 30 records, 20 fields.
I posted the question on Tableau Forums.
Thank you, @wiswedel.
This was resolved with the help of Tableau engineer.
The cause was the presense of an older Tableau API kit which is now superceded by a newer SDK kit, which now has the combined API & SDK functionality.
The PATH variable was pointing to both older API and newer SDK kits, and they had some binaries with the same name.
Removing the older kit fixed the issue.
Hi
This is the error I am getting
ERROR Tableau Writer (TDE) 2:13 Execute failed: Unable to load library 'TableauExtract': The specified module could not be found.
Can you please help me?
Have a look at the node description how to set it up.
Followed all the steps still the result same. Can you please guide me setting the path?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.