{"id":78,"date":"2017-10-28T09:57:07","date_gmt":"2017-10-28T09:57:07","guid":{"rendered":"http:\/\/4us2use.at\/?p=78"},"modified":"2018-03-09T12:16:26","modified_gmt":"2018-03-09T12:16:26","slug":"reporting-subscriptions-stucks-in-status-pending-after-domain-user-migration","status":"publish","type":"post","link":"http:\/\/4us2use.at\/?p=78","title":{"rendered":"Reporting Subscriptions stucks in status &#8220;Pending&#8221; after domain user migration"},"content":{"rendered":"<p>Problem Description:<\/p>\n<p>after a user&#8217;s account has been migrated from sourdeomain to targetdomain, the subscriptions created with that user account stopped working.\u200b<\/p>\n<p>Resolution:<\/p>\n<p>stsadm migration on SharePoint doesn&#8217;t fix this problem; you have to manually change the subscription users in the database of the SharePoint Reporting service application.<\/p>\n<p>To identify:<\/p>\n<p>\u200bSELECT<br \/>\njobs.name AS JobName,<br \/>\nC.path AS ReportPath,<br \/>\nC.name AS ReportName,<br \/>\nu.username AS SubscriptionOwner<br \/>\nFROM dbo.ReportSchedule RS<br \/>\nJOIN msdb.dbo.sysjobs jobs<br \/>\nON CONVERT(varchar(36), RS.ScheduleID) = jobs.name<br \/>\nINNER JOIN dbo.Subscriptions S<br \/>\nON RS.SubscriptionID = S.SubscriptionID<br \/>\nINNER JOIN dbo.Catalog C<br \/>\nON s.report_oid = C.itemid<br \/>\nINNER JOIN dbo.users u<br \/>\nON s.ownerid = u.userid<\/p>\n<p>To fix:<\/p>\n<p>DECLARE @OldUserID uniqueidentifier<br \/>\nDECLARE @NewUserID uniqueidentifier<br \/>\nSELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = &#8216;sourcdomain\\firstname.lastname&#8217;<br \/>\nSELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = &#8216;targetdomain\\firstname.lastname&#8217;<br \/>\nUPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID<\/p>\n<span id=\"post-ratings-78\" class=\"post-ratings\" data-nonce=\"6b4a9449db\"><img id=\"rating_78_1\" src=\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/stars\/rating_off.gif\" alt=\"1 Star\" title=\"1 Star\" onmouseover=\"current_rating(78, 1, '1 Star');\" onmouseout=\"ratings_off(0, 0, 0);\" onclick=\"rate_post();\" onkeypress=\"rate_post();\" style=\"cursor: pointer; border: 0px;\" \/><img id=\"rating_78_2\" src=\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/stars\/rating_off.gif\" alt=\"2 Stars\" title=\"2 Stars\" onmouseover=\"current_rating(78, 2, '2 Stars');\" onmouseout=\"ratings_off(0, 0, 0);\" onclick=\"rate_post();\" onkeypress=\"rate_post();\" style=\"cursor: pointer; border: 0px;\" \/><img id=\"rating_78_3\" src=\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/stars\/rating_off.gif\" alt=\"3 Stars\" title=\"3 Stars\" onmouseover=\"current_rating(78, 3, '3 Stars');\" onmouseout=\"ratings_off(0, 0, 0);\" onclick=\"rate_post();\" onkeypress=\"rate_post();\" style=\"cursor: pointer; border: 0px;\" \/><img id=\"rating_78_4\" src=\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/stars\/rating_off.gif\" alt=\"4 Stars\" title=\"4 Stars\" onmouseover=\"current_rating(78, 4, '4 Stars');\" onmouseout=\"ratings_off(0, 0, 0);\" onclick=\"rate_post();\" onkeypress=\"rate_post();\" style=\"cursor: pointer; border: 0px;\" \/><img id=\"rating_78_5\" src=\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/stars\/rating_off.gif\" alt=\"5 Stars\" title=\"5 Stars\" onmouseover=\"current_rating(78, 5, '5 Stars');\" onmouseout=\"ratings_off(0, 0, 0);\" onclick=\"rate_post();\" onkeypress=\"rate_post();\" style=\"cursor: pointer; border: 0px;\" \/> (No Ratings Yet)<br \/><span class=\"post-ratings-text\" id=\"ratings_78_text\"><\/span><\/span><span id=\"post-ratings-78-loading\" class=\"post-ratings-loading\"><img src=\"http:\/\/4us2use.at\/wp-content\/plugins\/wp-postratings\/images\/loading.gif\" width=\"16\" height=\"16\" class=\"post-ratings-image\" \/>Loading...<\/span>\n","protected":false},"excerpt":{"rendered":"<p>Problem Description: after a user&#8217;s account has been migrated from sourdeomain to targetdomain, the subscriptions created with that user account stopped working.\u200b Resolution: stsadm migration on SharePoint doesn&#8217;t fix this problem; you have to manually change the subscription users in the database of the SharePoint Reporting service application. To identify: \u200bSELECT jobs.name AS JobName, C.path &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/4us2use.at\/?p=78\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Reporting Subscriptions stucks in status &#8220;Pending&#8221; after domain user migration&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/78"}],"collection":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=78"}],"version-history":[{"count":2,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions"}],"predecessor-version":[{"id":154,"href":"http:\/\/4us2use.at\/index.php?rest_route=\/wp\/v2\/posts\/78\/revisions\/154"}],"wp:attachment":[{"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4us2use.at\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}