How has this been modelled in the BMM layer? This would help if you could possibly provide a screenshot of the model and joins for the 3 facts and the dimension.

Maybe some screenshots might help to explain your scenario.

To get any help on here you should really provide as much information as possible as @Gianni Ceresa mentioned above. Is this Unix? If so, it’s very like that this is a file permission issue. Are all files owned by the oracle user? There may be some owned by the root user which normally cause this type of issue.

Do both instances have the same data volumes? It appears to be a temp space issue. Also take a look at this support document. It sounds like this is a large data extract.

This is a Database issue it would appear and something that you’d need your DBAs to look at. This looks like a SQL Server DB configuration setting - https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15

That looks like a SQL Server error. Have you tried running the SQL generated by OBIEE directly on the SQL Server database?

The 11g Agent history isn't migrated across in the 12c upgrade so you don't need this. Take a look at https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-D0867450-1AEF-43DE-8144-7816F7105CB1.htm#BIMIG-GUID-D0867450-1AE… for more information.

Which OS user are using to fire up OAS? is it the same user that was used to install OAS?

I’d start off checking file permissions to ensure that the Linux user that OAS was installed with has access to that file.

Have you looked at any log files for any clues of the error? Which version of OBIEE?

One option would be to use a UNION and have one with a 2000-2999 filter and the second with a NULL filter.

Using the rpd (repository) for your Analytics gives you many advantages because you are making use of a centralised semantic layer. You don’t need it for answers, BI publisher or Data Visualisation bit you loose the benefit of the repository’s many features. Answering your 2nd question, yes, you can use a 12c repository in…

Have you tried using a different browser other than chrome? Have you tried different dashboards and analyses? Have you looked at your JavaHost log files? Have you looked at your Presentation Services log files? Come back with some answers and you might be pointed in the right direction. There is a lot of stuff you need to…

Can you see users from both the default authenticator and the SQL authenticator in the user listing?

just to reiterate what has already been pointed out by @Gianni Ceresa and @Christian Berg, the only way that you will get any help from these forums is by providing as much information as possible. Remember that no one here has access to your systems every bit of diagnostics information helps us to understand your…

The other point worth noting is that if you’ve set up your catalog security properly then you won’t get this error. The error indicates that the user somehow has access to an area in the catalog that they shouldn’t have access to.

OPatch lsinventory should give you the definitive list a bugs fixed. If the bug is listed and still not fixed then this is something that you will need to raise with Oracle support.

To take a step back, why do you need 2 repositories in a single OBIEE instance? it is designed to work with a single repository.

As @Christian Berg mentioned, you don't apply patches unless your instance needs the patch fix. It isn't clear from your original post if you have this problem in your instance. Did you search on support.oracle.com for details of the patch?

The issue that you're describing isn't an OBIEE one as such but a Unix one. Have you tried looking at the OBIEE log files as a starting point? Just by the way, 12.2.1.3 is no longer supported and if you were to raise an SR for your issue, the 1st thing that Oracle Support will say to you is to upgrade to a supported…