Error: "Failed Loading Data for Web PM Com.Primavera.Guisupport.Activities.Data.Activitiesdataloader" When Editing a Filter (Doc ID 2281833.1)

Last updated on JULY 21, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 16.2.5.0 and later
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 16.2.5.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to customize or add a new filter the P6 Web application will hang and display a blank page.


ERROR
-----------------------
EEST ACTIVE ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR /BO (User Id: 134 DB Id: 1) com.primavera.bo.remotable.RemoteRequest ?:? Failed loading data for web pm com.primavera.guisupport.activities.data.ActivitiesDataLoader
com.primavera.bo.remoting.RemoteDataException: Unable to load data for activities
at com.primavera.guisupport.activities.data.ActivitiesDataLoader.load(Unknown Source)
at com.primavera.bo.remotable.RemoteRequest.loadData(Unknown Source)
at sun.reflect.GeneratedMethodAccessor234.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.primavera.infr.q.AbstractQProxyObject.performAction(Unknown Source)
at com.primavera.infr.q.AbstractQProxyObject.execute(Unknown Source)
at com.primavera.oriweb.preshelpers.BusinessObjectServletServices.executeProxyObject(Unknown Source)
at com.primavera.pvweb.servlet.BusinessObjectServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.primavera.pvweb.HeaderInserterFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.primavera.pvweb.XSSFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.primavera.pvweb.FrontFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.primavera.pvweb.filters.ApplicationContextInjector.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)
at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
Caused by: com.primavera.bo.base.DBEngineException: DBEngine.executeSelect:

......

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1355)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1532)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:3274)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:4433)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:386)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:320)
at com.primavera.infr.db.PPreparedStatement.execute(Unknown Source)
... 19 more


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log into P6 Web
  2. Customize a filter
  3. Notice that the applications is hanging
  4. Create a new filter
  5. Notice that the filter cannot be saved


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot customize existing filters or add new filters

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms