Problem Statement:

If a user profile is setup incorrectly with a wrong OUTQ name or a wrong JOBD authority or both, an error appears when the user signs on to query.
ERROR: 'Error occurred in SQL call level interface _ HY017 '

Any subsequent user who tries to sign on to Query will also receive the same error.


Fixed in IBM PTF for V6R1 and V7R1:
V6R1 - See APAR SE45716
Resolved by applying PTF 5761SS1  SI41813

To verify if PTF is applied already on V6R1, run command: DSPPTF LICPGM(5761SS1) SELECT(SI41813)

V7R1 - See APAR SE46127
Apply PTF 5770SS1 SI49603 and all pre/co-requisites

To verify if PTF is applied already on V7R1, run command: DSPPTF LICPGM(5770SS1) SELECT(SI49603)


  1. Check the QSQSRVR joblogs for why the login failed.
  2. Fix the profile by verifying the Authority, along with JOBD, OUTQ, LOCALE, or log in with a different profile.
  3. Once you are in the bad state where the ShowCase Server is hung,  you will need to recycle  the ShowCase server.

Note: If using JDE One World, make sure the 'SCSECUSR' value (System User - iSeries profile that makes the connection to iSeries) is a valid profile and has a valid job description.


Ref#: 1488009





Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 21, 2017