OBIEE Report not fetching output

Question

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.

Gianni Ceresa · Answer

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.

User_OGKIB · Answer

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

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.