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
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
<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
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