jdbcquery Activity java.lang.NullPointerException

[Sebastian Cieslik]

Hi everybody,

I'm getting a java.lang.NullPointerException in the JDBCQuery activity, whenrunningprocess in TEA. (Designer is working fine.)

What I did is, I copied the jdbc.jar (test with 6,7 and 8) into

[bw_home]bw6.5configdriversshellsjdbc.oracle.runtimeruntimepluginscom.tibco.bw.jdbc.datasourcefactory.oraclelib

and execute bwinstall oracle-driver

But getting this error, what is wrong and what should I do

 

THANKS and regards

Sebastian

 

Logfile:

2019-07-25 09:20:01.751 ERROR [bwEngThread:In-Memory Process Worker-6] com.tibco.bw.core -

TIBCO-BW-CORE-500050: The BW processinstance faulted,

TIBCO-BW-CORE-500051: Activity [JDBCQuery] fault.

com.tibco.bw.runtime.ActivityFault: null-

java.lang.NullPointerException

 

Catched exception:

JDBCQuerynull-{ActivityName=JDBCQuery, ProcessName=bwjdbctest.module.Process, ModuleName=BWjdbcTest.module}null-{ActivityName=JDBCQuery, ProcessName=bwjdbctest.module.Process, ModuleName=BWjdbcTest.module}com.tibco.bw.runtime.ActivityFaultActivityFaultbwjdbctest.module.Process/JDBCQuerynull-{ActivityName=JDBCQuery, ProcessName=bwjdbctest.module.Process, ModuleName=BWjdbcTest.module}

at com.tibco.bw.palette.jdbc.runtime.query.JDBCQueryRuntime.postExecute(JDBCQueryRuntime.java:369)

at com.tibco.bw.core.runtime.bx.BWBxActivityBridgeImpl.postEval(BWBxActivityBridgeImpl.java:1005)

at com.tibco.bx.core.behaviors.activity.BxExtensionBehavior.doExternal(BxExtensionBehavior.java:267)

at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.handleModelEvent(BxActivityBaseBehavior.java:1179)

at com.tibco.bx.core.behaviors.activity.BxActivityBaseBehavior.handleModelEvent(BxActivityBaseBehavior.java:1)

at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleModelEvent(IpmEventDirectorBase.java:204)

at com.tibco.pvm.infra.api.impl.util.director.IpmEventDirectorBase.handleEvent(IpmEventDirectorBase.java:111)

at com.tibco.pvm.infra.support.work.impl.WorkItemAbstract.execute(WorkItemAbstract.java:177)

at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.doWorkBlock(ImxSTWorkRunnable.java:170)

at com.tibco.pvm.infra.services.engine.impl.STWorkRunnable.run(STWorkRunnable.java:50)

at com.tibco.pvm.im.rt.xm.util.work.ImxSTWorkRunnable.run(ImxSTWorkRunnable.java:62)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.lang.NullPointerException

at com.tibco.bw.sharedresource.jdbc.runtime.connectionpool.JDBCPool.o00000(JDBCPool.java:256)

at com.tibco.bw.sharedresource.jdbc.runtime.connectionpool.JDBCPool.00000(JDBCPool.java:218)

at com.tibco.bw.sharedresource.jdbc.runtime.connectionpool.JDBCPool.getPooledConnection(JDBCPool.java:194)

at com.tibco.bw.sharedresource.jdbc.runtime.connectionpool.BWDataSource.getConnection(BWDataSource.java:147)

at com.tibco.bw.palette.jdbc.runtime.query.JDBCQueryRuntime$JDBCQueryExeutor.run(JDBCQueryRuntime.java:505)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

... 3 more

[Hitesh Nembhwani]

did the bwinstall oracle-driver execute successfully

assuming you installed the Oracle driver after the appnode/app was already running, did you restart the appnode

what is the database driver you're using in the JDBC shared resource

[Hitesh Nembhwani]

and which BW6 version are you using

[Sebastian Cieslik]

1) yes "BUILD SUCCESSFUL". (ojdbc file was also copied ...bw6.5systemlib)

 

2) yes also restarted the whole server

 

3)oracle.jdbc.OracleDriver.

 

Many thanks in advance!

[Sebastian Cieslik]

6.5.0

 

Many thanks!

[Rufina Scott]

The following cases throw that exception:

 

Invoking a method from a null object.

Accessing or modifying a null objects field.

Taking the length of null, as if it were an array.

Accessing or modifying the slots of null object, as if it were an array.

Throwing null, as if it were a Throwable value.

When you try to synchronize over a null object.

[Sebastian Cieslik]

Hi,my question is: why is the workflow in BW Designer (debug mode) working perfectly and in TEA notHow should I identify this "null object"

For me it looks like a config problem in TEA.

I can't really debug it, because it's working fine in BW desginer.ThanksSebastian

[Sebastian Cieslik]

Created a new AppSpace, AppNode and deployed the App into it - and it's working. strange