cannot perform regular express match for value of type string: pattern does not match

[cyberphantom]

Hello
I've configured an prototype item on zabbix and added a regex preprocessing: "{#TEST6}":"(.*?)" cause the output of my main item is a block of text, like:

[{"{#TEST}":"aaaa","{#TEST2}":"bbbb","{#TEST3}": "cc cc","{#TEST4}":"dddd","{#TEST5}":"eeee","{#TEST6}":"6","{#TEST7}":"ffff","{#TEST8}":"gggg"}(...it continues repeating the same)

I've tested this regex on regex101, it worked well, but on zabbix my items are not supported and with this error -> "Preprocessing failed for: [{"{#TEST}":" 1. Failed: cannot perform regular expression ""6":"(.*?)"" match for value of type "string": pattern does not match"
It seems that the preprocessing is working, because it's returning the correct value (in this case, 6)...
The itens are configured with the type "text".
It's something wrong with regex?

[cyber]

Works as expected for me...



Only way I managed to get similar error was, when I entered "6" into macro value instead of {#TEST6}.

[cyberphantom]

Thanks for your answer!!
I see...
Here it's working now, my items are enabled and I tested some items, preprocessing is returning the expected value. But I can't see this value in "latest data" in "last value" field
Is this right? I'm new to Zabbix, so maybe I'm doing something wrong...
These items were generated by a discovery rule, they are dependent items (in item prototype) of the master item, which is a "database monitor" type item. This master item is collecting data from my DB, and it's working well... as you can imagine, this DB data collector item is using the key "db.odbc.discovery" so it's transforming the response as lld macros ([{"{#TEST}":"aaaa","{#TEST2}":"bbbb","{#TEST3}": "cc cc","{#TEST4}":"dddd","{#TEST5}":"eeee","{#TEST6}":"6","{#TEST7}":"ffff","{#TEST8}":"gggg"](...))
I'm trying to understand what's happening...

[cyberphantom]

Ok, I understood why this is happening
I've unmarked the option "Storage period" and forgot it
now is returning the values, but regex is catching just the first value, so every item is with the same value, which is wrong
Trying to solve it

[cyber]

Setting storage period to 0 is only useful for master items, which retrieve a lot of data and spread it down to dependent items. So each time you pull data, it is preprocessed an split up to dependent items and that big master data is never saved to DB. Saves a lot of room.

[shawnbrown]

Works as expected for me...



Only way I managed to get similar error was, when I entered "6" into macro value instead of {#TEST6}. JJsploit

Thanks a lot This totally worked for me

[shawnbrown]

Also try to check the option called "Storage period", it might work for you