Hi,
I have integrated the ActivityReport component in the SAP EP 6.0. This ActivityReport is giving statistics on the number of users and is connected to a Windows Service Aggregator running on MS SQL Server 2000.
The problem is that I get an error in the Log Viewer for the portal:
There are currently 100 open statements for one connection. The statement texts are:
Source : com.sap.sql.jdbc.common.CommonConnectionImpl
100: PreparedStatement = INSERT INTO "WCR_USERNODESTAT" ("TIMESTAMPHOUR","NODEID","HASHEDUSERID","USERTYPE","LOGONID") VALUES (?,?,?,?,?)
Is there any way to increase this limit ?
Is it adviced to do it ?
Does the Aggregator source code needs to be modified to limit the number of statements per connection ?
Is there any other solution to replace the Aggregator and provide statistics on the number of users ?
Thanks.
Jean-Marc Denoyel