April 17, 2014 at 2:41 pm
Hi,
I am trying to run a report on using SSRS 2008 and II7 my report runs fine in my ssrs manager, when I try to run my application I am getting 403 forbidden on my application and below is what I see in my SSRS log( enable verbose logging to get more details)
ANY HELP WOULD BE APPRECIATED.
Warning (Tablix1.Hidden) : The Hidden expression for the tablix ‘Tablix1’ uses a numeric aggregate function on data that is not numeric. Numeric aggregate functions (Sum, Avg, StDev, Var, StDevP, and VarP) can only aggregate numeric data. [rsAggregateOfNonNumericData]
chunks!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: ### ID=ad306e22-5edf-4b18-9a73-9b911f6487f5, Length=0, CompressedLength=0, TimeCompressing=0, TimeUncompressing=0, Ratio=0, Buffering=0, Permanent=True
chunks!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: ### ID=4dda249c-de3b-45ae-8d4d-35bd3309ca4c, Length=0, CompressedLength=0, TimeCompressing=0, TimeUncompressing=0, Ratio=0, Buffering=0, Permanent=False
chunks!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Committing shared chunk transaction for snapshot '4dda249c-de3b-45ae-8d4d-35bd3309ca4c', Permanent=False.
library!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Transaction commit.
library!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Transaction begin.
library!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Caching secondary streams...
cache!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Cache content:
Key: ChunkSegmentCache:aa1d3137-40bb-e311-8abe-bf729ac39ed0
Cached item:
Type: Microsoft.ReportingServices.Library.SegmentCacheEntry
Expires: 12/31/9999 11:59:59 PM Estimated Size: 31 KB
Key: ChunkSegmentCache:ab1d3137-40bb-e311-8abe-bf729ac39ed0
Cached item:
Type: Microsoft.ReportingServices.Library.SegmentCacheEntry
Expires: 12/31/9999 11:59:59 PM Estimated Size: 31 KB
Key: ChunkSegmentCache:d1e35f30-b6c4-e311-8abe-bf729ac39ed0
Cached item:
Type: Microsoft.ReportingServices.Library.SegmentCacheEntry
Expires: 12/31/9999 11:59:59 PM Estimated Size: 0 KB
Key: ChunkSegmentCache:ac1d3137-40bb-e311-8abe-bf729ac39ed0
Cached item:
Type: Microsoft.ReportingServices.Library.SegmentCacheEntry
Expires: 12/31/9999 11:59:59 PM Estimated Size: 3 KB
Key: ChunkSegmentCache:a91d3137-40bb-e311-8abe-bf729ac39ed0
Cached item:
Type: Microsoft.ReportingServices.Library.SegmentCacheEntry
Expires: 12/31/9999 11:59:59 PM Estimated Size: 31 KB
Key: ChunkSegmentCache:cce35f30-b6c4-e311-8abe-bf729ac39ed0
Cached item:
Type: Microsoft.ReportingServices.Library.SegmentCacheEntry
Expires: 12/31/9999 11:59:59 PM Estimated Size: 0 KB
Key: ChunkSegmentCache:cde35f30-b6c4-e311-8abe-bf729ac39ed0
Cached item:
Type: Microsoft.ReportingServices.Library.SegmentCacheEntry
Expires: 12/31/9999 11:59:59 PM Estimated Size: 0 KB
library!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Transaction commit.
runningjobs!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Thread pool settings: Available worker: 100, Max worker: 100, Available IO: 100, Max IO: 100
runningjobs!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Spawning new thread for a work item.
runningjobs!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: ThreadJobContext.EndCancelableState
runningjobs!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: ThreadJobContext.WaitForCancelException entered
runningjobs!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: ThreadJobContext.WaitForCancelException finished
runningjobs!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Executing user callback
session!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Adding report with path 'MYREPORT Path' to session DB
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: ### CreateChunk('GroupTree', Main) this=4dda249c-de3b-45ae-8d4d-35bd3309ca4c, #ReadChunks=0, #WriteChunks=0
library!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Transaction begin.
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Open|Create Segmented Chunk (4dda249c-de3b-45ae-8d4d-35bd3309ca4c, False, GroupTree, '0', Create)
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Creating chunk (4dda249c-de3b-45ae-8d4d-35bd3309ca4c, False, GroupTree, '0'
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: ### CreateChunk('Metadata', Main) this=4dda249c-de3b-45ae-8d4d-35bd3309ca4c, #ReadChunks=0, #WriteChunks=1
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Open|Create Segmented Chunk (4dda249c-de3b-45ae-8d4d-35bd3309ca4c, False, Metadata, '0', Create)
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Creating chunk (4dda249c-de3b-45ae-8d4d-35bd3309ca4c, False, Metadata, '0'
runningjobs!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: RunningJobList.RemoveJob: 4qhhb445qnwt1j3djbpes255 was removed
bufferedresponse!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: HttpResponseStream suppressed one and only flush
bufferedresponse!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Closed HttpResponseStream
webserver!ReportServer_0-1!804!04/15/2014-10:50:58:: i INFO: Processed report. Report='MYREPORT Path', Stream=''
library!ReportServer_0-1!804!04/15/2014-10:50:58:: v VERBOSE: Disposing StreamFactory:22050476-c6c3-4968-867a-9a63b866440b
rshost!rshost!804!04/15/2014-10:50:58:: v VERBOSE: HttpPipelineCallback::EndOfRequest(): continue pipeline=0x000000000027DB00.
rshost!rshost!738!04/15/2014-10:50:58:: v VERBOSE: ThreadContinuePipeline: processing request on pipeline=0x000000000027DB00, state=2, IOError=0, node=0.
rshost!rshost!66c!04/15/2014-10:50:58:: v VERBOSE: HttpPipeline::DisconnectCallback: releasing pipeline=0x000000000027DB00.
rshost!rshost!ca4!04/15/2014-10:50:58:: v VERBOSE: ThreadContinuePipeline: processing request on pipeline=0x000000000027DB00, state=0, IOError=2250, node=0.
rshost!rshost!ca4!04/15/2014-10:50:58:: v VERBOSE: State machine disconnected pipeline=0x000000000027DB00, state=4 ...
rshost!rshost!ca4!04/15/2014-10:50:58:: v VERBOSE: HttpPipeline::DoStateDisconnected: releasing pipeline=0x000000000027DB00.
rshost!rshost!ca4!04/15/2014-10:50:58:: v VERBOSE: HttpPipeline::ReleaseOnce: releasing pipeline=0x000000000027DB00.
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Closing segmented chunk (4dda249c-de3b-45ae-8d4d-35bd3309ca4c, False, 'Metadata')
processing!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: ScalabilityCache Processing|GroupTree Done. ExecutionId: vso32q55l0sz1a450py3my55 AuditedHeapSerialized: 0 KB. Serialization Time 0 s. AvgSpeed NaN KB/s. StreamSize 0 MB. FinalAuditedHeapSize 4 KB. LifetimeFreedHeapSize 0 KB.
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Closing segmented chunk (4dda249c-de3b-45ae-8d4d-35bd3309ca4c, False, 'GroupTree')
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: ### ID=4dda249c-de3b-45ae-8d4d-35bd3309ca4c, Length=0, CompressedLength=0, TimeCompressing=0, TimeUncompressing=0, Ratio=0, Buffering=0, Permanent=False
chunks!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Committing shared chunk transaction for snapshot '4dda249c-de3b-45ae-8d4d-35bd3309ca4c', Permanent=False.
library!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Transaction commit.
session!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Finished serializing report
rshost!rshost!804!04/15/2014-10:50:58:: v VERBOSE: Destroying pipeline=0x000000000027DB00, callback=0x0000000000DCE520 ...
session!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Saved report snapshot to session in a background thread. Key="myaccount";vso32q55l0sz1a450py3my55;MYREPORT path;<Parameters />
library!ReportServer_0-1!73c!04/15/2014-10:50:58:: v VERBOSE: Transaction commit.
library!DefaultDomain!73c!04/15/2014-10:52:26:: v VERBOSE: Transaction begin.
library!DefaultDomain!73c!04/15/2014-10:52:27:: v VERBOSE: Transaction begin.
library!DefaultDomain!73c!04/15/2014-10:52:27:: v VERBOSE: Transaction begin.
library!DefaultDomain!73c!04/15/2014-10:52:27:: v VERBOSE: Transaction begin.
library!DefaultDomain!73c!04/15/2014-10:52:27:: v VERBOSE: Transaction begin.
library!DefaultDomain!73c!04/15/2014-10:52:27:: v VERBOSE: Transaction begin.
April 17, 2014 at 3:54 pm
Looks like in your tablix you are attempting to average, sum, etc. data that is not a numeric value. I.E. trying to sum a string.
April 17, 2014 at 4:03 pm
To make sure I just ran another test sample report which doenst have any parameters it still throws same errors and same logs in SSRS logs. These reports run very well in my report manager and doesnt run in my application and I see these errors in logs of SSRS. I checked all permissions on SSRS IIS and all servers and every thing seem fine but I still see this issue.
April 18, 2014 at 3:19 am
Does the account the application is running under have permissions to the report? How are permissions to the underlying data sources setup?
Joie Andrew
"Since 1982"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply