I'm setting up Business Objects servers in a new network area with a firewall between the BO server and the database as well as between the BO server and the customers.
I've set this up before and had these two new servers running out of the box reports until the systems were moved to the new "secure" area.
Question: What ports are needed for Business Objects to connect to the database server? I have 1521 opened to the Oracle database and can test from Oracle Net Manager as well as in Designer. This is all setup right as it worked before as well.
The error in report history is "Failed to open the connection. ~tmp19a485a19d37d60.rpt Details: [Database Vendor Code: 12154 ]". This happens running any report, custom or OOB.
Is anyone aware of another port besides 1521 that would need to be opened to run out of the box reports? I can even run 'create BO users';