Current Position:Home > [bug] "failed to bind columns" in cr4e

[bug] "failed to bind columns" in cr4e

Update:11-30Source: network consolidation
Advertisement
(sorry, i don't know where to report this kind of bug/problem)
i am using cr4e 2.0.2. i added a table into the report. i always got "failed to bind columns" error yesterday when i tried to browsing the data in the generated report (report is generated by java code, datasource is xml).
with the same piece of code, i can successfully generate the report, browse the data with another different structure.
i ran the same piece of code this morning (computer is restarted), the error "failed to bind columns" is gone!
but:
- the table is empty when i tried to browse the data by table;
- the data is there when i tried to browse the data by column;
- the data is there when i dragged the column into the report and preview it.
what will cause this kind of weird problem? the data structure? or special character? or the cr4e is not stable? or a bug of cr4e?
thanks,

The Best Answer

Advertisement
I have a report that contains multiple regular subreports including two cross-tab subreports that get data from SQL Server stored procedures. It runs perfectly in a PowerBuilder app using RDC. I am trying to migrate it to Java using JRC (CR for Eclipse 2.0). When I run this report using JRC (CR for Eclipse 2.0), it fails with the following errors. If I delete the two cross-tab subreports, the report runs fine. Can someone decifer the error message and tell me what should be done to make the report run?
Thank you.
com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Failed to bind columns.---- Error code:-2147467259 Error code name:failed
     at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(SourceFile:237)
     at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:147)
     at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:128)
     at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(SourceFile:111)
     at com.crystaldecisions.reports.sdk.PrintOutputController.export(SourceFile:54)
     at com.wellsfargo.cts.reportWriter.impl.ReportWriterJRC.generateReport(ReportWriterJRC.java:147)
     at com.wellsfargo.cts.reportWriter.RemitRptWriter.createReport(RemitRptWriter.java:255)
     at com.wellsfargo.cts.reportWriter.RemitRptWriter.main(RemitRptWriter.java:135)
     at com.wellsfargo.cts.test.MainDriverClassTest.testRunReport(MainDriverClassTest.java:17)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:585)
     at junit.framework.TestCase.runTest(TestCase.java:164)
     at junit.framework.TestCase.runBare(TestCase.java:130)
     at junit.framework.TestResult$1.protect(TestResult.java:106)
     at junit.framework.TestResult.runProtected(TestResult.java:124)
     at junit.framework.TestResult.run(TestResult.java:109)
     at junit.framework.TestCase.run(TestCase.java:120)
     at junit.framework.TestSuite.runTest(TestSuite.java:230)
     at junit.framework.TestSuite.run(TestSuite.java:225)
     at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
     at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
     at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: com.crystaldecisions.reports.queryengine.RowsetException: Failed to bind columns.
     at com.crystaldecisions.reports.queryengine.Rowset.z9(SourceFile:1049)
     at com.crystaldecisions.reports.queryengine.Rowset.Aa(SourceFile:988)
     at com.crystaldecisions.reports.queryengine.Rowset.z3(SourceFile:967)
     at com.crystaldecisions.reports.queryengine.Rowset.bL(SourceFile:533)
     at com.crystaldecisions.reports.queryengine.Rowset.zM(SourceFile:245)
     at com.crystaldecisions.reports.queryengine.RowsetBase.zA(SourceFile:156)
     at com.crystaldecisions.reports.queryengine.QueryInfo.vE(SourceFile:261)
     at com.crystaldecisions.reports.datafoundation.DFQuery.for(SourceFile:601)
     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.dataengine.DataProcessor2.if(SourceFile:4816)
     at com.crystaldecisions.reports.dataengine.DataProcessor2.a(SourceFile:2020)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:309)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:250)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.a(SourceFile:922)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.e(SourceFile:784)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.f.e(SourceFile:383)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.u.for(SourceFile:242)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:243)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ObjectFormatter.a(SourceFile:210)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:185)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.v.a(SourceFile:230)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:511)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:452)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.a(SourceFile:369)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ah.a(SourceFile:72)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ReportColumnFormatter.a(SourceFile:86)
     at com.crystaldecisions.reports.formatter.formatter.paginator.SinglePageFormatter.a(SourceFile:332)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:359)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ai.for(SourceFile:133)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.ColumnFormatter.for(SourceFile:120)
     at com.crystaldecisions.reports.formatter.formatter.paginator.SinglePageFormatter.for(SourceFile:177)
     at com.crystaldecisions.reports.formatter.formatter.objectformatter.aa.a(SourceFile:64)
     at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.do(SourceFile:727)
     at com.crystaldecisions.reports.formatter.formatter.paginator.PageFormatter.formatPage(SourceFile:226)
     at com.crystaldecisions.reports.formatter.export2.a.a(SourceFile:96)
     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:1940)
     at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(SourceFile:657)
     at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(SourceFile:163)
     at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(SourceFile:525)
     at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(SourceFile:523)
     at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(SourceFile:102)
     at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(SourceFile:521)
     at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(SourceFile:420)
     at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(SourceFile:348)
     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.PrintOutputController.if(SourceFile:223)
     ... 26 more
Edited by: Mallik Basoor on Oct 29, 2009 8:38 PM
  • [bug] "failed to bind columns" in cr4e Update:11-30

    (sorry, i don't know where to report this kind of bug/problem) i am using cr4e 2.0.2. i added a table into the report. i always got "failed to bind columns" error yesterday when i tried to browsing the data in the generated report (report is gen

  • ReportSDKException: Failed to bind columns Update:11-30

    Hi I am getting the following exception when my SQL Function is returning more than 10 column fields. I am using the Crystal reports 2008 SP2. Java environment. com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Failed to bind columns.----

  • Unable to initialize the server: Server failed to bind to the requested por Update:10-11

    I am facing the error while starting the server. I see the following error. <Sep 26, 2007 11:49:54 PM EDT> <Emergency> <WebLogicServer> <BEA-000350> <Unable to create a server socket on Channel Default for: 162.86.20.87, port: 8

  • Bug report - OOB site column ArticleStartDate is crawled according to GMT0 not user/server timezone Update:10-11

    This issue can be reproduced easily on any SP2013 farm (on-premise) and I heard Sharepoint online do not have this problem. Issue: Site column "Article Date" with fieldname "ArticleStartDate" is crawled as GMT 0 regardless what timezon

  • Javax.naming.NameAlreadyBoundException: Failed to bind remote object Update:11-30

    I am getting an error while deploying wli-ejbs.ear file. This ear uses oracle thin drivers to connect to database. But while deploying i am receiving an error as below. Can anyone please help me to solve this problem? Deployer:149033]preparing applic

  • Fail to bind Java Short/Byte type in  Oracle Driver in WLS6.1 Update:11-30

    Hi, In Oracle, the field is defined as Number(5), but we failed to bind the Java Short/Byte object to the PreparedStatement in WLS. WLS 6.1 with SP2. Any hint here? Or other people can succeed with Oracle's own driver. I have noticed a post about WLS

  • OSD Failed to bind - Can't find failure in logs Update:11-30

    I have one model computer that is failing to bind, it pxe's, loads image & app, just not bind.  When i look at the BDD.log log I seem to have a 5 minute gap where nothing gets logged between the 'ztisetbackground' step and the 'ZTIGather' step. see b

  • ApacheJServ/1.1: Failed to bind to port(s) Update:11-30

    Hi, I'm running Oracle-HTTP-Server/1.3.28 on Red Hat Linux and JDK 1.4.2 For many months, everything was running fine. Now I get the following error message (many times) in file "jserv.log": [Note: reformatted for easier reading.] [02/08/2007 18

  • MultiServer peoplesoft PIA Domain doesnt start; failed to bind, port in use Update:11-30

    Multi Server PIA Domain does not start (failed to bind, port in use) Default (Peoplesoft) PIA multi server domain installation; After the setup we cannot start PIA and both PIA/ PIA2 cluster. One of them fails with error message about port conflict,

  • Active Directory Discovery fails to bind to OU Update:11-30

    I am continuously receiving the following error: Active Directory System Discovery Agent failed to bind to container LDAP://OU=DOMAIN CONTROLLERS,DC=MYDOMAIN,DC=COM. Error: The specified directory service attribute or value does not exist. Not sure w