Is there any XMLSERVICE limitation?

General discussion on Zend Server for IBM System i

Is there any XMLSERVICE limitation?

Postby supa6221 on Fri Jun 30, 2017 1:04 pm

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.
supa6221
 
Posts: 1
Joined: Fri Jun 30, 2017 12:21 pm

Return to Zend Server for IBM i

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest