August 10, 2011 at 2:48 am
Hi,
I have a report in which a SP is used 6 times with diferrent parameters.
when it is individualy run i got the deisred result but it is taking 1- 1:30 minutes to exucute.
now if excute in reports all 6 are executing in a gap of 1 or 2 seconds because of this i am getting "Transaction was deadlocked on lock resources with another process and has been chosen".
is there a way to run th sp after the previous one completes.
input table and temporary table all are same in this case.
kindly suggest.
Regards
Durai Nagarajan
August 12, 2011 at 9:15 am
Kindly help me on this if there is any work around.
Regards
Durai Nagarajan
August 12, 2011 at 10:12 am
If I understand you have a single SP that you use to create 6 different results within a single report, perhaps with 6 different tables, or matrix, or charts.
If the parameters are fixed, or programmable, not user input, you could try making the input parameters multi select, and input them all to the SP only one time, then for each table, etc. filter the results down to the parameters you want to display right there. This way you are only making one call to the db/sproc.
If the parameters are user input every time the report is run that could present a problem depending on the type of parameters you are using.
August 12, 2011 at 11:43 am
My SP and table are one each.
but when i invoke it every time i use different parameter.
so due to inusffucient time, this is happening.
do you nee more information on this.
Regards
Durai Nagarajan
August 12, 2011 at 12:31 pm
So you have one Sp, one table, on one report. How are you executing it 6 times concurrently with different parameters? Subscription?
August 13, 2011 at 4:54 am
Hi,
on same reporting calling it with manually different parameters and calling in the same report.
output has to be shown in 6 tables.
Regards
Durai Nagarajan
August 23, 2011 at 10:27 am
Hi,
is there a way out, kindly help.
temporarily created sp's and using different tables based on a parameter selected but which is not a good resource usage.
Regards
Durai Nagarajan
August 23, 2011 at 11:35 am
I still don't see how you can execute a single report with a single table with 6 different sets of parameters at the exact same time that would cause locking issues.
Do you have 6 tables on the report?
August 24, 2011 at 1:20 am
My problem is i want to execute a single sp which is using 1 table with 6 different parameter.
temporarily i have changed the SP to use 6 different tables based on parameter i pass tath too i run one by one.
i want a solution for the first one , can we delay running the second sp when the first one is running.
thanks in advance.
Regards
Durai Nagarajan
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply