Category Archives: OBIEE

Invalid Username/Password for all users logging into OBIEE (#OBIEE11g)

Issue: Invalid Username/Password for all users logging into OBIEE <Jan 9, 2017 9:26:15 AM EST> <Error> <oracle.wsm.resources.security> <hostname> <bi_server2> <[ACTIVE] ExecuteThread: ’12’ for queue: ‘weblogic.kernel.Default (self-tuning)’> <<anonymous>> <> <jjskshdmdm@kl^^^hmdbnsl123> <1389277575608> <WSM-00008> <Web service authentication failed.javax.security.auth.login.LoginException: [Security:090304] Authentication Failed: User bisystemoid … Continue reading

Posted in OBIEE, WebLogic | Leave a comment

ORA-39117: Type needed to create table is not included in this operation

Issue: ORA-39117: Type needed to create table is not included in this operation. Failing sql is: CREATE TABLE “MVDEMO2″.”CITIES_US” (“LOCATION” “MDSYS”.”SDO_GEOMETRY” , “CITY” VARCHAR2(42 BYTE), “STATE_ABRV” VARCHAR2(2 BYTE), “POP90” NUMBER, “RANK90” NUMBER) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS … Continue reading

Posted in OBIEE, Oracle Database | Leave a comment

<Server subsystem failed. Reason: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 #WebLogic

Issue: While starting the Managed Server in WebLogic (SOA or OBIEE or any FMW for that matter), the Managed Server goes to “Failed Not Restart able” mode. Below is the complete error message, <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: … Continue reading

Posted in OBIEE, WebLogic | Leave a comment

Purge BIPLATFORM Schema (S_NQ_ACCT) in OBIEE Database

Purge BIPLATFORM Schema in OBIEE: Analysis: In RCU Schemas of OBIEE, DEV_BIPLATFORM schema occupies decent amount of space if Usage Tracking is enabled. And out of which, LOBSEGMENT is the Object Type which would be consuming more space than the … Continue reading

Posted in OBIEE, Oracle Database | Leave a comment