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

Details

    • Team A
    • Sprint 63 (Apr 2020)
    • 1

    Description

      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.

      Attachments

        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

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: