#39 After Upgrade sybase 16.0.sp03.pl10 the Asemon is not work

[Anonymous]

Hello Jean Paul,
Since the sybase migration from 15.7 to 16.0.sp03pl10 :

• Procs from statements have no data
• statements have no data

Asemon version : 3.1.10

Thanks for your help

Sherrif

[Jean-Paul Martin]

Hi Sherrif,
strange, many customers are using asemon with ASE 16 SP03
Check your config file (it should look to "sampleConfig.xml" in root directory of asemon distrib)
Do you have any error in output of asemon_logger ?

If you still have problem, send me output of asemon_logger and your config file

By the way, the latest version is 3.1.14 (but 3.1.10 was OK with procs and statements collect)

Best regards
JP

[Anonymous]

Hi Jp
This is the message from Asemon after the migration :
2022/09/11 15:10:06.304 ALP13005_MonSQL - ERROR - Error on commit before returning connection to pool : 0 JZ0C0: Connection is already closed.
2022/09/11 15:10:06.304 ALP13005_MonSQL - Error in loop on table 'ALP13005_StmtStat' on connection : 'ARCH'. Error=207 state=ZZZZZ. SQL message=Invalid column name 'SnapCodegenTime'.

asemon_logger.AsemonSQLException: Invalid column name 'SnapCodegenTime'.

   at asemon_logger.CollectorMonSQL$RunningStmt.saveStmtStat(CollectorMonSQL.java:1016)
    at asemon_logger.CollectorMonSQL$RunningStmt.access$4000(CollectorMonSQL.java:374)
    at asemon_logger.CollectorMonSQL.getMetrics(CollectorMonSQL.java:2001)
    at asemon_logger.Collector.run(Collector.java:380)


  Thank you for your help

[Jean-Paul Martin]

are you sure you executed installmaster after upgrade ?
can you send me the result of "sp_version" ?
jp

[Anonymous]

Hello,

The issue is resolved now with the new version of Asemon.
Thank you JP

Sherrif