[ZBX-19227] Oracle 19c errors during data.sql execution Created: 2021 Apr 08  Updated: 2024 Apr 10  Resolved: 2022 Nov 08

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Installation (I)
Affects Version/s: 5.0.9
Fix Version/s: 6.4 (plan)

Type: Problem report Priority: Critical
Reporter: Igor Gorbach (Inactive) Assignee: Aleksandre Sebiskveradze (Inactive)
Resolution: Workaround proposed Votes: 1
Labels: oracle
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Causes
Sub-task
depends on ZBX-19717 DATA.SQL build scripts fails with ORA... Closed
depends on ZBX-19604 Error cloning template "Template DB O... Closed
part of ZBX-19562 Oracle - data.sql script broken - Tem... Closed
Team: Team INT
Sprint: Sprint 78 (Jul 2021), 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), Sprint 87 (Apr 2022), Sprint 88 (May 2022), Sprint 89 (Jun 2022), Sprint 90 (Jul 2022), Sprint 91 (Aug 2022), Sprint 92 (Sep 2022), Sprint 93 (Oct 2022), Sprint 94 (Nov 2022)
Story Points: 0.5

 Description   

Steps to reproduce:

  1. Install and configure Oracle 19c db
  2. Try to import schema.sql, data.sql, images.sql files

Result:
schema.sql and images.sql files imported, errors during execution data.sql script

ERROR at line 3: ORA-12899: value too large for column "ZABBIX"."ITEMS"."DESCRIPTION" (actual: 2216, maximum: 2048)

As a workaround data.sql file from Zabbix 5.0.2 has used to fix the issue

Expected:
All data exported successfully

 
Generated at Thu Jun 12 12:53:55 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.