Help!

We recently changed the password on the account used by Reporting Services 2000.  As a result the ReportServer quit working.  I used rsconfig.exe to update and specify a new (more appropriate) domain account.  Added that account to rsExecRole. 

I have it back to the point where I can go to the website and run reports again.  The problem is when I try to export any of the reports to any type (pdf, excel, etc), I get this error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Invalid column name 'ParamsHash'. Invalid column name 'UserParams'. Invalid column name 'UserParams'.

If I look in the log file, i see this.  I have no idea what the problem is.  I do not know what UserParams or ParamsHash is even referring to - certainly nothing I've defined.

3wp!library!1060!05/05/2008-14:37:54:: i INFO: Call to GetPermissions:/
w3wp!library!1060!05/05/2008-14:37:54:: i INFO: Call to GetSystemPermissions
w3wp!library!ff8!05/05/2008-14:37:57:: i INFO: Call to GetPermissions:/Information Services
w3wp!library!ff8!05/05/2008-14:37:57:: i INFO: Call to GetSystemPermissions
w3wp!library!1060!05/05/2008-14:37:58:: i INFO: Call to GetPermissions:/Information Services/AOPO Reports
w3wp!library!e64!05/05/2008-14:37:58:: i INFO: Call to GetSystemPermissions
w3wp!library!ff8!05/05/2008-14:37:59:: i INFO: Call to GetPermissions:/Information Services/AOPO Reports/AOPOMonthlySurvey
w3wp!library!e64!05/05/2008-14:37:59:: i INFO: Call to GetSystemPermissions
w3wp!library!ff8!05/05/2008-14:38:06:: i INFO: Call to RenderFirst( '/Information Services/AOPO Reports/AOPOMonthlySurvey' )
w3wp!library!ff8!05/05/2008-14:38:07:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
w3wp!webserver!ff8!05/05/2008-14:38:07:: i INFO: Processed report. Report='/Information Services/AOPO Reports/AOPOMonthlySurvey', Stream=''
w3wp!session!14e4!5/5/2008-14:38:07:: e ERROR: Unhandled Sql Error in SetSessionData: System.Data.SqlClient.SqlException: Invalid column name 'UserParams'.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Library.DatabaseSessionStorage.SetSessionData(SessionReportItem sessionReport, ConnectionManager connectionManager)
w3wp!session!e64!05/05/2008-14:38:11:: e ERROR: Sql Error in GetSnapshotData: System.Data.SqlClient.SqlException: Invalid column name 'ParamsHash'.
Invalid column name 'UserParams'.
Invalid column name 'UserParams'.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String reportPath, String userName, String userParams, ConnectionManager connMgr)
w3wp!webserver!e64!05/05/2008-14:38:11:: e ERROR: Internal error: System.Data.SqlClient.SqlException: Invalid column name 'ParamsHash'.
Invalid column name 'UserParams'.
Invalid column name 'UserParams'.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String reportPath, String userName, String userParams, ConnectionManager connMgr)
   at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String reportPath, String userName, String userParams)
   at Microsoft.ReportingServices.Library.SessionReportItem.Load(DatabaseSessionStorage sessionStorage, LoadAction loadFlags, String sessionId, String reportPath, DateTime snapshotDate, String userName, String userParams, String imageName, DatasourceCredentialsCollection dataSourceCred)
   at Microsoft.ReportingServices.WebServer.HttpClientRequest.LoadFromDB(LoadAction loadFlags, CatalogItemContext context)
   at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, String userName, Boolean createIfSessionNotExists)
   at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, String userName)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!e64!05/05/2008-14:38:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Invalid column name 'ParamsHash'.
Invalid column name 'UserParams'.
Invalid column name 'UserParams'.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteReader()
   at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String reportPath, String userName, String userParams, ConnectionManager connMgr)
   at Microsoft.ReportingServices.Library.DatabaseSessionStorage.GetSessionData(String sessionId, String reportPath, String userName, String userParams)
   at Microsoft.ReportingServices.Library.SessionReportItem.Load(DatabaseSessionStorage sessionStorage, LoadAction loadFlags, String sessionId, String reportPath, DateTime snapshotDate, String userName, String userParams, String imageName, DatasourceCredentialsCollection dataSourceCred)
   at Microsoft.ReportingServices.WebServer.HttpClientRequest.LoadFromDB(LoadAction loadFlags, CatalogItemContext context)
   at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, String userName, Boolean createIfSessionNotExists)
   at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, String userName)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
   at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
   --- End of inner exception stack trace ---

Hi,

From the error log, it seems that you had already set the permissions for the ASPNET user in the ReportServer table to allow RSExecRole. Besides, you had to do the same for the ReportServerTempDB.

Thanks.