Data Source Performance Errors

Problem: Response time for client synchronization degrades, or Unwired Server reports timeout errors while obtaining connections.

Explanation: You may see playback and timeout exceptions reported when some queries are executed:

ResourceMonitorTimeoutException: data source:<datasource_name> ).

You may see errors that indicate client synchronization performance is degraded:

Client receives an error code -85 (SQLE_COMMUNICATIONS_ERROR)) .

These errors indicate that the connection pool size is too small for your user base, and that resources are not managed sufficiently.

Solution: Increase the connection pool size with the maxPoolSize property. This value change increases the number of connection pools available to users on your network. You can also increase the value for maxWaitTime to increase the timeout value used by the data source.

You set this in the data source connection. In Sybase Control Center, navigate to Domains > <Domain-> > Connections, then select the connection and click Properties. The property value can be modified or added as needed.

You can modify connection properties either from Sybase Control Center by clicking Connections on the navigation pane, or you can manually modify the ANT file in <UnwiredPlatform_InstallDir>\Unwired Platform\Servers\UnwiredServer\config\default-data-sources.xml.

After changing this file, run configure.bat default-data-sources to implement changes.

Note: Run configure.bat default-data-sources only if you manually modified default-data-sources.xml.