on 04-07-2017 3:37 PM
Searching the forum I haven't been able to get an answer and my apologies if there were to be an oversight from my side.I am very new to the crystal report environment
Environment :Crystal report server 2013 sp2 and crystal reports 2013 sp2
CMS db on sql server:
All installed in one server.
I have two issues: I created a report based on command with three parameters,it runs fine in the designer.when I deployed it using the CMS and in the report properties I made the param property as prompt user to pick and cleared the default values.The report fails to run with an error insufficient values.I do the same thing in Cr11 and have no issues.I read that since the Params are in the command they can't be made optional.so how can I manage running this report through bi launch pad.
Issue 2:in the cms monitoring services dashboard my report processing services always has the red warning services and the application log file and events viewer say that there is a database deadlock.
I created both 32 and 64 odbc connections to the cms and audit db but it still persists.
Thanks so much for taking your time to read.
Regards
Thanks Denis for your reply, I sent an earlier reply and am not sure why it is not showing up, may because I attached a image?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I want to share with the community how I resolved the above issue. Upgraded the Crysta lReports server from sp2 to sp9
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Very much Dell for your reply.
I don't have dynamic parameters. The report is based on Command and there are three parameters within the command.
I set it up in CMC for user to prompt and removed the default values.I also pass the DB access credentials and have checked for the report to use the DB credentials while viewing or scheduling reports.
my CrystalReports2013ReportApplicationServer(in its name it has 2013) is running and the health indicator is green
I have two CrystalReportProcessingServer running-CrystalReports2013ProcessingServer which is running but the health indicator is red as i had mentioned it turns red only after the report fails to process
I also have CrystalReportsProcessingServer enabled and running for which the health indicator is green.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
How did you configure the dynamic parameter? Did you set it up correctly in the Business View Manager? Also, do you have a running Crystal Report Application Server (RAS)? The RAS handles the LOV for the dynamic parameter and is 32-bit.
Also, you only need the 32-bit connections on the server for running "classic" Crystal reports, which will be run on the Crystal Reports 2013 Processing Server. The "Crystal Processing Server" that doesn't have "2013" in the name is 64-bit, but it is used only for running Crystal for Enterprise reports.
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I am adding to my original question since I found some additional information regarding issue 2.
Issue 1 I was able to do a workaround,I entered default values and I can run the report through cms ,but when a user wants to view the report using bi launch pad then after entering the param values if they try to view it throws an error saying that the report processer failed to run the report and I found a correlation between this and my second issue which was the health of the report processing server in the danger zone.I
The report processing servers health goes to the danger zone only after the report fails to run.I will really appreciate if some one can give me feedback as it has held up my work for a week:(
Thanks folks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
for #2 - you need to check what those red warning light is for. You can do it by clicking on it or by going to CMC>Monitoring and investigating it there. If I had to guess - you do not have enough resources on your server to run CRS and SQL at the same time.
Database deadlock errors you need to discuss with your DBA or on SQL server forums.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.