0 Replies Latest reply on Oct 24, 2016 2:01 PM by 3283622

    Regarding EDIS Primavera issue

    3283622

      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