Editing Dbo.uspLogError (procedure)

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Procedure
| dbo.uspLogError
|- valign="top"
| '''Description
| Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.
|}

=== Source ===
<pre>
-- uspLogError logs error information in the ErrorLog table about the 
-- error that caused execution to jump to the CATCH block of a 
-- TRY...CATCH construct. This should be executed from within the scope 
-- of a CATCH block otherwise it will return without inserting error 
-- information. 
CREATE PROCEDURE [dbo].[uspLogError] 
    @ErrorLogID [int] = 0 OUTPUT -- contains the ErrorLogID of the row inserted
AS                               -- by uspLogError in the ErrorLog table
BEGIN
    SET NOCOUNT ON;

    -- Output parameter value of 0 indicates that error 
    -- information was not logged
    SET @ErrorLogID = 0;

    BEGIN TRY
        -- Return if there is no error information to log
        IF ERROR_NUMBER() IS NULL
            RETURN;

        -- Return if inside an uncommittable transaction.
        -- Data insertion/modification is not allowed when 
        -- a transaction is in an uncommittable state.
        IF XACT_STATE() = -1
        BEGIN
            PRINT 'Cannot log error since the current transaction is in an uncommittable state. ' 
                + 'Rollback the transaction before executing uspLogError in order to successfully log error information.';
            RETURN;
        END

        INSERT [dbo].[ErrorLog] 
            (
            [UserName], 
            [ErrorNumber], 
            [ErrorSeverity], 
            [ErrorState], 
            [ErrorProcedure], 
            [ErrorLine], 
            [ErrorMessage]
            ) 
        VALUES 
            (
            CONVERT(sysname, CURRENT_USER), 
            ERROR_NUMBER(),
            ERROR_SEVERITY(),
            ERROR_STATE(),
            ERROR_PROCEDURE(),
            ERROR_LINE(),
            ERROR_MESSAGE()
            );

        -- Pass back the ErrorLogID of the row inserted
        SET @ErrorLogID = @@IDENTITY;
    END TRY
    BEGIN CATCH
        PRINT 'An error occurred in stored procedure uspLogError: ';
        EXECUTE [dbo].[uspPrintError];
        RETURN -1;
    END CATCH
END;
</pre>

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type
| '''Object Type
| '''Referenced Object

|- valign="top"
| Insert
| Table
| [[dbo.ErrorLog_(_(table))|dbo.ErrorLog]]

|- valign="top"
| Execute
| Procedure
| [[dbo.uspPrintError_(_(procedure))|dbo.uspPrintError]]

|}

=== Dependencies ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type
| '''Object Type
| '''Referencing Object

| '''Child Type
| '''Child Object

|- valign="top"
| Execute
| Procedure
| [[HumanResources.uspUpdateEmployeeHireInfo_(_(procedure))|HumanResources.uspUpdateEmployeeHireInfo]]

| 
| 
|- valign="top"
| Execute
| Procedure
| [[HumanResources.uspUpdateEmployeeLogin_(_(procedure))|HumanResources.uspUpdateEmployeeLogin]]

| 
| 
|- valign="top"
| Execute
| Procedure
| [[HumanResources.uspUpdateEmployeePersonalInfo_(_(procedure))|HumanResources.uspUpdateEmployeePersonalInfo]]

| 
| 
|- valign="top"
| Execute
| Table
| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]

| Trigger
| iWorkOrder
|- valign="top"
| Execute
| Table
| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]

| Trigger
| uWorkOrder
|- valign="top"
| Execute
| Table
| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]

| Trigger
| iPurchaseOrderDetail
|- valign="top"
| Execute
| Table
| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]

| Trigger
| uPurchaseOrderDetail
|- valign="top"
| Execute
| Table
| [[Purchasing.PurchaseOrderHeader_(_(table))|Purchasing.PurchaseOrderHeader]]

| Trigger
| uPurchaseOrderHeader
|- valign="top"
| Execute
| Table
| [[Purchasing.Vendor_(_(table))|Purchasing.Vendor]]

| Trigger
| dVendor
|- valign="top"
| Execute
| Table
| [[Sales.SalesOrderDetail_(_(table))|Sales.SalesOrderDetail]]

| Trigger
| iduSalesOrderDetail
|- valign="top"
| Execute
| Table
| [[Sales.SalesOrderHeader_(_(table))|Sales.SalesOrderHeader]]

| Trigger
| uSalesOrderHeader
|- valign="top"
| Execute
| Table
| [[Sales.Store_(_(table))|Sales.Store]]

| Trigger
| iStore
|}


== automatically generated ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''procedure
| dbo.uspLogError
|- valign="top"
| '''Description
| Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.
|-
|}

<pre>

-- uspLogError logs error information in the ErrorLog table about the 
-- error that caused execution to jump to the CATCH block of a 
-- TRY...CATCH construct. This should be executed from within the scope 
-- of a CATCH block otherwise it will return without inserting error 
-- information. 
CREATE PROCEDURE [dbo].[uspLogError] 
    @ErrorLogID [int] = 0 OUTPUT -- contains the ErrorLogID of the row inserted
AS                               -- by uspLogError in the ErrorLog table
BEGIN
    SET NOCOUNT ON;

    -- Output parameter value of 0 indicates that error 
    -- information was not logged
    SET @ErrorLogID = 0;

    BEGIN TRY
        -- Return if there is no error information to log
        IF ERROR_NUMBER() IS NULL
            RETURN;

        -- Return if inside an uncommittable transaction.
        -- Data insertion/modification is not allowed when 
        -- a transaction is in an uncommittable state.
        IF XACT_STATE() = -1
        BEGIN
            PRINT 'Cannot log error since the current transaction is in an uncommittable state. ' 
                + 'Rollback the transaction before executing uspLogError in order to successfully log error information.';
            RETURN;
        END

        INSERT [dbo].[ErrorLog] 
            (
            [UserName], 
            [ErrorNumber], 
            [ErrorSeverity], 
            [ErrorState], 
            [ErrorProcedure], 
            [ErrorLine], 
            [ErrorMessage]
            ) 
        VALUES 
            (
            CONVERT(sysname, CURRENT_USER), 
            ERROR_NUMBER(),
            ERROR_SEVERITY(),
            ERROR_STATE(),
            ERROR_PROCEDURE(),
            ERROR_LINE(),
            ERROR_MESSAGE()
            );

        -- Pass back the ErrorLogID of the row inserted
        SET @ErrorLogID = @@IDENTITY;
    END TRY
    BEGIN CATCH
        PRINT 'An error occurred in stored procedure uspLogError: ';
        EXECUTE [dbo].[uspPrintError];
        RETURN -1;
    END CATCH
END;
</pre>


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type
| '''Object Type
| '''Referenced Object

|-
| Insert
| Table
| [[dbo.ErrorLog_(table)|dbo.ErrorLog]]

|-
| Execute
| Procedure
| [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]

|}


{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Reference Type
| '''Object Type
| '''Referencing Object

| '''Child Type
| '''Child Object

|-
| Execute
| Procedure
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]

| 
| 
|-
| Execute
| Procedure
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]

| 
| 
|-
| Execute
| Procedure
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]

| 
| 
|-
| Execute
| Table
| [[Production.WorkOrder_(table)|Production.WorkOrder]]

| Trigger
| iWorkOrder
|-
| Execute
| Table
| [[Production.WorkOrder_(table)|Production.WorkOrder]]

| Trigger
| uWorkOrder
|-
| Execute
| Table
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]

| Trigger
| iPurchaseOrderDetail
|-
| Execute
| Table
| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]

| Trigger
| uPurchaseOrderDetail
|-
| Execute
| Table
| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]

| Trigger
| uPurchaseOrderHeader
|-
| Execute
| Table
| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]

| Trigger
| dVendor
|-
| Execute
| Table
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]

| Trigger
| iduSalesOrderDetail
|-
| Execute
| Table
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]

| Trigger
| uSalesOrderHeader
|-
| Execute
| Table
| [[Sales.Store_(table)|Sales.Store]]

| Trigger
| iStore
|}