Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Report not fetching output

Received Response
21
Views
3
Comments
User_OGKIB
User_OGKIB Rank 1 - Community Starter
edited August 2024 in Oracle Analytics Cloud and Server

I have configured a new database and a connection pool in my existing RPD and did the RPD development in all 3 layers. I can connect to the database from RPD and import data in physical layer. I can also view the data from the physical layer. But when the RPD is deployed, and I am creating a report with the column i am not getting results and it Justs executes and finally the attached message can be seen.

Analysis Error Message.png
View Data Repository.png

Please help me to resolve the issue.

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited May 2023

    Development of the RPD is done on your local PC, the OBIEE server is a different story.

    Your error is a database error: ORA-12170: TNS:Connect timeout occured at OCI Call OCIServerAttach

    Check firewalls and network connectivity between the OBIEE server and the database. And just in general make sure that the OBIEE server know how to find the database server you defined in the RPD and it can connect.

  • User_OGKIB
    User_OGKIB Rank 1 - Community Starter

    Thanks for the quick response. Just a quick question to get clarification "I am able to connect to RPD in online mode and can import the tables into RPD. Does it still can be a network and fire wall issue?"


    Thanks.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Even in online mode, by default you are checking out pieces of the RPD locally, work locally, and then checking them back in to the server. The work is still done locally and not from the OBIEE server.