When I try to connect to my S3 using the Amazon S3 Connection node, and I push the “Test connection” button in the configuration windows, it connects but the following message is triggered:
Couldn't initialize a SAX driver to create an XML reader
Would you be able to supply your KNIME.log file after you've seen the error (find that in <workspace>\.metadata\knime\knime.log). Can you also confirm whether you have any additional extensions installed into the Analytics Platform.
Thank you for your reply. What is following is the log produced by the system when I use the Amazon S3 Connection.
2017-01-30 09:31:42,668 : INFO : SwingWorker-pool-4-thread-2 : S3Connection : Amazon S3 Connection : 3:1996 : Create a new AmazonS3Client in Region "eu-west-1" with connection timeout 30000 milliseconds
2017-01-30 09:31:43,206 : WARN : SwingWorker-pool-4-thread-2 : TestConnectionDialog$TestWorker : Amazon S3 Connection : 3:1996 : Couldn't connect
2017-01-30 09:31:43,206 : DEBUG : SwingWorker-pool-4-thread-2 : TestConnectionDialog$TestWorker : Amazon S3 Connection : 3:1996 : Couldn't connect
com.amazonaws.AmazonClientException: Couldn't initialize a SAX driver to create an XMLReader
at com.amazonaws.services.s3.model.transform.XmlResponsesSaxParser.<init>(XmlResponsesSaxParser.java:85)
at com.amazonaws.services.s3.model.transform.Unmarshallers$ListBucketsUnmarshaller.unmarshall(Unmarshallers.java:37)
at com.amazonaws.services.s3.model.transform.Unmarshallers$ListBucketsUnmarshaller.unmarshall(Unmarshallers.java:34)
at com.amazonaws.services.s3.internal.S3XmlResponseHandler.handle(S3XmlResponseHandler.java:62)
at com.amazonaws.services.s3.internal.S3XmlResponseHandler.handle(S3XmlResponseHandler.java:31)
at com.amazonaws.http.AmazonHttpClient.handleResponse(AmazonHttpClient.java:1274)
at com.amazonaws.http.AmazonHttpClient.executeOneRequest(AmazonHttpClient.java:913)
at com.amazonaws.http.AmazonHttpClient.executeHelper(AmazonHttpClient.java:723)
at com.amazonaws.http.AmazonHttpClient.doExecute(AmazonHttpClient.java:475)
at com.amazonaws.http.AmazonHttpClient.executeWithTimer(AmazonHttpClient.java:437)
at com.amazonaws.http.AmazonHttpClient.execute(AmazonHttpClient.java:386)
at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:3996)
at com.amazonaws.services.s3.AmazonS3Client.invoke(AmazonS3Client.java:3933)
at com.amazonaws.services.s3.AmazonS3Client.listBuckets(AmazonS3Client.java:851)
at com.amazonaws.services.s3.AmazonS3Client.listBuckets(AmazonS3Client.java:857)
at org.knime.cloud.aws.s3.filehandler.S3Connection.getBuckets(S3Connection.java:117)
at org.knime.cloud.aws.s3.filehandler.S3Connection.open(S3Connection.java:64)
at org.knime.base.filehandling.remote.files.RemoteFile.open(RemoteFile.java:126)
at org.knime.base.filehandling.remote.files.RemoteFileFactory.createRemoteFile(RemoteFileFactory.java:134)
at org.knime.base.filehandling.remote.connectioninformation.node.TestConnectionDialog$TestWorker.doInBackgroundWithContext(TestConnectionDialog.java:234)
at org.knime.base.filehandling.remote.connectioninformation.node.TestConnectionDialog$TestWorker.doInBackgroundWithContext(TestConnectionDialog.java:1)
at org.knime.core.util.SwingWorkerWithContext.doInBackground(SwingWorkerWithContext.java:106)
at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at javax.swing.SwingWorker.run(SwingWorker.java:334)
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: org.xml.sax.SAXException: SAX2 driver class org.apache.xerces.parsers.SAXParser not found
java.lang.ClassNotFoundException: org.apache.xerces.parsers.SAXParser
at org.xml.sax.helpers.XMLReaderFactory.loadClass(XMLReaderFactory.java:230)
at org.xml.sax.helpers.XMLReaderFactory.createXMLReader(XMLReaderFactory.java:191)
at com.amazonaws.services.s3.model.transform.XmlResponsesSaxParser.<init>(XmlResponsesSaxParser.java:83)
... 27 more
Caused by: java.lang.ClassNotFoundException: org.apache.xerces.parsers.SAXParser
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:331)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at org.eclipse.osgi.internal.framework.ContextFinder.loadClass(ContextFinder.java:132)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at org.xml.sax.helpers.NewInstance.newInstance(NewInstance.java:82)
at org.xml.sax.helpers.XMLReaderFactory.loadClass(XMLReaderFactory.java:228)
... 29 more
Please, what do you mean exacly with "additional extensions"?
Could you try to make the connection with a fresh KNIME Installation. Does that help?
Do you have a list of installed extensions for the KNIME installation that cannot make the connection? Could you also share your OS version and the KNIME AP version that you are using.
Does the issue happen after a KNIME restart when this is the first node that is run?
We've had issue with XML and xerces, for example using the XPATH node will break XML parsing in our java libraries unless we implement a workaround. But I don't believe it was the same issue reported in the stack trace.
I continue to have this problem even starting from a fresh new installation of knime (version 3.5.0). Please, is there a way to know what is that causes the problem?