This content has been marked as final. Show 2 replies
In your database file sqlnet.ora
look for entry
tcp.invited_nodes=(<addyourBI Box hostname>,127.0.0.1)
add your bi box hostname and then restart the tns listener or else check with your dba
if helps pls mark else update me
As it turned out there were two nodes, the second servers tnsnames was incorrect hence the issue.
Simple answer, the clue was in the Workflow logs where consistently successful jobs completed on node1 but not node2. A bit 'Doh!' but resolved.