Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-17512

Oracle: Not possible to import some media type integrations into DB due to input length limitation

XMLWordPrintable

    • Sprint 63 (Apr 2020)
    • 1

      Problem description: when importing schema.sql and data.sql files into an Oracle database, import of some of the media types fails due to limited number of character per field. Errors like below are observed:

      ERROR at line 1:
      ORA-00926: missing VALUES keyword
      
      Input truncated to 7499 characters
      SP2-0027: Input is too long (> 2499 characters) - line ignored
      Input truncated to 7499 characters
      SP2-0027: Input is too long (> 2499 characters) - line ignored
      hr(13) || chr(10) || '} catch (error) {' || chr(13) || chr(10) || 'Zabbix.Log(3, ''Slack notification failed : '' + error);' || chr(13) || chr(10) || 'throw ''Slack notification failed : '' + error;' || chr(13) || chr(10) || '}','30s','1','1','{EVENT.TAGS.__message_link}','Open in Slack: {EVENT.TAGS.__channel_name}','')
      *
      ERROR at line 2:
      ORA-00926: missing VALUES keyword
      
      Input truncated to 7499 characters
      SP2-0027: Input is too long (> 2499 characters) - line ignored
      SP2-0027: Input is too long (> 2499 characters) - line ignored
      INSERT INTO media_type (mediatypeid,type,name,smtp_server,smtp_helo,smtp_email,exec_path,gsm_modem,username,passwd,status,smtp_port,smtp_security,smtp_verify_peer,smtp_verify_host,smtp_authentication,exec_params,maxsessions,maxattempts,attempt_interval,content_type,script,timeout,process_tags,show_event_menu,event_menu_url,event_menu_name,description)
      

      Steps to reproduce:

      1. Set up an oracle database
      2. Run ./configure (dont forget to add --with-oracle=/opt/oracle/instantclient_19_6), make, make install and make dbschema commands
      3. Import the data.sql, schema.sql and images.sql to Your oracle database.

      Result: multiple errors like "SP2-0027: Input is too long (> 2499 characters) - line ignored" are observed. Full import log is available here: oracle_log2.log

      Expected: all media type integrations should be successfully imported.

        1. image-2020-04-27-12-52-07-549.png
          image-2020-04-27-12-52-07-549.png
          19 kB
        2. image-2020-04-27-12-53-05-026.png
          image-2020-04-27-12-53-05-026.png
          12 kB
        3. image-2020-04-27-12-53-51-630.png
          image-2020-04-27-12-53-51-630.png
          8 kB
        4. loss-of-bsn.png
          loss-of-bsn.png
          80 kB
        5. oracle_log2.log
          372 kB
        6. oracle.png
          oracle.png
          116 kB
        7. postgresql-media.png
          postgresql-media.png
          116 kB

            viktors.tjarve Viktors Tjarve
            solonkins Sergejs Olonkins
            Team A
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: