Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  Export to PDF: Invalid column name 'ParamsHash'.

Author  Topic  ibost Starting Member 3 Posts Posted - 2008-05-06 : 12:21:05 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 ---