Database Vendor Code: 904

I can run this report from CR XI but when I try to run from BO XI Enterprise I get the following error:

Failed to retrieve data from the database. Details: [Database Vendor Code: 904 ] Failed to retrieve data from the database. Error in File C:\DOCUME~1\hsg-boxi\LOCALS~1\Temp\{EE917AA0-43D7-4BC4-B56D-FF4A67207319}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 904 ]

I've changed DB drivers, and verified the DB afterwards.

I'm trying to run against an Oracle 9i DB and I'm using the ODBC (RDO) driver and I've tried the oracle driver. When changing to the oracle driver, the error message changes a little but it's essentially the same.
mbmcgraAsked:
Who is Participating?
 
wykabryanCommented:
Good point mlmcc.  If you are using Enterprise, did you set up the database portion of the CMC correctly?  Does the report run fine from the local machine?
0
 
wykabryanCommented:
Make sure that you have all the correct permission set.  This is the common problem. Are you using it through any semantic layer?
0
 
mlmccCommented:
How is database authentication done?

Does your application pass the userid and password?

mlmcc
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
mbmcgraAuthor Commented:
Yes, the report runs finr from the local machine.  CE prompts the users for logon info.  It appears to be authenticating but after ht eparameter prompts it craps out.
0
 
mbmcgraAuthor Commented:
The server admin was using the CR Oracle Driver for the DSN entry.  Changed it to Oracle's ODBC driver and changed the report driver to ODBC and worked.
0
 
mlmccCommented:
Glad i could help

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.