Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot connect to Essbase of Hyperion Planning through SmartView

1016083Jun 25 2013 — edited Jul 9 2013

Hi

I have following issue. I created a user using Hyperion Shared Services. I gave following roles to that user.

1. Server Access

2. Essbase Write Access

3. Planner

I was testing out if this user could connect to Essbase of a planning application and view data through SmartView. However, I received following error. Please help resolve. Thanks.

Cannot open cube view. Essbase Error (1054060): Essbase failed to select application because user is not completely provisioned by Planning.

After receiving above error. I tried to update security filters for that user. I went to Administration -> Manage -> Security Filters in Hyperion Shared Services. I selected a user and hit on create. I got following error message.

On checking log files at location

D:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\services

HyS9Planning-sysout.log and HyS9Planning-syserr.log

HyS9Planning-sysout.log

[Jun 25, 2013 2:57:26 PM]: Starting creation security filters for user:  for a cube: 2

[Jun 25, 2013 2:57:26 PM]: Thread  [ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)' releasing connection com.hyperion.planning.olap.HspEssConnection@317eb177

[Jun 25, 2013 2:57:26 PM]: Thread  [ACTIVE] ExecuteThread: '11' for queue: 'weblogic.kernel.Default (self-tuning)' released connection com.hyperion.planning.olap.HspEssConnection@317eb177

[Jun 25, 2013 2:57:26 PM]: Propegating external event[ FROM_ID: 183852f Class: class com.hyperion.planning.sql.HspLock Object Type: -1 Primary Key: 489921 ]

[Jun 25, 2013 2:59:07 PM]: Propegating external event[ FROM_ID: 183852f Class: class com.hyperion.planning.sql.HspActivityLease Object Type: 100 Primary Key: 3 ]

[Jun 25, 2013 2:59:07 PM]: Reaquired Reset Invalid PU Sub-states activity lease: Tue Jun 25 14:59:07 PDT 2013

[Jun 25, 2013 2:59:07 PM]: BEGIN Reset Invalid PU Sub-states activity: Tue Jun 25 14:59:07 PDT 2013

[Jun 25, 2013 2:59:07 PM]: END Reset Invalid PU Sub-states activity: Tue Jun 25 14:59:07 PDT 2013

[Jun 25, 2013 2:59:07 PM]: Propegating external event[ FROM_ID: 183852f Class: class com.hyperion.planning.sql.HspActivityLease Object Type: 100 Primary Key: 1 ]

Reaquired task list lease: Tue Jun 25 14:59:07 PDT 2013: 1372197547208

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2013
Added on Jun 25 2013
20 comments
6,242 views