#22 Purge Thread - SybSQLException: <ASE>_SysMon not found

[Cecil Chan]

hi Jean-Paul

I'm using logger version V3.0.7, and seem like the purge thread is not cleaning up after it try to purge <ASE>_SysMon tables, I don't have that table , and the purge thread stopped . Would you suggest any work around. Below is part of the log
2018/06/11 15:57:06.631 Purge <ASE> - Purge Thread : archive, error in loop. com.sybase.jdbc4.jdbc.SybSQLException: <ASE>_SysMon not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

com.sybase.jdbc4.jdbc.SybSQLException: <ASE>_SysMon not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

    at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4112)
    at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3229)
    at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:302)
    at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:284)
    at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(SybStatement.java:2762)
    at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:2746)
    at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(SybStatement.java:596)
    at asemon_logger.PurgeThread.archiveIndic(PurgeThread.java:87)
    at asemon_logger.PurgeThread.run(PurgeThread.java:158)

2018/06/11 15:57:06.633 Purge <ASE> - Purge Thread - archive,Closing connection
2018/06/11 15:57:06.653 Purge <ASE> - Purge Thread : error in loop. java.lang.NullPointerException
java.lang.NullPointerException
at asemon_logger.PurgeThread.run(PurgeThread.java:193)
2018/06/11 15:57:06.653 Purge <ASE> - Purge Thread - Closing connection

[Cecil Chan]

Hi JP:

I also found the data is not purging since I install this software, I set< purgearchive daysToKeep="60" deleteSleep="100" startDelay="1" batchsize="10000" />

But I still see records that are much older thans 60 days. Would you suggest that to check Please

1> select min(Timestamp) from sybaseserver_Engines
2> go

---

         Mar  3 2018 10:07AM

[Jean-Paul Martin]

Hi Cecil,
very strange because when the SysMon collector stats, it checks existance and structure of SysMon table and prepare the purge statement for the table.

You should also have problems when Asemon tries to insert data into the SysMon table
Can you attach your config file and I'll check if there are mistakes in it ?

I assume you did no modifications in the SysMon_xxx.xml files in the asemon/conf directory

Does your monitored server has a long name ? (more than 20 chars ?)

Best regards
Jpm

[Cecil Chan]

HI JP,

What I did is manually recreated empty SysMon tables as below, then the purge works.
It is working find now .

I did not included Sys in my config_<ASE<.xml file. I lsited below.

Thanks for responding to me .

create table ${SRV}_SysMon (
Timestamp datetime not null,
grpname varchar(25) not null, / compressed group_name /
field_id smallint not null,
fldname varchar(80) null, / compressed field_name /
d_value int not null, / delta value /
value int null / static value /
) lock datapages
go
create table ${SRV}_SysMonFl2 (
Timestamp datetime not null,
Interval int not null,
group_name varchar(25) null,
field_id smallint not null,
field_name varchar(79) null,
ASE_Version varchar(16) null
) lock datarows
go
grant select on ${SRV}_SysMon to mda_group
go
grant select on ${SRV}_SysMonFl2 to mda_group
go

---

<SrvDescriptors>
<SD>
<name> ASEV157 </name>
<type checkMonitoringConfig="yes"> ASE </type>
<version> 1570 </version>
<metricsDescriptorsFiles>
<md> AmStats.xml </md>
<md> AseDbSpce_V157_OL.xml </md>
<md> BlockedP.xml </md>
<md> CachePool_V157.xml </md>
<md> Cnx_OL.xml </md>
<md> CnxActiv_V157SP130_OL.xml </md>
<md> CnxWaits.xml </md>
<md> DataCache.xml </md>
<md> DeadLock_V157_OL.xml </md>
<md> Engines_V157.xml </md>

         <!-- <md> ErrLog.xml                                                                                        </md> -->
         <!--<md sp_fragmentation_proc="sp_asemon_fragmentation" HOUR_EXEC="6" minpages="1000"> Fragment_nonSA.xml  </md> -->
         <!-- <md HOUR_EXEC="6" minpages="1000"> Fragment_V157.xml                                                   </md> -->
         <md> IOQueue.xml                                                                                       </md>
         <!--
            commented out lockwaits per JP's advise not to use it in 15.7
         <md sp_objstats_proc="sp_asemon_objstats" > LockWaits.xml                                              </md>
         -->
         <!--
         <md> LogsHold.xml                                                                                      </md>
         -->
         <md> LogsHold_V157_OL.xml                                                                                 </md>
         <md> MonConf_OL.xml                                                                                       </md>
         <!--
         <md sp_showplan_proc="sp_asemon_showplan" > MonSQL_V15.xml                                             </md>
         -->
         <md> MonSQL_V157.xml                                                                                   </md>
         <md> MonState.xml                                                                                      </md>
         <md> NetworkIO.xml                                                                                     </md>
         <!--
         <md> FILTER_CLAUSE="and db_name(DBID) in ('PCSDS_WRK_INT')" > OpObjAct_V157SP100.xml                   </md>
         <md>  OpObjAct_V157SP100.xml                   </md>
           -->
         <md> OpenDbs.xml                                                                                       </md>
         <md> PModUse_OL.xml                                                                                       </md>
         <md> ProcCache_OL.xml                                                                                     </md>
         <md> SysCaches.xml                                                                                     </md>
         <md> SysConf.xml                                                                                       </md>
         <md> SysDev_V15.xml                                                                                    </md>
         <md> SysWaits_OL.xml                                                                                      </md>
         <md> WClassInf.xml                                                                                     </md>
         <md> WEvInf.xml                                                                                        </md>
         <md HOUR_EXEC="7,20" RET_DAYS="15"> TableSpace.xml                                                                      </md>
      </metricsDescriptorsFiles>

  </SD>

</SrvDescriptors>

</Config>