AS400 user access error

Posted on 2009-12-21
Last Modified: 2013-12-06
I have a user who has a query profile she hasn't used in awhile.  Now when she signs into the query app on the AS400 she gets the following error "job started in subsystem data area *LIBL/JHAPAR not found.  Not sure where to trouble shoot this!
Question by:redskye88
    LVL 13

    Expert Comment

    Sounds like a library is missing from her initial library list.
    Look for the data area using:
    to see where the data area is. If it is not found, then it was deleted, or the whole library it was in was deleted. If it is found, then that library has to get into her initial library list.
    Can you also the job log so we can look through it as well?
    Hope this helps!
    LVL 26

    Expert Comment

    > ...the following error "job started in subsystem data area *LIBL/JHAPAR not found.

    Unfortunately, that doesn't really tell us anything. Please provide the message identifier for that error. It actually looks like a messed up combination of two different messages that may be unrelated. Message identifiers can be more important than even the text of the messages.

    Any program can send out any message text desired. The identifiers help determine what the text might actually mean.


    Author Comment

    Actually there is no error identifier - it goes like this

      Job/123456/user-id/device-id started on 12/21/2009 at 10:34:29 in subsystem data area *LIBL/JHAPAR not found (C G D F) - that's it when the user tried to sign into the as400 GUI app
    LVL 13

    Accepted Solution

    What was the result of DSPOBJD above?
    LVL 26

    Expert Comment

    > 123456/user-id/device-id

    If this is really a job name, then any errors ought to be noted in that job. Use DSPJOB 123456/user-id/device-id from an AS/400 command line to see if any logging was done. If the job is still active, errors should be in the joblog. If the job ended but still exists, logging should be noted in one of the spooled files. If that job isn't found, the logging wasn't done or it has already been deleted.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    As the title indicates, I have done this before. It chills me everytime I update the OS on my phone, ( because one time I did this and I essentially had a bricked …
    Sometimes a user will call me frantically, explaining that something has gone wrong and they have tried everything (read - they have messed it up more and now need someone to clean up) and it still does no good, can I help them?!  Usually the standa…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now