This may or may not be related (it seems to be an OBIA rpd modelling issue) https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2501389_1.html

You need to do this on your 11g catalog. Once it has been cleaned up, you can recreate the migration bar file

So have you cleaned up your catalog and regenerated your migration bar file?

You're probably better off looking at BI Publisher to achieve this. This is OOTB BI Publisher functionality rather than trying to reinvent the wheel with OBIEE delivers.

As your snippet suggests, have you looked at the log files for further details on what could be causing your issue?

This document has details of the entire 11g to 12c process including prerequisites. You also didn’t mention the exact 11g version you have. Also, which 12c version are you upgrading to?

I see. Can you try moving the ons.jar file to a different directory?

ONS is a Oracle RAC feature (https://docs.oracle.com/cd/E11882_01/java.112/e16548/apxracfan.htm#JJDBC28934 ) which is enabled by default in OBIEE for some odd reason. The workaround is to rename the ons.jar file - Oracle Support Document 2318187.1 (OBIEE 12.2.1.3 Installation Failing At Configuration Step with…

you'll need to provide further information like the 11g & 12c versions as well as what teps you've followed for your upgrade. Is it an in place upgrade?

II personally wouldn’t recommend it because it’s quite possible that you’d need the GCC compilers for patches or upgrades in the future. This user has done what you are attempting to do - OBIEE - gcc but as I said, you may need the compilers further down the line. By the way, is there any particular reason why an…

Hi, is this an OBIEE issue? This sounds like an issue from your vertica data source end if I understand your question correctly.

https://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-1221certmatrix-2739738.xlsx By the way, that is a very old version of 12c. I would highly recommend that you consider upgrading to 12.2.1.4 as the version you are on is no longer supported by Oracle.

Which version of 12c to be precise? In the latest version,12.2.1.4, this is the compatibility matrix - https://www.oracle.com/technetwork/middleware/obiee-122140-certmatrix-4472983.xlsx. Check the interop tab.

My suggestion would be to actually identify the root cause behind the obis crashes.Have you looked at what may be causing these crashes?

These document should answer your questions - https://blogs.oracle.com/cealteam/obiee-12c%3a-configuring-kerberos-sso-for-obiee-12c…

You haven’t given the full picture. Is this a fresh installation? Is it an upgrade? Is this the guide that you’ve followed? - https://docs.oracle.com/middleware/bi12214/biee/index.html

I would take the version numbers on the Admin page with a pinch of salt. This article explains the version numbers that you are seeing - https://support.oracle.com/knowledge/Enterprise%20Performance%20Management%20and%20Business%20Intelligence/2289049_1.htm… . With regards to your upgrade process, take a look at the Oracle…

What version of OBIEE? Who’s OS? What were you doing that caused this exception? Which log files have you looked at ? All the above will help the community helping you resolve this.

Which steps did you follow for this installation? Did you follow these steps? - https://docs.oracle.com/en/middleware/lifecycle/12.2.1.3/bieig/installing-and-configuring-oracle-business-intelligence.p… Also, is there any reason why you've installed 12.2.1.3? This version went out of Oracle support a few months ago.…

Does the user in the connection pool have access to the table in question? Can you connect directly to the data source and run the same query that is run in OBIEE? If you can, does it run without an error?