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

      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.
      
      

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

              Created:
              Updated:
              Resolved: