Where can I download extension SAP Reader - extension SAP Reader (Theobald Software) for KNIME and install it in offline (no internet connection) mode?

PakornW · May 2, 2024, 8:41am

I would like to download the extension to my local path and install it.

I cannot drag and drop the extension or install with online mode (connect to url).

Where can I download the extension SAP reader for KNIME - extension SAP Reader (Theobald Software)?

steffen_KNIME · May 2, 2024, 9:45am

Hi,

are you talking about this node: SAP Reader (Theobald Software) – KNIME Community Hub ?
Which is part of this extension: KNIME SAP Integration based on Theobald Xtract Universal – KNIME Community Hub ?

At the bottom of the last link one can see this:

If you following the link about checking the update site, you can scroll down to get to the following section: KNIME Analytics Platform Installation Guide
There you can find the zipped update site for KNIME Analytics Platform Update Site, which you can then use as a local update site.

Does that help you already?

Best regards
Steffen

PakornW · May 2, 2024, 2:40pm

Hi,
I am refer to this url KNIME | Theobald Software Online Help (theobald-software.com)
that I would like to install the extension for SAP reader node from Theobald software

I already updated KNIME.

steffen_KNIME · May 2, 2024, 2:58pm

Hi,

the tutorial you linked is using exactly the extension I meant.

So you are saying that…

you can neither drag and drop the node or the extension from the Community Hub site (which is also linked in your tutorial),
nor can you install it via Install extensions... in KNIME Analytics Platform directly
nor could you download the zipped update site which I linked so you can install it locally from your update site.

Could you verify these three points?

Steffen

PakornW · May 2, 2024, 3:05pm

Hi,

you can neither drag and drop the node or the extension from the Community Hub site (which is also linked in your tutorial),

I cannot drag and drop the node.

nor can you install it via Install extensions... in KNIME Analytics Platform directly

I cannot install it via ‘Install extension…’ in KNIME Analytics platform directly.

nor could you download the zipped update site which I linked so you can install it locally from your update site.

I can download the zipped update site which linked and install it locally.

steffen_KNIME · May 2, 2024, 3:17pm

Ok, so the issue is resolved? For the other points, I would think that you might be sitting behind some proxy, but that is hard to tell without details or logs.

Best regards
Steffen

PakornW · May 2, 2024, 3:21pm

I can install it locally but the node "SAP Reader (from Theobald software)’ doesn’t available in the Nodes tab.

steffen_KNIME · May 2, 2024, 3:36pm

I can see in my installation.

What does your node repository show?
Some screenshots and the KNIME Log could be helpful.

PakornW · May 2, 2024, 3:45pm

2024-05-02 15:25:02,496 : WARN : AWT-EventQueue-0 : : KCSExecutorNodeModel : SAP Table : 3:1 : KCSExecutorNodeDialog
2024-05-02 15:25:02,514 : WARN : AWT-EventQueue-0 : : KCSExecutorNodeModel : SAP Table : 3:1 : loadAdditionalSettingsFrom
2024-05-02 15:25:02,514 : WARN : AWT-EventQueue-0 : : KCSExecutorNodeModel : SAP Table : 3:1 : loadAdditionalSettingsFrom
2024-05-02 15:25:02,515 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:02.515] [000100] [W] [APIBase] [PrepareAndExecuteRequest] [KCS for HUB - xCS URL: http://localhost:5550]
2024-05-02 15:25:02,515 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:02.515] [000140] [W] [APIBase] [PrepareAndExecuteRequest] [Got xCS location. url: http://localhost:5550 kcsConfig.xcsHost: http://localhost:5550]
2024-05-02 15:25:03,532 : ERROR : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:03.532] [000100] [E] [KCSDialogHelper] [deleteAllKCSFiles] [File read write operation remained unsuccessful. KCS license could not be deteremined.]
2024-05-02 15:25:03,533 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:03.533] [000100] [W] [APIBase] [PrepareAndExecuteRequest] [KCS for HUB - xCS URL: http://localhost:5550]
2024-05-02 15:25:03,533 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:03.533] [000140] [W] [APIBase] [PrepareAndExecuteRequest] [Got xCS location. url: http://localhost:5550 kcsConfig.xcsHost: http://localhost:5550]
2024-05-02 15:25:04,560 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:04.56] [000100] [W] [APIBase] [PrepareAndExecuteRequest] [KCS for HUB - xCS URL: http://localhost:5550]
2024-05-02 15:25:04,561 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:04.561] [000140] [W] [APIBase] [PrepareAndExecuteRequest] [Got xCS location. url: http://localhost:5550 kcsConfig.xcsHost: http://localhost:5550]
2024-05-02 15:25:05,581 : ERROR : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:05.581] [000110] [E] [KCSDialogHelper] [getBrowserSettings] [API request to check if a default browser setting exists failed. Exception: [Cannot invoke “String.toString()” because the return value of “java.util.HashMap.get(Object)” is null]]
2024-05-02 15:25:46,358 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:46.358] [000100] [W] [APIBase] [PrepareAndExecuteRequest] [KCS for HUB - xCS URL: http://localhost:5550]
2024-05-02 15:25:46,359 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:46.359] [000140] [W] [APIBase] [PrepareAndExecuteRequest] [Got xCS location. url: http://localhost:5550 kcsConfig.xcsHost: http://localhost:5550]
2024-05-02 15:25:47,376 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:47.376] [000100] [W] [APIBase] [PrepareAndExecuteRequest] [KCS for HUB - xCS URL: http://localhost:5550]
2024-05-02 15:25:47,377 : WARN : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:47.377] [000140] [W] [APIBase] [PrepareAndExecuteRequest] [Got xCS location. url: http://localhost:5550 kcsConfig.xcsHost: http://localhost:5550]
2024-05-02 15:25:48,412 : ERROR : AWT-EventQueue-0 : : Utilities : SAP Table : 3:1 : [2024-05-02 15:25:48.412] [000110] [E] [KCSDialogHelper] [getBrowserSettings] [API request to check if a default browser setting exists failed. Exception: [Cannot invoke “String.toString()” because the return value of “java.util.HashMap.get(Object)” is null]]
2024-05-02 15:48:32,254 : WARN : comm-pool-thread-8 : : Node : DB Connector : 3:1 : Please select a database type.
2024-05-02 21:43:08,243 : WARN : main : : HubURIImporter : : : Hub request failed
jakarta.ws.rs.ProcessingException: javax.net.ssl.SSLHandshakeException: SSLHandshakeException invoking https://api.hub.knime.com/nodes/org.knime.sap.theobald.node.v2.SAPTheobaldReader2NodeFactory?details=full: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at org.apache.cxf.jaxrs.client.AbstractClient.checkClientException(AbstractClient.java:638)
at org.apache.cxf.jaxrs.client.AbstractClient.preProcessResult(AbstractClient.java:612)
at org.apache.cxf.jaxrs.client.WebClient.doResponse(WebClient.java:1149)
at org.apache.cxf.jaxrs.client.WebClient.doChainedInvocation(WebClient.java:1086)
at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:931)
at org.apache.cxf.jaxrs.client.WebClient.doInvoke(WebClient.java:900)
at org.apache.cxf.jaxrs.client.WebClient.invoke(WebClient.java:363)
at org.apache.cxf.jaxrs.client.WebClient.get(WebClient.java:389)
at com.knime.explorer.server.internal.HubURIImporter.callHubApi(HubURIImporter.java:767)
at com.knime.explorer.server.internal.HubURIImporter.callHubApi(HubURIImporter.java:746)
at com.knime.explorer.server.internal.HubURIImporter.createNodeImport(HubURIImporter.java:562)
at org.knime.workbench.core.imports.URIImporter.createEntityImport(URIImporter.java:83)
at org.knime.workbench.core.imports.URIImporter.createEntityImport(URIImporter.java:105)
at org.knime.workbench.core.imports.URIImporterFinder.createEntityImportFor(URIImporterFinder.java:118)
at org.knime.ui.java.api.ImportURI.getEntityImportResult(ImportURI.java:163)
at org.knime.ui.java.api.ImportURI.importURI(ImportURI.java:133)
at org.knime.ui.java.browser.KnimeBrowserLocationListener.changing(KnimeBrowserLocationListener.java:89)
at com.equo.chromium.swt.internal.Chromium.lambda$18(Chromium.java:1354)
at com.equo.chromium.swt.internal.Chromium.syncExec(Chromium.java:3078)
at com.equo.chromium.swt.internal.Chromium.onBeforeBrowse(Chromium.java:1352)
at com.equo.chromium.swt.internal.Chromium.access$14(Chromium.java:1340)
at com.equo.chromium.swt.internal.Chromium$RequestHandler.onBeforeBrowse(Chromium.java:1179)
at org.cef.CefClient.onBeforeBrowse(CefClient.java:766)
at org.cef.CefApp.N_DoMessageLoopWork(Native Method)
at org.cef.CefApp.lambda$0(CefApp.java:328)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4029)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3645)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1155)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:643)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:550)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:171)
at org.knime.product.rcp.KNIMEApplication.start(KNIMEApplication.java:204)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:136)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:402)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:659)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:596)
at org.eclipse.equinox.launcher.Main.run(Main.java:1467)
Caused by: javax.net.ssl.SSLHandshakeException: SSLHandshakeException invoking https://api.hub.knime.com/nodes/org.knime.sap.theobald.node.v2.SAPTheobaldReader2NodeFactory?details=full: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.mapException(HTTPConduit.java:1452)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1433)
at org.apache.cxf.io.AbstractWrappedOutputStream.close(AbstractWrappedOutputStream.java:77)
at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56)
at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:717)
at org.apache.cxf.transport.http.HttpClientHTTPConduit.close(HttpClientHTTPConduit.java:112)
at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:63)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:307)
at org.apache.cxf.jaxrs.client.AbstractClient.doRunInterceptorChain(AbstractClient.java:710)
at org.apache.cxf.jaxrs.client.WebClient.doChainedInvocation(WebClient.java:1085)
… 46 more
Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source)
at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection$10.run(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection$10.run(Unknown Source)
at java.base/java.security.AccessController.doPrivileged(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getChainedException(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at java.base/java.net.HttpURLConnection.getResponseCode(Unknown Source)
at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(Unknown Source)
at org.apache.cxf.transport.http.URLConnectionHTTPConduit$URLConnectionWrappedOutputStream$2.run(URLConnectionHTTPConduit.java:370)
at org.apache.cxf.transport.http.URLConnectionHTTPConduit$URLConnectionWrappedOutputStream$2.run(URLConnectionHTTPConduit.java:366)
at java.base/java.security.AccessController.doPrivileged(Unknown Source)
at org.apache.cxf.transport.http.URLConnectionHTTPConduit$URLConnectionWrappedOutputStream.getResponseCode(URLConnectionHTTPConduit.java:366)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.processRetransmit(HTTPConduit.java:1503)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleRetransmits(HTTPConduit.java:1490)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1621)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1420)
… 54 more
Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/sun.security.ssl.Alert.createSSLException(Unknown Source)
at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
at java.base/sun.security.ssl.TransportContext.fatal(Unknown Source)
at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.checkServerCerts(Unknown Source)
at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.onConsumeCertificate(Unknown Source)
at java.base/sun.security.ssl.CertificateMessage$T13CertificateConsumer.consume(Unknown Source)
at java.base/sun.security.ssl.SSLHandshake.consume(Unknown Source)
at java.base/sun.security.ssl.HandshakeContext.dispatch(Unknown Source)
at java.base/sun.security.ssl.HandshakeContext.dispatch(Unknown Source)
at java.base/sun.security.ssl.TransportContext.dispatch(Unknown Source)
at java.base/sun.security.ssl.SSLTransport.decode(Unknown Source)
at java.base/sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at java.base/sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
at java.base/sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at java.base/sun.net.www.protocol.http.HttpURLConnection.getHeaderFields(Unknown Source)
at java.base/sun.net.www.protocol.https.HttpsURLConnectionImpl.getHeaderFields(Unknown Source)
at org.apache.cxf.transport.http.Headers.readFromConnection(Headers.java:280)
at org.apache.cxf.transport.http.URLConnectionHTTPConduit$URLConnectionWrappedOutputStream.updateCookiesBeforeRetransmit(URLConnectionHTTPConduit.java:330)
at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleRetransmits(HTTPConduit.java:1488)
… 56 more
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/sun.security.validator.PKIXValidator.doBuild(Unknown Source)
at java.base/sun.security.validator.PKIXValidator.engineValidate(Unknown Source)
at java.base/sun.security.validator.Validator.validate(Unknown Source)
at java.base/sun.security.ssl.X509TrustManagerImpl.checkTrusted(Unknown Source)
at java.base/sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(Unknown Source)
at org.knime.core.util.KNIMEX509TrustManager.checkServerTrusted(KNIMEX509TrustManager.java:109)
… 77 more
Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(Unknown Source)
at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(Unknown Source)
at java.base/java.security.cert.CertPathBuilder.build(Unknown Source)
… 83 more
2024-05-02 21:54:41,247 : WARN : ModalContext : : Node : Missing Value : 4:379:375 : Column “Email” still contains missing values.
Column “CorporateEmail” still contains missing values.
2024-05-02 21:54:41,435 : WARN : ModalContext : : Node : Missing Value : 4:312 : Column “CorporateEmail” still contains missing values.
Column “Email” still contains missing values.
2024-05-02 21:54:41,838 : WARN : ModalContext : : Node : Bar Chart : 4:327 : There are rows with missing values in one of the selected frequency columns. These frequencies are not displayed for this row.

steffen_KNIME · May 2, 2024, 3:53pm

The error seems to be

 Caused by: javax.net.ssl.SSLHandshakeException: SSLHandshakeException invoking https://api.hub.knime.com/nodes/org.knime.sap.theobald.node.v2.SAPTheobaldReader2NodeFactory?details=full: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

PKIX path building failed errors can be resolved following this thread. If I see that correctly, than the first option is following the linked video and the other one might be faster with altering your knime.ini file:

Does that work?

PakornW · May 2, 2024, 4:01pm

I downloaded the site update with this url

Suppose this is the node I am looking for

steffen_KNIME · May 2, 2024, 4:05pm

Yes, but you installed that already, did you not?

Let me know whether my previous post works for you.

PakornW · May 2, 2024, 4:08pm

After update the platform update sites, it is there.