Uploaded image for project: 'Talend Component Kit'
  1. Talend Component Kit
  2. TCOMP-2629

[Studio] Guess schema for Processor doesn't work when it has additional subjob

Apply templateInsert Lucidchart DiagramXMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • None
    • schema-record, Studio

      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
       
       
       

        1. image.png
          image.png
          116 kB
        2. image-2024-02-16-15-50-11-926.png
          image-2024-02-16-15-50-11-926.png
          38 kB
        3. Mock_job_for_Guess_schema.java
          167 kB
        4. sfm_output_guess_schema_delete.zip
          32 kB
        5. sfm_output_guess_schema.zip
          45 kB

            wyuan Wei Yuan
            ozhelezniak Oleksandr Zhelezniak
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: