Former Member

Mar 03, 2011 at 11:48 AM

Failed to bind columns - Error JRCCommunicationAdapter

196 Views

Hi All,

I have a crystal report with Command that uses a stored procedure.

Command has the script - EXECUTE [TestCrystalCastIssueSP] '{?name}','{?valueStr}',{?valueInt}

I use the below replaceConnection in the code for replacing the connections on run time for each table :

databaseController.replaceConnection(originalConnectionInfo, newConnectionInfo, fields, DBOptions._doNotVerifyDB);

All works fine.

Now I change the script in stored procedure from 'SELECT * from TestCrystalCastIssue t' to 'SELECT t.name, t.valueStr, t.valueint from TestCrystalCastIssue t' - which means selecting only few columns of the table

Execute the report from java web application but the crystal engine throws the following error.

Please assist me. Thanks.

-- start of error log --

Error com.businessobjects.reports.sdk.JRCCommunicationAdapter - detected an exception: Failed to bind columns.

at com.crystaldecisions.reports.datafoundation.DFQuery.for(SourceFile:632)

at com.crystaldecisions.reports.datalayer.a.do(SourceFile:1621)

at com.crystaldecisions.reports.datalayer.a.a(SourceFile:1404)

at com.crystaldecisions.reports.dataengine.m.b(SourceFile:334)

at com.crystaldecisions.reports.dataengine.j.b(SourceFile:515)

at com.crystaldecisions.reports.dataengine.m.o(SourceFile:408)

at com.crystaldecisions.reports.dataengine.m.a(SourceFile:173)

at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:114)

at com.crystaldecisions.reports.dataengine.ContextNode.a(SourceFile:95)

at com.crystaldecisions.reports.dataengine.j.case(SourceFile:1080)

at com.crystaldecisions.reports.dataengine.h.<init>(SourceFile:108)

at com.crystaldecisions.reports.dataengine.DataContext.a(SourceFile:254)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4660)

at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:4574)

at com.crystaldecisions.reports.dataengine.DataProcessor2.new(SourceFile:2652)

at com.crystaldecisions.reports.dataengine.DataProcessor2.byte(SourceFile:2610)

at com.crystaldecisions.reports.dataengine.DataProcessor2.try(SourceFile:2282)

at com.crystaldecisions.reports.dataengine.DataProcessor2.int(SourceFile:2442)

at com.crystaldecisions.reports.dataengine.DataProcessor2.I(SourceFile:1013)

at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.fo(SourceFile:526)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.if(SourceFile:613)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.a(SourceFile:578)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.X(SourceFile:387)

at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.moveToPageN(SourceFile:339)

at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:78)

at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:247)

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.if(SourceFile:642)

at com.crystaldecisions.reports.formatter.export2.ExportSupervisorEx.a(SourceFile:586)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(SourceFile:636)

at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(SourceFile:672)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(SourceFile:1944)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:661)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:167)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:529)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:527)

at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:525)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:424)

at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:352)

at com.businessobjects.sdk.erom.jrc.a.a(SourceFile:54)

at com.businessobjects.sdk.erom.jrc.a.execute(SourceFile:67)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(SourceFile:716)

at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(SourceFile:125)

at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(SourceFile:537)

at com.crystaldecisions.sdk.occa.report.application.ds.a(SourceFile:186)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:1558)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(SourceFile:337)

at com.crystaldecisions.sdk.occa.report.application.ReportSource.export(SourceFile:286)

at com.crystaldecisions.sdk.occa.report.application.AdvancedReportSource.export(SourceFile:209)

at com.businessobjects.report.web.event.bh.a(SourceFile:158)

at com.businessobjects.report.web.event.o.a(SourceFile:146)

at com.businessobjects.report.web.event.bw.broadcast(SourceFile:93)

at com.businessobjects.report.web.event.am.a(SourceFile:53)

at com.businessobjects.report.web.a.t.if(SourceFile:2104)

at com.businessobjects.report.web.e.a(SourceFile:300)

at com.businessobjects.report.web.e.a(SourceFile:202)

at com.businessobjects.report.web.e.a(SourceFile:135)

at com.crystaldecisions.report.web.ServerControl.a(SourceFile:607)

at com.crystaldecisions.report.web.viewer.ReportExportControl.a(SourceFile:124)

at com.crystaldecisions.report.web.ServerControl.processHttpRequest(SourceFile:342)

at MyCrystalReportServlet.renderReport(MyCrystalReportServlet.java:565).

-- end of error log --

-

start of stored procedure --

ALTER PROCEDURE [dbo].[TestCrystalCastIssueSP]

@p_name varchar(10),

@p_valueStr varchar(10),

@p_valueInt varchar(10)

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

-- Insert statements for procedure here

DECLARE @valueIntParam INT

SET @valueIntParam = cast(@p_valueInt AS INTEGER)

-- below statement causes report to fail. there are four columns in the table.

--SELECT t.name, t.valueStr, t.valueint from TestCrystalCastIssue t WHERE t.valueInt = @valueIntParam

SELECT * from TestCrystalCastIssue t WHERE t.valueInt = @valueIntParam

END

-

end of stored procedure --

Edited by: ratan korlam on Mar 3, 2011 12:52 PM