#47 Logging into IQ error

[Anonymous]

Hi,
We are getting this error when using IQ as the logging database:
Table XXXX_Cnx_temp requires an RLV store merge before table-level modification
where XXXX is our ASE server being monitored.

we tried modifying RV_Auto_Merge_Eval_Interval down to 1 (min) but still no joy

[Jean-Paul Martin]

Hi,
If your Archive server (asemon repository) is IQ, then you must configure RLV store on this IQ server. Asemon_logger must user RLV store
Regards
JPM

[Anonymous]

We have configured RLV store on our IQ logger store and everything starts but we get these errors from fairly regularly:

2024/05/28 13:03:29.560 IMAG_QA2_Engines - RLV enable already set for 'IMAG_QA2_Engines'
2024/05/28 13:03:29.659 IMAG_QA2_DevIO - RLV enable already set for 'IMAG_QA2_DevIO'
2024/05/28 13:03:29.808 IMAG_QA2_DeadLock - RLV enable already set for 'IMAG_QA2_DeadLock_temp'
2024/05/28 13:03:29.914 IMAG_QA2_DataCache - RLV enable already set for 'IMAG_QA2_DataCache'
2024/05/28 13:03:30.005 IMAG_QA2_CnxWaits - RLV enable already set for 'IMAG_QA2_CnxWaits'
2024/05/28 13:03:30.133 IMAG_QA2_CnxActiv - RLV enable already set for 'IMAG_QA2_CnxActiv'
2024/05/28 13:03:30.259 IMAG_QA2_Cnx - RLV enable already set for 'IMAG_QA2_Cnx_temp'
2024/05/28 13:03:30.280 IMAG_QA2_Cnx - Error in loop on table 'IMAG_QA2_Cnx' on connection : 'ARCH'. Error=21. SQL message=SQL Anywhere Error -1001105: Table IMAG_QA2_Cnx_temp requires an RLV store merge before table-level modification.
-- (dblib/db_drop.cxx 371) state=QRA05
asemon_logger.AsemonSQLException: SQL Anywhere Error -1001105: Table IMAG_QA2_Cnx_temp requires an RLV store merge before table-level modification.
-- (dblib/db_drop.cxx 371)
at asemon_logger.Archive_IQ.saveValues(Archive_IQ.java:466)
at asemon_logger.CollectorCnx.getMetrics(CollectorCnx.java:114)
at asemon_logger.Collector.run(Collector.java:387)
2024/05/28 13:03:30.363 IMAG_QA2_CachePool - RLV enable already set for 'IMAG_QA2_CachePool'

Does ASEmon call "sp_iqmergerlvstore 'BLOCKING',IMAG_QA2_Cnx_temp,IMAG_ASEmon" ?
Is there something in the logger xml we need to enable ?

BTW, no errors when logging into IQ if RLV is OFF but it's slower.

[Jean-Paul Martin]

Hi,
from your stack trace I can see you are not using the lastest asemon_logger version
Can you install V3.2.3 and see if you still have this error ?
I fixed this error in the past

Regards
JPM

[Anonymous]

Thanks Jean-Paul - we'll do that ASAP