USP_WPPARSINGERROR_ADD

Adds WealthPoint data parsing errors.

Parameters

Parameter	Parameter Type	Mode
@WPSEARCHHISTORYID	uniqueidentifier	IN
@DATATABLENAME	nvarchar(100)	IN
@LOCATION	nvarchar(100)	IN
@ROWERROR	nvarchar(255)	IN
@PARENTID	uniqueidentifier	IN
@ERRORROWIDENTIFIER	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ERRORDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_WPPARSINGERROR_ADD (
                @WPSEARCHHISTORYID uniqueidentifier,
                @DATATABLENAME nvarchar(100) = '',
                @LOCATION nvarchar(100) = '',
                @ROWERROR nvarchar(255),
                @PARENTID uniqueidentifier = null,
                @ERRORROWIDENTIFIER nvarchar(100) = '',
                @CHANGEAGENTID uniqueidentifier = null,
        @ERRORDATE datetime = null
            ) as begin
                set nocount on;

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

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

                begin try
                    insert into dbo.WPPARSINGERROR (
                        WPSEARCHHISTORYID,
                        DATATABLENAME,
                        LOCATION,
                        ROWERROR,
                        PARENTID,
                        ERRORROWIDENTIFIER,
                        ERRORDATEUTC,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values (
                        @WPSEARCHHISTORYID,
                        @DATATABLENAME,
                        @LOCATION,
                        @ROWERROR,
                        @PARENTID,
                        @ERRORROWIDENTIFIER,
                        @ERRORDATE,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE
                    );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;
            end