Thanks Chris !!! Please find below screenshot, where I can query the table without error , however I can see only column names and not data. Whilst table is having data as well. Kindly help if I am missing some thing here.

Hi Gianni, Thanks for your help !!! Yes , I want to do a Direct Database Request analysis. I thought I would need a system DSN for that. Do I need to pass connection pool like below: localhost:1521/orcl Tried and got error like below: This is very first time I am using this DDR and not sure if this is the right way? Below…

Thanks Chris Not sure why I am getting this error and what should I do, may be I can try my luck by reinstalling ODBC 64 bit driver.

After spending my 1.5 days time and googling like any thing , I managed to solve this issue. Problem was : Error loading Presentation Catalog. for obips1 server. Error loading \\?\C:\obiee\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog\root.atr [IDD-GUID: ]…

Hello Experts, As per error in above post message , issue seems to be 2 libraries: * oracle.applcore.model * oracle.bi.security However both libraries are present at: C:\obiee\Oracle\Middleware\Oracle_Home\bi\bifoundation\jee\analytics.ear : Also I verified at weblogic console, all these libraries are present and active:…

In Log file I can see below error: <Aug 15, 2020 9:17:16,249 PM IST> <Warning> <J2EE> <BEA-160188> <Unresolved application library references, for application analytics.ear, defined in weblogic-application.xml: [Extension-Name: oracle.applcore.model, exact-match: false], [Extension-Name: oracle.bi.security, exact-match:…

Hi Chris, Thanks for helping. I just saw one app in deployment as an example and does not realize any issue. I am having no clue and struggling as every thing looks fine and not able to login, whilst it was perfectly fine till yesterday.

Hi Sareesh, Thanks for your reply !!! I did the same. What is surprised for me that - if I see BI servers status at EM, all is up and running: However when trying to login to Analytics page , getting below error after entering user id/pwd: Every thing was working fine and I did not change any thing from my side. Kindly…

Hi Sareesh, Thanks for help !!! By referring the link , I could see one hogging thread as below: I am not sure if this created issue and what to do . Thanks,

Thanks Gianni, Direct Database Request (DDR) is a seprate app in OBIEE and require separate cost?

Hi Sareesh, Please find below the complete screenshot: Thanks,

Thanks Gianni, Please bear with me if I have not completely understood this, for example: I added a new prompt with new column unselected and it is displaying as a separate prompt: Then I selected new column for city name prompt and dashboard visualization seems to be intact: Thanks,

Hi Sareesh, I tried as per below screenshot, I guess this way is also fine :

Thanks, I am not getting option to close this loop by marking your answer as correct. I guess some issue with thread.

Thank you, it helps !!!

Thanks Gianni, I executed below command: importarchive.cmd ssi "C:\obiee\Oracle\Middleware\Oracle_Home\bi\bifoundation\samples\sampleapplite\SampleAppLite.bar" encryptionpassword=xxxxxx it got executed successfully, however I can not see SampleAppLite subject area listed again (screenshot is attached). I guess I am missing…

Thanks Gianni, If I want to revert to previous state and want to get Sample Sales Lite subject area listed again I want to deploy the existing one. But existing one is .bar file and not .rpd file. Do I need to mention this .bar file in place of .rpd - in order to upload into server?

What I observed that once I deployed my own RPD , this Sample Sales Lite subject area got vanished:

Thank you !!! very helpful.

Thanks Saresh, it resolved the issue. Port 9514 is the default port we need to use? How you determine that? Thanks,