i am using BO XI R 3.1. i have two nodes (lets say node 1 , node 2)attached to run my reports.
i am continuously getting error for 2-3 reports as stated when run on node 2.
Connection or SQL sentence error: (DA0005): [Exception: DBD, ORA-00904:
and if run the same report on node 1 , it runs fine. funny thing is error captured doesn’t say much and it seems that it is being reflected only half of the full error message.
BOnd007 
(BOB member since 2009-08-11)
I would do a Google search to see what the Oracle Error ORA-00904 means. This is a database error, not a BOE error, so you’ll need to look in the Oracle documentation for it. Once you have that information, you’ll know more about what the problem is and what the possible resolution is.
-Dell
hilfy 
(BOB member since 2007-04-16)
had it been database issue,these reports shouldnot be running okay at another node which is attached to this node where they fail.
BOnd007 (BOB member since 2009-08-11)
However, ORA-00904 is an ORACLE error NOT a BusinessObjects error.
Are both of your nodes running on the same server or are they on different servers? If they’re on different servers, I’d compare the TNSNames.ora files to see if there are any differences that might be causing this issue.
-Dell
hilfy (BOB member since 2007-04-16)
both are running on different server. Node 1 is at server_01 and Node 2 is at server_02.
tnsnames.ora ,i will check it.
BOnd007 (BOB member since 2009-08-11)
SAP team told us to install hotfix 1.8.it will resolve the issue.told it was bug in cluster environment
BOnd007 (BOB member since 2009-08-11)