FIM Reporting initial sync running long time RRS feed

  • Question

  • We have installed FIM Reporting last month , afterwards our FIM reporting initial sync powershell script is running from last month to Sync FIM data with SCSM server , but still only half data is synced with SCSM server ,

    we have 4 server

    1. Server1 --FIM server

    2. Server2 -- FIM database

    2. Server3 -- SCSM service manager  and SQL server Databases for Service manager and Data warehouse

    4. Server4 -- Data warehouse server

    As FIM initial sync script is taking long time to sync so we found some errors in Server 4 (Data warehouse server) multiple times during ETL jobs running.

    Error screen shot

    Please give some suggestions to make FIM initial sync faster

    Saturday, October 11, 2014 11:22 AM

All replies

  • Please try Resume-FIMReportingInitialSync instead of starting initial sync once again.

    Sadly Initial Sync is very long and even on test environments it can take a long time.

    But it seems that data from FIM was successfully moved to reporting database, but it hasn't been calculated by Service Manager correctly between its databases. 

    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.

    Saturday, October 11, 2014 7:16 PM
  • Dominik , I am running Resume-FIMReportingInitialSync  only that is too slow.During ETL jobs I am getting the exception declared above (Time Out Expired)
    Monday, October 13, 2014 7:38 AM
  • Hi ,

    Any suggestions , i am also facing the same issue.


    Monday, October 20, 2014 10:19 AM