Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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!!
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.
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
helpful, thank you 🙂
rectified it