Thursday, October 22, 2015

Quick fix: Report Subscription Owner change

When you create report subscriptions using the OpsMgr console, your user account’s guid (assigned by SSRS internally) is made the owner of the subscription. If your user account is removed or disabled, this will cause the report subscriptions to fail. To fix this, you need to replace the owner GUID with a GUID of a valid user. To do so, you can use the following steps:

  1. Using the SQL Server Management Studio, connect to the server hosting the ReportServer database for your OpsMgr environment
  2. Select the ReportServer database, right click and select New Query
  3. Run the following query:

    select OwnerID from subscriptions
    where laststatus like '%Failure%'

    This returns the OwnerID of any reports that have failed to run. You will need this OwnerID for step 5

  4. Open another New Query window, and run the following query:

    select OwnerID from subscriptions
    where laststatus not like '%Failure%'

    This returns the OwnerID of any reports that have not failed to run. You will need this OwnerID for step 5

  5. Open another New Query window, and run the following query:

    USE [ReportServer]
    GO

    UPDATE [dbo].[Subscriptions]
    SET [OwnerID] = <OwnerID of successful reports>
    WHERE OwnerID = <OwnerID of failed reports>
    GO

    It should look something like this:

    USE [ReportServer]
    GO

    UPDATE [dbo].[Subscriptions]
    SET [OwnerID] = '9DF9EBCD-F913-40C1-AEF9-0F7634EAE571'
    WHERE OwnerID = '94738FA7-FD24-4190-9B64-355557DF0035'
    GO

Thursday, October 9, 2014

First glance: System Center vNext Operations Manager Technical Preview

Along with the announcement of Windows 10 last week, the Technical Previews of the System Center suite and Windows Server was also announced. I finally got round to installing into my lab. Prerequisites match those of System Center 2012 R2 Operations Manager, with the required SQL version being SQL Server 2014.

The most obvious new feature I can see are a bunch of new widget types for the Dashboards:

image

I can see some very attractive new dashboards being built. I just played a little bit with some of the widgets, and considering I have nothing monitored yet, this is not too shabby :)

image

Now to get some agents in and push this puppy.

Sunday, October 5, 2014

First glance: Windows 10

The technical preview of Windows 10 was announced this week and is open to the public (download here). As I was travelling, I had to wait a couple of days before downloading, but finally got round to it this morning. I fired up a new machine in Hyper-V and got cracking.

The installation is pretty straight forward, and looks very much like the previous Windows installers.

 image

And even with only 1GB of memory, the installation took less than 8 minutes to complete.

image

The OS is responsive, the UI is clean and I love the snappable start menu. I look forward to playing with this new release a lot more over the next couple of weeks for some real impressions.

Monday, June 2, 2014

Windows 2008 VM on Hyper-V in Windows 8

A note to self: If you want to deploy a Windows Server 2008 VM within Hyper-V on Windows 8, the VM needs to be created as a generation 1 VM, not 2. If you use Generation 2, not even switching off Secure boot will allow the installation to go through.

In other news, my lab is now just about built. Not sure why it took me so long, considering I’ve been in my new position for 3 months already.

Wednesday, May 21, 2014

AppFabric installation error

While trying to set up a SharePoint 2013 machine in my lab for testing OpsMgr dashboards, I ran into this error with installing one of the prerequisites, AppFabric:

AppFabric installation failed because installer MSI returned with error code : 1603

This solution resolved the problem for me. Issue is caused by an extraneous quote at the end of the PSModulePath in Environmental variables. To resolve, as per th resolution posted:

Incorrect path:

C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files (x86)\Microsoft SQL Server\110\Tools\PowerShell\Modules"

removing the extraneous " corrected the issue

To change this go to Control Panel -> System -> Advanced System Settings -> On the Advanced Tab Select Enviroment Variables -> Under System Variables there is a Variable named PSModulePath, select it -> Click Edit -> Remove trailing "

q0Y05

Credit for solution goes to original poster. Really just keeping this here for my own sanity.

Related Posts with Thumbnails