Hello everybody,
Everytime I try to extract ChEMBL data with "ChEMBLdb Connector", I get an error message saying :
WARN ChEMBLdb Connector 0:11 The XML URL may be invalid: Connection timed out
ERROR ChEMBLdb Connector 0:11 Execute failed: Cannot get table: container is not closed.
WARN ChEMBLdb Connector Input 0:12 The XML URL may be invalid: Connection timed out
WARN ChEMBLdb Connector Input 0:12 Node created an empty data table.
I have correctly set up my "Network Connections". I don't understand why am I getting this error message ? Can you help me ?
Best Regards,
Baptiste CANAULT
Hi Baptiste,
Could you try pasting this into your web browser? What happens?
https://www.ebi.ac.uk/chembl/api/data/activity
Thanks,
Jon
Hello Jon,
When I paste this into my web browser, I get this message :
"This XML file does not appear to have any style information associated with it. The document tree is shown below."
And I see XML page : <response><activities><activity><activity_comment/> ...
Is it normal ?
Baptiste
Hi Baptiste,
That sounds normal, and means that you can rule out a network issue from your machine. Are you using the latest version of the ChEMBL connectors?
One other test you could do is to use the REST, 'Get Resource' node with the URL I gave above. Does that work?
Best,
Jon
Hi Jon,
I try to install the latest version of KNIME (3.0.0) but without success.
Get Resource solution : ERROR GET Resource 2:6 Execute failed: Error when trying to submit request: java.net.ConnectException: Connection timed out
Thanks,
Baptiste
Hi Baptiste,
Best to use KNIME 2.12.1 for testing. In any case it looks like a network issue since the GET Resouce node also fails.
I guess that this means that you are behind some kind of proxy and you'll need to go to File > Preferences and setup the proxy in KNIME.
Best,
Jon
Hi Jon,
With 2.12.2 : ERROR GET Resource Execute failed: Invalid URL: https://www.ebi.ac.uk/chembl/api/data/activity.
I am connected to internet and I set up correctly my proxy connexion because the nodes "ChEBI" work fine. What is most surprising is that "ChEMBL" nodes have stopped to work in the last month or so.
Regards,
Baptiste
Hi Baptiste,
Just to note that the question was answered here: https://tech.knime.org/forum/embl-ebi/chembldb-connector-connexion-failed
Best,
Jon