#28 Fragment getting Arithmetic overflow

[Murali Sabapathi]

Using asemon 2.7.5 against ASE 15.7 ESD#2, getting,

2012/08/18 07:30:26.444 BOJ1_TOK_PRD_ASE_Fragment - ERROR catch com.sybase.jdbc3.jdbc.SybSQLException 247 Arithmetic overflow during implicit conversion of NUMERIC NULL value '4294967293' to a INT field .

com.sybase.jdbc3.jdbc.SybSQLException: Arithmetic overflow during implicit conversion of NUMERIC NULL value '4294967293' to a INT field.

I ran 'dbcc checkdb' on both the monitored & archived db, yet I got the error.

Let me know how this can be fixed.

[Jean-Paul Martin]

Had this same problem with my test server. The "emptypgcnt" was wrong for some tables. Execute manually the sql query contained in "Fragment_V15.xml" and see which table generates this overflow. Then fix it by executing reorg rebuild (or may be "update statistics" ) on this table.

May be you can fisrt execute "update statistics" on all tables and see if the problem persist

[Jean-Paul Martin]

I also have to change the Fragment collector because some columns (leafcnt, pagecnt, emptypgcnt, ...) are UNSIGNED INT rather than INT

[Murali Sabapathi]

I updated below columns in Fragment_V15.xml as shown and it seems to work fine.

pagecnt           unsigned int  null,
leafcnt           unsigned int  null,
emptypgcnt        unsigned int  null,

[Jean-Paul Martin]

I post new version V2.7.6 today. It includes this modification and adds somme ESD#2 support