need help in rectifying this error

[Soumya_M]

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

[gjeremy1617088143]

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

[Soumya_M]

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!!

[gjeremy1617088143]

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.

[Anonymous · Accepted solution]

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

[Soumya_M]

helpful, thank you 🙂

rectified it