MSCM Error Log Notification

kim-gonzalez

Does anyone have an automated error log reporting process set up to notify someone if there are upload errors? This would be something like an e-mail to notify of an authentication or upload error just in case someone forgets to go in and check the staus of their handheld uploads.

unknown

We recently asked our IT to set up a smart note email to our group when an error occurs, using the table query below.

SELECT DISTINCT PMSCM_EVENT_HEADER.EVENT_HEADER_ID, PMSCM_EVENT_DETAIL.EVENT_DETAIL_SEQ, PMSCM_EVENT_HEADER.EVENT_TYPE, PMSCM_EVENT_HEADER.HEADER_UPLOAD_IND, PMSCM_EVENT_HEADER.HH_SYNC_TIMESTAMP, PMSCM_EVENT_HEADER.CREATION_DT, PMSCM_ERROR_LOG.FORM_NAME, PMSCM_ERROR_LOG.MESSAGE_TEXT, PMSCM_ERROR_LOG.EVT_DETAIL_SEQ, PMSCM_EVENT_DETAIL.ITEM_ID, PMSCM_EVENT_DETAIL.REQUIRING_BIN_NO, PMSCM_EVENT_DETAIL.QUANTITY, PMSCM_EVENT_DETAIL.UOM, PMSCM_USERS.FIRST_NAME, PMSCM_USERS.LAST_NAME, PMSCM_LOCATION.LOCATION_CODE, PMSCM_LOCATION.NAME, PMSCM_ITEM.ITEM_NO, PMSCM_ITEM.DESCR
FROM ((((PMSCM_EVENT_HEADER INNER JOIN PMSCM_EVENT_DETAIL ON PMSCM_EVENT_HEADER.EVENT_HEADER_ID = PMSCM_EVENT_DETAIL.EVENT_HEADER_ID) INNER JOIN PMSCM_ERROR_LOG ON (PMSCM_EVENT_DETAIL.EVENT_DETAIL_SEQ = PMSCM_ERROR_LOG.EVT_DETAIL_SEQ) AND (PMSCM_EVENT_HEADER.EVENT_HEADER_ID = PMSCM_ERROR_LOG.EVT_HEADER_ID)) INNER JOIN PMSCM_USERS ON PMSCM_EVENT_HEADER.USER_ID = PMSCM_USERS.USER_ID) INNER JOIN PMSCM_LOCATION ON PMSCM_EVENT_HEADER.EVENT_HEADER_GT_01 = PMSCM_LOCATION.LOCATION_ID) LEFT JOIN PMSCM_ITEM ON PMSCM_EVENT_DETAIL.ITEM_ID = PMSCM_ITEM.ITEM_ID
WHERE (((PMSCM_EVENT_HEADER.EVENT_TYPE)='PAR') AND ((PMSCM_EVENT_HEADER.HEADER_UPLOAD_IND)='UPLERR') AND ((PMSCM_EVENT_HEADER.HH_SYNC_TIMESTAMP)>#4/14/2015#));