Email Errors with cleaner Formatting?
I would like to email a cleaner simpler error email to my users when loads fail or partially fail. Can I pull out some of the details from GlobalRunErrors (or GlobalLastError) and rearranged the results to something easier for my users to read?
Sql procedure error codes returned:
Error Number = 305 Stored Procedure taPMTransactionInsert Error Description = Document Number (DOCNUMBR) already exists in the PM00400, PM10000, PM20000, PM30200, POP10300 or the MC020103 Table
Node Identifier Parameters: taPMTransactionInsert
BACHNUMB = IM102820141808
VCHNUMWK = 00000000000008555
VENDORID = CDW
DOCNUMBR = PF14813
DOCTYPE = 5
DOCDATE = 2014-09-03
Related Error Code Parameters for Node : taPMTransactionInsert
Error Description = Document Number (DOCNUMBR = PF14813) already exists in the PM00400, PM10000, PM20000, PM30200, POP10300 or the MC020103 Table
If you would like to submit an answer or comment, please sign in to the eOne portal.