How about configuring a Read-Only SQL Authentication (ReadOnlySQLAuthenticator) with Weblogic to make your database authentication as part of Fusion Middleware Security. (Version 11.1.1.7.x document link) 3.4.3 Configuring a Database as the Authentication Provider (Version 11.1.1.9.x document link) 3.4.3 Configuring a…

Your assumptions are quite right, usage tracking is a packaged functionality within OBIEE that is the reason we can leverage it by just following simple configuration steps and have no control over in what form data gets inserted into out of the box usage tracking tables, I am sure that if someone dig deep into what code…

I am pointing to the text from the document again. In WebLogic Server, you configure database connectivity by adding data sources to your WebLogic domain. WebLogic JDBC data sources provide database access and database connection management. Each data source contains a pool of database connections that are created when the…

In my understanding It is not an error please check Weblogic Product Documentation on same. Understanding JDBC Data Sources If your JDBC Data Sources would have been actually failing then there would have been error message reported for same but in your attached there are no error messgae just information on what weblogic…

Did you verify your steps as per OBIEE 12c SSL configuration document, make sure you have followed all the steps. OBIEE 12c: How To Configure SSL Including Examples (Doc ID 2188982.1) If you are on windows environment then also check if you are facing issue described in below mentioned document. OBIEE 12c: After Enabling…

Nope mine is OBIEE 12.2.1.1.0 upgrade to 12.2.1.2.0, but there was no AD configuration in prior version, I did AD configuration just as part of test for your issue and I did not face any issues as described by you I even maintained configuration as per your environment in order to replicate the issue but no success, I am…

Try below formula: CASE WHEN "Employee Personal Attributes"."Employee Birth Date" IS NULL THEN 0 ELSE CASE WHEN (MONTH("Employee Personal Attributes"."Employee Birth Date") <= MONTH(CURRENT_DATE) AND DAY("Employee Personal Attributes"."Employee Birth Date") <= DAY(CURRENT_DATE)) THEN TIMESTAMPDIFF(SQL_TSI_YEAR,"Employee…

Not able to correlate how these two functionalities are related, because as far as I know RPD deployment and Analysis 'Advanced' Tab access are not something related as 'Advanced' access is controlled by privileges defined in Administration-->Manage Privileges-->Under Permissions in Answers section-->Access Advanced Tab…

Not worked on Google Big Query in OBIEE but could see below blogs on same. https://www.cdata.com/kb/tech/bigquery-jdbc-obiee.rst https://www.cdata.com/kb/tech/bigquery-odbc-obiee.rst

I did exact test as mentioned before on OBIEE 11.1.1.7.170418(latest OBIEE 11.1.1.7.x bundle patch) and even there did not face any issue,may be you are trying something more then just passing multiple value through a presentation variable to a column on a single dashboard with a single report, because whatever testing I…

Confirm that the database server and its services are up and running and is allowing connections. If you are unsure where to look or how to check, contact your Database Administrator (DBA). Ensure the database name used in the parameter, located in odbc.ini file, is correct. Open RPD in online mode and check the…

That confirms it, that BI Server isn't able to resolve certain piece of code when trying to fetch result for report from cache hence the error(SQOIGeneratorCache), but when cache is not hit then you get your result. Now it could be of different reason for facing this issue, it can be a product bug or design issue or maybe…

Strange wasn't it throughing error in first place when you set the password less than 8 characters? As far as I remember password cannot be less than 8 characters and if entered otherwise then tool doesn't allow to proceed with installation/configuration. Anyways you have resolve the issue close the thread marking helpful…

What is your OBIEE version with complete patch level is it 10g(10.3.x)/11g(11.1.1.X.X)/12c(12.2.1.X.X)? What is the database source(Oracle, Essbase etc..) for the report which fails with mentioned error? From the error it looks to be an issue with cache(SQOIGeneratorCache), is simple report/dashboard refresh is resolving…

What is the error message logged in your install log(install2017-08-08_07-56-23AM) present at following location /proj/app/oracle/oraInventory/logs ? also post the error message logged in your biee.log present at following location /proj/app/oracle/oraInventory/logs/config2017-08-08_07-56-23AM ? Faliure step has nothing to…

odbc.ini is present under DOMAIN_HOME\config\fmwconfig\bienv\core, if after upgrade you have a new DOMAIN_HOME then yes you would need to copy odbc.ini to new location

I don't have a environment to check the same right now , but I think if RCU making use of /tmp as excution folder then it might be defined within RCU script to make use of temporray directory of the system as execution folder. Did you check the same within rcu.bat|rcu.sh file?

Looks like a bug, if you have test case then log a Service Request with Oracle with steps to replicate the issue, below Bug has already been logged but it is for Admin Tool 12.2.1.0.0 as it was with respect to RPD uploaded in BICS environment for which the only supported Admin Tool is 12.2.1.0.0 Bug 26102738 : BICS 12C…

Will test it on 11.1.1.7.160119 and let you know. Meanwhile checkout below KM document which explains on how to make use of Presentation Variable in Column formula based on Column Type OBIEE 11g: Presentation Variable With Multi Value Selected Gives 'No Results' and Wrong Query Generated. (Doc ID 1418868.1)

No external LDAP(Active Directory,Oracle Internet Directory,BISQLGroupProvider,ReadOnlySQLAuthenticator etc..) configuration comes out of the box(for an fresh install environment) you need configure the same once the software is installed and configured, the only LDAP which comes configured in Default LDAP which is…