EnterpriseOne IBM iSeries (AS400) Power Outage Fix

POWER OUTAGE IN THE DATA CENTER!

WHAT!?! That’s not supposed to happen.

Don’t I know it. Don’t ask.

After this unfortunate incident, EnterpirseOne came back up great. Nothing in the logs indicating an issue and no issues reported by users.

That is until several users logged in and the system came to a screeching halt. Grids wouldn’t populate. UBE jobs stayed in a “Waiting” status. And eventually, the following error was found in the enterprise server logs:

IPC2100017 – createIPCMsgq (name Net32Q) failed, errno=3457: File exists..

It was a very frustrating day, but thankfully we were able to resolve it using Oracle Support Doc 659250.1 :

Cause

Invalid files exist in system library.

UBEs on the iSeries process in USRQs (User Queues).? When the UBE is done processing, the USRQ should be deleted by EnterpriseOne. On occasion, USRQs do not get deleted, leaving orphaned USRQs in the system.? If another UBE is submitted to the server, it may try to use the orphaned USRQ causing the error message above.? To resolve this issue, the orphaned USRQ(s) need to be deleted.

Solution

Steps to delete a USRQ:

1. ENDNET to end oneworld services using AS400 user profile ONEWORLD
2. CLRIPC
3. Issue command:? WRKOBJ E910SYS/Q0000*? –? where E910SYS is your E1 system library name
4. If the object type is *USRQ you can delete these orphaned user queues.
   NOTE: If there are no *USRQs, this is not the problem and further investigation is warranted.
5. CLRIPC
6. STRNET to start JDE services
7. Start HTML server

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.

stewart@9rains.com

http://stewartschatz.com