BC:

Question:

Article:

Has anyone restored from an M3 Archive

A user accidentally archived a large number of customer orders to the Archive library in M3 15.1.4. According to the cases in the Infor Customer portal, there is no M3 program to do this. It looks like there are 13 tables involved, including OOHEAD.

Does anyone have a process for restoring these archived entries?

Thanks!
Mike
Delivered Read
Group: *MUGA
Comments (5) (Descending Chronological Order)
There are no comments at this time, be the first to comment
BC:
Hi Mike,
You’re right there isn’t a standard M3 program to restore archived orders once they’ve been moved. We’ve come across this scenario before and know it can be tricky. If it would be helpful, we’d be glad to share how we’ve approached this in the past to ensure the restore is complete, validated, and avoids downstream issues. Feel free to email me at denise@doppiogroup.com.
BC:
Thanks Jill and John, I inserted the records into the PRD table from ARCH and am waiting on reports from users. I don't think I'll have issues.
Mike
BC:
We had this happen back on version 14.1.2, also running on IBM i. Since the order archive is simply moving the order (and related data) to the archive library not doing any calculation logic like the MITTRA archive we simply inserted the records from the archive library back into the active library and everything was good to go again.
BC:
We are running iSeries, so I imagine that will make it easier. The job entails about 13 different file as near as I can tell.
BC:
While I've never done it, you should be able to look at the archive log and see what tables were archived. Then you can copy the records from the archive schema back into production. Are you running on Windows or iSeries?

Online