Error: Failed to open connection

building reports crystal reports
1

I attempted to view-on-demand and schedule a report from InfoView but received this error:

“Failed to open the connection. C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\boreport.reportjobserver~tmp____.rpt”

It’s straight against a SQL Server database (no universes). I checked the ODBC/DSN connection and it tested successfully. I also restarted the CR Report Job Server from CCM & CMC. In the CCM, the Dependency tab shows all 3 services, including RPC, as running.

I suspect this isn’t a database connection issue, but rather some kind of network/firewall problem. When I tried to Modify the report from InfoView, I get the same error, but this time it references C:\Windows\tmp{______}.rpt instead.

I’m at a lost at this point. Does anyone have other ideas on how to diagnose this issue? I’d really appreciate it!

bluesky :us: (BOB member since 2006-03-02)

2

Can you successfully run the report within the crystal developer after opening it from the Enterprise Repository? Sometimes the errors are more descriptive in the CR environment. You may also want to try to run the report within CR from your B.O. server directly…

Also, I’m sure you already do, but make sure your database settings are set up in the CMC for the report.

tamiller73 :us: (BOB member since 2005-11-18)

3

I’ve got the same problem. It runs great in the Report Designer, but it fails on the Enterprise.

Also, the Database option from the CMC, process tab is grayed out.

Anyone have any solutions? Thx

rlspill (BOB member since 2006-05-11)

4

I had the same problem, it turns out on my system it was a file replication problem. I opened up the file on the BOE server by using the file explorer search using the rpt. name in the error message and saved it back as the regular file name and then updated the db info. It then opened right up. This is a temporary work around.

We are reworking our file replication process to fix the overall problem.

rwoods (BOB member since 2005-04-28)

5

Thanks for the response. I tried renaming the file like suggested, but the problem still exists.

The CMC acts as though the report has no DATASOURCE, the DATABASE option is grayed out and unselectable.

So when the report is attempted to run via Infoview, it errors out “Failed to open connection”

The report runs fine in Crystal Reports Designer, and retrieves data from the Business View.

Any other suggestions would be greatly appreciated. Thx

rlspill (BOB member since 2006-05-11)

6

you have verified that the odbc exists on both the server and matches the one on your local machine? as well are there sql drivers on that box? MDAC?

LANFIELD :us: (BOB member since 2006-05-18)

7

As it turns out, I mistook the Server Name (in database connection) as a ‘literal’ server name. It should be whatever value used for the ODBC DSN entry. I realized this when I opened the report from a local CR client and clicked on to select/refresh the database connection. The successful testing of the ODBC connection separately didn’t reveal this discrepancy.

bluesky :us: (BOB member since 2006-03-02)

8

First sorry for my english

We have the same error in different circunstances
We have two BO servers, with the same software Business Objects XI R2
we import the files from server “A” to “B” using the import wizard, in server “A” the reports that uses universes, has no problems, but in the server B the same reports fail with this error:

“Unable to retrieve Object
Failed to open connection.XXX.rpt”

The last time that we had this error, we need to re install the software to solve, becouse we can’t find the solution.

if somebody resolve this please, tell us

Thank

Sir_Hades (BOB member since 2007-10-01)

9

sorry more details

our reports use universes
and Oracle connectios, this connections work fine in “Designer” but in the cmc preview or in the infoview fail

Sir_Hades (BOB member since 2007-10-01)

10

Hi All,
Env:BOXIR2, Oracle10g

I am also running into same error message.
Crystal reports are scheduled in infoview but its failed.
Crystal Reports are built using Stored Procedure.

Did anyone have solutions for this error.

Your help is highly appreciated.

GNK_BO (BOB member since 2007-07-17)

11

Thanks Lanfield,
This jogged something in my head to make me realise that the data source was setup on my local machine but didn’t exist on the server.

My fix was:
ON THE SERVER WHERE BUS OBJ LIVES
go into START>RUN>odbcad32
Set the data source up under system DSNs (not user DSN).
Test connection and it will hopefully be successful otherwise you may need to look into data source permissions a bit further.
Save, close.

This semed to fix my issue

Hope that helps someone.

Cheers
Elbee

elbeeuk (BOB member since 2008-11-24)

12

Elbee,

THANK YOU for this fix - this is EXACTLY what I was running into.

Everything ran correctly via CR on the server, but not via BOE. Per your advice, I just verified that while the correct User DSN was setup, there was no System DSN entry. Once I created the System DSN entry, everything worked correctly through BOE.

Thanks again!!

  • Mirán

mfernandez (BOB member since 2012-02-27)

13

Exist on the ODBC server and matching on the local machine? And that box of SQL driver?

arigatou (BOB member since 2012-03-21)