Four Stars

SQLBuilder doesn't working...

Enviornment : 


OS : windows server 2008 R2 Standard x64,  windows 10 x64 pro,  centos 6.5 x64


java : jdk 1.8, 17


Talend Studio : 6.2 / 6.4



I tried to open the SQLbuilder, it doesn't running, no response.


Ironically. when i run the job...  it's fine.

  Select Query(2.HISTORY_LIB_odp_link) is success, also insert/update Query is ok, and exit code is Zero.




 but SQLbuilder is doesn't pop UP!!


I think suspicious is the include of modules.

because Talend doesn't download mssql-jdbc.jar automatically. and then i go to download Microsoft. 

and put the external jar...   



I also many of DBMS(more than 7).

Despite the same enviorment, same target DBMS,

sometime SQLbuilder is doesn't work..(auto installed module by talend)  

What should I check out?



+ Additional Questions!


If I have Many Job(maybe more then 20) Talend Open Studio is too slow(somtimes TOS is shutdown!),  

(env : i5, SSD, 8GB)

Especially When Click the metadata.. It seems to be the limite base on the eclipse, but what can i do?


Thank you!!!







  • Data Integration

Re: SQLBuilder doesn't working...


Is there any message in error log(Window-->show view-->General-->error log) when the SQLbuilder doesn't run and no response? Does this issue only repro on your tMSSqlXXX Component?


Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: SQLBuilder doesn't working...

Thank you, reply


i didn't know error log ..



SQL builder error is 

Message : Unhandled event loop exception

Exception Stack Trace : 

java.lang.IllegalArgumentException: Index out of bounds
at org.eclipse.swt.SWT.error(
at org.eclipse.swt.SWT.error(
at org.eclipse.swt.SWT.error(
at org.eclipse.swt.widgets.Widget.error(
at org.eclipse.swt.widgets.Tree.getItem(
at org.talend.sqlbuilder.ui.DBStructureComposite.openNewEditor(
at org.talend.sqlbuilder.ui.SQLBuilderDialog.createDialogArea(
at org.eclipse.jface.dialogs.Dialog.createContents(
at org.eclipse.jface.window.Window.create(
at org.eclipse.jface.dialogs.Dialog.create(
at org.eclipse.swt.widgets.TypedListener.handleEvent(
at org.eclipse.swt.widgets.EventTable.sendEvent(
at org.eclipse.swt.widgets.Display.sendEvent(
at org.eclipse.swt.widgets.Widget.sendEvent(
at org.eclipse.swt.widgets.Display.runDeferredEvents(
at org.eclipse.swt.widgets.Display.readAndDispatch(
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$
at org.eclipse.core.databinding.observable.Realm.runWithDefault(
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(
at org.eclipse.ui.internal.Workbench$
at org.eclipse.core.databinding.observable.Realm.runWithDefault(
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(
at org.talend.rcp.intro.Application.start(
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.eclipse.equinox.launcher.Main.invokeFramework(
at org.eclipse.equinox.launcher.Main.basicRun(



yes, only MSsql Input component only occured.


I press "Guess Query".. but still didn't work.



Re: SQLBuilder doesn't working...


We cannot repro your issue on our end. What does your input query look like? Can you use SQL builder in a simple job? Such as, toracleinput-->tlogrow.

Did you also get some memory exception?

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.