Showing posts with label CLUSTERING. Show all posts
Showing posts with label CLUSTERING. Show all posts

Monday, April 8, 2013

OBIEE 11g Scalling Vs High Availability

Scalling and High Availability go hand in hand, but they are different.

Scalling is used to achieve higher capacity of the system in terms of ability to handle more load, but it may or may not provide high availability.

High Availability on the other hand is achieved through a way of scalling out an installation.

More documentation on this topic available at following link:

http://docs.oracle.com/cd/E28280_01/bi.1111/e10541/part3.htm#BABBHIJB

Thursday, February 7, 2013

Unexplained intermittent error in OBIEE UAT server only

We made few RPD changes and code was migrated to UAT server. Intermittently, in UAT, we were getting error on report side:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27005] Unresolved column: "Dim - Derivative"."Derivative ID". (HY000)

As a work around, we would clear the cache, delete cookies, close browser completely and try again. This time error was gone. The error kept coming back next day, and we could also recreate the issue just be repeating steps for work around.

I asked admin team to look at it, and we found that this was happening due to clustered environment in UAT. Probably one of the server was still pointing to old RPD.