during creation of e-mail subscription in SSRS I'm receiving this error:
ERROR: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: The specified @category_id ('100') does not exist.
I found this: http://www.sqlservercentral.com/Forums/Topic392091-162-1.aspx#bm1323298 as a solution but I need to know if it is supported by MS.
Could you tell where SSRS is holdig category_id number? Is it hardcoded in application? I couldn't find it in any of ReportServer tables nor configuration files and even in registry.
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)