
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
need help in rectifying this error
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
helpful, thank you 🙂
rectified it
