November 29, 2012 at 3:05 pm
Containers can have some options that can mess with connections, like transactions, but it doesn't sound like you activated them. Go to the sequence containers and make sure they're set to TransactionOption Supported, and Isolation Level Serializable (that's the defaults).
Otherwise, I've never had similar issues to what you describe. I'd double check your Execution settings on the containers however, and make sure they're all set to False and MaximumErrorCount is 1. Once done, if you continue with problems, set delayValidation to True and see if that cures the issue.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
November 29, 2012 at 5:45 pm
+1 @craig-2 regarding "set delayValidation to True"
You will find this setting on nearly every control and I believe on the package level itself
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 30, 2012 at 7:14 am
Evil Kraig F (11/29/2012)
<snip>TransactionOption Supported, and Isolation Level Serializable (that's the defaults).
</snip>
Somehow the TransactionOption had got set to "Required" on the first container, but not the others.
Setting it back to "Supported" provided the expected behavior.
Much appreciated!
November 30, 2012 at 10:01 am
Michael Gerholdt (11/30/2012)
Somehow the TransactionOption had got set to "Required" on the first container, but not the others.Setting it back to "Supported" provided the expected behavior.
Much appreciated!
My pleasure. Sounds like a misclick somewhere along the way then, or something silly happened in the background. Glad that resolved it. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply