Upgrade to 2.4 with Oracle database backend.

[oitss]

Database Upgrade procedure from 2.2 to 2.4 ends without error. But all filters definitions in LLD rules become empty.
It happens because table "item_condition" is not filled with necessary data.

SQL query from DBpatch_2030024
"select itemid,filter from items where filter<>'' and flags=1"
return no rows under Oracle DB.

After this no rows are inserted into "item_condition" table.

[kloczek]

Database Upgrade procedure from 2.2 to 2.4 ends without error. But all filters definitions in LLD rules become empty.

You need to be a bit more precise about which one LLD rule you are talking about

[oitss]

I have several Linux hosts with linked "Template OS Linux".
All LLD rules screens on Hosts and Template have empty "Macro" and "Regexp" fields.

For me, the problem was solved, patching dbupgrade_2030.c

253c253
< if (NULL == (result = DBselect("select itemid,filter from items where filter<>'' and flags=1")))
---
> if (NULL == (result = DBselect("select itemid,filter from items where filter IS NOT NULL and flags=1")))

[kloczek]

I have several Linux hosts with linked "Template OS Linux".
All LLD rules screens on Hosts and Template have empty "Macro" and "Regexp" fields.

For me, the problem was solved, patching dbupgrade_2030.c

253c253
< if (NULL == (result = DBselect("select itemid,filter from items where filter<>'' and flags=1")))
---
> if (NULL == (result = DBselect("select itemid,filter from items where filter IS NOT NULL and flags=1")))

Seems your issue has nothing to do with exact SQL query or Oracle engine.
You need to add macro name in your LLD setup which must contain json vector field name.

[oitss]

I already have working LLD setup with macro definitions in version 2.2. All macro definitions was lost during upgrade procedure to version 2.4. Do you want to say, that it is normal result and the only way out, is to renew all macro definitions by hand ?