1

Resolved

Exception when logging the POV & PRV events

description

Version: 0.2.3.0
The use of the POV and PRV switches fires an exception.
 
I tried with a fully empty package (no tasks) with neither loggging nor package configuration. The package only contains an oledb connection which uses a couple of expressions altering InitialCatalog and ServerName.
I cannot see any reason, but DTLoggedExec crashes only when the connection alters both the properties; if I change just InitialCatalog or ServerName it works...
 
C:\DTLoggedExec\DTLoggedExec\bin\Any\Release\DTLoggedExec.exe /FILE:CG_Test.dtsx /LE:POV,E
All the best
pf
 
EDIT: kindly read the "Events switches seem to alter the behaviour" ticket too as there's a common issue bound to connections.
 
Here below the exception when using POV:
Unhandled Exception: System.ArgumentException: An item with the same key has already been added.
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at DTLoggedExec.LogProviders.CSVLogProvider.GetPropertiesWithExpressions(IDTSPropertiesProvider dpp)
at DTLoggedExec.LogProviders.CSVLogProvider.GetExpressions(Package package)
at DTLoggedExec.LogProviders.CSVLogProvider.LogEventData(String eventName, DtsObject dtsobj, String message)
at DTLoggedExec.CustomEventHandler.LogData(String eventName, DtsObject dtsobj) in C:\Work\SSIS Logging\DTLoggedExec\DTLoggedExec\CustomEventHandler.cs:line 250
at DTLoggedExec.CustomEventHandler.OnPreValidate(Executable exec, Boolean& fireAgain) in C:\Work\SSIS Logging\DTLoggedExec\DTLoggedExec\CustomEventHandler.cs:line 176
at Microsoft.SqlServer.Dts.Runtime.ReverseIDTSEventsWrapper.OnPreValidate(IDTSExecutable90 exec, Boolean& fireAgain)
at Microsoft.SqlServer.Dts.Runtime.DtsContainer.Execute(Connections connections, Variables variables, IDTSEvents events, IDTSLogging log, Object transaction)
at DTLoggedExec.Program.ExecutePackage(Package package, String[] configurations, String[] values, String[] rparams, CustomEventHandler customEventHandler) in C:\Work\SSIS Logging\DTLoggedExec\DTLoggedExec\Program.cs:line 278
at DTLoggedExec.Program.Main(String[] args) in C:\Work\SSIS Logging\DTLoggedExec\DTLoggedExec\Program.cs:line 149

comments

manowar wrote May 3, 2010 at 1:36 PM

Hi, can you please attach the CG_Test.dtsx file? I did some test but I haven't been able to reproduce the error.

PGFIORE wrote May 5, 2010 at 9:44 AM

The CG_Test.dtsx package is already attached to the other issue I opened, the #25738; it is exactly the same. Ciao pf