SharePoint General
We noticed a strange behavior today. We set subscriptions on a SQL Server 2008 R2 SSRS report and when we later tried to add new subscriptions to the report we noticed that the previously created subscriptions are missing from the list although sending regular updates. A few days later the missing subscriptions re-appeared magically. After some investigation it turned out that the subscriptions are stored in the SSRS using the SPUrlZone method which explicitly returns the URL of the report in the exact way it's accessed. This URL is than written into SSRS. The problem is with Alternate Access Mapping which enables you to access the same report using different URLs. When the subscriptions were missing we simply used a different URL and for that URL SSRS could not find any subscriptions. This issue is present in both SQL Server 2008 R2 and SQL Server 2012. I heard from Microsoft that they are working on a fix. Until it's released the only workaround is to use the same AAM every time.
Thanks for the good article, I was searching for details like this, going to check out the other posts.
Cancel reply to comment
Name* Required Please choose another name
E-mail*
Country [Not specified] Afghanistan Albania Algeria Angola Argentina Armenia Australia Austria Azerbaijan Bahrain Bangladesh Belarus Belgium Belize Bermuda Bolivarian Republic of Venezuela Bolivia Bosnia and Herzegovina Botswana Brazil Brunei Darussalam Bulgaria Cambodia Cameroon Canada Caribbean Chile China Colombia Congo [DRC] Costa Rica Croatia Czech Republic Denmark Dominican Republic Ecuador Egypt El Salvador Eritrea Estonia Ethiopia Faroe Islands Finland France Georgia Germany Greece Greenland Guatemala Guinea Haiti Honduras Hong Kong Hong Kong SAR Hungary Iceland India Indonesia Iran Iraq Ireland Israel Italy Ivory Coast Jamaica Japan Jordan Kazakhstan Kenya Korea Kuwait Kyrgyzstan Lao PDR Latin America Latvia Lebanon Libya Liechtenstein Lithuania Luxembourg Macao SAR Macedonia (Former Yugoslav Republic of Macedonia) Madagascar Malaysia Maldives Mali Malta Mexico Moldova Mongolia Montenegro Morocco Myanmar Nepal Netherlands New Zealand Nicaragua Nigeria Norway Oman Pakistan Panama Paraguay Peru Philippines Poland Portugal Principality of Monaco Puerto Rico Qatar Réunion Romania Russia Rwanda Saudi Arabia Senegal Serbia Serbia and Montenegro (Former) Singapore Slovakia Slovenia Somalia South Africa Spain Sri Lanka Sweden Switzerland Syria Taiwan Tajikistan Thailand Trinidad and Tobago Tunisia Turkey Turkmenistan U.A.E. Ukraine United Kingdom United States Uruguay Uzbekistan Vietnam Yemen Zimbabwe
5+5 = The captcha value you provided is incorrect.
Notify me when new comments are added
Hi! I'm Marcell Mikolcsó, SharePoint and Enterprise Administrator, System Architect.
Get notified when a new post is published.