| Author |
Topic |
|
aoriju
Posting Yak Master
156 Posts |
 Posted - 2008-12-15 : 00:04:03
|
| Dear All,We are Working On SSRS.One SSRS Report values Showing Duplicate Values(I Mean Values Repeating) After Some Days Just ike 20,30 Days.But Corresponding Store Procedure Return The Actual Records.Then We Conclude that the problem is from Report.Then We Rebuild that report and Diployed In Client Site also Alter and Delete the Procedure.In that time Problem Solved.But that Problem Comes After Some Days.Then We recreate that Report and Diployed In Client Site And Run The Procedure.Then Problem Solved.After 35 Days Problem Comes Again.Then We rebuild the Report and Diployed In Client Site.This Time Problem Is Not OverComed.Then We Just Delete and Re Run The Procedure on Client Site .Then It Working....Can't Understand what's Reason.Tell Me If You These sort ExperienceByRiju A.O |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 00:20:00
|
| seems like a caching issue. whats the caching settings set for report on report server?Also are you using procedure or query for dataset source? |
 |
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 00:26:21
|
| Normal Cache Settings For Other 70 or 80 reports.Problem Only in 1 Report |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 00:37:57
|
| ok..in that case whats the procedure/ query behind doing? can you give a brief idea on it? is it using some staging tables to store the results? |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 00:47:58
|
| We Are Using Procedures Using For DataSet Source.Table Variables are using inside the store procedure. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 00:49:23
|
quote:
Originally posted by aoriju
We Are Using Procedures Using For DataSet Source.Table Variables are using inside the store procedure.
and inside report you're using dataset data directly? also are you applying any grouping? |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 00:53:13
|
| Directly Applying fields.No Grouping On Records. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 00:56:28
|
| is it consuming only a single dataset or are there multiple containers (tables,matrices,..) which uses more than 1 dataset? |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 01:06:58
|
| 3 DataSet are Used.one for loading the corresponding Parameterother two for displaying the reports(I that one for showing the Reports details other for Displaying the common client things in header part).Reports Displaying in a single table. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 01:14:52
|
quote:
Originally posted by aoriju
3 DataSet are Used.one for loading the corresponding Parameterother two for displaying the reports(I that one for showing the Reports details other for Displaying the common client things in header part).Reports Displaying in a single table.
and i guess its the one thats showing detail is getting duplicated? |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 01:18:33
|
| Yes.Showing Details is getting duplicated.But corresponding Procedure not showing Duplication. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 01:26:37
|
| is this happening even when you run report locally on preview tab or is this happening only at server always? |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 01:32:53
|
| Its Happing Only on Client Site. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 01:35:58
|
| can you try setting do not cache property for this report and see if the problem persists? |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 01:39:56
|
| We are always using Cache propert as Donot Cache Temporary copies of the report |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 01:45:00
|
| also can you please check if the objects (db tables) used in query exists only as a single copy under dbo schema and not both under your default schema and dbo schema? |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 01:59:16
|
| we are only using the dbo schema. And the procedures is created under dbo. How to check the objects (db tables) used in query exists only as a single copy under dbo schema?Also i would like to remind you that, within the procedure the data taken from the physical tables are been inserted into multiple table variables for further processing and the resultant table set is retrieved using these table variables. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 02:03:41
|
quote:
Originally posted by aoriju
we are only using the dbo schema. And the procedures is created under dbo. How to check the objects (db tables) used in query exists only as a single copy under dbo schema?Also i would like to remind you that, within the procedure the data taken from the physical tables are been inserted into multiple table variables for further processing and the resultant table set is retrieved using these table variables.
to check if objects exists as single copy useSELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME='YourTable' this should return only a single recordby table variables do you mean @tables. if yes, i dont think they would be a problem as they will automatically be destroyed after query batch execution |
|
|
|
aoriju
Posting Yak Master
156 Posts |
Posted - 2008-12-15 : 02:17:04
|
| Yes. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-12-15 : 06:09:02
|
| orif objectproperty(object_id('table_name'),'isusertable')=1print 'exists'elseprint 'doesnt exist'MadhivananFailing to plan is Planning to fail |
|
|
|
|
Duplicating Records On SSRS