Category Archives: OBIEE

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

Posted on July 17, 2017 by

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

Posted on July 3, 2017 by

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

Posted on May 30, 2017 by

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

Posted on May 23, 2017 by

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