Only manual records are inserted into the table sa_source_metric_type

[sergiojr]

Hi Guys,

I have a scenario that is at least strange and has no solution so far.

Only manually inserted records are created in the sa_source_metric_type table when the number of 100k records in that table is reached. I have an integration with Zabbix to collect metrics and new records are not inserted when this table reaches 100k records, I did a test where I removed several records from the ITOM Agent source that were not being used, reducing the number of records in the table from 100k to approximately 70k and in the next connector collection new metric types were inserted into the table normally.

Has anyone ever seen this scenario? If so, how did I resolve it?

[AJ-TechTrek]

Hi @sergiojr 

Refer below articles, which may help.

https://docs.servicenow.com/bundle/washingtondc-servicenow-platform/page/administer/assessments/task...

https://docs.servicenow.com/bundle/vancouver-it-operations-management/page/product/event-management/...

https://docs.servicenow.com/bundle/vancouver-governance-risk-compliance/page/product/metrics/reuse/a...

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

[sergiojr]

Hi @AJ-TechTrek,

Thank you for your support, in consulting the links you provided, unfortunately none of them helped with the problem we faced.
Important, I can't even delete any metric type so that other metric types can be added to the table, even if I did so in the future, if the number of records in the table reaches 100k again, the problem will appear again.

[sergiojr]

Hi Guys,

The "problem" is the architeture of ClothoDB, in fact there is a limitation on table, but there is currently no solution for this, as it is an architectural feature.