#26 asemon 273 purge - Arithmetic overflow occurred

[Murali Sabapathi]

2012/05/24 17:11:58.415 Purge GLS4_TOK_REC_REP - Purge Thread - Table : 'GLS4_TOK_REC_REP_Trends' : error in purge loop. com.sybase.jdbc3.jdbc.SybSQLException: Arithmetic overflow occurred.

2012/05/24 17:11:58.416 Purge GLS4_TOK_REC_REP - Purge Thread - Closing connection
2012/05/24 17:11:58.417 Purge GLS4_TOK_REC_REP - Purge Thread : error in loop. java.sql.SQLException: JZ0C0: Connection is already closed.
java.sql.SQLException: JZ0C0: Connection is already closed.
at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
at com.sybase.jdbc3.jdbc.SybConnection.checkConnection(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.checkDead(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.checkStatement(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(Unknown Source)
at asemon_logger.PurgeThread.run(PurgeThread.java:69)
2012/05/24 17:11:58.418 Purge GLS4_TOK_REC_REP - Purge Thread - Closing connection

[Jean-Paul Martin]

Can you execute the query :

select TrendID, count(*) from GLS4_TOK_REC_REP_Trends group by TrendID order by TrendID

and send me the result. this will help me diagnose on which trend is the problem

[Murali Sabapathi]

select TrendID, count(*) from GLS4_TOK_REC_REP_Trends group by TrendID
order by TrendID
;
TrendID

---

   1         680
   2         680
   3         689
   8         680
   9         234
  10         234
  11         234
  12         234
  13         234
  14         233
  15         234
  16         234
  17         234
  18         177
  19         177
  20         234
  21         234
  25         234
  26         234
  27         234

(20 rows affected)

[Jean-Paul Martin]

New version of RSTrends.xml

[Jean-Paul Martin]

Can you use the new RSTrends.xml file, attached to this

(Replace the old RSTrends.xml file in conf dir and restart asemon_logger)