USP_RE7INTEGRATION_LOGERROR

Logs an RE7 Integration error and deletes any old errors from the table.

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@JOBID	uniqueidentifier	IN
@RE7RECORDID	int	IN
@MESSAGE	nvarchar(4000)	IN
@ID	uniqueidentifier	INOUT

Definition

Copy



            CREATE procedure dbo.USP_RE7INTEGRATION_LOGERROR(
                @CHANGEAGENTID uniqueidentifier,
                @JOBID uniqueidentifier,
                @RE7RECORDID int,
                @MESSAGE nvarchar(4000),
        @ID uniqueidentifier = null output
            )
            as
            begin
                set nocount on

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                if @ID is null
                    set @ID = newid();

                insert into dbo.RE7INTEGRATIONERROR(
          ID,
                    JOBID,
                    RE7RECORDID,
                    MESSAGE,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED
                )values(
          @ID,
                    @JOBID,
                    @RE7RECORDID,
                    @MESSAGE,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                )        

                delete from 
                    dbo.RE7INTEGRATIONERROR
                where
                    DATEADDED < dateadd(month, -1, @CURRENTDATE)        
            end