infor.com
concierge
infor u
developer portal
Home
Groups
Lawson - Supply Chain Management Customer Community [READ ONLY]
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.
Find more posts tagged with
Infor Lawson Supply Chain Management - Discussion
Comments
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#));
moellerg
Denny:
Where is the PMSCM_EVENT_HEADER table at? I can't seem to find it on our system.
Thanks,
-Greg
unknown
The data is actually pulled from the PMSCM_ERROR_LOG table in the MSCM PROD ODBC tables.
kim-gonzalez
Thank you all for the information.
moellerg
I'm connected to the MSCM prod database, but I don't have any tables beginning with PMSCM... Could this be a version difference, or did you come up with a view or something different?
unknown
Using Toad for SQL database I see the table called 'ERROR_LOG' .. I didn't realize that the upload errors were in this but yep there they are!
unknown
I didn't think of that, Greg. I may very well be a version or config variable we have from our design phase years ago. But it is the ERROR_LOG though
Stace Webley
@Greg
Moeller, if you are on v9.0.1 replace PMSCM with MSCMP.
Rhythm for Commerce Customer Newsletter August September 2020.pdf
moellerg
Got it figured out.... just needed to remove PMSCM_ and fiddle with the date parameter a little since we are on Oracle.
Works great!! Thanks, all!
EDI Anforderung Daimler.pdf
unknown
Just as an addendum, we have had problems with MSCM simply hanging. The log files all look good, but things mysteriously stop processing. So I wrote the following which I plugged into our monitoring script to make sure stuff in MSCM didn't stop processing
echo "MSCM Process Check">>$LAWDIR/JOB_MONITOR.log
#MSCM check for counts pending upload
rm $FTPGLIN/mscmstat.lst
rm $FTPGLIN/mscmstat1.lst
#first match waiting counts against counts that were waiting last run
(echo "$LOGIN/$PASSWD1@$ORACLE_SID1
spool $FTPGLIN/mscmstat.lst;
select count(*)
from lawson.event_detail@prd9 a, MSCM_EVENT_PNDUPL b
where a.event_header_id=b.event_header_id
and a.event_detail_seq=b.event_detail_seq
and a.detail_upload_ind=b.detail_upload_ind
and a.creation_dt=b.creation_dt;
spool off;") | sqlplus
sed -e '1,9d' $FTPGLIN/mscmstat.lst > $FTPGLIN/mscmstat1.lst
more $FTPGLIN/mscmstat1.lst | read mscmstat
# echo $mscmstat
#now reload the file of counts pending
(echo "$LOGIN/$PASSWD1@$ORACLE_SID1
delete from MSCM_EVENT_PNDUPL;
commit;
insert into MSCM_EVENT_PNDUPL
(select event_header_id, event_detail_seq, detail_upload_ind, creation_dt
from lawson.event_detail@prd9
where detail_upload_ind='PNDUPL');
COMMIT;
") | sqlplus
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Popular Tags
Infor Lawson Human Resources Group - Discussion
Infor Lawson Technology Group - Discussion
General Discussions
VISUAL - Enterprise General Discussions
Infor Lawson Supply Chain Management - Discussion
Process Automation (IPA) - General Discussions
Pegasus - Partner General Discussions
Infor Lawson Supply Chain Group - Discussion
Infor Lawson Financials Group - Discussion
Infor EPM Discussions