Text item limits

[lptarik]

Hello I am using Zabbix 5.4 and I am monitoring some sql servers with proxy installed with mariadb database.

Some of my items having below error.

Preprocessing failed for: [{"object_name":"MSSQL$SQLServer","counter_name" :"U ptime","instance_name":"","cntr_value":"891570...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='MSSQL$SQLServerDatabases' && @.counter_name=='Log File(s) Size (KB)' && @.instance_name=='xxxxxxxxxxx')].cntr_value.first()": no data matches the specified path

I belive it is related to text value size but i can't prove it. Should i install Postgresql for this ? Does it have more limit? I can't understand 65536 characters vs 65536 . Which one is bigger? Thanks

[cyber]

Preprocessing should take place before anything is stored. So I think your initial data is not containing things you are looking for... "no data matches the specified path"

[lptarik]

Yes when i was debugging I saw instance name as SQLServer not MSSQL$SQLServer. I guess it is mentioned in template you should add as MSQQL$ . Thanks