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

*

Tamoxifen for sale Furosemide 40 mg without prescription Cytotec no prescription to buy buy Requip 2mg order Seroquel online canada buy Clomiphene australia buy Seroquel generic order no prescription Metformin online Requip buy Seroquel purchase overnight delivery Seroquel no prescription needed 50mg buy seroquel online without prescription from canada no prescription generic seroquel seroquel for sale canadian pharmacy no prescription seroquel buy seroquel online uk buy seroquel 25 mg seroquel online 50mg how to buy seroquel online seroquel online uk seroquel 50mg canada buy generic seroquel seroquel no script seroquel online without a prescription can you buy seroquel online buy seroquel usa buy seroquel in canada Prednisone on line buy Prednisone overnight buy cheap Prednisone online free consult buy Prednisone on line amex uk buy Prednisone buy cod Prednisone order overnight Prednisone medikament Prednisone Prednisone order online buy Prednisone no scams buy Prednisone mastercard online purchase Prednisone buy cheap Prednisone no prescription buy Prednisone amex online without rx buy Prednisone canada purchasing Prednisone without a script where to buy generic Prednisone online without a prescription Prednisone drug non rx cheap Prednisone order Prednisone cheap overnight fedex Prednisone overnight without a prescription buy Prednisone 20 mg buy Prednisone where Prednisone without prescription overnight shipping purchasing Prednisone without a script Prednisone without rx overnight shipping where to purchase Prednisone no prescription no fees Prednisone online overnight delivery cod Prednisone prescription order order Prednisone without rx from us pharmacy buy Prednisone pills in toronto buy Prednisone online online pharmacies Prednisone buy Prednisone no prescriptions buy Prednisone once a day order Prednisone pay pal online without rx buy Prednisone where buy line Prednisone best finpecia online pill Cytotec purchase overnight delivery where buy Lisinopril purchasing finpecia with overnight delivery no prescription requip buy requip over the counter where can i order requip online how to get arimidex arimidex cheap online buy Requip online australia generic requip no prescription arimidex ordering requip no rx in us requip buying requip online without prescription Requip express online i need to order Requip without a prescription buy Requip from the uk purchase Arimidex order requip without rx arimidex online order where can i buy arimidex without prescriptions buy arimidex generic requip for sale without prescription buy generic arimidex buy requip no prescription needed order requip online overnight shipping cheap generic arimidex no prescription requip buy online no prescription Lisinopril overnight cod cheap order rx metformin prednisone 40 mg cheapest place to buy Metformin purchase Metformin online Maxalt no prescription needed 10mg Maxalt 10mg canada where to buy Maxalt uk buy generic Maxalt canada buy metformin cod discount Cytotec order Cytotec uk purchase Cytotec online no membership overnight shipping best Cytotec online pill Valacyclovir Cytotec want to buy Cytotec in usa Cytotec online overnight delivery cod buy cytotec with a mastercard order Cytotec no rx how to order Cytotec online without a rx how to buy Metformin without a prescription Metformin price buy Alli without prescription