USP_IMPORTPROCESSEXCEPTION_GETLIST

Gets a list of exceptions from an import process run.

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSSTATUSID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_IMPORTPROCESSEXCEPTION_GETLIST(@BUSINESSPROCESSSTATUSID uniqueidentifier)
as
    set nocount on;

    exec dbo.USP_GET_KEY_ACCESS; 

    select IMPORTPROCESSEXCEPTION.ROWNUMBER,
         dbo.UFN_DECRYPT_XMLTOTEXT(IMPORTPROCESSEXCEPTION.ROWDATAXML) [ROWDATA]
    from dbo.IMPORTPROCESSEXCEPTION 
    where BUSINESSPROCESSSTATUSID = @BUSINESSPROCESSSTATUSID and 
    IMPORTPROCESSEXCEPTION.ROWDATAXML is not null
    order by IMPORTPROCESSEXCEPTION.ROWNUMBER;

    close symmetric key sym_BBInfinity;