OBIEE11g: Error:[nQSError: 43126] Authentication failed: invalid user/password. error when Logging into Answers/analytics

After restarting all services (Admin server, Node manager, Managed server and OPMN), users were not bale to login to Presentation Services (commonly known as answers/analysis). It was showing invalid user/password error.

Log file:  /u01/APP/OBIEE/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/nqserver.log

error: [2017-08-02T21:53:52.000+05:30] [OracleBIServerComponent] [ERROR:]1] [] [] [ecid: 0000LqZjaJG4qmmpsoL6iX1PWVhs000002,0:26:1:6] [tid: eaed6700] oracle.webservices.provider.ProviderException: java.lang.RuntimeException: oracle.bi.security.service.SecurityServiceException: SecurityService::authenticateAccess is denied for the specified credentials/identity.
[2017-08-02T21:53:52.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0000LqZjaJG4qmmpsoL6iX1PWVhs000002,0:26:1:6] [tid: eaed6700] [nQSError: 43126] Authentication failed: invalid user/password.

Root Cause: The BISystemUser account has become locked.

Solution:

  1. Log in to the WebLogic Server Administration Console.
  2. Navigate to Security Realms > myrealm > Users and Groups > Users > BISystemUser > Password
  3. Reset the password to same as of old password (i.e. you just need to reset to same password) and save.
  4. Login to Enterprise Manager.
  5. Navigate to WebLogic Domain  and right click on bifoundation_domain.
  6. Click on Security > Credentials
  7. click on oracle.bi.system and then system.user
  8. Then click on edit on top of this table and reset the password same as you set for BISystemUser in WebLogic Server Administration Console.
  9. Restart OPMN services and wait (i did so) for 10 minutes before login into Answers.
  10. It should work.

 

Thank You

Akash (@akashdgarg).

How to insert page breaks while printing OBIEE Answer’s result in PDF

Sometimes we wonder how to insert page break in PDF output of Answers. We think that there is something to do with pdf file properties or the version of pdf is not compatible with OBIEE, but you may be wrong here as it is very simple to do it from OBIEE.

In this example I will use product type for grouping for page break.

1. Let’s use Sample Sales to do this example. Create an analysis report like the following:

insert_page_break_01

2. Create either a pivot table or table. I’ll use table as an example.

insert_page_break_02

  1. When you edit the table, drag product type to Sections. Then edit Section Properties. You will be able to see the first option called Insert Page Break!

insert_page_break_03

  1. The drop down allows you to choose No Page Break, Innermost Column, Outermost Column or a specific column which in this case will only be Products.Product Type.

No Page Break literally means no page break.

Innermost Column would be the first column you have on your sections area.

Outermost Column would be the last column you have on your sections area.

Specific Column would contain all the possible columns for Page Break and you can only choose one.It does not matter which one you choose if you have only 1 column in the section area. When you have more than one, then you’ll need to give it some thought. Generally, I would choose the specific name in case I modify the sections area. If you need to combine 2 or more columns for the page break, you’ll have to concat these items in criteria before you use this feature.

insert_page_break_04

5. So this is what you will get in Answers.

insert_page_break_05

  1. Click on Print button to print PDF

insert_page_break_06

  1. You can achieve the same by exporting to PDF.

insert_page_break_07

  1. The result as follows, page break by product type in PDF!

insert_page_break_08

Keep visiting this page for more posts!

JReport – An Intuitive Reporting Interface

JReport? what is this? how to use? what it does? Is it something related to Java? Hold your thoughts for a while. After completing this blog, all of your curiosity will be vanished and you will be ignited to know more about it. You will also be able to stifle the burning flames of same curiosity of others.

JReport is basically a data visualization tool, developed by Jinfonet Software. It is also being referred  as Reporting Tool/Business Intelligence tool. JReports provide embedded reporting solutions for an Enterprise. A Good thing about JReport, It is a Java Based Platform and can be embedded into any application and delivers enterprise reports, dashboards, analysis via web and mobile devices. JReport is accessible through mobile devices with an interactive interface and user friendly GUI. JReport’s approach to design, Build and deployment simplifies the life of both developer and users.JReport Can be deployed as an embedded reporting engine in other applications, as a stand alone system, or in any public, private or hybrid cloud environment.

For Developers; JReport provides wizard based interface similar to a software installation where you just press Next and Finish button (No Jokes). Wizard will not let you skip any step in creation of a report and you will be saved from finding a root cause for not getting desired output as compared to other conventional reporting tools. (Not saying that JReport is fool proof!). JReport has In-House Report Layouts such as Banded, Table (Group Above, Group Left, Group Left Above, Summary etc.), Croostab, chart and more which makes a developer’s life easy.

In this Blog, I will discuss more about the different Components of JReport and advantages and limits of the tool.

JReport Server Live, JDashboard, JReport Mobile and JReport Designer are key components of JReport. Let’s discuss in detail about each component.

JReport Server Live is a high performance, 100% Java report server able to seamlessly integrate with any enterprise application and scale to any workload. JSL provides complete report management, distribution and administrative functionality with highest reliability. On top of its high throughput report generation, JSL also supports on-demand, live report creation and modification, providing JReport’s powerful ad-hoc reporting solution. End users are empowered with JReport to create their own visual and interactive reports for powerful and secure data exploration in a completely self-service manner. JReport Server Live also provides a full administrator user interface to schedule reports, manage servers in a clustered environment, and provide ad-hoc capabilities such as browser-based report creation.

JDashboard delivers data visualization to end users. As an extension to JReport, JDashboard displays data in interactive visual components like maps, various forms of charts, graphs, tables and live charts. JDashboard combines them with a robust set of  on-screen interactions. JDashboard is accessible on mobile devices too with the help of JReport Mobile App for any iOS device. JDashboard enables users to analyze the business trend and helps in making decision for future targets.

JReport Mobile is a native iOS reporting application that provides data visualization through touch screen interactions. It comes equipped with sample data. Users can connect to JReport server to access their own dashboards built with JDashboard. JReport Mobile lets you choose how you want to view your data. In just one touch, you can quickly switch to different chart types. Seeing data from alternate perspectives will give you a clearer picture of your information. This app can be downloaded free from Apple app store.

JReport Designer is a report design tool which facilitates report build using precise and in-built layouts, flexible output and actionable reporting without any dependency on OS or hardware configuration. JReport is the component used very frequently and most important for report developers. Developers are able to use intuitive wizards to guide them through selecting data source, creating query and designing layouts. Additionally, Designer provides CSS style support allowing CSS style sheets to be applied at run time to provide custom report formats for users.

Designer is able to use data from different data sources in the same report and almost every data source system is supported by JReport. Designer provides a fexibilty to create reports in designer and publish them to server and use by web device. JReport Designer frees developers from the need to maintain static propmt lists for each individual report. Dynamic parameters can be passed at runtime to control the result of reports.

A Powerful utility of Designer is querying, Developers can write sql query to create reports and query will be used as a source for reports. Moreover, there are no limitations on using In-Built layouts with query featured reports as like OBIEE (Oracle Business Intelligence, has limitations on using direct sql query for reports).

Next, i will briefly discuss about advantages and limits of JReports:

Open source, freeware installation, Actionable reporting, Flexible Output, Visual-Rich and Interactive dashboards, Hundreds of ready to use templates, Mobile device accessibility, CSS supported, compatibility with any data source and ability to make reports with multiple data sources in single report enables JReport stands on different position in the world of BI.

But on the other hand it has some limitations supporting Java VMs from Sun and IBM only, JReport Mobile for iOS devices only, LDAP support limitations etc. There may be some more features of JReport which I couldn’t get through but will keep posted as soon as I come across any.

I will stop here till the next time. Keep reading my blogs as I will write more in coming blogs about Architecture, Best Practices, Development experiences of JReport etc.

Please give me your feedback and comments about this blog.