Zabbix Server installed on RedHat 7.9 (3.10.0-1160.25.1.el7.x86_64 #1) by compilation of sources version 5.0.10.
PHP 7.2 (“rh-php72” package from RedHat SCL repository).
Web Server httpd24 package from RedHat SCL repository
Oracle 19 database (not local)
Sprint 79 (Aug 2021), Sprint 80 (Sep 2021), Sprint 81 (Oct 2021), Sprint 82 (Nov 2021), Sprint 83 (Dec 2021), Sprint 84 (Jan 2022), Sprint 85 (Feb 2022), Sprint 86 (Mar 2022)
Steps to reproduce:
- Select "Template DB Oracle by ODBC" from Configuration -> Templates
- Click "Full Clone" and rename
- Click on "Add"
See screenshot error.jpg
No error and template cloned.
When installing, the provided database scripts were failing due to column size. We had to change the script to increase the size of "params" and "description" columns from "items" table from 2048 to 4000 in "schema.sql" script. This change corrected many insert errors except one that tried to insert a value size of 8000 (as we didn't need that item, we accepted that failure).
Also we needed to change item queries because of some inserts with NCLOB values were not being inserted in the database. We compare how the new Zabbix version had that entries in "data.sql" script and changed them for 5.0.10 "data.sql" script.
The only error that remain after executing the database scripts were the one about the size of 8000 (impossible to correct).
So, our database has "params" colum size of 4000 at "items" table, so no error should be raised by Zabbix. Our suspect is that the "clone" function in the web server ¿? is setting somewhere this size and as some items have more than 2048 (in this case, one item of the "Template DB Oracle by ODBC") it fails.