I am facing problem publishing a crystal report with dynamic cascading prompts into the BOE repository. I have a crystal report which has state and county paramaters. I have set up dynamic cascading prompts which will show list of counties based on the selection of the state.
My report uses an ODBC connection pointing directly to the SQL Server database.
When i publish it in the BOE repository, it throws up error something like this:
List of Values failure: fail to get values. [Cause of error: createRowsets ReportSDKException(-2147482892):Failed to open the connection. Cannot open database. Failed to open the connection. C:\DOCUME~1\BUSINE~1\LOCALS~1\Temp{AC3A7DD1-F353-45B5-A540-A8832EA8C104}.rpt]
ERROR: List of Values failure: fail to get values. [Cause of error: createRowsets ReportSDKException(-2147482892):Failed to open the connection. Cannot open database. Failed to open the connection. C:\DOCUME~1\BUSINE~1\LOCALS~1\Temp{AC3A7DD1-F353-45B5-A540-A8832EA8C104}.rpt]
I did some search in this forums but didnt find a solution for this problem.
I am using BO XIR2 and CR XIR2. I hope I am clear, please let me know, if I am not and I would be more than happy to explain it all over again.
Am I missing anything. Please help !!! Any help is greatly appreciated. Thanks.
CR comes with drivers other than the ones developed by the vendor. Some can be downloaded from the SAP website as well. I was merely wondering if you could get it to work with those. Although I don’t think that’s where your problem lies. When creating a cascading prompt and exporting it to the repository the LOV will be generated by the LOV service. Actually, doing it this way is not a best practice, because cascading prompts should be created through the Business View Manager and reused in reports. It might have something to do with your LOV service not running or being enabled, or the user under which the server is running.
I did try to republish the same report today … but still getting this different error now …
CrystalReportViewer
List of Values failure: fail to get values. [Cause of error: createRowsets ReportSDKException(-2147482991):A processing limit was reached. Error in File C:\DOCUME~1\BUSINE~1\LOCALS~1\Temp{D1355097-64F4-45EC-95FA-2FDDFD6B701C}.rpt: Max processing time or Max records limit reached]
ERROR: List of Values failure: fail to get values. [Cause of error: createRowsets ReportSDKException(-2147482991):A processing limit was reached. Error in File C:\DOCUME~1\BUSINE~1\LOCALS~1\Temp{D1355097-64F4-45EC-95FA-2FDDFD6B701C}.rpt: Max processing time or Max records limit reached]
Looks like the max processing or recordset timeouts are tripping on either the Crystal Reports Server or the RAS server (don`t know your BOXI version).
Maybe you have a parameter which is loading a huuuuge list. What happens if you remove the parameters, does it then work?
I could find out the problem of the report. Let me explain from the scratch …
I have a crystal report that runs on SQL code, i.e. command. When I did build the SQL code in SQL Server 2005, then the SQL itself used to take a long time to run even for a months data as it was calling the biggest table(workorders table) (TABLE A) as a parent table and again as a child table (TABLE A alias TABLE B).
TABLE A (Parent)
CO_ID (PK)
TABLE B (Child or alias of TABLE A )
CO_ID (PK)
ParentID (FK)
TableA is called again as TableB with the following join:
select <col 1>,<col 2>, … ,
from
tablea as parent
left join tablea as child
on child.parentid=parent.co_id
Because of this join itself, it was taking a long time for the report to run. That should probably be the reason why it is not able to load the LOV for the cascading prompts.
I am not sure though. I just removed the cascading prompts and added that parameter as a normal parameter and published it again, it ran good. The user is ok without the cascading prompts also.
They just need to be able to filter on county also along with state.
Well, I will try another simple report with cascading prompts and publish it and will try to run it and see if it runs without any problems …
I hope I am clear … let me know if you have any questions with my report. Also let me know if I should know anything.
If the report is running fine in crystal and not saving in BOE Repository means, you might have versioning problem. You have to make sure the Crystal software on your computer has letest and gretest patches or upgrades.
First check with your system engineer. It is nothing do with developer.
List of values are stored in the repository. Repository should be in a position hold the list of values created by you.
hi - i know this reply is a bit late but i had the same issue a while ago and the fastest and easiest fix i came up with was to open the rpt file using Crystal Reports, verify it and all that stuff, then save-as directly to the enterprise
hope that helps
(BOB member since 2007-05-31)
(BOB member since 2006-02-08)
(BOB member since 2006-04-19)