Dbo.uspLogError (procedure) - Revision history

Bot at 22:15, 23 June 2010

2010-06-23T22:15:46Z

Bot at 21:59, 23 June 2010

2010-06-23T21:59:57Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:16Z

Bot at 21:56, 28 December 2009

2009-12-28T21:56:46Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:49Z

Bot at 05:40, 30 November 2009

2009-11-30T05:40:02Z

Bot at 05:26, 30 November 2009

2009-11-30T05:26:27Z

Bot at 22:58, 26 November 2009

2009-11-26T22:58:46Z

Bot at 22:27, 26 November 2009

2009-11-26T22:27:57Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | dbo.uspLogError |- |}

 -- uspLogError logs error information in the ...

2009-01-03T12:36:17Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | dbo.uspLogError |- |} <pre> -- uspLogError logs error information in the ...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''procedure
| dbo.uspLogError
|-
|}

<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>

@@ Line 84: / Line 84: @@
 | Insert
 | Table
-| [[dbo.ErrorLog_(_(table))|dbo.ErrorLog]]
+| [[dbo.ErrorLog_(table)|dbo.ErrorLog]]
 |- valign="top"
 | Execute
 | Procedure
-| [[dbo.uspPrintError_(_(procedure))|dbo.uspPrintError]]
+| [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
 |}
@@ Line 106: / Line 106: @@
 | Execute
 | Procedure
-| [[HumanResources.uspUpdateEmployeeHireInfo_(_(procedure))|HumanResources.uspUpdateEmployeeHireInfo]]
+| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
+|
@@ Line 113: / Line 113: @@
 | Execute
 | Procedure
-| [[HumanResources.uspUpdateEmployeeLogin_(_(procedure))|HumanResources.uspUpdateEmployeeLogin]]
+| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
+|
@@ Line 120: / Line 120: @@
 | Execute
 | Procedure
-| [[HumanResources.uspUpdateEmployeePersonalInfo_(_(procedure))|HumanResources.uspUpdateEmployeePersonalInfo]]
+| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
+|
@@ Line 127: / Line 127: @@
 | Execute
 | Table
-| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
+| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 | Trigger
@@ Line 134: / Line 134: @@
 | Execute
 | Table
-| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
+| [[Production.WorkOrder_(table)|Production.WorkOrder]]
 | Trigger
@@ Line 141: / Line 141: @@
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Trigger
@@ Line 148: / Line 148: @@
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
 | Trigger
@@ Line 155: / Line 155: @@
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderHeader_(_(table))|Purchasing.PurchaseOrderHeader]]
+| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
 | Trigger
@@ Line 162: / Line 162: @@
 | Execute
 | Table
-| [[Purchasing.Vendor_(_(table))|Purchasing.Vendor]]
+| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
 | Trigger
@@ Line 169: / Line 169: @@
 | Execute
 | Table
-| [[Sales.SalesOrderDetail_(_(table))|Sales.SalesOrderDetail]]
+| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 | Trigger
@@ Line 176: / Line 176: @@
 | Execute
 | Table
-| [[Sales.SalesOrderHeader_(_(table))|Sales.SalesOrderHeader]]
+| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 | Trigger
@@ Line 183: / Line 183: @@
 | Execute
 | Table
-| [[Sales.Store_(_(table))|Sales.Store]]
+| [[Sales.Store_(table)|Sales.Store]]
 | Trigger

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Procedure
 | dbo.uspLogError
@@ Line 8: / Line 8: @@
 | '''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 ===
@@ Line 83: / Line 81: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Insert
 | Table
-| [[dbo.ErrorLog_(table)|dbo.ErrorLog]]
+| [[dbo.ErrorLog_(_(table))|dbo.ErrorLog]]
-|-
+|- valign="top"
 | Execute
 | Procedure
-| [[dbo.uspPrintError_(procedure)|dbo.uspPrintError]]
+| [[dbo.uspPrintError_(_(procedure))|dbo.uspPrintError]]
 |}
@@ Line 105: / Line 103: @@
 | '''Child Object
-|-
+|- valign="top"
 | Execute
 | Procedure
-| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
+| [[HumanResources.uspUpdateEmployeeHireInfo_(_(procedure))|HumanResources.uspUpdateEmployeeHireInfo]]
+|
+|
-|-
+|- valign="top"
 | Execute
 | Procedure
-| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
+| [[HumanResources.uspUpdateEmployeeLogin_(_(procedure))|HumanResources.uspUpdateEmployeeLogin]]
+|
+|
-|-
+|- valign="top"
 | Execute
 | Procedure
-| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
+| [[HumanResources.uspUpdateEmployeePersonalInfo_(_(procedure))|HumanResources.uspUpdateEmployeePersonalInfo]]
+|
+|
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Production.WorkOrder_(table)|Production.WorkOrder]]
+| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
 | Trigger
 | iWorkOrder
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Production.WorkOrder_(table)|Production.WorkOrder]]
+| [[Production.WorkOrder_(_(table))|Production.WorkOrder]]
 | Trigger
 | uWorkOrder
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
 | Trigger
 | iPurchaseOrderDetail
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
+| [[Purchasing.PurchaseOrderDetail_(_(table))|Purchasing.PurchaseOrderDetail]]
 | Trigger
 | uPurchaseOrderDetail
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
+| [[Purchasing.PurchaseOrderHeader_(_(table))|Purchasing.PurchaseOrderHeader]]
 | Trigger
 | uPurchaseOrderHeader
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
+| [[Purchasing.Vendor_(_(table))|Purchasing.Vendor]]
 | Trigger
 | dVendor
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
+| [[Sales.SalesOrderDetail_(_(table))|Sales.SalesOrderDetail]]
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
+| [[Sales.SalesOrderHeader_(_(table))|Sales.SalesOrderHeader]]
 | Trigger
 | uSalesOrderHeader
-|-
+|- valign="top"
 | Execute
 | Table
-| [[Sales.Store_(table)|Sales.Store]]
+| [[Sales.Store_(_(table))|Sales.Store]]
 | Trigger

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''procedure
+| '''Procedure
 | dbo.uspLogError
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 -- uspLogError logs error information in the ErrorLog table about the
@@ Line 74: / Line 76: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 93: / Line 95: @@
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 188: / Line 190: @@
 | iStore
 |}

@@ Line 5: / Line 5: @@
 | '''procedure
 | dbo.uspLogError
 |-
 |}
@@ Line 70: / Line 73: @@
 END;
 </pre>
 == automatically generated ==

@@ Line 77: / Line 77: @@
 | 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.
 |-
 |}

@@ Line 70: / Line 70: @@
 END;
 </pre>
 == automatically generated ==
@@ Line 148: / Line 147: @@
 END;
 </pre>