Solved

Reporting Services 2008 error

Posted on 2010-09-06
2
2,141 Views
Last Modified: 2012-05-10
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
Comment
Question by:garbertravel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 250 total points
ID: 33616729
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
 
LVL 9

Assisted Solution

by:sureshbabukrish
sureshbabukrish earned 250 total points
ID: 33617001
please confirm whether your report has a parameter named 'SiteZone'
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSRS Total a column based on a calulated field - Report Writer 3.0 12 90
SSRS Matrix Grand Total 2 72
SSRS - Date Report Options 2 45
parameters reportbuilder 1 20
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question