topic Re: Error while running a job in Talend Studio

Error while running a job

BlueOcean_ProvePharm — Fri, 15 Nov 2024 22:15:49 GMT

Team.,

I am getting below error while running a job , could you please advise what is the issue:

!ENTRY org.talend.platform.logging 4 0 2022-12-20 02:07:43.098

!MESSAGE 2022-12-20 02:07:43,096 ERROR org.talend.commons.exception.CommonExceptionHandler - Job compile errors

At least job "TestAccountJob" has a compile errors, please fix and export again.

Error Line: 3188

Detail Message: row1 cannot be resolved to a variable

There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

!STACK 0

org.talend.designer.runprocess.ProcessorException: Job compile errors

At least job "TestAccountJob" has a compile errors, please fix and export again.

Error Line: 3188

Detail Message: row1 cannot be resolved to a variable

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:359)

at org.talend.designer.runprocess.DefaultRunProcessService.checkLastGenerationHasCompilationError(DefaultRunProcessService.java:534)

at org.talend.designer.runprocess.RunProcessService.checkLastGenerationHasCompilationError(RunProcessService.java:318)

at org.talend.designer.runprocess.ProcessorUtilities.generateBuildInfo(ProcessorUtilities.java:826)

at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:706)

at org.talend.designer.runprocess.ProcessorUtilities.generateCode(ProcessorUtilities.java:2029)

at org.talend.designer.runprocess.RunProcessContext$2.run(RunProcessContext.java:663)

at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:436)

at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:352)

at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:468)

at org.eclipse.ui.internal.progress.ProgressMonitorJobsDialog.run(ProgressMonitorJobsDialog.java:228)

at org.eclipse.ui.internal.progress.ProgressManager.run(ProgressManager.java:984)

at org.talend.designer.runprocess.RunProcessContext.exec(RunProcessContext.java:610)

at org.talend.designer.runprocess.ui.ProcessComposite.exec(ProcessComposite.java:1447)

at org.talend.designer.runprocess.ui.views.ProcessView$RunAction.run(ProcessView.java:736)

at org.talend.designer.runprocess.ui.actions.RunProcessAction.run(RunProcessAction.java:63)

at org.talend.designer.core.debug.JobLaunchConfigurationDelegate$1$1.run(JobLaunchConfigurationDelegate.java:98)

at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)

at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:185)

at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4001)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3629)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1157)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1046)

at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)

at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:644)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:338)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:551)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:156)

at org.talend.rcp.intro.Application.start(Application.java:303)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:401)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:566)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:654)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

at org.eclipse.equinox.launcher.Main.run(Main.java:1462)

at org.eclipse.equinox.launcher.Main.main(Main.java:1435)

Re: Error while running a job

Anonymous — Tue, 20 Dec 2022 08:52:03 GMT

Hello,

When you get some compile errors, could you please check your "Code" tab in your job to see if there will be your compile error highlighted in red line?

Best regards

Sabrina

Re: Error while running a job

BlueOcean_ProvePharm — Tue, 20 Dec 2022 11:28:34 GMT

@Xiaodi Shi Sabrina I don't see anything highlighted in red. But it is a line currentComponent = "tMap_2"; not sure what that means.

Re: Error while running a job

jlolling — Tue, 20 Dec 2022 19:15:37 GMT

Please show us the job design. I guess you use code and this cause problems.

Re: Error while running a job

jlolling — Tue, 20 Dec 2022 19:16:17 GMT

Please show us the design and also the Mapping of the tMap

Re: Error while running a job

BlueOcean_ProvePharm — Wed, 21 Dec 2022 05:23:24 GMT

@Jan Lolling I am not using any code the job that is erroring out was working fine previously. I just added a If - else condition to populate a column.

Re: Error while running a job

Anonymous — Wed, 21 Dec 2022 05:24:15 GMT

Hello,

We are supposing that there is an exception in the mapping of your tMap component. Please post your Mapping of the tMap screenshots here and mask your sensitive data as well.

Best regards

Sabrina

Re: Error while running a job

BlueOcean_ProvePharm — Wed, 21 Dec 2022 05:45:19 GMT

@Xiaodi Shi Sabrina ., There was a issue with my tMap component and after fixing that the job is running now. Thanks for your help.

Re: Error while running a job

Anonymous — Wed, 21 Dec 2022 06:07:55 GMT

Hello,

Great it works and feel free to let us know if there is any further help we can give.

Best regards

Sabrina

Re: Error while running a job

BlueOcean_ProvePharm — Wed, 21 Dec 2022 06:26:46 GMT

@Xiaodi Shi Thanks for your help. I have one more question. I am using a below If Else statement to populate a Multi select picklist field in Salesforce :

row4.Contract_Name=="ABC Inc"?"ABC Inc,XYZ Inc":"XYZ Inc"

However it is not updating the multi select picklist , please confirm if the syntax that I am using here is correct for : "ABC Inc,XYZ Inc"

Re: Error while running a job

Anonymous — Wed, 21 Dec 2022 08:52:41 GMT

Hello,

Usually, we don't use =="" and instead use .equals("") or .isEmpty().

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Error while running a job

BlueOcean_ProvePharm — Wed, 21 Dec 2022 09:04:11 GMT

@Xiaodi Shi I am using the syntax for if else statement based on the talend help article : https://help.talend.com/r/en-US/7.3/tmap/if-else-statement

My requirement is : I have Multi select drop down value which should be populated with two drop down values if there is an existing value , if there is no value on the field it should only populate single drop down value.

Example : On the Salesforce record which I am trying to update already has a value 'ABC Inc' I want to update the field value with multiple dropdown values 'ABC Inc' & 'XYZ Inc' , else just with 'XYZ Inc'.

I hope this helps.

Re: Error while running a job

jlolling — Wed, 21 Dec 2022 20:18:08 GMT

Picklists are semicolon separated strings. Replace , with ;

Re: Error while running a job

jlolling — Wed, 21 Dec 2022 22:49:08 GMT

== mean both values are the same Object. In some edge cases this could be the case if the values is from the same program because of the String literal cache. But it is highly unlikely.

Here the solution which works (also as picklist!)

"ABC Inc".equals(row4.Contract_Name) ? "ABC Inc;XYZ Inc" : "XYZ Inc"