it.blo.gg

Annoying message that doesn't go away even after a restart.

 

To remove it:

 

1. Make sure you have good backup of the site DB

2. Run the following select statement to find the Distribution Points in this state: select * from dbo.DistributionStatus where InsStr2 = '3010'

3. Once identified then Delete a record an affected DP with: delete from dbo.DistributionStatus where ID = <DPID of affected DP identified by above command>

 

Source:

https://social.technet.microsoft.com/Forums/en-US/127b59c0-d9fc-4224-be8f-03efe9a97544/distribution-point-configuration-status-sms-client-restart-might-required?forum=configmanagerdeployment

If you get this error, you need to do the following to fix it!

 

1. Download and install http://download.microsoft.com/download/A/C/6/AC61A4C8-CF2A-4994-B8AD-B850759FFA7D/1033/x86/ReportBuilder3.msi

 

2. When installing, enter your default target server url, e.g. https://sccm.domain.com/reportserver

 

3. Open up regedit and change ReportBuilderApplicationManifestName to ReportBuilder_3_0_0_0.application, located under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\ConfigMgr10\AdminUI\Reporting

 

4. Edit X:\Microsoft Configuration Manager\AdminConsole\bin\Microsoft.ConfigurationManagement.exe.config and change to ReportBuilder_3_0_0_0.application in the ReportBuilderMapping section

 

Please read the following article if you're experiencing this.

 

After upgrading Service Manager 2012 from SP1 to R2 Reporting stops working.

 

Looking at Data Warehouse - Data Warehouse Jobs in the Service Manager Console some of the jobs are listed as Failed, amongst them, Load.Common, Load.OMDWDataMart and Load.CMDWDataMart.

 

After a great deal of Googling I came across this site:

 

 

Stating the it's a known issue and that all you need to do is to run a SQL-script against 4 databases on the Data Warehouse server.

 

The databases are:

 

- DWRepository

- DWDataMart

- CMDWDataMart

- OMDWDataMart

 

The script:

 

IF OBJECT_ID('tempdb..#PKFixQueries') IS NOT NULL
    DROP TABLE #PKFixQueries

;WITH FactName
AS (
        SELECT  w.WarehouseEntityName
        FROM    etl.WarehouseEntity w
        JOIN    etl.WarehouseEntityType t ON w.WarehouseEntityTypeId = t.WarehouseEntityTypeId
        WHERE   t.WarehouseEntityTypeName = 'Fact'
),FactList
AS (
    SELECT  PartitionName, p.WarehouseEntityName
    FROM    etl.TablePartition p
    JOIN    FactName f ON p.WarehouseEntityName = f.WarehouseEntityName
)
, FactWithPK
AS (
    SELECT  f.WarehouseEntityName, f.PartitionName, b.CONSTRAINT_NAME, a.COLUMN_NAME
    FROM    FactList f
    JOIN    INFORMATION_SCHEMA.KEY_COLUMN_USAGE a ON f.PartitionName = a.TABLE_NAME
    JOIN    INFORMATION_SCHEMA.TABLE_CONSTRAINTS b ON a.CONSTRAINT_NAME = b.CONSTRAINT_NAME AND b.CONSTRAINT_TYPE = 'Primary key'
)
, FactWithDefaultOrNoPK
AS (
    SELECT  DISTINCT f.WarehouseEntityName, f.PartitionName
            , 'PK_' + f.WarehouseEntityName AS DefaultPKConstraint
            , 'PK_' + f.PartitionName AS NewPKConstraint
    FROM    FactList f
    LEFT JOIN    FactWithPK pkf ON pkf.WarehouseEntityName = f.WarehouseEntityName AND pkf.PartitionName = f.PartitionName
    WHERE   pkf.WarehouseEntityName IS NULL OR pkf.CONSTRAINT_NAME = 'PK_' + f.WarehouseEntityName
)
, FactPKList
AS (
    SELECT  DISTINCT f.WarehouseEntityName, f.COLUMN_NAME
    FROM    FactWithPK f
)
, FactPKListStr
AS (
    SELECT  DISTINCT f1.WarehouseEntityName, F.COLUMN_NAME AS PKList
    FROM    FactPKList f1
    CROSS APPLY (
                    SELECT  '[' + COLUMN_NAME + '],'
                    FROM    FactPKList f2
                    WHERE   f2.WarehouseEntityName = f1.WarehouseEntityName
                    ORDER BY COLUMN_NAME
                    FOR XML PATH('')
                ) AS F (COLUMN_NAME)
)
SELECT  f.PartitionName,
        '----------------------------- [' + f.PartitionName + '] -----------------------------' + CHAR(13) +
        'IF OBJECT_ID(''[' + f.DefaultPKConstraint + ']'') IS NOT NULL' + CHAR(13) +
        'BEGIN' + CHAR(13) +
        '  ALTER TABLE [dbo].[' + f.PartitionName + '] DROP CONSTRAINT [' + f.DefaultPKConstraint + ']' + CHAR(13) +
        'END' + CHAR(13) + CHAR(13) +
        'IF OBJECT_ID(''[' + f.NewPKConstraint + ']'') IS NULL' + CHAR(13) +
        'BEGIN' + CHAR(13) +
        '  ALTER TABLE [dbo].[' + f.PartitionName + '] ADD CONSTRAINT [' + f.NewPKConstraint + '] PRIMARY KEY NONCLUSTERED (' + SUBSTRING(pk.PKList, 1, LEN(pk.PKList) -1) + ')' + CHAR(13) +
        'END' AS Query
INTO    #PKFixQueries
FROM    FactWithDefaultOrNoPK f
JOIN    FactPKListStr pk ON pk.WarehouseEntityName = f.WarehouseEntityName

DECLARE @PartitionName NVARCHAR(MAX), @Query NVARCHAR(MAX)
WHILE EXISTS (SELECT 1 FROM #PKFixQueries)
BEGIN
    SELECT  TOP 1
            @PartitionName = PartitionName,
            @Query = Query
    FROM    #PKFixQueries

    PRINT   @Query
    EXEC(@Query)

    DELETE  #PKFixQueries
    WHERE   PartitionName = @PartitionName
END

 

After running the script against these 4 databases, start the jobs in the Service Manager Shell using the command Start-SCDWJob -JobName Load.Common -ComputerName <dwservername>. You will see the BatchId and StartTime being updated after running the jobs. Use Get-SCDWJob -JobName Load.Common -ComputerName <dwservername> to get information about the jobs.

 

 

After installing the VMM Console and Agent on our DPM server to enable back up of Hyper-V Live Migration Cluster, the DPM-VMM Helper Service (VmmHelperServiceHost.exe) does not start on Windows Server 2012.

 

This can be found in Event Viewer:

 

Log Name: Application

Source: DpmVmmHelperService

Event ID: 0

 

 Service cannot be started. System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Security.SecurityException: Requested registry access is not allowed.
   at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)
   at Microsoft.Internal.EnterpriseStorage.Dls.VmmHelper.RunSpacePool.GetNumberOfSteadyStateRunspaces()
   at Microsoft.Internal.EnterpriseStorage.Dls.VmmHelper.CVmmHelperService..ctor()
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.ServiceModel.Description.ServiceDescription.CreateImplementation(Type serviceType)
   at System.ServiceModel.Description.ServiceDescription.SetupSingleton(ServiceDescription serviceDescription, Object implementation, Boolean isWellKnown)
   at System.S...

 

When trying to start the service in services.msc, it states:

 

The DPM-VMM Helper Service service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

 

I fired up Process Monitor (http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx) and filtered out the process VmmHelperServiceHost.exe highlighting the result ACCESS DENIED and found this:

 

VmmHelperServiceHost.exe 7392 RegOpenKey HKLM\Software\Microsoft\Microsoft Data Protection Manager\2.0\Configuration ACCESS DENIED Desired Access: Read

 

I opened up regedit and browsed to HKLM\Software\Microsoft\Microsoft Data Protection Manager\2.0\Configuration, added the permission Everyone Read to that key and voila! The service started.

 

Hope this helps someone out as I couldn't find anything regarding this issue on google.

 

Ciao :)

 

 

Add the following style sheet to the SMPortalPage.master to solve this issue:

 

<style>
body.v4master {
                height:inherit;
                width:inherit;
                overflow:visible!important; //!important to override the original theme.
}

body #s4-workspace {
                overflow-y:auto !important;
                overflow-x:auto !important;
                height:auto !important;
}
</style>

 

Source: http://blogs.technet.com/b/servicemanager/archive/2012/07/05/fixing-the-missing-scroll-bar-issue-on-the-scsm-2012-portal.aspx

When trying to invoke a runbook in Runbook Designer I get the following error message:

 

Cannot start runbook 'RunbookName'. The specified account may be missing privileges required to  invoke a runbook. Add the account to the Orchestrator System Group to give it the required authority.

 

The solution is to add the account that you are trying to invoke the runbook with to the local group OrchestratorSystemGroup.

 

I realized this after finding this error in the System event log:

 

Source: DistributedCOM

Event ID: 10016

 

 

When googling this I found the following page:

http://social.technet.microsoft.com/Forums/systemcenter/en-US/dfc465bc-7bbd-483e-b98b-2ba56fa98313/the-applicationspecific-permission-settings-do-not-grant-local-launch-permission-for-the-com-server?forum=configmgrgeneral

 

1. dcomcnfg, expand Component Services -> Computers -> My Computer -> DCOM Config
2. Click View -> Detail -> Now you will get Application Name and Application ID in right side
3. Scroll down and find the application ID {D1D9ECD5-8094-4FB8-8D69-A3AD701FF02C} -> Right Click -> Properties and select the Security tab.

 

This is where I found out that the OrchestratorSystemGroup is added here, and that my service account need to be added to this local group.

 

Cheers!

 

 

After updating to DPM 2012 R2 the DPMDB says Agent unreachable in the Protection area in DPM. Looking in the Event Viewer - System Log, there is the following two error messages:

 

Source: DistributedCOM

Event ID: 10005

DCOM got error "1053" attempting to start the service DPMRA with arguments "Unavailable" in order to run the server: {DA6AA17A-D61C-4E9C-8CEA-DB25DEA52A95}

 

Source: Service Control Manager

Event ID: 7009

A timeout was reached (30000 milliseconds) while waiting for the DPMRA service to connect.

 

If you try to start DPMRA.exe manually in a command prompt it says that VssRequestor.dll is missing. After copying this file from another server (C:\Program Files\Microsoft Data Protection Manager\DPM\bin\VssRequestor.dll) to C:\Program Files\Microsoft System Center 2012\DPM\DPM\bin the DPMRA starts successfully.

 

Source: http://social.technet.microsoft.com/Forums/en-US/c4a7cbeb-53fa-492f-b300-9f6b7a0f441f/2012-sp1-dcom-1053?forum=dataprotectionmanager

When launching the DPM 2012 R2 update I get stuck at the first step, checking prereqs. The error message says:

 

The instance provided is not a SQL Server instance. Please provide a SQL Server instance.

 

Looking at C:\Program Files\Microsoft System Center 2012 R2\DPM\DPMLogs\DpmSetup.log, I found the following error messages:

 

[11/13/2013 10:03:06 AM] Information : Querying WMI Namespace: \\dpm01\root\Microsoft\SqlServer\ComputerManagement10 for query: Select * from SqlServiceAdvancedProperty where ServiceName='MSSQL$MSDPM2012' and PropertyName='Version'

[11/13/2013 10:03:06 AM] * Exception :  => System.Management.ManagementException: Invalid class

[11/13/2013 10:03:06 AM] Information : Getting the error code for check : SqlServer and result : 67141632

[11/13/2013 10:03:06 AM] Information : Found Error Code:SqlNotInstalled and Severity: Error

[11/13/2013 10:03:06 AM] Information : Got Error Message: The instance provided is not a SQL Server instance. Please provide a SQL Server instance.

[11/13/2013 10:03:06 AM] Information : Got Error Message: The prerequisite (SQL Server 2008) required to perform this check is missing.

As you can see the error messages states that we're asking for an invalid class when querying the wmi namespace. So we need to recompile the SQL WMI provider with the following command:

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"

After doing this, the upgrade proceeds normally.

 

Source: 

http://social.technet.microsoft.com/Forums/en-US/469634e4-eb9b-4c01-8664-fa53cb804763/reinstalling-dpm-keep-failing-and-cant-regonize-our-sql-server-2008-r2?forum=dataprotectionmanager