-
Problem report
-
Resolution: Fixed
-
Critical
-
5.0.3
-
None
-
Oracle 19c, CentOS 7
-
Sprint 68 (Sep 2020)
-
0.25
Steps to reproduce:
1. Run make dbschema, cd to database/oracle
2. Load schema.sql and images.sql with sqlplus as described in the manual
3. Log in with sqlplus, then from sqlplus command prompt:
set echo on whenever sqlerror exit sql.sqlcode; @data.sql
Result:
SP2-0341: line overflow during variable substitution (>3000 characters at line 3) ... ... ERROR at line 1: ORA-02291: integrity constraint (ALEXK50T.C_ITEMS_5) violated - parent key not found
Find a line which inserts record for item with id 31055 (for Zabbix 5.0.4rc1). It has two problems:
1. The field param starts with concatenation operator "||".
2. The line is too long for sqlplus.
gen_data.pl has a special processing for long fields which is used for media types. This processing generates wrong SQL lines for items.
- caused by
-
ZBX-17512 Oracle: Not possible to import some media type integrations into DB due to input length limitation
- Closed
- part of
-
ZBXNEXT-6196 Zabbix is limited on oracle to store large templates
- Closed
- mentioned in
-
Page Loading...