-
Problem report
-
Resolution: Fixed
-
Critical
-
4.4.7, 5.0.0alpha3
-
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:
- Set up an oracle database
- Run ./configure (dont forget to add --with-oracle=/opt/oracle/instantclient_19_6), make, make install and make dbschema commands
- 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.
- causes
-
-
- Closed
-