KNIME Server - Could not find Oracle driver

Hello,

I have an interesting problem with the KNIME Server.

For reporting, I use a database connection to Oracle 12c. The driver is registered (Pref->Database) and locally on the executer (form KNIME Server), the workflow works proberly. But after deployment, I get the following error message:

The flow xxx of user xxx finished with state IDLE.
The workflow did not fully execute.

The following messages were collected:
ERROR Database Connector 2:2: Execute failed: Could not create connection to database: Could not find driver class: oracle.jdbc.driver.OracleDriver
WARNING WrappedNode Input 2:30:0:28: Outer workflow does not have input data, execute it first
WARNING WrappedNode Output 2:30:0:29: Outer workflow does not have input data, execute it first

Has anyone an idea?

Thx ,
Jacqueline

Hi Jacqueline,

Thanks for the question. There are a couple more steps required to setup the Oracle driver to work with the KNIME Server. You’ve already gone through most of the steps. The final steps are:

  1. Export the preferences file from the executor (here I’m assuming you’re using Windows). Launch the executor and choose File > Export Preferences.
  2. Save the file as /config/preferences.epf
  3. Restart the KNIME Server

Now test your workflow on the server and everything should work as expected.

Best,

Jon

Hi Jon,

I am so sorry… After 3 h of searching, I recognized that I saved the file in the wrong folder. :woman_facepalming:t2:

Thanks a lot!
Jacka

Hello, I have the same problem, please what’s the right location to save the oracle driver ?

You can save the driver anywhere on the KNIME Server filesystem. You need to make sure that it has the same file permissions as the rest of the KNIME Server executor installation. Then finally you need to make sure that the preferences.epf file points to the location of the drivers.

hi jonfuller,

Thanks for the advises, but I tried several times and did not solve the problem.

Following pic shows the contents of my KNIME server.

I export the “preferences.epf”, copy it to conf (configuration,config) of ‘apache-tomee-plus-7.0.5’,‘knime_executor’ and ‘workflow_repository’ respectively. Then restart the server and the problem remains.

Could you mind telling me the absolute path to save ‘preferences.epf’, emmm, I mean which dir I should choose to save ‘preferences.epf’, Thank you very much.

image

Hi @jzy,

Based on your screenshot, the preferences.epf should go in ./workflow_repository/config/. There, you should also find a preferences.epf.template, according to which you can structure your own version.

If you have already placed it there, please send the content of your preferences.epf so we can have a look (or double check with the preferences.epf.template to see where it might be wrong).

Cheers,
Roland

hi @RolandBurger

Thanks for answering the question.

OS of the server is Windows Server 2012, and I tried 2 version of KNIME servers(4.7.4,4.8.2)
preferences.epf is saved to /workflow_repository/config/client-profiles.template/windows,and i move the file into other dir as well, to solve the problem.It does not work.

Attached is the preferences.epf.Thanks in advance for your help.

#Wed Jun 12 11:55:10 CST 2019
!/=
/configuration/org.eclipse.core.net/org.eclipse.core.net.hasMigrated=true
/configuration/org.eclipse.ui.ide/MAX_RECENT_WORKSPACES=10
/configuration/org.eclipse.ui.ide/RECENT_WORKSPACES=C:\Users\iceyx\knime-workspace\n
/configuration/org.eclipse.ui.ide/RECENT_WORKSPACES_PROTOCOL=3
/configuration/org.eclipse.ui.ide/SHOW_RECENT_WORKSPACES=true
/configuration/org.eclipse.ui.ide/SHOW_WORKSPACE_SELECTION_DIALOG=true
/instance/de.mpicbg.knime.scripting.python/python.exec=C:\Python27\python2.exe
/instance/de.mpicbg.knime.scripting.python/python.plot.template.resources=(“https://raw.githubusercontent.com/knime-mpicbg/scripting-templates/master/knime-scripting-templates/Python/figure-templates.txt”,true)
/instance/de.mpicbg.knime.scripting.python/python.template.resources=(“https://raw.githubusercontent.com/knime-mpicbg/scripting-templates/master/knime-scripting-templates/Python/script-templates.txt”,true)
/instance/de.mpicbg.knime.scripting.r/template.snippets=(“https://raw.githubusercontent.com/knime-mpicbg/scripting-templates/master/knime-scripting-templates/R/snippet-templates.txt”,true)
/instance/de.mpicbg.knime.scripting.r/templates.figures=(“https://raw.githubusercontent.com/knime-mpicbg/scripting-templates/master/knime-scripting-templates/R/figure-templates.txt”,true)
/instance/org.eclipse.ant.ui/useAnnotationsPrefPage=true
/instance/org.eclipse.ant.ui/useQuickDiffPrefPage=true
/instance/org.eclipse.core.resources/version=1
/instance/org.eclipse.debug.ui/org.eclipse.debug.ui.PREF_LAUNCH_PERSPECTIVES=<?xml version\="1.0" encoding\="UTF-8" standalone\="no"?>\r\n\r\n
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.classpathVariable.ECLIPSE_HOME=C:/Program Files/KNIME/
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.classpathVariable.JRE_LIB=C:/Program Files/KNIME/jre/lib/rt.jar
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.classpathVariable.JRE_SRC=
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.classpathVariable.JRE_SRCROOT=
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.classpathVariable.JUNIT_HOME=C:/Program Files/KNIME/plugins/org.junit_4.12.0.v201504281640/
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.8
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.compiler.compliance=1.8
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.compiler.problem.assertIdentifier=error
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.compiler.problem.enumIdentifier=error
/instance/org.eclipse.jdt.core/org.eclipse.jdt.core.compiler.source=1.8
/instance/org.eclipse.jdt.launching/org.eclipse.jdt.launching.PREF_VM_XML=<?xml version\="1.0" encoding\="UTF-8" standalone\="no"?>\r\n<vmSettings defaultVM=“57,org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType13,1530971063547”>\r\n<vmType id=“org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType”>\r\n<vm id=“1530971063547” name=“KNIME” path=“C:\Program Files\KNIME”/>\r\n\r\n\r\n
/instance/org.eclipse.jdt.ui/content_assist_proposals_background=255,255,255
/instance/org.eclipse.jdt.ui/content_assist_proposals_foreground=0,0,0
/instance/org.eclipse.jdt.ui/fontPropagated=true
/instance/org.eclipse.jdt.ui/org.eclipse.jdt.ui.editor.tab.width=
/instance/org.eclipse.jdt.ui/org.eclipse.jdt.ui.formatterprofiles.version=12
/instance/org.eclipse.jdt.ui/org.eclipse.jdt.ui.javadoclocations.migrated=true
/instance/org.eclipse.jdt.ui/org.eclipse.jface.textfont=1|Courier New|10.0|0|WINDOWS|1|0|0|0|0|0|0|0|0|1|0|0|0|0|Courier New;
/instance/org.eclipse.jdt.ui/proposalOrderMigrated=true
/instance/org.eclipse.jdt.ui/spelling_locale_initialized=true
/instance/org.eclipse.jdt.ui/tabWidthPropagated=true
/instance/org.eclipse.jdt.ui/useAnnotationsPrefPage=true
/instance/org.eclipse.jdt.ui/useQuickDiffPrefPage=true
/instance/org.eclipse.pde.core/workspace_target_handle=local:1530971069885.target
/instance/org.eclipse.ui.browser/internalWebBrowserHistory=file:/C:/Users/iceyx/AppData/Local/Temp/2/intro4792946712704590049.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro3909479062220263287.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro7801695562829859521.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro8663601256907400381.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro6944935224223885287.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro6213160456132006982.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro2452271110653752351.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro5441392429182356690.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro3890996965323600656.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro9051160893199339687.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro6685430543498286455.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro7883464495448467877.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro427829594649623220.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro3513314596234531355.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro1004592540256354381.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro8037557117564335986.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro4298585259612543377.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro4728859799372649841.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro6579868695174311339.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro959817803796828910.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro5758302912170464974.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro7431097330146021633.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro8525455972439889249.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro1183824844267860911.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro9145765751950362748.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro3892216023724176892.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro1735983494841187478.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro5253860401780026383.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro8065049246707830070.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro714946898211015608.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro1378631462300654299.html||file:/C:/Users/iceyx/AppData/Local/Temp/2/intro626209460724978804.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro5821893233154289077.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro751510600056248315.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro1805429697835837291.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro7998903308901669938.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro7515069145664848345.html||file:/C:/Users/iceyx/AppData/Local/Temp/intro3430350872490952272.html||file:/C:/Users/iceyx/AppData/Local/Temp/5/intro2203163040129628918.html||file:/C:/Users/iceyx/AppData/Local/Temp/5/intro5915500890136389484.html||file:/C:/Users/iceyx/AppData/Local/Temp/5/intro1437190766962203193.html||file:/C:/Users/iceyx/AppData/Local/Temp/5/intro2756132615866486164.html||file:/C:/Users/iceyx/AppData/Local/Temp/5/intro7320722551814494661.html||file:/C:/Users/iceyx/AppData/Local/Temp/5/intro2634041003189269945.html||
/instance/org.eclipse.ui.editors/overviewRuler_migration=migrated_3.1
/instance/org.eclipse.ui.workbench//org.eclipse.ui.commands/state/org.eclipse.ui.navigator.resources.nested.changeProjectPresentation/org.eclipse.ui.commands.radioState=false
/instance/org.knime.ext.r.bin/knime.r.home=C:\Program Files\R\R-3.4.2
/instance/org.knime.ext.r.bin/knime.r.maxinbuf=0
/instance/org.knime.python2/defaultPythonOption=python3
/instance/org.knime.python2/python2Path=C:\Python27\python2.exe
/instance/org.knime.python2/python3Path=C:\Program Files\Python36\python.exe
/instance/org.knime.python2/serializerId=org.knime.serialization.flatbuffers.column
/instance/org.knime.workbench.core/database_drivers=C:\Users\iceyx\Desktop\Knime_server_0604\ojdbc6.jar
/instance/org.knime.workbench.core/knime.askedToSendStatistics=true
/instance/org.knime.workbench.core/knime.sendAnonymousStatistics=true
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/active=true
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/address=http://public-server.knime.com:80/tomee/ejb
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/defaultMountID=EXAMPLES
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/factoryID=com.knime.explorer.server.examples
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/mountID=EXAMPLES
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/mountpointNumber=1
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/restPath=/com.knime.enterprise.server/rest
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/useRest=false
/instance/org.knime.workbench.explorer.view/mountpointNode/EXAMPLES/user=knime-guest
/instance/org.knime.workbench.explorer.view/mountpointNode/LOCAL/active=true
/instance/org.knime.workbench.explorer.view/mountpointNode/LOCAL/defaultMountID=LOCAL
/instance/org.knime.workbench.explorer.view/mountpointNode/LOCAL/factoryID=org.knime.workbench.explorer.workspace
/instance/org.knime.workbench.explorer.view/mountpointNode/LOCAL/mountID=LOCAL
/instance/org.knime.workbench.explorer.view/mountpointNode/LOCAL/mountpointNumber=2
/instance/org.knime.workbench.explorer.view/mountpointNode/LOCAL/useRest=false
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/active=true
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/address=http://192.168.*.*:8080/tomee/ejb
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/factoryID=com.knime.explorer.server
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/mountID=knime-server
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/mountpointNumber=0
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/restPath=/knime/rest
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/useRest=false
/instance/org.knime.workbench.explorer.view/mountpointNode/knime-server/user=knimeadmin
/instance/org.knime.workbench.workflowcoach/community_node_triple_provider=true
@de.mpicbg.knime.scripting.python=3.3.0.v201902130805
@de.mpicbg.knime.scripting.r=3.3.0.v201902130805
@org.eclipse.ant.ui=3.7.0.v20170412-1054
@org.eclipse.core.resources=3.12.0.v20170417-1558
@org.eclipse.debug.ui=3.12.50.v20170920-1329
@org.eclipse.jdt.core=3.13.102.v20180330-0919
@org.eclipse.jdt.launching=3.9.100.v20180323-1351
@org.eclipse.jdt.ui=3.13.100.v20180330-0726
@org.eclipse.pde.core=3.11.101.v20171228-1230
@org.eclipse.ui.browser=3.6.100.v20170418-1342
@org.eclipse.ui.editors=3.11.0.v20170202-1823
@org.eclipse.ui.workbench=3.110.1.v20170704-1208
@org.knime.ext.r.bin=3.7.1.v201901281201
@org.knime.python2=3.7.2.v201904170931
@org.knime.workbench.core=3.7.1.v201901281550
@org.knime.workbench.explorer.view=8.3.2.v201904170930
@org.knime.workbench.workflowcoach=3.7.0.v201810020654
file_export_version=3.0

Hi @jzy,

The preferences.epf has to go in /workflow_repository/config/

Reading through the one you posted, there are quite a few references to local files in there, so it is very likely that this won’t work once on the server.

I recommend that, instead of using your full preferences.epf, you take the preferences.epf.template (in /workflow_repository/config/), modify it to your needs, and store it in the same location as preferences.epf.

Also note that the ojdbc6.jar absolutely has to be located on the KNIME Server machine as well.

Restarting the server should then fix this.

Cheers,
Roland