SQL Server Performance Forum – Threads Archive

Create Subscriptions Error

Hi,
I have an issue when creating subsrciptions, each time I try to create one i get the error
"The specified ‘@category_name’ is invalid (valid values are returned by sp_help_category)."
The system is win2003/sqlserver2000 + sp4/ reportingservices + sp2. Thanks
Andy

Hi
I got the very same problem here…. and have used a lot of time to debug it with no result I’m using a SQL 2000 Enterprise with SQL Reporting Services + SP2. I have just removed all Reporting Services from the server, removed all reporting databases and installed it again with the same result. I have created a account call SQLREP with full permission to Master, MSDB and the usertable for the reports, I have executed EXEC sp_help_category and EXEC sp_helplogins with this user and it works fine. The resultlog from the server when I try to create a subscription is: ——
w3wp!library!1754!07-07-2005-13:50:34:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!library!1754!07/07/2005-13:54:12:: i INFO: Call to GetSystemPermissions
w3wp!library!1754!07/07/2005-13:54:12:: i INFO: Call to GetPermissions:/ISAO/SupplierView
w3wp!library!1754!07/07/2005-13:54:12:: 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: The specified ‘@category_name’ is invalid (valid values are returned by sp_help_category).
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.SqlAgentScheduler.CreateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.CreateTimeBasedSubscriptionSchedule(String reportName, Guid subscriptionID, Task task)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.CreateSubscription(Guid id, String report, Guid reportID, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings, Byte[] reportSecDesc)
at Microsoft.ReportingServices.Library.RSService._CreateSubscription(Guid id, String report, ExtensionSettings extensionSettings, String description, String eventType, String matchData, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.RSService.CreateSubscription(Guid batchId, String report, ExtensionSettings extensionSettings, String description, String eventType, String matchData, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
— End of inner exception stack trace —
Any suggertions ? Best regards Jan Borup Coyle

May refer tohttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3204 relevant post and search under MS for a fix. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>