Failed to Open the Connection System.Runtime.InteropServices.COMException

[GHExplorer]

Hi,

We're trying to deploy this in Prod, and it's working everywhere else. We've tested the exact same command line in multiple environments. Can anyone offer some hints on where to look first?

When we try to generate a PDF, with a command line like

CrystalReportsNinja.exe -S SERVICE -U REPORT_USER -P REPORT_PASSWORD -F OurCrystalReport.rpt -E pdf -O OurCrystalReport -a "BEGIN_DATE:01-28-2021" -a "END_DATE:02-02-2021"

, we get an error:

Report loaded successfully
Database Login done
Failed to open the connection.connection.
OurCrystalReport 2840_1604_{C9XXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}.rpt
Inner Exception: System.Runtime.InteropServices.COMException (0x800002F4): FaileFailed to open the connection.
OurCrystalReport 2840_1604_{C9XXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}.rpt
at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)

[GHExplorer]

This might be related to the difference in odbc drivers, in Prod vs the other environments.

The other environments contain the client drivers (like Oracle in OraClient, etc..)

, whereas Prod has only a generic Microsoft ODBC driver.

Not sure yet. I'm asking someone to install the Oracle cliient drivers in Prod (I'm only allowed to copy files, but cannot update anything in Prod that hits the registry).

[mhertzfeld]

If you are able to, you may want to try my fork of the project. It has better logging, bug fixes and many more features than the original.

Please read through the documentation on the main page as there may be some differences in the parameters compared to the original version.

https://github.com/mhertzfeld/CrystalReportsNinja

[GHExplorer]

Thanks Matt, I believe that I tried your fork sometime back, when I first had problems with the Ninja executable. But there were so many issues (no, I don't recall what they were), that I went back to the original, and eventually resolved those problems. Regards, DC

…

-----------------------------------------From: "Matthew Hertzfeld" To: "rainforestnet/CrystalReportsNinja" Cc: "GHExplorer", "Author" Sent: Friday February 12 2021 12:23:48PM Subject: Re: [rainforestnet/CrystalReportsNinja] Failed to Open the Connection System.Runtime.InteropServices.COMException (#56) If you are able to, you may want to try my fork of the project. It has better logging, bug fixes and many more features than the original. Please read through the documentation on the main page as there may be some differences in the parameters compared to the original version. [1]https://github.com/mhertzfeld/CrystalReportsNinja [2] — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub [3], or unsubscribe [4]. Links: ------ [1] https://github.com/mhertzfeld/CrystalReportsNinja [2] https://github.com/mhertzfeld/CrystalReportsNinja [3] #56 (comment) [4] https://github.com/notifications/unsubscribe-auth/ABBF4DZU3QEMAOPQGUHBBPTS6VP2FANCNFSM4XQ7Y6TA

[BasisOneCO]

Hello friends,
Using CrystalReportsNinja, When we try to generate a PDF, with a command line like

CrystalReportsNinja -F C:\no_borrar\CrystalNinja1\entrega.rpt -O C:\no_borrar\CrystalNinja1\salida.pdf -E pdf -a "Dockey@:29415" -U SYSTEM -p 1234

I've got an error:

14-03-2021 19:30:31
14-03-2021 19:30:31 ================== LoadReport, Output File and DB logion ===========
14-03-2021 19:30:32 Report entrega.rpt loaded successfully
14-03-2021 19:30:32 Output Filename : C:\no_borrar\CrystalNinja1\salida.pdf
14-03-2021 19:30:32 Output Format : pdf
14-03-2021 19:30:32 Logged into  Database on  successfully with User id: SYSTEM
14-03-2021 19:30:32
14-03-2021 19:30:32 ================== ProcessParameters ===============================
14-03-2021 19:30:32 Number of Parameters detected in the report = 1
14-03-2021 19:30:32 Number of Parameters passed by the users script = 1
14-03-2021 19:30:32
14-03-2021 19:30:32 Applied Parameter 'Dockey@' as MultiValue 'False'
14-03-2021 19:30:32 Discrete Parameter : Dockey@ = 29415
14-03-2021 19:30:32 Single Value Parameter - Prompt = DocKey - Dockey@ = 29415
14-03-2021 19:30:33
14-03-2021 19:30:33
14-03-2021 19:30:33 ================== STEP = PerformOutput ============================
14-03-2021 19:30:33
14-03-2021 19:30:33 ===================Logs and Errors =================================
14-03-2021 19:30:33 Message: No se pudo abrir la conexión.
entrega 19208_53816_{0234DDB5-3B19-47EA-A89D-B6227FF6BC60}.rpt
14-03-2021 19:30:33 HResult: -2147221760
14-03-2021 19:30:33 Data: System.Collections.ListDictionaryInternal
14-03-2021 19:30:33 Inner Exception: System.Runtime.InteropServices.COMException (0x800002F4): No se pudo abrir la conexión.
entrega 19208_53816_{0234DDB5-3B19-47EA-A89D-B6227FF6BC60}.rpt
   en CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext)
   en CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
14-03-2021 19:30:33 StackTrace:    en CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception e)
   en CrystalDecisions.ReportSource.EromReportSourceBase.HandleException(Exception exception)
   en CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
   en CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
   en CrystalDecisions.CrystalReports.Engine.FormatEngine.Export(ExportRequestContext reqContext)
   en CrystalDecisions.CrystalReports.Engine.FormatEngine.Export()
   en CrystalDecisions.CrystalReports.Engine.ReportDocument.Export()
   en CrystalReportsNinja.ReportProcessor.PerformOutput()
   en CrystalReportsNinja.ReportProcessor.Run()
14-03-2021 19:30:33 ====================================================================
The database corresponds to a SAP Business One for SAP HANA system, the database route is 192.168.0.202:30015 but I tried using the ODBC DNS, parameter -S"HANA".

Please your help with some hints on how to fix it.

[mhertzfeld]

@BasisOneCO if you can I would suggest trying my fork to see if you get the same error. This RainForestNet version hasn't been updated in ages.

Most new development and bug fixes are happening in my fork, there are a few of us that are contributing to it.

The parameters may be slightly different and it may require a more recent version of the Crystal Runtimes than you may be using. Read the documentation on the main page.

If you are still having issues when using my fork, please post in the issues under my fork and we will try to help. At this point the RainForestNet version is so far behind I'm not even attempting to troubleshoot.

https://github.com/mhertzfeld/CrystalReportsNinja