Resources Assignments ‘Basic View’ Doesn’t Load Any Data. Error "AssignmentViewName: View name must be unique" in WebAccessLogs.

(Doc ID 2146951.1)

Last updated on JUNE 22, 2016

Applies to:

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

Symptoms

When attempting to show resource assignments page in basic view,
the following error occurs.

ERROR
-----------------------
Unable to load data. Unknown error, please contact your system administrator.

In WebAccessLogs, the error message below is found.

May-18-2016 04:18:31 145, UTC [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)' ERROR com.primavera.lwfsupport.assignments.AssignmentsLWFDataLoader ?:? @#$%/rest/assignments/loadGridData (User Id: 124 DB Id: 4)
com.primavera.PhoenixException: Unable to load data for activities
at com.primavera.lwfsupport.assignments.AssignmentsViewLWFDataLoader.load(Unknown Source)
at com.primavera.lwfsupport.assignments.AssignmentsLWFDataLoader.a(Unknown Source)
at com.primavera.lwfsupport.assignments.AssignmentsLWFDataLoader.load(Unknown Source)
at com.primavera.rest.service.assignments.AssignmentsServiceImpl.getAssignmentDataStore(AssignmentsServiceImpl.java:416)
at com.primavera.rest.service.assignments.AssignmentsServiceImpl.loadGridData(AssignmentsServiceImpl.java:219)
at com.primavera.rest.resources.assignments.AssignmentsResource.loadGridData(AssignmentsResource.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715)
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.github.ziplet.filter.compression.CompressingFilter.doFilter(CompressingFilter.java:300)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.primavera.pvweb.NoCacheNoStoreFilter.doFilter(Unknown Source)
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:1575)
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.BOFieldException:
Errors located:
AssignmentViewName: View name must be unique.
at com.primavera.bo.base.BOFieldException.addFieldError(Unknown Source)
at com.primavera.bo.rules.update.AbstractGanttViewPrefUE.performFieldValidationBatch(Unknown Source)
at com.primavera.bo.base.UpdateEngineImpl.performFieldValidationRow(Unknown Source)
at com.primavera.bo.base.CreateEngineImpl.create(Unknown Source)
at com.primavera.bo.base.server.ServerDAOImpl.create(Unknown Source)
at com.primavera.bo.remotable.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.remotable.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.remotable.qproxy.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.DBReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.base.client.ClientDAOImpl.createWithTransactionAndOptions(Unknown Source)
at com.primavera.bo.base.client.ClientDAOImpl.createWithOptions(Unknown Source)
at com.primavera.bo.base.client.ClientDAOImpl.create(Unknown Source)
at com.primavera.lwfsupport.assignments.AssignmentsViewLWFDataLoader.a(Unknown Source)
... 58 more
Original Exception:
com.primavera.bo.base.BOFieldException:
Errors located:
AssignmentViewName: View name must be unique.
at com.primavera.bo.base.BOFieldException.addFieldError(Unknown Source)
at com.primavera.bo.rules.update.AbstractGanttViewPrefUE.performFieldValidationBatch(Unknown Source)
at com.primavera.bo.base.UpdateEngineImpl.performFieldValidationRow(Unknown Source)
at com.primavera.bo.base.CreateEngineImpl.create(Unknown Source)
at com.primavera.bo.base.server.ServerDAOImpl.create(Unknown Source)
at com.primavera.bo.remotable.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.remotable.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.remotable.qproxy.ReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.DBReqMgr.createObjectWithWbsContext(Unknown Source)
at com.primavera.bo.base.client.ClientDAOImpl.createWithTransactionAndOptions(Unknown Source)
at com.primavera.bo.base.client.ClientDAOImpl.createWithOptions(Unknown Source)
at com.primavera.bo.base.client.ClientDAOImpl.create(Unknown Source)
at com.primavera.lwfsupport.assignments.AssignmentsViewLWFDataLoader.a(Unknown Source)
at com.primavera.lwfsupport.assignments.AssignmentsViewLWFDataLoader.load(Unknown Source)
at com.primavera.lwfsupport.assignments.AssignmentsLWFDataLoader.a(Unknown Source)
at com.primavera.lwfsupport.assignments.AssignmentsLWFDataLoader.load(Unknown Source)
at com.primavera.rest.service.assignments.AssignmentsServiceImpl.getAssignmentDataStore(AssignmentsServiceImpl.java:416)
at com.primavera.rest.service.assignments.AssignmentsServiceImpl.loadGridData(AssignmentsServiceImpl.java:219)
at com.primavera.rest.resources.assignments.AssignmentsResource.loadGridData(AssignmentsResource.java:55)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)
at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$TypeOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:185)
at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)
at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)
at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542)
at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419)
at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409)
at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540)
at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715)
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.github.ziplet.filter.compression.CompressingFilter.doFilter(CompressingFilter.java:300)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
at com.primavera.pvweb.NoCacheNoStoreFilter.doFilter(Unknown Source)
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:1575)
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)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to p6 web access.
2. Navigate to Resource assignments page.
3. Show in basic view.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot show resource assignments page in basic view.

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