Can't open a connection within Enterprise

[Smithsc]

I've written a simple report from a data source (a) in Crystal reports which, when run from Crystal works perfectly. I then put the report into Business Objects enterprise and try to run it again. It fails every time with the error message:

Failed to open the connection. E:\Program Files\Business Objects\BusinessObjects Enterprise 11\Data\procSched\elsprod13.reportjobserver\~tmp19744bcaa519474b.rpt

I've tried the following to help solve the problem:

Written a different report from a different data source (b) and this works fine.
Tried running a report that was written a little while ago from data source (a) and this works fine.
Got a collegue create a report from data source (a) and put it into BO Enterprise and this fails. This was done on a different machine.

The report only returns 1 record so it's not the size of the output thats the problem.

Not sure what to try next. Please help....

 

[Turkbear]

Hi,
What database and connection type is involved?

If ODBC, be sure the same DSN exists and is accessable on the BOE server..
If File system based, be sure the page server has access to the location..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hilfy]

If you're running the report on demand in Enterprise, the page server needs access to the location for file based databases. If you're scheduling it, the job server needs the access. (We have all of our BO server services using the same user ID which is a network ID - this type of access to files out on the network doesn't work if you use the local services account!)

If your db is Oracle, the Oracle client needs to be on the BO server machine and the TNSNames.ora file needs to have an entry for your database.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.