• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Supply Chain Management Lawson S3 Supply Chain

IC81 changes not updating in MSCM MPC

 6 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
F Rongione
New Member Send Private Message
Posts: 2
New Member
4/16/2013 7:28 PM

We recently upgraded our Lawson environment to 9.0.1.11 from 9.0.1.5.  We are on MSCM MPC 9.0.1.2.4.  After we did the environment upgrade, changes made to pars in IC81 stopped flowing over to the MSCM MPC pars.  Has anyone else had this problem?  Lawson told us to purge ICAUDIT records to make this work.  We have purged a lot of records from ICAUDIT and the changes in IC81 are still not updating in the hand held.  Any ideas?

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
4/16/2013 7:38 PM
We have this happen ALL the time.... so often, in fact, that I've scheduled a script to be run at least once a day to fix this.
Lawson will tell you that PT so-and-so fixes this, so you upgrade to that version that includes it, but sooner or later, it'll break again.
Here's the script that I wrote and scheduled:
[code] ## Execute sqlplus to determine which emps qualify for term /usr/local/bin/sqlplus -s mscm/password@sid < /dev/null 2>&1 DELETE FROM MSCM.ICAUDIT_TRACKER ; commit ; exit ENDSQL [/code]
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
4/16/2013 7:40 PM
This deletes the last update time from the MSCM database, and upon the next round of queries (we have ours scheduled every 15 minutes), it will see that it hasn't done an update yet, and will force one.
JonA
Veteran Member Send Private Message
Posts: 1163
Veteran Member
4/16/2013 7:46 PM
We have to do this from time to time as well and it does the trick.
Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
F Rongione
New Member Send Private Message
Posts: 2
New Member
4/17/2013 1:11 PM
Thanks for the information.  We are hosted by Velocity so I will work with me on your suggested script.  
Leslie
Veteran Member Send Private Message
Posts: 46
Veteran Member
5/9/2013 7:56 PM
We have this problem as well; we "solved" it by turning off the auditing function for the item location (IC192) in the IC01 setup, but that brings its own set of issues.
The Alchemist
Advanced Member Send Private Message
Posts: 34
Advanced Member
5/9/2013 8:25 PM
I know you said changes in IC81 but thought it might be worth mentioning that if end users are crossing over into IC82 we have seen that most changes do not carry over to MSCM. I believe it is because it does not create an audit record but dont quote me on that.