RS error = ''@category_name'' is invalid
-
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
-
This was removed by the editor as SPAM
-
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
-
Hey jan,
I see you've posted this around a bit
Have you tried tracing your sql server (start it just before the subscription creation attempt and then stop it soon after) to see what category id is being requested by RS? I know in my local install (sql 2k sp3a, rssp2) the category id is 100. Not sure if this is standard but definitely looks 'intentional' as the cateogires are not voerly sequential.
Based on finding this out, you could then post to the newsgroups 9usually well monitored by msft guys) with the additional level of detail (e.g. I try to create a subscription, RS calls fo rthis category from SQLAgent categories and it jut plain doesn't exist).
let us know what you find and how it goes getting it fixed.
Cheers,
Steve.
-
Just a quick follow-up, i just dialled into a work server, it's set to 100 also. What does your sp-help_category return as valid category values?
Steve.
-
Whaaauuuu Steve....
Thanks very much for the quick reply, it was much more than I had hoped for.
I have done some research with SQL profiler, and publish the results on my website here.
1. The first runs as credentials stored with SA (http://www.xess.dk/sql/ScreenShot1.jpg), and the outcome from profiler (http://www.xess.dk/sql/ReportServer1.sql) seems to call the add_job with @CategoryID=106 but the sp_help_category (http://www.xess.dk/sql/ScreenShot3.jpg) do not have a 106 item.
2. Second is run with my on Windows credential (http://www.xess.dk/sql/ScreenShot2.jpg) but the outcome (http://www.xess.dk/sql/ReportServer2.sql) is the same with the error (http://www.xess.dk/sql/ScreenShot4.jpg)
My enviroment is nearly the same as your Win2003, SQL 2000 SP3a , Report Services SP2
I very much hope you can help me.
THANKS VERY MUCH in advance.
Best regards
Jan Borup Coyle
Denmark
-
Hi Jan,
Based on your screenshot3, I'd be a bit concerned - I can't see an entry there for Reporting Services, in fact, I have exactly the same list as you *except* that I have the 'Report Server' category (as mentioned, ID = 100).
If I had to guess, I'd assume that there was a problem during install, maybe you installed with an account that wasn't a local admin? Seeing as you've just re-installed, you might want to look for install log iles to see if there's anything in there. If you open the RS BOL, then using the index type in 'Install' you should get to a 'Install Reporting Services' entry which contains a sub-entry of 'log files' which will point you to where the files (and .cab that contains them) will be.
HTH,
Steve.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply