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

ORA-00904 invalid identifier in database creation scripts

    XMLWordPrintable

Details

    Description

      Looks like we cannot use row as field name (renaming it helps)

      Error:

      	row			 number(10)	 DEFAULT '0'		   NOT NULL,
      	*
      ERROR at line 6:
      ORA-00904: : invalid identifier
      
      
      CREATE INDEX widget_1 ON widget (dashboardid)
                               *
      ERROR at line 1:
      ORA-00942: table or view does not exist
      

      Full Log:

      SQL> @schema.sql
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Table created.
      
      
      Index created.
      
      
      Table created.
      
      
      Index created.
      
      	row			 number(10)	 DEFAULT '0'		   NOT NULL,
      	*
      ERROR at line 6:
      ORA-00904: : invalid identifier
      
      
      CREATE INDEX widget_1 ON widget (dashboardid)
                               *
      ERROR at line 1:
      ORA-00942: table or view does not exist
      
      
      
      Table created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Index created.
      
      
      Table created.
      
      
      1 row created.
      
      
      Sequence created.
      
      
      Trigger created.
      
      
      Sequence created.
      
      
      Trigger created.
      
      
      Sequence created.
      
      
      Trigger created.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      ALTER TABLE widget ADD CONSTRAINT c_widget_1 FOREIGN KEY (dashboardid) REFERENCES dashboard (dashboardid) ON DELETE CASCADE
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist
      
      
      ALTER TABLE widget_field ADD CONSTRAINT c_widget_field_1 FOREIGN KEY (widgetid) REFERENCES widget (widgetid) ON DELETE CASCADE
                                                                                                 *
      ERROR at line 1:
      ORA-00942: table or view does not exist
      
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      
      Table altered.
      
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            vso Vladislavs Sokurenko
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: