Page 1 of 1

Is there any XMLSERVICE limitation?

PostPosted: Fri Jun 30, 2017 1:04 pm
by supa6221
Hello,

My php web application using toolkitservice to call RPG program and everything working fine run by job QSQSRVR on QSYSWRK.
connect using random maxpool

Current
Subsystem /Job User Type CPU % Function Status
QSQSRVR USR01 BCI .0 PGM-XMLSERVICE SEMW
QSQSRVR USR01 BCI .0 PGM-XMLSERVICE SEMW
QSQSRVR USR01 BCI .0 PGM-XMLSERVICE SEMW
QSQSRVR USR01 BCI .0 PGM-XMLSERVICE SEMW


The problem is occured when the number of concurrent job increase and frequency call I found too many error log in Toolkit.log
then some request fail to Call RPG program.

29 Jun 2017 10:07:7.870749 Toolkit request failed. Review the database code and message. Database code (if any): 'HY021'. Message: Error occurred in SQL Call Level Interface
29 Jun 2017 10:07:17.711485 Toolkit request failed. Review the database code and message. Database code (if any): 'HY021'. Message: Error occurred in SQL Call Level Interface
29 Jun 2017 10:07:31.678134 Toolkit request failed. Review the database code and message. Database code (if any): 'HY021'. Message: Error occurred in SQL Call Level Interface
29 Jun 2017 10:07:34.179364 Toolkit request failed. Review the database code and message. Database code (if any): 'HY021'. Message: Error occurred in SQL Call Level Interface SQLCODE=-99999
29 Jun 2017 10:08:24.661271 Toolkit request failed. Review the database code and message. Database code (if any): 'HY021'. Message: Error occurred in SQL Call Level Interface SQLCODE=-99999
...


After I restart Zend Server , Apache and ENDPJ Qsyswork/Qsqsrvr
My job comeback to work smooth again
But after that around 24 hours this problem is ouccured again.

Please help me solve this problem.
I don't know is there any limitation on Zendserver (Basic Edition)?

Thanks,
Supatcha.

Re: Is there any XMLSERVICE limitation?

PostPosted: Fri Aug 04, 2017 9:06 am
by strysd
Have you checked this knowleadge base?
zend18.zendesk.com/hc/en-us/articles/115000872328-IBM-i-SQ99999-error-code-21-or-Toolkit-request-request-failed-HY021
Thank You.