cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Report via SelectHR

liamhayes
Discoverer
0 Kudos

We are running Cystalreports on IIS 6.0 with SQL 2014 over TLS 1.2 and get the following error with reunning a report. The process completes and happens with delivering the report.

ErrorFailed to open the connection. Failed to open the connection. fn2zd13t.zhv 4436_2980_{2D201E19-036D-4D35-96D5-7521B7DC0EDD}.rpt
System.Runtime.InteropServices.COMException (0x80000000): No error. at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.VerifyDatabase() at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.VerifyDatabase() at CrystalDecisions.CrystalReports.Engine.ReportDocument.VerifyDatabase()

former_member27
Community Manager
Community Manager
0 Kudos

Hi liamhayes,

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

* Use the "insert code" feature when sharing your code, so members have an easier time reading.

Should you wish, you can revise your question by selecting Actions, then Edit.

Check the Welcome Corner thread with advice from our champions: https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. As it stands, I don't know if there is enough information here for members to understand your issue. So please consider revising your question because I'd really like to see you get a solution to your problem!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Regards,

Dedi

liamhayes
Discoverer
0 Kudos

Hello Dedi

Thanks for the advice. I appreciate the help.

liamhayes
Discoverer
0 Kudos

We use SelectHR web package from Access software on IIS 6.0 aspx website on Windows server 2012R2.

We use .Net 4.5 application pool for this webpage.

The database is stored on a separate Server 2012R2 running Microsoft SQL 2014. and as part of this package. We recently deprecated TLS1.0 and 1.1 and as far as I am informed this issue started with Crstal reports. However, re-enabling TLS 1.0 & 1.1 has not resolved the issue so I suspect there may be something something else going on.

I downloaded and reinstalled x68 and x64 versions of SAP runtime installers with no success.

Both versions 13.0.12.1494

I installed system dsn drivers for both OBDC x86 and x64 as shown below:

The process seems to run through all steps successfully, opens a new web page with requests for additional information. I enter it and the page looks like it is generating a report but returns the following error:

ErrorFailed to open the connection. Failed to open the connection. fn2zd13t.zhv 4436_2980_{2D201E19-036D-4D35-96D5-7521B7DC0EDD}.rpt<br>
System.Runtime.InteropServices.COMException (0x80000000): No error. at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.VerifyDatabase() at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.VerifyDatabase() at CrystalDecisions.CrystalReports.Engine.ReportDocument.VerifyDatabase()

Accepted Solutions (0)

Answers (0)