Bugs item #1461607, was opened at 2006-03-30 13:43
Message generated for change (Settings changed) made by tdonohue
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=119984&aid=1461607&group_id=19984
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: 1.4 alpha 1
>Status: Closed
>Resolution: Out of Date
Priority: 5
Private: No
Submitted By: Lester Bowser (lbowser)
Assigned to: Nobody/Anonymous (nobody)
Summary: errors on oracle -- database_schema_13-14.sql
Initial Comment:
-- database_schema_13-14.sql
--
-- Version: $Revision: 1.4 $
--
-- Date: $Date: 2006/03/27 04:54:58 $
from isqlplus on oracle
Sequence created.
Sequence created.
Table created.
Table created.
Sequence created.
Sequence created.
Sequence created.
Table created.
Table created.
Table created.
1 row created.
66 rows created.
INSERT INTO MetadataValue (item_id, metadata_field_id,
text_value, text_lang, place)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("DSPACE"."METADATAVALUE"."METADATA_VALUE_ID")
Table dropped.
View created.
SELECT setval('metadatafieldregistry_seq',
max(metadata_field_id)) FROM metadatafieldregistry
*
ERROR at line 1:
ORA-00904: "SETVAL": invalid identifier
SELECT setval('metadatavalue_seq',
max(metadata_value_id)) FROM metadatavalue
*
ERROR at line 1:
ORA-00904: "SETVAL": invalid identifier
SELECT setval('metadataschemaregistry_seq',
max(metadata_schema_id)) FROM metadataschemaregistry
*
ERROR at line 1:
ORA-00904: "SETVAL": invalid identifier
Table dropped.
Index created.
Index created.
Index created.
result_code VARCHAR PRIMARY KEY,
*
ERROR at line 3:
ORA-00906: missing left parenthesis
result VARCHAR(64) REFERENCES
checksum_results(result_code)
*
ERROR at line 11:
ORA-00942: table or view does not exist
Sequence created.
result VARCHAR(64) REFERENCES
checksum_results(result_code)
*
ERROR at line 9:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
insert into checksum_results
*
ERROR at line 1:
ORA-00942: table or view does not exist
date_trunc('milliseconds', now()),
*
ERROR at line 18:
ORA-00904: "DATE_TRUNC": invalid identifier
update most_recent_checksum
*
ERROR at line 1:
ORA-00942: table or view does not exist
most_recent_checksum.last_checksum
*
ERROR at line 13:
ORA-00923: FROM keyword not found where expected
update checksum_history
*
ERROR at line 1:
ORA-00942: table or view does not exist
ALTER TABLE community DROP CONSTRAINT community_name_key
*
ERROR at line 1:
ORA-02443: Cannot drop constraint - nonexistent constraint
Sequence created.
Table created.
Index created.
View created.
View created.
----------------------------------------------------------------------
Comment By: Lester Bowser (lbowser)
Date: 2006-04-04 20:16
Message:
Logged In: YES
user_id=55119
Fixed result_code VARCHAR PRIMARY KEY,
*
ERROR at line 3:
ORA-00906: missing left parenthesis
and rerun still getting invalid ident though
Sequence created.
Sequence created.
Table created.
Table created.
Sequence created.
Sequence created.
Sequence created.
Table created.
Table created.
Table created.
1 row created.
67 rows created.
INSERT INTO MetadataValue (item_id, metadata_field_id,
text_value, text_lang, place)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("DSPACE"."METADATAVALUE"."METADATA_VALUE_ID")
Table dropped.
View created.
SELECT sval('metadatafieldregistry_seq', max
(metadata_field_id)) FROM metadatafieldregistry
*
ERROR at line 1:
ORA-00904: "SVAL": invalid identifier
SELECT sval('metadatavalue_seq', max(metadata_value_id))
FROM metadatavalue
*
ERROR at line 1:
ORA-00904: "SVAL": invalid identifier
SELECT sval('metadataschemaregistry_seq', max
(metadata_schema_id)) FROM metadataschemaregistry
*
ERROR at line 1:
ORA-00904: "SVAL": invalid identifier
Table dropped.
Index created.
Index created.
Index created.
Table created.
Table created.
Sequence created.
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
date_trunc('milliseconds', now()),
*
ERROR at line 18:
ORA-00904: "DATE_TRUNC": invalid identifier
set to_be_processed = false
*
ERROR at line 2:
ORA-00904: "FALSE": invalid identifier
most_recent_checksum.last_checksum
*
ERROR at line 13:
ORA-00923: FROM keyword not found where expected
0 rows updated.
ALTER TABLE community DROP CONSTRAINT community_name_key
*
ERROR at line 1:
ORA-02443: Cannot drop constraint - nonexistent constraint
Sequence created.
Table created.
Index created.
View created.
View created.
----------------------------------------------------------------------
Comment By: Lester Bowser (lbowser)
Date: 2006-04-04 20:14
Message:
Logged In: YES
user_id=55119
Fixed result_code VARCHAR PRIMARY KEY,
*
ERROR at line 3:
ORA-00906: missing left parenthesis
and rerun still getting invalid ident though
Sequence created.
Sequence created.
Table created.
Table created.
Sequence created.
Sequence created.
Sequence created.
Table created.
Table created.
Table created.
1 row created.
67 rows created.
INSERT INTO MetadataValue (item_id, metadata_field_id,
text_value, text_lang, place)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into
("DSPACE"."METADATAVALUE"."METADATA_VALUE_ID")
Table dropped.
View created.
SELECT sval('metadatafieldregistry_seq', max
(metadata_field_id)) FROM metadatafieldregistry
*
ERROR at line 1:
ORA-00904: "SVAL": invalid identifier
SELECT sval('metadatavalue_seq', max(metadata_value_id))
FROM metadatavalue
*
ERROR at line 1:
ORA-00904: "SVAL": invalid identifier
SELECT sval('metadataschemaregistry_seq', max
(metadata_schema_id)) FROM metadataschemaregistry
*
ERROR at line 1:
ORA-00904: "SVAL": invalid identifier
Table dropped.
Index created.
Index created.
Index created.
Table created.
Table created.
Sequence created.
Table created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
1 row created.
date_trunc('milliseconds', now()),
*
ERROR at line 18:
ORA-00904: "DATE_TRUNC": invalid identifier
set to_be_processed = false
*
ERROR at line 2:
ORA-00904: "FALSE": invalid identifier
most_recent_checksum.last_checksum
*
ERROR at line 13:
ORA-00923: FROM keyword not found where expected
0 rows updated.
ALTER TABLE community DROP CONSTRAINT community_name_key
*
ERROR at line 1:
ORA-02443: Cannot drop constraint - nonexistent constraint
Sequence created.
Table created.
Index created.
View created.
View created.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=119984&aid=1461607&group_id=19984
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Dspace-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-devel
