1

Resolved

Events switches seem to alter the behaviour

description

SQL Server 9.0.4035 Standard
DTLoggedExec 0.2.3.0
I'm facing a weird behaviour with a script task, but I feel it's bound to db connections which are altered using expressions...
 
EDIT: I reach the idea it depends on the "expression" info DTLoggedExec reports when the "I" flag is used; I think there's something wrong in a routine and the issue gets out every time it's called to manage connections
(see my other error "Exception when logging the POV & PRV events Title is required")
 
Here we go with the long explanation (attached the dtsx I used for testing)
 
A) The package contains:
1) one variable
2) one script task which only prints the variable using Dts.Events.FireInformation
3) two ole db connection:
the first without any expressions is used for logging,
the latter, with two expressions (InitialCatalog and ServerName), is there just for forcing the error
4) full logging
5) no package configuration
 
A) w/o the Information switch (package with expressions)
DTLoggedExec.exe /FILE:C:\CG_Test.dtsx /LE:E
Package end.
Total warnings: 0
Total errors: 0
Elapsed time: 0,3437588 secs.
...Package Executed.
Result: Success
The original log in the SSIS shows the expected information (a bit edited): "OnInformation CG_Test 60953889-5E08-4F99-B8BE-2DAF42EC0911 2009-12-21 15:06:45.000 -1 0x pippo"
 
B) with the Information switch
DTLoggedExec.exe /FILE:C:\CG_Test.dtsx /LE:E,I
 
OnInformation: Script Task
OnError: Script Task
OnError: Script Task
OnError: Script Task
Package end.
Total warnings: 0
Total errors: 3
Elapsed time: 0,2031302 secs.
...Package Executed.
Result: Success
 
The original SSIS log still shows, as reported above, the expected information, but followed by a couple of errors:
"OnError CG_Test 1FB798F8-31A9-48A4-B125-47BC5B52A423 2009-12-21 15:08:42.000 2 0x The script threw an exception: Value does not fall within the expected range."
"5 0x The script files failed to load."
"-1073594108 0x The Execute method on the task returned error code 0x80070057 [...]. The Execute method must succeed, and indicate the result using an "out" parameter.
 
C) with the Information switch, BUT I MODIFIED THE PACKAGE TO REMOVE ONE OF THE EXPRESSIONS
DTLoggedExec.exe /FILE:C:\CG_Test.dtsx /LE:E,I
 
OnInformation: Script Task
    Package Name:           CG_Test
    Task Type:              ScriptTask (Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask, Microsoft.SqlServer.ScriptTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91)
    Description:            Script Task
    Object ID:              {375E1F62-61C1-480E-898D-9D7BC74CE904}
    Container Name:         CG_Test
    Container ID:           {C05C08CC-45F0-47F4-9100-D21C6E4BA3DC}
    StartTime:              21/12/2009 15:18:40
    EndTime:                21/12/2009 15:18:41
    Message:                localhost
    Variables:
            \Package.Variables[User::ConfigCatalog] = msdb
            \Package.Variables[User::ConfigServer] = localhost
    Expressions:
            \Package.Connections[OLEDB_Config].Properties[ServerName]: localhost
 
Package end.
Total warnings: 0
Total errors: 0
Elapsed time: 0,1718057 secs.
...Package Executed.
Result: Success

file attachments

comments

manowar wrote May 3, 2010 at 2:05 PM

Thanks a lot for the feedback. I've been able to repro the problem and I found a problem in the "GetPropertiesWithExpressions" method both in CSV and Console Log Provider. It has been fixed in the just release version 1.0