Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2192
  • Last Modified:

Reporting Services 2008 error

I am getting the following error when I try to run a report in reporting services:

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
Procedure or function 'CreateSession' expects parameter '@SiteZone', which was not supplied.
0
garbertravel
Asked:
garbertravel
2 Solutions
 
ValentinoVBI ConsultantCommented:
The clue can be found in that last line.  The report is using a stored procedure (or function) called CreateSession.  This SP is expecting a parameter (@SiteZone) but it's not getting it from the report.
0
 
sureshbabukrishCommented:
please confirm whether your report has a parameter named 'SiteZone'
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now