Regarding EDIS Primavera issue

3283622 · Oct 24, 2016 10:01AM

Hi All,

We need your help, About EDIS Primavera p6 application. We are getting error while run the PrimDataUpload.exe file. We are getting error like FATAL ERROR .

Issue: Whenever we try to run the Primadataupload.exe, we are getting an exception error during Login(). The error is, Fatal Error: Null.

Issue Origin: A null pointer exception occurs in the Server nyguiappt49v

Analysis: When I look into the server nyguiappt49v, I found the log file systemout.log under the path \IBM\WebSphere70\AppServer\profiles\AppSrv01\logs\server1 which contains the below log entry. From this log, we can notice that there is a java exception at com.primavera.infr.db.SQLConnectionPoolMgrImpl.g(SQLConnectionPoolMgrImpl.java:1121. We need to see why we are getting this exception error.

In the server, there are two components

1. Primavera P6 V7

2. IBM Webshere 70

The exception occurs in IBM Websphere while connecting to the primavera the database.

Action Item:

1. I am still doing my analysis with the help of google on why the Websphere component throw this error "java.lang.NullPointerException at com.primavera.infr.db.SQLConnectionPoolMgrImpl.g(SQLConnectionPoolMgrImpl.java:1121)"

2. Check with primavera support team on this issue.

Log entries:

File: \IBM\WebSphere70\AppServer\profiles\AppSrv01\logs\server1/systemout.log

[10/5/16 10:43:01:719 EDT] 0000002f JAXWSFacade I login called.

[10/5/16 10:43:01:719 EDT] 0000002f SQLConnection I com.primavera.infr.log.c info Configuring connection pool for database 1

[10/5/16 10:43:01:719 EDT] 0000002f Authenticatio E Exception caught in Authentication Provider:

com.primavera.integration.client.ClientException: Fatal error: null

at com.primavera.integration.client.Session.a(Session.java:411)

at com.primavera.integration.client.Session.login(Session.java:371)

at com.primavera.ws.jaxws.b.a(JAXWSFacade.java:161)

at com.primavera.ws.jaxws.provider.AuthenticationProviderDelegate.invoke(AuthenticationProviderDelegate.java:73)

at com.primavera.ws.jaxws.provider.AuthenticationProvider.invoke(AuthenticationProvider.java:33)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:599)

at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:166)

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:82)

at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:55)

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:68)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:57)

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

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:314)

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

at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:95)

at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:236)

at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:89)

at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:99)

at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:368)

at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:183)

at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:163)

at org.apache.cxf.transport.servlet.AbstractCXFServlet.doPost(AbstractCXFServlet.java:141)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)

at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)

at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)

at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)

at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)

at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)

at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:445)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:504)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:301)

at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:275)

at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)

at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)

at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)

at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)

at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:816)

at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1604)

Original Exception:

java.lang.NullPointerException

at com.primavera.infr.db.SQLConnectionPoolMgrImpl.g(SQLConnectionPoolMgrImpl.java:1121)

at com.primavera.infr.db.SQLConnectionPoolMgrImpl.a(SQLConnectionPoolMgrImpl.java:117)

at com.primavera.infr.db.SQLConnectionPoolMgrImpl.d(SQLConnectionPoolMgrImpl.java:784)

at com.primavera.infr.db.SQLConnectionPoolMgrImpl.getAuthenticationMode(SQLConnectionPoolMgrImpl.java:733)

at com.primavera.bre.SystemFacadeImpl.getAuthenticationMode(SystemFacadeImpl.java:171)

at com.primavera.bo.common.LoginHelper.login(LoginHelper.java:97)

at com.primavera.bo.remotable.SessionLifetime.login(SessionLifetime.java:57)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:599)

at com.primavera.infr.q.AbstractQProxyObject.performAction(AbstractQProxyObject.java:469)

at com.primavera.infr.q.nullq.NullQProxyObject.enqueue(NullQProxyObject.java:31)

at com.primavera.infr.q.AbstractQProxyObject.executeMethod(AbstractQProxyObject.java:305)

at com.primavera.bo.remotable.qproxy.SessionLifetime.login(SessionLifetime.java:84)

at com.primavera.bo.DBSessionLifetime.login(DBSessionLifetime.java:26)

at com.primavera.integration.server.ServerFacadeBase.login(ServerFacadeBase.java:397)

at com.primavera.integration.server.ServerFacade.login(ServerFacade.java:11)

at com.primavera.integration.client.LocalSession.login(LocalSession.java:92)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:45)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)

at java.lang.reflect.Method.invoke(Method.java:599)

at com.primavera.integration.client.Session.a(Session.java:383)