• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2116
  • Last Modified:

Crystal Report Server XI "Failed to Open Connection"

I am currently running Crystal Reports XI Developer Edition, and I have a web server that runs the crystal reports server side, and an application server that runs the crystal reports xi release 2.  Once, I log into the Central Console Manager and attempt to schedule a report for disrtubtion, I continue getting and error message that states "Failed to Open the connection to

Failed to open the connection. C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\reportjobserver\~tmp1c9861322d18570.rpt

Whcih user needs permissions to open the folder and write the temporary file?
0
nitayalevette
Asked:
nitayalevette
  • 8
  • 5
  • 4
2 Solutions
 
LinInDenverCommented:
A couple of questions:
1) Does the report run on the server (open it inside Crystal Reports on the server and test it)
2) Does the report execute when VIEWED (not scheduled) online?

It might be possible that you are missing an ODBC connection on the server used in the report.
0
 
nitayalevetteAuthor Commented:
The report does open on the server in crystal reports xi release 2.
The report does execute when viewed.

ODBC connectinos are setup and working.

Seems like the reporting server is unable to write to the directory.  Is there a certain user I should give accees too?
0
 
LinInDenverCommented:
I had a network service account created for my instance - all services run under that user, and that user is also a local admin on the server.

Is this happening on all reports, or just one? It might be worth a re-publish if it is only this report.

Also, if it is only this one report, page through to the end of it when you have it in developer. It is possible there is a formula error inside the report that you don't see since you haven't hit the page with it. When scheduling a report it basically paginates the entire document and will fail if an error occurs (this won't happen on view until you hit the page that displays the bad formula).
0
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
nitayalevetteAuthor Commented:
I have only deployed one report for testing purposes.  What local admin account runs the reports being delivered to the report server?  

How can I create a network service account to run all my instances?
0
 
LinInDenverCommented:
I believe by default the user who installed the software on the server is the account used to run services.

I asked "the network people" to create a service account - one whose password never expires/requires change.

On the server you will open your services (from inside control panel) and you can change any crystal/business objects components to run under your new service account.

Before you go to the trouble of this, maybe try paging through the report when you have it open in the viewer to make sure all pages do successfully display. If not, and a formula is causing your issue, you will get a more useful error message when paging through (will tell you the name of the formula that fails).

The service account is a good practice, and will probably make other things easier in the future (i.e.: writing to file path share destinations). However, it probably isn't causing your troubles.
0
 
nitayalevetteAuthor Commented:
I am running a simple select statement, nothing major.  The strange thing is...that I am the DBA, and I have enterprise admin credentials, and I installed the application...but I'm still unable to get this report to wrtie to the reports folder under the Program Files folder.
0
 
nitayalevetteAuthor Commented:
Also, the service is running under the local system account.
0
 
LinInDenverCommented:
this might be worth a check on SAP's forums. It could be something strange in your install - maybe they have seen the error before.

Sorry I can't help more. This is the forum link. I think you have to sign up to post, but it is free. I think you can also browse answers without being signed up.

http://forums.sdn.sap.com/index.jspa?categoryID=1


This topic here might actually solve your issue (issue with 64 bit): http://forums.sdn.sap.com/thread.jspa?messageID=8837190#8837190
0
 
mlmccCommented:
Is your Crystal XI release 1 or 2?

I believe there is an incompatiblity between CR XI R1 and BOE XI R2

mlmcc
0
 
nitayalevetteAuthor Commented:
Crystal XI Release 2; however it's running on Windows Server 2003 x64
0
 
mlmccCommented:
Are you running in 32-bit emulation mode?

Did you install the 64-bit merge modules?

mlmcc
0
 
nitayalevetteAuthor Commented:
Are you running in 32-bit emulation mode? No, not sure how to run 32 bit emulation mode

Did you install the 64-bit merge modules? No, I did not install merge modules.

If I need to install the above, will you point me in the right direction?
0
 
LinInDenverCommented:
Nita were you able to open the SAP forum article? if you are running on Server 2003 x64, it sounds like you need to do some service packs in order to handle the "()" in that file name path.
0
 
nitayalevetteAuthor Commented:
I am currently downloading the service packs.
0
 
nitayalevetteAuthor Commented:
mlmcc...I'm currently downloading the hot fixes and service packs for crystal reports server.  Are you referring to all hot fixes and service packs as the merge modules or one in particular?
0
 
mlmccCommented:
You just need the merge moduels that correspond to your SP level.

mlmcc
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 8
  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now