(Doc ID 1060852.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 to 7.3.0 [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 03-Dec-2015***


On :  7.3 version, Worksheet

When after running cleanup package (DATA_CLEANUP.CLEAN_SCHEMA_TEMPS and DATA_CLEANUP.CLEAN_LEVEL_DATA)  and bouncing OAS, when users go to a worksheets which do not have any filter and the time scale is also set to cover enough time buckets they get an error

 "ODPM-10074 You do not have proper rights to see the members of the worksheet filter".

Then when User goes to filter add a filter and select all items and locations then the data show up. So, without any filter it does not bring the data. It happens to most worksheet

Collaborator logs have the following error:

009-12-01 10:19:59,438 CST [OC4J Launcher] DEBUG appserver.system: Service Demantra Application Server/7.3.0  (351) Started.
2009-12-01 10:19:59,441 CST [OC4J Launcher] INFO  tunnel.general: ODPM-50020: Servlet context initialization in progress.
2009-12-01 10:48:36,812 CST [AJPRequestHandler-HTTPThreadGroup-5] ERROR appserver.error: ODPM-70301: Error: Can't Find Members For Filter. (Query Id: 13290, Level Id: 444)
2009-12-01 10:48:36,817 CST [AJPRequestHandler-HTTPThreadGroup-5] ERROR appserver.error:
com.demantra.applicationServer.appServerExceptions.NoFilterMembersException: ODPM-10074: You do not have proper rights to see the members of the worksheet filter.
at com.demantra.applicationServer.services.QueryDataSource.(QueryDataSource.java:143)
at com.demantra.applicationServer.services.QueryDataSource.(QueryDataSource.java:88)
at com.demantra.applicationServer.services.queryrun.QueryRunnerFactory.getCombRunner(QueryRunnerFactory.java:203)
at com.demantra.common.beans.ObjectBrowserBean.(ObjectBrowserBean.java:104)
at com.demantra.portal.beans.ObjectBrowserCache$UserCache.get(ObjectBrowserCache.java:99)
at com.demantra.portal.beans.ObjectBrowserCache$UserCache.access$100(ObjectBrowserCache.java:84)
at com.demantra.portal.beans.ObjectBrowserCache.get(ObjectBrowserCache.java:54)

The issue can be reproduced at will with the following steps:
1. run cleanup script
2. run worksheet


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