2062712 - Unable to connect to CR2011server

Reports throw error "Communication error occurred when trying to connect to server appsecurity.CrystalReports2011ReportApplicationServer (FWM 01009) [CRSDK00000847] ---- Error code:0 [CRWEB00000119]" when viewing in InfoView.

Business Intelligence 4.0 Server

Create a stored procedure with the following sample parameters:

create or replace procedure test_proc(

paramIn1 In char,

paramIn2 In char,

paramInOut1 In Out char

)

Note that the report based on this procedure will fail when running with the CrystalReports2011ReportApplicationServer. 

The CrystalReports2011Application Server expects reports based on Oracle stored procedures to have their input and output parameters in a particular order.

Change the procedure to read as follow: 

create or replace procedure test_proc(

paramInOut1 In Out char,

paramIn1 In char,

paramIn2 In char

 )

The above example will run to success. 

RSH , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem