Issue when trying to build a job

One Star

Issue when trying to build a job

Hi All, 
I have an issue when I try to build a job, the error message is :
Detail Message: The method getString(int, String) in the type PreparedStatement is not applicable for the arguments (int, Date) There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio
org.talend.designer.runprocess.ProcessorException: Job compile errors
At least job "Contracts" has a compile errors, please fix and export again.
Error Line: 2151
Detail Message: The method setString(int, String) in the type PreparedStatement is not applicable for the arguments (int, Date)
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.
at org.talend.designer.runprocess.JobErrorsChecker.checkLastGenerationHasCompilationError(JobErrorsChecker.java:281)
at org.talend.designer.runprocess.JobErrorsChecker.checkExportErrors(JobErrorsChecker.java:168)
at org.talend.designer.runprocess.DefaultRunProcessService.checkExportProcess(DefaultRunProcessService.java:306)
at org.talend.designer.runprocess.RunProcessService.checkExportProcess(RunProcessService.java:243)
at org.talend.repository.ui.wizards.exportjob.action.JobExportAction.exportJobScript(JobExportAction.java:187)
at org.talend.repository.ui.wizards.exportjob.action.JobExportAction.run(JobExportAction.java:117)
at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:464)
at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:372)
at org.eclipse.jface.wizard.WizardDialog.run(WizardDialog.java:1008)
at org.talend.repository.ui.wizards.exportjob.JobScriptsExportWizardPage.finish(JobScriptsExportWizardPage.java:1408)
at org.talend.repository.ui.wizards.exportjob.JavaJobScriptsExportWSWizardPage.finish(JavaJobScriptsExportWSWizardPage.java:1649)
at org.talend.repository.ui.wizards.exportjob.JobScriptsExportWizard.performFinish(JobScriptsExportWizard.java:126)
at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:811)
at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:430)
at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:624)
May I have your help, please.
Thanks in advance.
Malek.
Seventeen Stars

Re: Issue when trying to build a job

Check if you have installed at least Java 7.
Open the studio preferences and open Java->Installed JRE and use the Add button. Choose here the home directory of your installed JRE (best choice is Java 7).
This way you prevent Talend Open Studio from self detecting and sets a valid runtime JVM which is definitely compatible.
One Star

Re: Issue when trying to build a job

Hijlolling,
Thanks for your reply, I checked the configuration and the Java 7 is already configured.

Thanks.
Malek.
One Star

Re: Issue when trying to build a job

Hi All,
Now I have this error message : Detail Message: Type mismatch: cannot convert from Character to String
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.
May I have your help, please.
Thanks,
Malek.
One Star

Re: Issue when trying to build a job

Hi All,
I found how to resolve the issue, I changed the type of a column from char to String, and now it's ok.
Thanks,
Malek.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now