I'm attempting to implement the SSIS Management Framework and I think I did everything as I was told, except in order to get it approved by our architects I had to change the BatchLog table to PackageGroupLog and I changed the variables with Batch in the name to have PackageGroup instead. Anyway, I built the tables and procs and the template package and I'm attempting to run it from BIDS before making the copy for others to use.

So on the LogPackageStart Execute SQL Task I'm getting errors like:

Error: 0xC001405B at SQL LogPackageError: A deadlock was detected while trying to lock variable "User::PackageLogID" for read access. A lock could not be acquired after 16 attempts and timed out.

(I created a variable for this although there were not specific instructions to do so it seemed required to fill in the result set parameters.)

I get this one
Warning: 0x8001201A at SSIS_PDS_Template: Configuration from a parent variable "PackageGroupLogID" did not occur because there was no parent variable collection.
( I get this warning on my equivilent to the BatchLogId variable I created )


Anyone else have similar problems or know what I did wrong?

I also get these others in case they are helpful:
Error: 0xC00291EA at SQL LogPackageError, SQL Task: Variable "User::PackageLogID" does not exist.

Error: 0xC0024107 at SQL LogPackageError: There were errors during task validation.

Warning: 0x80019002 at OnError: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

Error: 0xC001F009 at SSIS_PDS_Template: The type of the value being assigned to variable "User::EndPackageGroupAudit" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.

Warning: 0x80019002 at OnError: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

I worked past the problem by changing the type of "EndBatchAudit" to INT both in my proceedures and in the package, but I think the problem was that I typed it as Byte in SSIS when it was at its original type of BIT in the Stored Proc. (I should have typed it as INT16 or maybe boolean in ssis)

Anyway, when I did that the deadlock on the other variable went away.

TEvers,

I'm so glad you were able to fix your problem.

For future references or for others who may have similar errors, here are reasons they may occur:

• Referring to a variable that is out of scope of the calling task
• Misspelled or Case mismatching of variables
• Different data types for setting or retrieving parent-child variables

I hope the rest of the framework is working well for you now!
Jessica