CODEWITHSUNDEEP
ssrs-2008
freddoo
freddoo

Reputation: 6858

New Email Subscriptions are not delivering in SQL Server 2005 Reporting services after migration

I have a problem with our new ssrs 2008 subscription not being sent out. The old subscription work fine.

This happens since we migrated our ssrs server from Windows Server 2005/SSRS 2008 to a new vm with Windows Server 2008/SSRS 2008.

The main difference that I can see in the data table is that the new Subscription State field is 268435457 instead of 1 or 3.

So my server config should be fine since the old subscription are working fine, only the new subscription are not going out.

I have found someone with the same issue but no solution provided

New Email Subscriptions are not delivering in SQL Server 2005 Reporting services

Thanks

Upvotes: 1

Views: 413

Answers (1)

freddoo
freddoo

Reputation: 6858

It was our mistake, since 3 employee worked on the problem, I could not see all that was done.

Then I activated the verbose logging and got an error.

The weird thing is that the error did not show up in the log until the verbose setting was used. The error should have been added to the logs at the 'info' level

schedule!WindowsService_ .... :: Error processing event 'TimedSubscription', data = .... , 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 INSERT statement conflicted with the FOREIGN KEY constraint "FK_Notifications_Subscriptions". The conflict occurred in database "ReportServer", table "dbo.Subscriptions_OLD", column 'SubscriptionID'.

When we troubleshooted something else someone renamed the 'Subscription' table to 'Subscription_Old', and created a new 'Subscription' evrything worked fined except for the scheduled reports

Upvotes: 1

Related Questions