Skip to Content
0
Former Member
Jan 05, 2006 at 09:20 AM

SAP EP & ActivityReport

42 Views

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