topic Re: tDBBulkExec - Oracle - null pointer exception in Talend Studio

tDBBulkExec - Oracle - null pointer exception

talendtester — Sat, 16 Nov 2024 06:20:51 GMT

I have a table created in an Oracle database.

I have a delimited data file with data I have already successfully loaded into the table in the past.

I truncated the table.

I am trying to load the table using the tDBBulkExec component so all the data is loaded with a single commit.

I am using Encoding WE8ISO8859P15 which was used to create the data file I am trying to load.

Record Format Steam Record terminator "\\n"

Any ideas?

Exception in component tDBBulkExec_1 (Test_BulkLoad)
java.lang.NullPointerException

job |context|priority|type |origin |message |code|
-------------|-------|--------|--------------|-------------|-----------------------------------|----|
Test_BulkLoad|Default|6 |Java Exception|tDBBulkExec_1|java.lang.NullPointerException:null|1

Re: tDBBulkExec - Oracle - null pointer exception

akumar2301 — Wed, 13 Mar 2019 19:40:36 GMT

Do you have any column defined as not null , you might be getting null

Re: tDBBulkExec - Oracle - null pointer exception

talendtester — Wed, 13 Mar 2019 20:19:44 GMT

All the columns are VARCHAR(255) and Nullable.

Re: tDBBulkExec - Oracle - null pointer exception

akumar2301 — Wed, 13 Mar 2019 20:27:01 GMT

hmm , do you have more detail on error , looks like java error rather than database

we need to identify which line of code is giving this error ?

Re: tDBBulkExec - Oracle - null pointer exception

talendtester — Wed, 13 Mar 2019 21:29:42 GMT

The component successfully completes the Truncate table.

I looked at the code window, it doesn't point to a specific line of code.

Re: tDBBulkExec - Oracle - null pointer exception

talendtester — Wed, 13 Mar 2019 23:05:24 GMT

For this limitation, does it mean if the Oracle SQL*Plus database client is installed on the same virtual machine where Talend Studio DI is installed it will work? Or is that maybe the reason for the null pointer error?

https://help.talend.com/reader/hm5FaPiiOP31nUYHph0JwQ/OiE9c8HiCI9t0YIWF97K9w

Limitation

The database server/client must be installed on the same machine where the Studio is installed or where the Job using tOracleBulkExec is deployed, so that the component functions properly.

Re: tDBBulkExec - Oracle - null pointer exception

akumar2301 — Thu, 14 Mar 2019 10:36:10 GMT

Yes SqlPlus should be in machine of jobserver.

Can you please do a java debug of your code and check which line it is giving this error ?

Re: tDBBulkExec - Oracle - null pointer exception

talendtester — Mon, 18 Mar 2019 21:54:41 GMT

Here is the Java Debug:

Here is the warning:

Re: tDBBulkExec - Oracle - null pointer exception

talendtester — Mon, 18 Mar 2019 22:16:27 GMT

What does this mean? Is it one of those phantom errors where I need to delete folders and have the project rebuild?

org.eclipse.swt.SWTException: Failed to execute runnable (java.lang.NullPointerException)
at org.eclipse.swt.SWT.error(SWT.java:4441)
at org.eclipse.swt.SWT.error(SWT.java:4356)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:139)
at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4147)
at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3764)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)
at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)
at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)
at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)
at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)
at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)
at org.talend.rcp.intro.Application.start(Application.java:265)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)
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:380)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)
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(Main.java:648)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)
at org.eclipse.equinox.launcher.Main.run(Main.java:1465)
Caused by: java.lang.NullPointerException
at org.talend.designer.runprocess.ui.DebugProcessTosComposite$16$1.run(DebugProcessTosComposite.java:1139)
at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35)
at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:136)
... 23 more

Re: tDBBulkExec - Oracle - null pointer exception

talendtester — Mon, 18 Mar 2019 22:22:32 GMT

I found this:

This issue seems to be reproducible when an external program (e.g. MS-Word) is set as the Default Editor in Eclipse for opening *.java files.

https://github.com/EvoSuite/evosuite/issues/133