FR Report scheduling error in Workspace

By -

Recently, I encountered an error with FR while scheduling a report in workspace and thought of sharing the same with all.
Issue Description:
  • While opening the FR report in Workspace, the report appears blank even though there is no suppression applied to the grid
  • While scheduling a batch for the report/book, following error appears
; nested exception is: javax.jcr.RepositoryException: com.sqribe.transformer.AuthorizationException: com.sqribe.transformer.GetMiniContainerBySmartCutCommand.execute: Read access to "/TstBatch" is not permitted



Solution:
This error occurs when the system has been configured with external directories along with Native Directory and a user "admin" also exists in the external directory along with Native Directory. This causes the system to search for user rights for the "admin" which exist in external directory and not Native Directory.
This is due to the search order defined for the native and external directories. The Native Directory has been assigned to search in the end (or after the external directories). Since external directories are assigned precedence for search before native directory, "admin" user of external directory does not have access to internal folders of FR and prompts error.
Changing the search order in shared services resolves the issue.
  1. Login to shared services
  2. Select Administration -> Configure User Directories
  3. Reorder the directories to assign search order to Native Directory as 1
  4. Restart services
Hope this helps!!!

Comments

Post a Comment

Popular posts from this blog

Power BI + Oracle PBCS - Part 1: REST API Structure

By -
Image
“Visualization gives you answers to questions you didn’t know you had.” – Ben Schneiderman . Undoubtedly, visualization is playing a vital role in today’s corporate world. The data is no longer confined to tables or worksheets, be it a CXO or analyst, its far easy to consume information and report via pretty visuals knit together into colourful dashboards. This has lead to an upward trend of visualization tools like Oracle Analytics Cloud (OACS), Microsoft Power BI, Qlik Sense, Tableau, etc. With each product bringing its own benefits to the table, it is important for the firms to invest in the best and harness each product’s capability. PBCS might be a leading planning and budgeting SaaS application but doesn’t offer all dashboarding capabilities or the varied charts available with Power BI. Similarly, Power BI or OACS are best for dashboards not for planning and budgeting. Not all firms invest in OACS with PBCS and tend to have a heterogeneous architecture of BI products. Thu...
Read more

Unexpected Essbase error 1007083

By -
I came across this issue and thought of sharing one of the possible solutions for it. The solution of mine may not apply in all situations but you never know it may help. Before going ahead, I would just like to give a small background of the situation. I have an ASO application with 10 dimensions in Essbase version 11.1.2.0. I had a task to clean up some metadata to get rid of unwanted members and thus developed few load rules. All load rules ran well except for one which gave this error Object [outline name] is locked by user [user name] Dimension build failed. Error code [1090040]. Check the server log file and the dimension build error file for possible additional info. Unexpected Essbase error 1007083 Object [outline name] unlocked by user [user name] The log files do not provide any information about the error. Initial search on web, oracle forums, support says a lot many things. From all those sources I could get information that this error may occur due to any one ...
Read more

Groovy Series 4: Playing with cell level formatting

By -
Image
When it comes to highlighting certain data cells or making them read only, we all must have got our hands dirty with validation rules and valid intersections. Undoubtedly, they make things quite descriptive and help to control data entry when required. But at the same time, the trouble to maintain all these objects is equally troublesome. Lets consider three random scenarios which client must have proposed to highlight certain cells on a data form or make certain cells read-only If the entity is E105 and COA member is among ‘A66001’ or ‘A82580’, colour it red If the entity is E100 and COA member is A65001 , colour it green If COA member is A84001 , make the first open period of scenario as read only Considering the above requirements, if we intend to implement them, we would have to create validation rules to highlight the cells and create valid intersections to make specific cell read-only. W hat if, we have multiple calculating scenarios which run in isolation, say Plan scenario wher...
Read more