ETL jobs are stucked RRS feed

  • Question

  • We installed SCSM 2010 for reporting to Forefront identity manager. It was working fine till last month. From last month ETL jobs are running but current data is not coming in reporting. While current data is there service manager database. ETL jobs status is in running only , from long. Looks like ETL jobs have hanged as there is not any event being generated in Eventviewer under operations manager for ETL jobs from last month. Tried restarting services but still there is not any event for ETL. We checked in SCSM console , there ETL job modules are being stucked in running state

    Through powershell , we run Get-SCDWJobModules for module status and error. From there we noticed , for few modules  error are coming

    "Cannot open database ""DWRepository"" requested by the login. The login failed. Login failed for user 'domain\scsm_admin' "

    while scsm_admin is a sysadmin and dbowner for DWRepository. And it was working fine before.

    There were some more errors in modules as "TimeOut Exception" and "Dead locked resources"

    Could any body help us in this ?

    Dushyant Singh

    Thursday, May 19, 2016 2:11 PM

All replies

  • check permissions. DBAs do that all the time, revoke access.

    Nosh Mernacaj, Identity Management Specialist

    Wednesday, May 25, 2016 5:36 PM