EPM Framework and SQL 2012

Jan 17, 2013 at 9:32 AM

hi,

Does EPM works on SQL 2012 and for SQL 2012 Servers?

Does someone have experience with that kind of configuration?

Thanks,

Regards,

Y

Coordinator
Feb 13, 2013 at 1:47 PM
I'll test locally and get back to you.
Coordinator
Feb 13, 2013 at 9:12 PM

Awesome! Thanks Jorge!

From: sqlchicken [email removed]
Sent: Wednesday, February 13, 2013 7:47 AM
To: Lara Rubbelke
Subject: Re: EPM Framework and SQL 2012 [EPMFramework:429875]

From: sqlchicken

I'll test locally and get back to you.

Feb 18, 2013 at 10:19 AM
hi,

I have installed EPM on a SQL 2012 and it works fine.

Thanks,
Regards,
Apr 29, 2014 at 11:08 PM
wonder if I can still participate in this thread. I have attempted to setup the EPM framework in SQL v2012. I am using exactly the steps mentioned here:
https://epmframework.codeplex.com/SourceControl/latest

I am inputting this into the SQL Server Powershell window:

SL "D:\directoryname\”
.\EPM_EnterpriseEvaluation_3.0.0.ps1 -ConfigurationGroup "" -PolicyCategoryFilter "" –EvalMode “Check”

NOTE: I am not putting a ConfigurationGroupName in there because on all previous attempts, when I had passed it in, the program did nothing. Having removed the ConfigGroupName, it actually does a lot. Goes along for quite some time, presumably evaluating policies. Ultimately, there is no policy data created. I just have a huge page of what appears to be the same error again and again:

Invoke-PolicyEvaluation : Property 'IsHadrEnabled' does not exist.
At D:\directoryname\EPM_EnterpriseEvaluation_3.0.0.ps1:81 char:27
  • Invoke-PolicyEvaluation <<<< -Policy $Policy -TargetServerName $
    ServerName -AdHocPolicyEvaluationMode $EvalMode -OutputXML > $OutputFile;
    • CategoryInfo : NotSpecified: (:) [Invoke-PolicyEvaluation], Mis
      singPropertyException
    • FullyQualifiedErrorId : PolicyEvaluationError,Microsoft.SqlServer.Manage
      ment.PowerShell.InvokePolicyEvaluationCommand
PS D:\directoryname >




Do any of you have any ideas?
Aug 4, 2014 at 3:46 PM
lewisrl wrote:
Do any of you have any ideas?
Since SQL Server 2012 has System Policies for viewing the health of Availability Groups, the PowerShell script will run Invoke-PolicyEvaluation for each Policy in the store.
A System Condition used in the AlwaysOn System Policies checks the Server Property "IsHadrEnabled" , but that property doesn't exist for versions lower than SQL Server 2012.

I modified the PowerShell script to skip all policies with a name starting with "AlwaysOn" and the script ran without errors.

Replace
        if (($Policy.PolicyCategory -eq $PolicyCategoryFilter)-or ($PolicyCategoryFilter -eq "")) 
with
        if (($Policy.PolicyCategory -eq $PolicyCategoryFilter)-or ($PolicyCategoryFilter -eq "") -and ($policy.name -notlike "AlwaysOn*"))