TIBCO Spotfire File Writer - cannot write sbdf to spotfire library

[WThomas]

Hi - once I configure the TIBCO Spotfire File Writer and Execute, it loads to 99%. Then in the Knime Console display’s the following.

ERROR TIBCO Spotfire File Writer 0:2 Other exception while loading types
WARN TIBCO Spotfire File Writer 0:2 Small file upload didn’t succeed!
WARN TIBCO Spotfire File Writer 0:2 Error uploading to library: Upload failed

LOGS are.

2020-05-25 21:41:52,064 : WARN : KNIME-Worker-2 : : SpotfireFileWriterNodeModel : TIBCO Spotfire File Writer : 0:2 : Error uploading to library: Upload failed! … Retry number: 1
java.lang.Exception: Upload failed!
at com.tibco.ext.spotfire.filewriter.node.SpotfireFileWriterNodeModel.oopUploadToLibrary(SpotfireFileWriterNodeModel.java:495)
at com.tibco.ext.spotfire.filewriter.node.SpotfireFileWriterNodeModel.uploadToLibrary(SpotfireFileWriterNodeModel.java:340)
at com.tibco.ext.spotfire.filewriter.node.SpotfireFileWriterNodeModel.execute(SpotfireFileWriterNodeModel.java:179)
at org.knime.core.node.NodeModel.execute(NodeModel.java:733)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:567)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1192)
at org.knime.core.node.Node.execute(Node.java:979)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:559)
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)
2020-05-25 21:41:57,088 : WARN : KNIME-Worker-2 : : Node : TIBCO Spotfire File Writer : 0:2 : Execution canceled

Looking for a resolution, I have looked through the network and cannot find a solution.

[gab1one]

Hi @WThomas,

did you set the log level to DEBUG in the KNIME Preferences? If not please do and retry, this should give us a more detailed error message.

best,
Gabriel

[WThomas]

Hey Gabriel,

Thanks for your response, I am new to Knime. I turned on Debug and below is that log.

ERROR TIBCO Spotfire File Writer 0:2 Other exception while loading types
INFO TIBCO Spotfire File Writer 0:2 Done LoadType
WARN TIBCO Spotfire File Writer 0:2 Small file upload didn’t succeed!
INFO TIBCO Spotfire File Writer 0:2 Falling back to Out-of-Process file uploader
INFO TIBCO Spotfire File Writer 0:2 C:\Program Files\KNIME\plugins\com.tibco.spotfire.libraryclient.oop_1.8.20
INFO TIBCO Spotfire File Writer 0:2 “C:\Program Files\KNIME\plugins\com.tibco.spotfire.libraryclient.oop_1.8.20\bin\C:\Program Files\KNIME\plugins\com.tibco.spotfire.libraryclient.oop_1.8.20\lib*”
INFO TIBCO Spotfire File Writer 0:2 command line: “C:\Program Files\KNIME\plugins\org.knime.binary.jre.win32.x86_64_1.8.0.202-b08\jre\bin\java.exe” -classpath “C:\Program Files\KNIME\plugins\com.tibco.spotfire.libraryclient.oop_1.8.20\bin\C:\Program Files\KNIME\plugins\com.tibco.spotfire.libraryclient.oop_1.8.20\lib*” com.tibco.spotfire.libraryclient.FileUploader https://huskyspotfire:9443/spotfire/Users/Thomas%20Wayne/test.sbdf HQ\thomaw yMBKKWlgo64hqd1dCryaAA== “C:\Users\thomaw\AppData\Local\Temp\knime-spotfire5858491289541448861.sbdf”
INFO TIBCO Spotfire File Writer 0:2 [C:\Program Files\KNIME\plugins\org.knime.binary.jre.win32.x86_64_1.8.0.202-b08\jre\bin\java.exe, -classpath, “C:\Program Files\KNIME\plugins\com.tibco.spotfire.libraryclient.oop_1.8.20\bin\C:\Program Files\KNIME\plugins\com.tibco.spotfire.libraryclient.oop_1.8.20\lib*”, com.tibco.spotfire.libraryclient.FileUploader, https://huskyspotfire:9443/spotfire/Users/Thomas%20Wayne/test.sbdf, HQ\thomaw, yMBKKWlgo64hqd1dCryaAA==, “C:\Users\thomaw\AppData\Local\Temp\knime-spotfire5858491289541448861.sbdf”]
INFO TIBCO Spotfire File Writer 0:2 Error: Could not find or load main class com.tibco.spotfire.libraryclient.FileUploader
WARN TIBCO Spotfire File Writer 0:2 Error uploading to library: Upload failed! … Retry number: 1
INFO TIBCO Spotfire File Writer 0:2 Writing TIBCO Spotfire file: C:\Users\thomaw\AppData\Local\Temp\knime-spotfire6944541201538274282.sbdf
DEBUG TIBCO Spotfire File Writer 0:2 Closing input stream on “C:\Users\thomaw\AppData\Local\Temp\knime_Spotfire_test876\knime_container_20200526_3299453046690293553.tmp”, 0 remaining
INFO TIBCO Spotfire File Writer 0:2 Uploading to library with the file: /spotfire/Users/Thomas%20Wayne/test.sbdf
INFO TIBCO Spotfire File Writer 0:2 Uploading TIBCO Spotfire file: C:\Users\thomaw\AppData\Local\Temp\knime-spotfire6944541201538274282.sbdf
INFO TIBCO Spotfire File Writer 0:2 Plugin version: null
INFO TIBCO Spotfire File Writer 0:2 LibraryServiceClient url: https://huskyspotfire:9443/spotfire username: HQ\thomaw password: **************
INFO TIBCO Spotfire File Writer 0:2 Using URL: https://huskyspotfire:9443/spotfire
INFO TIBCO Spotfire File Writer 0:2 created client
INFO TIBCO Spotfire File Writer 0:2 NOT Authenticating in SPOServletServiceClient as authentication should be maintained as part of the session
INFO TIBCO Spotfire File Writer 0:2 Servlet client URL: https://huskyspotfire:9443/spotfire/attachment
INFO TIBCO Spotfire File Writer 0:2 In LoadType
ERROR TIBCO Spotfire File Writer 0:2 Other exception while loading types
INFO TIBCO Spotfire File Writer 0:2 Done LoadType
WARN TIBCO Spotfire File Writer 0:2 Small file upload didn’t succeed!

[WThomas]

We have Kerberos enable in Spotfire which provides us a SSO on spotfire. By having this the Knime Spotfire File Writer will not connect. Knime\Tibco are working on this.