org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar

Six Stars

org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar

Hello Folks,

 

I am getting following error when I execute the job from Job Conductor in TAC. Its clearly mentioning the ojdbc14.jar is missing. I am not able to figure out the location where I need to place the jar files. Please advice.

 

java.lang.RuntimeException: org.talend.designer.runprocess.ProcessorException: org.talend.commons.exception.PersistenceException: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.commandline.command.ExtensionCommandSwitch.caseExtensionServerCommand(ExtensionCommandSwitch.java:191)
at org.talend.commandline.client.command.extension.AbstractExtensionCommandSwitch.doSwitch(AbstractExtensionCommandSwitch.java:31)
at org.talend.commandline.command.CommandProcessorSwitch.caseExtensionCommand(CommandProcessorSwitch.java:179)
at org.talend.commandline.client.util.CommandAbstractSwitch.doSwitch(CommandAbstractSwitch.java:70)
at org.talend.commandline.command.CommandConsumer.executeCommand(CommandConsumer.java:57)
at org.talend.commandline.command.CommandConsumer.execute(CommandConsumer.java:35)
at org.talend.commandline.mode.ServerCommandLine$CommmandConsumerRunnable.run(ServerCommandLine.java:139)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.talend.designer.runprocess.ProcessorException: org.talend.commons.exception.PersistenceException: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.commandline.util.JobHandler.export(JobHandler.java:215)
at org.talend.commandline.command.execute.BuildJobExecuteCommand.execute(BuildJobExecuteCommand.java:191)
at org.talend.commandline.command.ExtensionCommandSwitch.caseExtensionServerCommand(ExtensionCommandSwitch.java:189)
... 7 more
Caused by: org.talend.commons.exception.PersistenceException: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:252)
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:177)
at org.talend.commandline.util.JobHandler.export(JobHandler.java:204)
... 9 more
Caused by: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.designer.runprocess.java.JavaProcessorUtilities.handleMissingJarsForProcess(JavaProcessorUtilities.java:502)
at org.talend.designer.runprocess.java.JavaProcessorUtilities.sortClasspath(JavaProcessorUtilities.java:419)
at org.talend.designer.runprocess.java.JavaProcessorUtilities.computeLibrariesPath(JavaProcessorUtilities.java:323)
at org.talend.designer.runprocess.DefaultRunProcessService.updateLibraries(DefaultRunProcessService.java:352)
at org.talend.designer.runprocess.RunProcessService.updateLibraries(RunProcessService.java:203)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1067)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:904)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1578)
at org.talend.repository.ui.wizards.exportjob.handler.BuildJobHandler.generateJobFiles(BuildJobHandler.java:156)
at org.talend.repository.ui.wizards.exportjob.handler.AbstractBuildJobHandler.prepare(AbstractBuildJobHandler.java:350)
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager$1.run(BuildJobManager.java:219)
at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:246)
... 11 more

org.talend.gwtadministrator.client.module.dashboard.commandline.model.CommandLineBean.executeGroupCommand(CommandLineBean.java:286)
org.talend.administrator.scheduler.business.job.generate.JobGenerator.executeGroupCommand(JobGenerator.java:319)
org.talend.administrator.scheduler.business.job.generate.JobGenerator.generate(JobGenerator.java:151)
org.talend.administrator.scheduler.business.ExecutionTaskHandler.generateJobScriptUnit(ExecutionTaskHandler.java:491)
org.talend.administrator.scheduler.business.ExecutionTaskHandler.runTaskUnit(ExecutionTaskHandler.java:1156)
org.talend.administrator.scheduler.jobs.RemoteTaskExecution.executeRemoteJob(RemoteTaskExecution.java:476)
org.talend.administrator.scheduler.jobs.RemoteTaskExecution.execute(RemoteTaskExecution.java:248)
org.talend.administrator.scheduler.jobs.RemoteExecutionSwitcher.execute(RemoteExecutionSwitcher.java:50)
org.quartz.core.JobRunShell.run(JobRunShell.java:199)
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
Caused by: java.lang.RuntimeException: org.talend.designer.runprocess.ProcessorException: org.talend.commons.exception.PersistenceException: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.commandline.command.ExtensionCommandSwitch.caseExtensionServerCommand(ExtensionCommandSwitch.java:191)
at org.talend.commandline.client.command.extension.AbstractExtensionCommandSwitch.doSwitch(AbstractExtensionCommandSwitch.java:31)
at org.talend.commandline.command.CommandProcessorSwitch.caseExtensionCommand(CommandProcessorSwitch.java:179)
at org.talend.commandline.client.util.CommandAbstractSwitch.doSwitch(CommandAbstractSwitch.java:70)
at org.talend.commandline.command.CommandConsumer.executeCommand(CommandConsumer.java:57)
at org.talend.commandline.command.CommandConsumer.execute(CommandConsumer.java:35)
at org.talend.commandline.mode.ServerCommandLine$CommmandConsumerRunnable.run(ServerCommandLine.java:139)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.talend.designer.runprocess.ProcessorException: org.talend.commons.exception.PersistenceException: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.commandline.util.JobHandler.export(JobHandler.java:215)
at org.talend.commandline.command.execute.BuildJobExecuteCommand.execute(BuildJobExecuteCommand.java:191)
at org.talend.commandline.command.ExtensionCommandSwitch.caseExtensionServerCommand(ExtensionCommandSwitch.java:189)
... 7 more
Caused by: org.talend.commons.exception.PersistenceException: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:252)
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:177)
at org.talend.commandline.util.JobHandler.export(JobHandler.java:204)
... 9 more
Caused by: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar
at org.talend.designer.runprocess.java.JavaProcessorUtilities.handleMissingJarsForProcess(JavaProcessorUtilities.java:502)
at org.talend.designer.runprocess.java.JavaProcessorUtilities.sortClasspath(JavaProcessorUtilities.java:419)
at org.talend.designer.runprocess.java.JavaProcessorUtilities.computeLibrariesPath(JavaProcessorUtilities.java:323)
at org.talend.designer.runprocess.DefaultRunProcessService.updateLibraries(DefaultRunProcessService.java:352)
at org.talend.designer.runprocess.RunProcessService.updateLibraries(RunProcessService.java:203)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1067)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:904)
at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:1578)
at org.talend.repository.ui.wizards.exportjob.handler.BuildJobHandler.generateJobFiles(BuildJobHandler.java:156)
at org.talend.repository.ui.wizards.exportjob.handler.AbstractBuildJobHandler.prepare(AbstractBuildJobHandler.java:350)
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager$1.run(BuildJobManager.java:219)
at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)
at org.talend.repository.ui.wizards.exportjob.scriptsmanager.BuildJobManager.buildJob(BuildJobManager.java:246)
... 11 more

 Thanks in advance

Crteja

Thirteen Stars

Re: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar

Six Stars

Re: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar

Thanks for the reply Manohar,

 

Followed steps as suggested in link but no luck any other suggestions?

 

Thanks

crteja

Moderator

Re: org.talend.designer.runprocess.ProcessorException: Missing jars: ojdbc14.jar

Hello,

Could you please try these 2 possible workarounds?

#1. copy the local studio (configuration/.m2/repository/org/talend/libraries to the commandline into the directory cmdline/studio/configuration/.m2/repository/org/talend/libraries.

or

 #2.

a. Import the missing jars in talend 'Modules' view in the studio side.

b. Delete the below 2 files in cmdline/studio/configuration folder

LibrariesIndex.xml
MavenUriIndex.xml
c. Restart the commandline

Let us know if it works.

With subscription solution, it's recommended to create a case on talend support portal so that our colleagues from support team will give you a webex seesion to help you through support cycle with priority.

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.