Details
-
Type:
Problem report
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 5.0.3
-
Fix Version/s: 5.0.5rc1, 5.2.0beta1, 5.2 (plan)
-
Component/s: Installation (I)
-
Labels:None
-
Environment:Oracle 19c, CentOS 7
-
Team:Team A
-
Sprint:Sprint 68 (Sep 2020)
-
Story Points:0.25
Description
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.
Attachments
Issue Links
- 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...