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

*

buy next day metformin prednisone oral tablet no prescription discount buy cheapest metformin prezzo premarin premarin drug i want to buy pregnizone without a prescription buy arimidex online us pharmacy buy premarin where synthroid non rx fedex overnight free buy synthroid generic premarin delivered overnight prescription finasteride online finasteride non prescription requip prices buy premarin where purchase online arimidex without rx where to purchase generic premarin online without a prescription arimidex mexico buy online premarin without rx buy no online rx valacyclovir purchase premarin without a rx online online pharmacy premarin where can i buy prednisone cheap orlistat no prescription purchase arimidex amex online without rx buy arimidex on line cheap premarin by money order requip online prescription arimidex cheap mexican purchase synthroid no visa without prescription where can i buy requip synthroid overnight no consult buy finasteride without buy cheap metformin with dr. prescription metformin metformin buy synthroid online with overnight delivery synthroid c.o.d. buy finpecia no prescription buy arimidex with no prescription buy no perscription premarin finasteride with free fedex overnight online pharmacy finasteride no prescription canada requip buy orlistat oral purchase finasteride online with overnight delivery generic synthroid tablets buy premarin diet pill prednisone fedex canadian synthroid diet pills without a prescription finasteride free consultation fedex overnight delivery order orlistat without rx where can i buy some prednisone online only using cash or money orders buy mail order arimidex cheap arimidex no rx non presciption finasteride buying synthroid without a prescription requip buy buy prednisone without a percsription buy cheap lisinopril without prescription no rx arimidex buy cheap seroquel online buy metformin in the uk order cheap overnight finasteride premarin delivered overnight synthroid no dr synthroid without a prescription or membership buy premarin where order buy requip online premarin mexico buy finpecia online paypal buy seroquel money buy premarin buy fedex c.o.d synthroid prednisone with out a prescription buy in metformin uk next day delivery on premarin saturday metformin canadian pharmacy prednisone online finasteride order online no membership overnight purchase cheap online lisinopril where to purchase cheap lisinopril no rx buy synthroid overnight delivery synthroid shipped c.o.d. buy prednisone no prescription valacyclovir requip