need help in rectifying this error

Soumya_M — Wed, 13 Jul 2022 09:19:42 GMT

org.talend.designer.runprocess.ProcessorException: Failed to generate code.

at org.talend.designer.runprocess.java.JavaProcessor.generateCode(JavaProcessor.java:703)

at org.talend.designer.runprocess.maven.MavenJavaProcessor.generateCode(MavenJavaProcessor.java:92)

at org.talend.designer.runprocess.ProcessorUtilities.generateContextInfo(ProcessorUtilities.java:892)

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

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.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)

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

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)

Caused by: org.talend.designer.codegen.exception.CodeGeneratorException: org.eclipse.emf.codegen.jet.JETException: InvocationTargetException in job1 job

at org.talend.designer.codegen.CodeGenerator.generateComponentCode(CodeGenerator.java:875)

at org.talend.designer.codegen.CodeGenerator.generateComponentsCode(CodeGenerator.java:574)

at org.talend.designer.codegen.CodeGenerator.generatesTreeCode(CodeGenerator.java:785)

at org.talend.designer.codegen.CodeGenerator.generateComponentsCode(CodeGenerator.java:577)

at org.talend.designer.codegen.CodeGenerator.generatesTreeCode(CodeGenerator.java:785)

at org.talend.designer.codegen.CodeGenerator.generateComponentsCode(CodeGenerator.java:577)

at org.talend.designer.codegen.CodeGenerator.generateComponentsCode(CodeGenerator.java:516)

at org.talend.designer.codegen.CodeGenerator.generateProcessCode(CodeGenerator.java:233)

at org.talend.designer.runprocess.java.JavaProcessor.generateCode(JavaProcessor.java:700)

... 38 more

Caused by: org.eclipse.emf.codegen.jet.JETException: InvocationTargetException

at org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:478)

at org.talend.designer.codegen.config.TalendJetEmitter.generate(TalendJetEmitter.java:696)

at org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:450)

at org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:441)

at org.talend.designer.codegen.proxy.JetProxy.generate(JetProxy.java:54)

at org.talend.designer.codegen.CodeGenerator.generateComponentCode(CodeGenerator.java:865)

... 46 more

Caused by: java.lang.reflect.InvocationTargetException

at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:116)

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

at org.eclipse.emf.codegen.jet.JETEmitter.generate(JETEmitter.java:470)

... 51 more

Caused by: java.lang.NullPointerException: Cannot invoke "String.equals(Object)" because "dbType" is null

at org.talend.designer.codegen.translators.databases.dbspecifics.postgresql.TPostgresqlOutputMainJava$PostgreManager.generateSetStmt(TPostgresqlOutputMainJava.java:3394)

at org.talend.designer.codegen.translators.databases.dbspecifics.postgresql.TPostgresqlOutputMainJava.generate(TPostgresqlOutputMainJava.java:8128)

at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:104)

... 53 more

Re: need help in rectifying this error

gjeremy1617088143 — Wed, 13 Jul 2022 09:56:45 GMT

Hi, it's seem you have a null pointer exception :

java.lang.NullPointerException: Cannot invoke "String.equals(Object)" because "dbType" is null

(row1.dbType).equals("toto") will throw null pointer exception if row1.dbType is null you can avoid this by doing this :

"toto".equals(row1.dbType)

cause "toto" is not null

Send me love and kudos

Re: need help in rectifying this error

Soumya_M — Wed, 13 Jul 2022 10:03:21 GMT

error:

Starting job trial at 15:28 13/07/2022.

[statistics] connecting to socket on port 3546

[statistics] connected

Batch entry 66 INSERT INTO "table"."telecom" ("Country","Invoice_No","Invoice_Date","Payslips","Total_Amount","Report_Month","Processing_Cost","Recurring_Cost","One_Time_Cost","Set_up_Cost","Other_Costs","Rebate","Payslips_Count","Total_Amount1") VALUES ('Czech Republic','E67','31/1/2020','','','1/1/2020',717617.6,154830.81,0.0,0.0,154804.1,0.0,'0.00',1027252.52) was aborted: ERROR: value too long for type character varying(7) Call getNextException to see other errors in the batch.

caused by: ERROR: value too long for type character varying(7)

[statistics] disconnected

Job trial ended at 15:28 13/07/2022. [Exit code = 0]

need help!!

Re: need help in rectifying this error

gjeremy1617088143 — Wed, 13 Jul 2022 13:14:35 GMT

Hi you have a data trucation in your sql query insert into :

check the fields where you have a varchar 7 then check the output before insert if you have a value wich is longer than 7.

Re: need help in rectifying this error

Anonymous — Thu, 14 Jul 2022 03:21:20 GMT

Hello,

The error indicates that the length of input data is longer than the length of the column in DB Table.

Could you please show us the screen shot of your job and make sure your sql statement is correct?

Best regards

Sabrina

Re: need help in rectifying this error

Soumya_M — Mon, 18 Jul 2022 05:59:07 GMT

helpful, thank you 🙂

rectified it

topic Re: need help in rectifying this error in Talend Studio

need help in rectifying this error

Re: need help in rectifying this error

Re: need help in rectifying this error

Re: need help in rectifying this error

Re: need help in rectifying this error

Re: need help in rectifying this error