Skip to content

Installing FIM R2 Reporting against Sytem Center 2012 R2 and SQL 2012

I’ve just installed FIM R2 reporting in an environment that had an existing System Center Data Warehouse infrastructure based on SC 2012 R2 and SQL 2012. I had a couple of problems along the way so here are the troubleshooting notes.

System Center Service Manager Console Not Installed

I got an error right after entering the name of the Management Server during the installation of Reporting: “Some required components are not installed on this computer. Please refer to the latest Forefront Identity Manager Service and Portal deployment guide for Reporting and install the required components before continuing.” The title of the box was “System Center Service Manager Console Not Installed”.

As I was installing this in the three server mode (SCSM and SCDW on seperate servers to the FIM Service) I had missed the requirement to install the SCSM Console on the FIM Server. I installed this from the SCSM installation media.

System Center Service Manager update Not Installed

“The System Center Service Manager update (KB2561430) is not installed on this computer. Please make sure you install this update on the console, management server, and data warehouse machines before continuing.”

This one was fixed in a FIM hotfix, so I just installed the latest version and all was good.

Thanks to David Steadman for this info: http://blogs.technet.com/b/steady/archive/2013/06/12/fim-2010-r2-sp1-reporting-failure-scsm-2012-sp1-you-must-apply-patch.aspx.

The term ‘Get-SCDWJob’ is not recognized

The next problem was with running the script FIMPostInstallScriptsForDataWarehouse.ps1 on the SCDW server.

It turns out that SC 2012 R2 no longer has the SMCmdletSnapIn, which has been replaced by a Module. In addition SQL 2012 doesn’t use the snapins loaded in the script.

PowerShell was clever enough to load the SQL module automatically when the first SQL cmdlet was called, so all I had to do to the script was comment out the SQL snapins. For SC I needed to replace the Add-PSSnapin line with an Import-Module. Once I made these changes the script ran correctly.

function Install-Sql-Server-Snapins
{ 
 #add-pssnapin $SQLServerCmdletsSnapIn -ErrorAction SilentlyContinue | Out-Null
 #add-pssnapin $SQLServerProviderSnapIn -ErrorAction SilentlyContinue | Out-Null
}
function Install-Service-Manager-Snapin
{
 #add-pssnapin $ServiceManagerSnapIn -ErrorAction SilentlyContinue | Out-Null
 import-module 'C:\Program Files\Microsoft System Center 2012 R2\Service Manager\Microsoft.EnterpriseManagement.Warehouse.Cmdlets.dll'
}

Thanks to Brian Desmond for help with this!

Transform.Common job failing

No data appears in the FIM reports until the following three Data Warehouse jobs have run (in order shown):

  • Extract_DWName
  • Transform.Common
  • Load.Common

My Transform.Common job  said “Failed”. Looking through the list of tasks I could see that TransformEntityRelatesToEntityFact and TransformEntityManagedTypeFact had failed. Looking in the Operations Manager event log on the SCDW server I could see they both failed with this message: “Cannot find either column “ETL” or the user-defined function or aggregate “ETL.CanContinueExecution”, or the name is ambiguous.”

Luckily for me others have had this problem before. The creation of the missing SQL function as proposed by Dimitar S on this thread sorted out the problem for me: http://social.technet.microsoft.com/Forums/systemcenter/en-US/096fd3e1-61fd-4101-a4e6-1de0c6c5ec4c/scsm-2012-transform-job-failing-in-datawarehouse?forum=systemcenterservicemanager

{ 2 } Comments

  1. Jef Kazimer | January 17, 2014 at 8:54 pm | Permalink

    Also useful is the ETL script for use against 2012. http://gallery.technet.microsoft.com/PowerShell-Script-to-Run-a4a2081c

  2. Eihab Isaac | April 16, 2014 at 12:27 am | Permalink

    Thank you Carol for the post. It helped us a lot.

Post a Comment

Your email is never published nor shared. Required fields are marked *

Spam comments will be blocked by Akismet

*

Endep online order order buy Endep online purchase Endep online without script buy generic Endep from india buy in Endep uk where to buy Endep without a prescription Endep from canada buy 10 mg Aricept generic Aricept cost order Nizoral no visa Nizoral 200 mg buy cheap Nizoral line Nizoral on line best finpecia online pill Requip Requip free Requip uk Amitriptyline generic buy generic Amitriptyline from india where buy Lisinopril purchasing finpecia with overnight delivery Nizoral online buy saturday delivery buy Nizoral in mo how to buy Cytotec online without a rx order Aricept pharmacy buy Aricept with no prescription buy Amitriptyline no perscription cod Online us Requip how to buy Amitriptyline without a prescription buy line Amitriptyline buy Amitriptyline money buy purchase Accutane 40 mg on line no rx Accutane 40 mg sale order 40 mg Accutane online next day delivery 40 mg Accutane online buy Lisinopril pay cod Lisinopril overnight cod buy lisinopril without prescription buy lisinopril purchase Premarin cod next day delivery where buy Premarin buy Premarin online free fedex delivery Premarin no rx Metformin buy Metformin canada cheapest place to buy Metformin purchase Metformin online generic 20mg prednisone online finpecia online overnight buy generic Finpecia uk online|Finpecia 1 mg order online|Finpecia generic vs propecia|Finpecia cost australia|buy generic Finpecia uk|purchase Finpecia uk|buy Finpecia online prescription|buy generic Finpecia 1mg|buy Finpecia|Finpecia online australia|buy Finpecia no prescription uk|order Finpecia 1mg|buy Finpecia cheap|Finpecia generic 1mg|Finpecia online prescription|Finpecia 1mg generic canada|Finpecia costco pharmacy|Finpecia 1mg india|Finpecia generic walmart|buy Finpecia no prescription forum|buy Finpecia online australia|Finpecia online uk) buy finpecia cheap legal buy Finpecia online online|buy cheap Finpecia online|order Finpecia|Finpecia generic walmart|Finpecia online prescription|buy Finpecia 1mg online|Finpecia generic online|Finpecia costco price|order Finpecia online|buy Finpecia 1mg malaysia|purchase Finpecia uk|topical Finpecia buy|Finpecia 1 mg order online|Finpecia generic|buy Finpecia online canada|Finpecia 1 mg order online|Finpecia online india|Finpecia generic 1 mg|order Finpecia uk|Finpecia depression women|buy cheap Finpecia 1mg|Finpecia generic names|legal buy Finpecia online|Finpecia depression women|buy Finpecia 1mg india|Finpecia generic walmart|buy Finpecia 1mg online|Finpecia online india|buy Finpecia 1mg online|Finpecia 1mg tablets|Finpecia costco price|order Finpecia canada|buy Finpecia online australia|Finpecia dose hair|buy Finpecia online paypal|Finpecia 1mg|Finpecia 1mg for sale|Finpecia online uk|buy Finpecia uk|Finpecia 1mg vs 1mg|Finpecia generic walmart|Finpecia costco pharmacy|buy Finpecia on buy Metformin toronto uk order Metformin Metformin online Metformin prescription buy Metformin where order finpecia canada buy finpecia order Metformin usa online Orlistat buy buy in Orlistat uk buy prednisone topix buy prednisone youtube Orlistat toronto buy discount Orlistat line buy cheap Orlistat without prescription prednisone prescription cost Metformin order online pharmacy Metformin how to buy Metformin without a prescription Metformin price lisinopril buy lisinopril