If I remember correctly, this error is related to security settings. Check if this user has at least Traverse rights on every folder in the report path: /shared, Finance Division, Temp folder and so on. And consider upgrading to a newer version. 11.1.1.6 got the last patch two or three years ago.

This looks very similar to the note 2174849.1 for me.

Pretty typical questions: was it ever working before? What been changed since it was working for the last time?

Just a thought. SA406 is an old VM, released about three years ago and running on Oracle Linux 6.5 with I don't know which JDK version (but most likely 1.6_something). OBIEE 12.2.1.0.0 is certified with Oracle Linux 6.6 and JDK 1.8.0_51+ (release date July 14, 2015). Are you sure the process was absolutely flawless and…

Christian is right. It's my fault I didn't notice you are on 12c not 11g.

The idea of my I-have-no-clue-why-deleted post was not "Passing an exam doesn't make you an expert". Long story short: the test is relatively easy for anyone professionally working with OBIEE. But if the topic starter does not work with OBIEE (the statement I obviously don't make), I'd recommend spending time on mastering…

I know it isn't a scientific method, but I prefer to get an error and after that search for a *.log changed in the last 5 minutes. So I can be sure I'm not missing something important. But you can start with logs from $ORACLE_HOME/user_projects/domains/bi/servers/obis1/logs directory.

I'm not saying it's your case, but as an example: if a user can't execute a mandatory init block during log in, he gets an error for /analytics but can connect easily to /em and /console. This kind of errors typically may be solved by inspecting log files.

Things really rarely happen by itself. If your system was working yesterday and is not working today, it typically means that something has changed. What have you done to your system since it was working? Are all components up and running? Are there any errors in log files? PS. I'm not your boss to blame you, so the more…

1. AFAIR when init block fails info about it is written into nqserver.log, not nqquery.log. 2. What database do you use? After resolving this variable issue you may encounter a new one: limitation for a number of elements in "in" operator. For Oracle DB the limit is 1K and that is significantly lower than your 7K.

This tutorial covers only a half or less of OBIEE security concept. OBIEE itself works with application roles, not LDAP groups. And have in mind that security is not something you do with a hit and miss approach following different how-tos from the internet: 1 Introduction to Security in Oracle Business Intelligence

The solution from this note works well. All you need to do is to copy files mentioned from a server to a client.

Yes, you understand it right. This script allows you to upload and download rpd file to and from a remote server. In that case, you should specify the server by passing its hostname and port.

Yes, of course, +1 to Michael Verzijl and rmoff. UT data is very useful, it is a good idea to keep it. My answer was about "why data from s_nq_err_msg disappears automatically after 7 days".

I believe this doc will help you with S_NQ_ERR_MSG table (PurgeInstDays parameter): https://docs.oracle.com/middleware/11119/biee/BIESG/deliversconfigset.htm#i1032471 Not sure that the same exists for S_NQ_ACCT.

Unfortunately, I don't have a system to potentially sacrifice during the experiment, but as a guess: browser cache.

As a result, you are supposed to get either rpd file or an error message. And because you say that you have no rpd, I guess you have some error message to share.

Eldar Ametov wrote:Often in real life, users would like to export the records and use elsewhere, and OBI Dev can't force them to change their will. In such cases Devs can his(her) best and provide users with most effective way of work with big umber of records still staying in OBI infrastructure. Very often users ask not…

Default maximum records count is 65K after aggregation. But a few other limitations exist, like a number of cells in a pivot table for example. And +1 to Christian. 20K is too much. As a rule of thumb, I typically use the following consideration: if a human can read and understand a data in a report it is possible OK. If a…

Yes, it's normal that instanceconfig.xml doesn't have some tags. You just add them manually. But! This error " "Exceeded configured maximum number of output records, prompts" connected with this "We are using OBIEE 12.2.1.0.0 and just started created some analysis" is a clear signal that you are possibly doing something…