GetFailedMessagesForProcessing

Hello,

   Is the below a Neuron fail message procedure?  Looks like the new one expects a ROW parameter and I was checking to see how I set this value.  I have a C# step where I set the exception message, then call a process that will call the stored procedure.  I've attached a screenshot.

Before Upgrade

ALTER PROCEDURE [dbo].[GetFailedMessagesForProcessing]

AS

BEGIN

      SET NOCOUNT ON;

      SET XACT_ABORT ON

      SET TRANSACTION ISOLATION LEVEL READ COMMITTED

      DECLARE @AuditTable table (

                  Sequence int NOT NULL,

                  Topic nvarchar(355) NULL,

                  MessageId nvarchar(36) NOT NULL,

                  Party nvarchar(100) NOT NULL,

                  Created datetime NOT NULL,

                  Machine nvarchar(15) NOT NULL,

                  Upn nvarchar(255) NULL,

                  failure_type nvarchar(100) NOT NULL,

                  failure_detail nvarchar(500) NOT NULL,

                  failure_date datetime NOT NULL,

                  MessageBody nvarchar(max) NOT NULL,

                  BodyType nvarchar (100) NULL);

      INSERT @AuditTable

      SELECT Sequence,  'Topic'=

After Upgrade

ALTER PROCEDURE [dbo].[GetFailedMessagesForProcessing]

      @Rows int

AS

BEGIN

      SET NOCOUNT ON;

      SET XACT_ABORT ON

      SET TRANSACTION ISOLATION LEVEL READ COMMITTED

      IF(@Rows < 1)

            BEGIN

                  SET @Rows = 1

            END

      DECLARE @AuditTable table (

                  Sequence int NOT NULL,

                  Topic nvarchar(355) NULL,

                  MessageId nvarchar(36) NOT NULL,

                  Party nvarchar(100) NOT NULL,

                  Created datetime NOT NULL,

                  Machine nvarchar(15) NOT NULL,

                  Upn nvarchar(255) NULL,

                  failure_type nvarchar(100) NOT NULL,

                  failure_detail nvarchar(500) NOT NULL,

                  failure_date datetime NOT NULL,

                  MessageBody nvarchar(max) NOT NULL,

                  BodyType nvarchar (100) NULL);

      INSERT @AuditTable

      SELECT TOP (@Rows) Sequence,  'Topic'=

            CASE

EXCEPTION CODE

//get the pipeline exception

Exception ex = (PipelineException)context.Properties["PipelineException"];

string

msg = "Exception: ";

if

(ex.InnerException != null)

{

msg += ex.InnerException.Message;

}

else

{

msg += ex.Message;

}

//trace to designer window

context.Instance.TraceError(msg);

Thanks,