Skip to Content
0
Former Member
Nov 25, 2014 at 02:33 PM

Red Hat Ent6, Reporting and PostgreSQL

38 Views

Hi,

I'm hoping someone on here can help me with this as I've been battling for a week or so on it.

I'll list my setup as points to show the approach I've taken:

  • Installed Crystal Reports 2013 for Linux on a brand new, dedicated Red Hat Enterprise 6.5 box.
  • Installed a separate web app, running on NodeJS with a PostgreSQL 9.3 DB.
  • Created a report using Crystal Designer 2011 for Windows. Report connects to the Psql DB using available ODBC driver.
  • Created a simple JSP application (running in Tomcat 8) using the CRSDK to open a BOEnterpriseSession, a connection to a RAS server and then displaying the result as HTML

CR 2013 installed with absolutely no problems, in fact it's running very smoothly. In CMC I can see all the servers/nodes are running (Green).

I have created a DSN in Windows, and a simple report in Designer, and can connect and retrieve data from a table within the PostgreSQL DB with no problems.

Now the problem.

I used CMC to upload the report to new folder. This was fine. I can also query the Infoview and see the report data.

But if I try to query the RAS and use the viewer from within the Java application I end up with:

The viewer could not process an event. Failed to open the connection.

Failed to open the connection.

31706_89724_{C3DE8BE1-71A2-11E4-B9CC-A02BB81FC138}.rpt [CRSDK00000000]

---- Error code:0 [CRWEB00000119]

I assumed the report couldn't connect to the database for some reason so I attempted to rule this out by setting some custom connection details within the report properties in CMC. But I then get:

javax.servlet.ServletException: com.crystaldecisions.sdk.occa.managedreports.ras.internal.ManagedRASException: Cannot open report document. --- There is an error with the custom database information specified in the InfoStore. This is a configuration problem. Please contact your system administrator.

cause:com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: There is an error with the custom database information specified in the InfoStore. This is a configuration problem. Please contact your system administrator.---- Error code:-2147467259 [CRSDK00000000] Error code name:failed

detail: There is an error with the custom database information specified in the InfoStore. This is a configuration problem. Please contact your system administrator.

Infuriating 😉

I then installed unixODBC and configured a DSN with the exact name as the one found on the Windows box. Using echo "select 1" | isql -v DeployedDB I can see the DSN is fine:

+---------------------------------------+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |

+---------------------------------------+

This still makes no difference to the JSP app and still returns the error above.

Any help would be greatly appreciated. But please be aware that we HAVE to use PostgreSQL as the application our client is attempting to report on uses it.

Thanks.