EnterpriseOne IBM iSeries (AS400) Power Outage Fix

Read Time:1 Min, 15 Sec

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.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

4 thoughts on “EnterpriseOne IBM iSeries (AS400) Power Outage Fix

    1. Thanks, David. I don’t think there would be any issue with that. However, I’m definitely not an iSeries guru so I would make sure with your friendly neighborhood IBM iSeries Pro.

  1. OMG Thank you so much for the help, what a life saver!

    System backup and we are ready for the day well before users log in.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post Restore SQL Server Database On A Schedule
Next post VBScript To Insert Values Into UBE Data Selection List Of Values