Warehouse Builder/Manager Connection Error-Processing of the SQL Statement Ended

 

Summary

A user is unable to log in to either Warehouse Builder or Warehouse Manager. After entering user name and password, they get a message like this:

Processing of the SQL statement ended. Reason code 0.

The same user on the same PC can log in to Query or Report Writer. The profile is enabled and DSPUSRPRF doesn't reveal anything unusual. Another user profile works fine.

The Showcase server job log shows an error similar to:

CPF9898 Information 40 06/04/18 07:06:40.585641 QSQROUTS QSYS *STMT QSQROUTS QSYS *STMT
From module . . . . . . . . : QSQSRVRC
From procedure . . . . . . : SQSERVER
Statement . . . . . . . . . : 8569
To module . . . . . . . . . : QSQSRVRC
To procedure . . . . . . . : SQSERVER
Statement . . . . . . . . . : 8569
Thread . . . . : 0000089F
Message . . . . : SRVR_RESULT : 000000000 WSQ_SRVR_KILLED : 00000000J.
Cause . . . . . : This message is used by application programs as a general escape message.

This is the first indication of a problem and is followed by several errors including the one displayed to the user.

Resolution

The problem is a result of the user profile having a job description that no longer exists. It seems that Query is tolerant of this situation, but Warehouse Manager and Warehouse Builder are not. There may be other causes to this problem, and it's best to follow the same procedure to make sure. We found the problem by displaying the QSQSRVR job log associated with the connection. Use the following to accomplish this:

1. Increase logging for QSQSRVR jobs with this command:

   CHGJOBD JOBD(QGPL/QDFTSVR) LOG(4 00 *SECLVL) LOGCLPGM(*YES) LOGOUTPUT(*JOBEND)

2. Since prestart jobs stay running after they're used, it would be necessary either to wait a day or so for new jobs to be created, or force the issue by ending the Showcase server and then forcing QSQSRVR jobs to restart. Issue the following commands:

   SCSERVER/ENDSCSVR ENDPJ SBS(QSYSWRK) PGM(QSQSRVR)

   STRPJ SBS(QSYSWRK) PGM(QSQSRVR)

   SCSERVER/STRSCSVR

3. Make a new connection to Warehouse Builder or Warehouse Manager using the profile that gets an error.

4. After seeing the error, go to a green screen and enter this command:

   WRKSPLF YOURUSER (where "youruser" is the name of the profile used in Step 3)

5. Look for a QSQSRVR job log. If there are more than one, press the F11 key to display date and time, and search for the one which corresponds to the time period that you got the error in Step 3. View the job log - it may be easier to use iSeries Navigator to transfer the spooled file to your PC as a text file.
6. You should see the error. If the job description is missing, you can create a new one by copying QGPL/QDFTJOBD or copying the job description from a similar user. You can also change the user profile to use a different job description.
7. Close Warehouse Manager or Warehouse Builder and try to connection again from a fresh session. This should resolve the issue.