Details
-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
None
-
All
-
Small
Description
Guess the schema for the Processor doesn't work when it has an additional sub job with an Input component in it.
For example we have subjob 1 and subjob 2.
When we have only subjob 1, the guess schema for Output (processor) component works well.
But when we have a subjob 2 linked to subjob 1, it fails with an error:
eclipse.buildId=unknown java.version=11.0.17 java.vendor=Amazon.com Inc. BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_US Framework arguments: -console-log Command-line arguments: -os win32 -ws win32 -arch x86_64 -console -console-log -clean org.talend.platform.logging Error Fri Feb 16 15:37:53 EET 2024 2024-02-16 15:37:53,421 ERROR org.talend.commons.exception.CommonExceptionHandler - [{"label":"NewID","nullable":true,"originalDbColumnName":"NewID","talendType":"id_Integer"},{"label":"NewObjectID","nullable":true,"originalDbColumnName":"NewObjectID","talendType":"id_String"}][FATAL] 15:37:52 local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema- tSalesforceMarketingInput_1 can't find the connection object java.lang.RuntimeException: can't find the connection object at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tSalesforceMarketingInput_1Process(Mock_job_for_Guess_schema.java:5334) [classes/:?] at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tFixedFlowInput_1Process(Mock_job_for_Guess_schema.java:1516) [classes/:?] at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.runJobInTOS(Mock_job_for_Guess_schema.java:8632) [classes/:?] at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.main(Mock_job_for_Guess_schema.java:8306) [classes/:?] Exception in component tSalesforceMarketingInput_1 (Mock_job_for_Guess_schema) java.lang.RuntimeException: can't find the connection object at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tSalesforceMarketingInput_1Process(Mock_job_for_Guess_schema.java:5334) at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tFixedFlowInput_1Process(Mock_job_for_Guess_schema.java:1516) at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.runJobInTOS(Mock_job_for_Guess_schema.java:8632) at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.main(Mock_job_for_Guess_schema.java:8306) ===== Root cause ====== java.lang.Exception: [{"label":"NewID","nullable":true,"originalDbColumnName":"NewID","talendType":"id_Integer"},{"label":"NewObjectID","nullable":true,"originalDbColumnName":"NewObjectID","talendType":"id_String"}][FATAL] 15:37:52 local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema- tSalesforceMarketingInput_1 can't find the connection object java.lang.RuntimeException: can't find the connection object at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tSalesforceMarketingInput_1Process(Mock_job_for_Guess_schema.java:5334) [classes/:?] at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tFixedFlowInput_1Process(Mock_job_for_Guess_schema.java:1516) [classes/:?] at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.runJobInTOS(Mock_job_for_Guess_schema.java:8632) [classes/:?] at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.main(Mock_job_for_Guess_schema.java:8306) [classes/:?] Exception in component tSalesforceMarketingInput_1 (Mock_job_for_Guess_schema) java.lang.RuntimeException: can't find the connection object at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tSalesforceMarketingInput_1Process(Mock_job_for_Guess_schema.java:5334) at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.tFixedFlowInput_1Process(Mock_job_for_Guess_schema.java:1516) at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.runJobInTOS(Mock_job_for_Guess_schema.java:8632) at local_project.mock_job_for_guess_schema_0_1.Mock_job_for_Guess_schema.main(Mock_job_for_Guess_schema.java:8306) ===== Root cause ====== at org.talend.sdk.component.studio.ui.guessschema.GuessSchemaSelectionAdapter.widgetSelected(GuessSchemaSelectionAdapter.java:156) at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252) at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89) at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4209) at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1043) at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4026) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3626) 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:322) 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) Caused by: java.lang.Exception at org.talend.sdk.component.studio.ui.guessschema.GuessSchemaSelectionAdapter.widgetSelected(GuessSchemaSelectionAdapter.java:152) ... 27 more
I attached the job from the screenshot there
The SFM connector that has this change you can find here:
https://qliktechnologies365.sharepoint.com/:f:/s/tdicomponent/EuTTdzjm0pxBhLx0yrI2MAkBcBCPKTASQibcee5CenSHZg?e=1oG83k
Please contact for credentials
Attachments
Issue Links
- duplicates
-
TCOMP-2710 Unable to guess schema - improve workflow and exception throwing/handling
- Done
- is related to
-
TCOMP-2710 Unable to guess schema - improve workflow and exception throwing/handling
- Done
-
TCOMP-2707 Guess schema throw exception but output correct schema
- Rejected