Sunday, March 25, 2012

DTS Error: transaction exceeded allotted time

I receive this error "The transaction has exceeded the allotted time" in a
pop-up sometimes when I use DTS. This happens in an randomly way, when I run a package, when I try to open a package or save it, and normally happens when the machine is very busy with another process.
The packages are saved as Meta Data Services Packages.
I'm running SQL Server 2000 with SP2, and Windows 2000 Advanced
Server with SP2.this may help u

resource timeout Option
Use the resource timeout option to specify the number of seconds to wait for a resource to be released. resource timeout controls the overall time out of asynchronous input/output (I/O) operations. The default setting is 10; any operation that takes longer than 10 seconds to complete results in a time-out warning.

Do not set this value too low or resources may time out in an unrealistically short time. Increase this value if the Microsoft SQL Server error log shows a lot of logwrite or bufwait time-out warnings; this reduces the frequency with which these errors are generated. Allowing a transaction to take more time is often better than allowing it to fail.

resource timeout is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change resource timeout only when show advanced options is set to 1. The setting takes effect immediately (without a server stop and restart).

No comments:

Post a Comment