I got through a seemingly strange issue in production some time back. Its that a Sql job scheduled to run daily on the prod server hung every now and then. The SSIS package never completed execution even days after when it hung. So this had to be carefully monitored and restarted whenever it got hung. Looking at SSIS logs it shows only validation message and no execution at all.
After a lot of research and working with the DBA, it turned out to be that the package tries to truncate and reload some tables. There was also a report which was trying to fetch data from the same table. The package hangs if the report executes the same time that the package started, since the report locks out the table that the package tries to truncate which never happens and enters a deadlock.
After a lot of research and working with the DBA, it turned out to be that the package tries to truncate and reload some tables. There was also a report which was trying to fetch data from the same table. The package hangs if the report executes the same time that the package started, since the report locks out the table that the package tries to truncate which never happens and enters a deadlock.
No comments:
Post a Comment