1
Vote

Exception when using Get Log Data activity from Standard Logging

description

When I try to use the Get Log Data activity from the Standard Logging integration pack it throws the following exception:

Data is Null. This method or property cannot be called on Null values.

Exception: SqlNullValueException
Target site: SqlBuffer.get_String

Stack trace:
at System.Data.SqlClient.SqlBuffer.get_String()
at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)
at StandardLogging.ExecuteSQL.GetSQLResults(Int32 spID, List`1 parameters, String sqlServer, String sqlDB, Boolean sqlTrustedConnection, String sqlUserID, String sqlPassword)
at StandardLogging.GetLogData.Execute(IActivityRequest request, IActivityResponse response)========================

The activity is using the same configuration settings as the Start and Success activities which are able to create and update records in the DB.

The exception occurs whether a filter is applied or not.

Does anyone know how to fix this?

comments