Hello,
Since we activated the data collection service in order to use the portal activity report we keep seeing this message at the defaultTrace file very often:
#1.5#0002B3DB0D93008000000A66000037A0000409DA1B7D0729#1136732275717#com._1144##There are currently 100 open statements for one connection. The statement texts are:##
And then there are many lines like this:
#1.5#0002B3DB0D93008000000A68000037A0000409DA1B7D0D67#1136732275717#com.sap.sql.jdbc.common.CommonConnectionImpl#sap.com/irj#com.sap.sql.jdbc.common.CommonConnectionImpl#Guest#0####092751907e0c11da9e940002b3db0d93#Thread[Data_Reporter,5,SAPEngine_Application_Thread[impl:3]_Group]##0#0#Error#1#/System/Database/sql/jdbc/common#Java#com.sap.sql.jdbc.common_1145##1: PreparedStatement = INSERT INTO "WCR_USERNODESTAT" ("TIMESTAMPHOUR","NODEID","HASHEDUSERID","USERTYPE","LOGONID") VALUES (?,?,?,?,?)#3#1#PreparedStatement#INSERT INTO "WCR_USERNODESTAT" ("TIMESTAMPHOUR","NODEID","HASHEDUSERID","USERTYPE","LOGONID") VALUES (?,?,?,?,?)#
Does this points on a problem and what can we do in order to avoid it?
Thank you in advance,
Roy Cohen.