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.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.