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 D:\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: D:\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)
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)
[10/5/16 10:43:01:735 EDT] 0000002f LoggingOutInt I Outbound Message
---------------------------
ID: 41383
Encoding: UTF-8
Content-Type: text/xml
Headers: {}
Payload: <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"></SOAP-ENV:Header><SOAP-ENV:Body xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Fault><faultcode>SOAP-ENV:Server</faultcode><faultstring>Fatal error: null</faultstring><detail><ns:IntegrationFault xmlns:ns="http://xmlns.oracle.com/Primavera/P6/V7/WS/IntegrationFaultType"><ns:ErrorType>Business Rules</ns:ErrorType><ns:ErrorCode>5000</ns:ErrorCode><ns:ErrorDescription>Fatal error: null</ns:ErrorDescription></ns:IntegrationFault></detail></SOAP-ENV:Fault></SOAP-ENV:Body></SOAP-ENV:Envelope>
--------------------------------------
Please inform me on +91-8962340398 Shubham.Gupta@nationalgrid.com