Skip to Content
avatar image
Former Member

Unmanaged RAS connection error - ORACLE DB Connection error

I installed Crystal Server 2016 and Crystal Report 2016.

I tried to connect to web application which was developed with Crystal Report 9.

We are upgrading the Crystal Enterprise Server 10 to Crystal Server 2016.

When I tried to print out pdf from my web application, there is a connection error for Crystal Report Server.

Crystal Server 2016 has one named user license.

Below is the error from test of the local client computer

Can anyone help me to fix the error?

com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException Failed to load database information. Error in File order 8992_8496_{8AA8D1EF-0094-4BBF-8C79-C1365B8987B5}.rpt:

Failed to load database information.

Installation info and JSP Logic

1) Installed version Operating System : WINDOWS SERVER 2012 R2

CRYSTAL SERVER 2016 SP02 FOR WINDOWS 64B

CRYSTAL REPORT 2016 (crystal_reports_2016_sp02_51050619)

2) Central Management Console > Crystal Report Server

a. Added Command Line Parameters -loggingPath "D:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -ipport 1566 -reportdirectory C:\oaadmin\rpt

b. Enabled Guest user on BO/CMC

Central Management Console >

Guest user Access Type : choose Guaranteed - named user

3) JSP Web application setting

a. WEB-INF\lib\clientSDKOptions.xml

I changed ip:ipport.

http://www.w3.org/1999/XMLSchema-instance" version="2" xsi:type="CrystalReports.ClientSDKOptions">

<ServerInfos version="2" xsi:type="CrystalReports.ServerInfos" id="1">

<ServerInfo version="2" xsi:type="CrystalReports.ServerInfo" id="2"> <Server>54.219.167.15:1566</Server>

<Adapter>TCPIP</Adapter> </ServerInfo>

</ServerInfos>

<CORBARequestTimeout>600000</CORBARequestTimeout> </CrystalReports.ClientSDKOptions>

b. report server connection from order.jsp

<%@ page import="com.crystaldecisions.sdk.occa.report.application.*, com.crystaldecisions.sdk.occa.report.data.*, com.crystaldecisions.sdk.occa.report.lib.*, com.crystaldecisions.sdk.occa.report.exportoptions.*, com.crystaldecisions.report.web.viewer.*, com.crystaldecisions.sdk.occa.report.reportsource.IReportSource, com.crystaldecisions.sdk.occa.report.lib.ReportSDKException, com.crystaldecisions.sdk.occa.report.document.*,

java.io.*"

String reportName = "order.rpt";

String path = "";

ReportAppSession ra = new ReportAppSession(); ra.createService("com.crystaldecisions.sdk.occa.report.application.ReportClientDocument");

ra.setReportAppServer("54.219.167.15:1566");

ra.initialize(); ReportClientDocument clientDoc = new ReportClientDocument(); clientDoc.setReportAppServer(ra.getReportAppServer() );

clientDoc.open(path + reportName, OpenReportOptions._openAsReadOnly); clientDoc.getDatabaseController().logon("DBUSER","DBPW");

c. CRConfig.xml

100 jdbc:oracle:thin:@ db.c0xa6sgbfy9x.us-west-1.rds.amazonaws.com:1521 oracle.jdbc.driver.OracleDriver oaadmin

<JNDIURL></JNDIURL>

<JNDIConnectionFactory></JNDIConnectionFactory> <JNDIInitContext>/</JNDIInitContext>

<JNDIUserName></JNDIUserName>

<GenericJDBCDriver> <Default>

<ServerType>UNKNOWN</ServerType> <QuoteIdentifierOnOff>ON</QuoteIdentifierOnOff> <StoredProcType>Standard</StoredProcType>

<LogonStyle>Standard</LogonStyle> </Default>

</GenericJDBCDriver> </JDBC>

d. JSP error message

ERROR 1) below is the test error from the same server computer com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException Unable to connect to the server: 54.219.167.15. --- Connection timed out: connect

ra.initialize(); does not procceed.

returned with error message

Thank you for your help in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 06, 2017 at 06:16 PM

    The old Crystal for Enterprise and the newer Crystal Server are two completely different sets of code with different SDKs for integrating them into your application. The code and libraries that worked with Crystal 9 will not work with the newer Crystal Server.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded