[ZBX-12505] ORA-00904 invalid identifier in database creation scripts - ZABBIX SUPPORT

Details

Type: Problem report
Status: Closed
Priority: Blocker
Resolution: Fixed
Affects Version/s: 3.4.0beta2
Fix Version/s: 3.4.0rc1
Component/s: API (A), Frontend (F), Installation (I)
Labels:
- oracle

Epic Link:
Merge Screens in to Dashboards
Team:
Team C
Sprint:
Sprint 14
Story Points:
0.5

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.

ORA-00904 invalid identifier in database creation scripts

Details

Description

Attachments

Activity

People

Dates