ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
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 === {{{{<nowiki> -- 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; </nowiki>}}}} === 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. |- |} {{{{<nowiki> -- 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; </nowiki>}}}} {| 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 |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.