[ZBX-24922] Oracle ODBC/By AGENT 2 template cannot be imported Created: 2024 Jul 26  Updated: 2024 Nov 19  Resolved: 2024 Sep 29

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: 7.0.1
Fix Version/s: 6.0.35rc1, 7.0.5rc1, 7.2.0alpha1

Type: Problem report Priority: Major
Reporter: Marco Avvisano Assignee: Janis Freibergs
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: 6h 40m
Original Estimate: Not Specified

Attachments: PNG File Screenshot 2024-07-29 at 20.07.02.png     PNG File Screenshot 2024-07-29 at 20.07.16.png     PNG File Screenshot 2024-07-29 at 20.07.24.png     PNG File Screenshot 2024-07-29 at 20.07.33.png     PNG File odbc1.png     PNG File odbc_2.png     PNG File odbc_3.png     File zbx_export_templates(1).yaml     File zbx_export_templates.yaml    
Issue Links:
Causes
caused by ZBXNEXT-7951 Configuration import improvements Closed
Duplicate
Team: Team C
Sprint: S24-W34/35, S24-W38/39
Story Points: 0.25

 Description   

Steps to reproduce:

  1. download template from git
  2. import template

Result:

Cannot find item "oracle.tbs_alloc_bytes"{#CON_NAME}","{#TABLESPACE}"" on "Oracle by ODBC" used in graph prototype "Oracle '{#CON_NAME}' TBS '{#TABLESPACE}': Tablespace '{#TABLESPACE}'" of discovery rule "Tablespace discovery" on "Oracle by ODBC".

Same results when i try to import template 'Oracle by agent 2'

See screenshot...
..



 Comments   
Comment by Alexey Pustovalov [ 2024 Jul 26 ]

Hello! Could you share link where from downloaded the template?

Comment by Marco Avvisano [ 2024 Jul 29 ]

Hi,
this is the link:
https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates?at=refs%2Fheads%2Ffeature%2FDEV-2491-7.1

Comment by Alexey Pustovalov [ 2024 Jul 29 ]

why you use some DEV branch? Did you try the following https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/oracle_odbc/template_db_oracle_odbc.yaml?at=refs%2Fheads%2Frelease%2F7.0 ?

Comment by Marco Avvisano [ 2024 Jul 29 ]

yes, even if I download the other version I still get the same error
Cannot find item "oracle.tbs_alloc_bytes"{#CON_NAME}","{#TABLESPACE}"" on "Oracle by ODBC" used in graph prototype "Oracle '{#CON_NAME}' TBS '{#TABLESPACE}': Tablespace '{#TABLESPACE}'" of discovery rule "Tablespace discovery" on "Oracle by ODBC".

Comment by Alexey Pustovalov [ 2024 Jul 29 ]

are you trying to import completely new template or update existing? Do you use Zabbix 7.0.1 frontend?

Comment by Marco Avvisano [ 2024 Jul 29 ]

I'm trying to import completely new template on zabbix 7.0.1 frontend

Comment by Alexey Pustovalov [ 2024 Jul 29 ]

Sorry, I can not reproduce the problem on Zabbix 7.0.1 frontend and  https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/oracle_odbc/template_db_oracle_odbc.yaml?at=refs%2Fheads%2Frelease%2F7.0 template:

  1. No Oracle templates at all:
  2. Import options:
  3. Import details:
  4. Success

What difference in your case? Do you have any errors in web-server error log?

Comment by Marco Avvisano [ 2024 Jul 29 ]

if i check the option 'update existing' (as you) it work fine, but I would like to keep the old version.
It seems that even if that import option is not selected it still carries out some import checks
I was unable to find specific errors in the log

Comment by Alexey Pustovalov [ 2024 Jul 29 ]

Sorry, that is what I asked you before, do you update existing template in your system? If you already have the same template in the system, please, attach it to the issue.

Comment by Marco Avvisano [ 2024 Jul 30 ]

zbx_export_templates.yaml zbx_export_templates(1).yaml

Hi Alexey, as I was saying, I don't want to update the template but I would like to keep both versions. The problem is that the import fails if I don't select 'Update existing' in the import options.
However, I am attaching the two templates

Comment by Alexey Pustovalov [ 2024 Jul 31 ]

OK. So you would like to add missing object and do not touch / do not update already existing ones?

I reproduced the issue with the attached template.

Comment by Marco Avvisano [ 2024 Jul 31 ]

Yes, Alexey.
Thanks

Comment by Janis Freibergs [ 2024 Aug 29 ]

Fixed in development branch feature/ZBX-24922-6.0

Comment by Janis Freibergs [ 2024 Sep 27 ]

Available in versions:

Generated at Mon Apr 14 20:56:51 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.