code=-805, state="51002", message="DB2 SQL error: SQLCODE: -805, SQLSTATE:

[Former Member]

Hello,

we have a portal system (nw04s, sp11) on aix 5.2.8 and db2 v8.2.2 (fixpak 10) where the activity report in the portal isn't running anymore. In the portal logfiles we can see the following error. Any idea why the portal isn't able to insert the data?

regards,

alexander

22.08.2007 08:00:43.362 ERROR 100: PreparedStatement = INSERT INTO WCR_USERSTAT (TIMESTAMPHOUR,AGGREGATIONLEVEL,HASHEDUSERID,USERTYPE,LOGONID) VALUES (? , ? , ? , ? , ?)

22.08.2007 08:00:44.131 ERROR SQL error occurred on connection b0d02t02:PP2:SAPPP2DB: code=-805, state="51002", message="DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERR

MC: NULLID.SYSLH103 0X5359534C564C3031";

22.08.2007 08:00:44.174 ERROR Exception during aggregation

22.08.2007 08:00:44.174 ERROR Exception during aggregation.

22.08.2007 08:16:37.500 ERROR Exception ID:08:16_22/08/07_0016_14024663

[Frank-Martin]

Hi Alexander,

yes, this fits with my theory. As a default DB2 can handle about 1600 concurrently open preparedStatement Objects per connection.

Regards

Frank