Kbase 18351: Error 20217 Generated with Apptivity and iPack Tools
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
Apptivity
SYMPTOM(s):
In Progress 9.x, the SQL-92 engine limits the number of open cursors to 50 in given connection, within Apptivity HTML projects where the iPack tool is used.
When accessing the SQL-92 engine from the Apptivity application either using the ODBC-JDBC bridge or the native JDBC, you might receive the error message:
error 20217.
Connection Exception. Network error on server.
CAUSE:
This is caused because the application is dynamically opening more than 50 cursors at the same time.
FIX:
One solution to this problem is to limit the number of application-opened cursors to less than 50. To accomplish this, you must edit the projects properties file as follows:
ipack.statements.max=45
ipack.statements.blocksize=5
These new settings will limit the number of open cursors to 45 and, at the moment the limit is reached, 5 open cursors will be closed and reused for new connections.