Forum OpenACS Development: Unable to install from "oacs-4-6"
While "Completing Install sequence by mounting the main site and other core packages" on the "oacs-4-6" branch, I get the following when installing on Oracle:
Completing Install sequence by mounting the main site and other core packages.
[19/Mar/2003:18:12:13][15886.49156][-conn0-] Error: Error sourcing /home/ola/web/dotlrntest/packages/acs-bootstrap-installer/installer/packages-install.tcl:
Selection did not return a value, and no default was provided
while executing
"db_string pretty_name_from_key {select pretty_name
from apm_enabled_package_versions
..."
(procedure "apm_package_instance_new" line 4)
invoked from within
"apm_package_instance_new $package_name $context_id $package_key"
(procedure "site_node::instantiate_and_mount" line 32)
invoked from within
"site_node::instantiate_and_mount -package_key acs-content-repository"
(procedure "apm_mount_core_packages" line 14)
invoked from within
"apm_mount_core_packages"
invoked from within
"if { ![ad_acs_admin_node] } {
ns_write " <blockquot..." (file "/home/ola/web/dotlrntest/packages/acs-bootstrap-installer/installer/packages-install.tcl" line 44) Does this ring a bell?
Posted by
Jeff Davis
on 03/19/03 01:27 PM
try looking further back in the error log for something like
an error loading the datamodel. I think this is just a symptom that the datamodel create failed.
an error loading the datamodel. I think this is just a symptom that the datamodel create failed.
Posted by
Ola Hansson
on 03/19/03 02:23 PM
Oh, there was more to it than I thought.
It seems to be ACS Mail that sets of this avalanche of errors.
Why is the installation allowed to go on if there are are errors in packages - has it always been like that?
# Installing data model for ACS Mail 4.6.2...
* Loading data model /home/ola/web/dotlrntest/packages/acs-mail/sql/oracle/acs-mail-create.sql...
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Mar 19 19:07:38 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
No errors.
No errors.
No errors.
No errors.
constraint acs_mail_mp_parts_c_obj_id_fk references cr_items,
*
ERROR at line 10:
ORA-00942: table or view does not exist
create index acs_mail_mpp_cr_item_id_idx ON acs_mail_multipart_parts(content_item_id)
*
ERROR at line 1:
ORA-00942: table or view does not exist
No errors.
No errors.
Warning: Package created with compilation errors.
Errors for PACKAGE ACS_MAIL_MULTIPART:
LINE/COL ERROR
-------- -----------------------------------------------------------------
28/2 PL/SQL: Declaration ignored
29/24 PLS-00201: identifier 'ACS_MAIL_MULTIPART_PARTS.MULTIPART_ID'
must be declared
No errors.
No errors.
No errors.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY ACS_MAIL_MULTIPART:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00905: object DOTLRNTEST.ACS_MAIL_MULTIPART is invalid
1/14 PLS-00304: cannot compile body of 'ACS_MAIL_MULTIPART' without
its specification
No errors.
No errors.
No errors.
No errors.
No errors.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY ACS_MAIL_NT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
21/13 PLS-00201: identifier 'CR_ITEMS.ITEM_ID' must be declared
21/13 PL/SQL: Item ignored
22/16 PLS-00201: identifier 'CR_REVISIONS.REVISION_ID' must be declared
22/16 PL/SQL: Item ignored
68/2 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
68/2 PL/SQL: Statement ignored
77/2 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
LINE/COL ERROR
-------- -----------------------------------------------------------------
77/2 PL/SQL: Statement ignored
78/2 PL/SQL: Statement ignored
78/35 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
81/2 PL/SQL: Statement ignored
81/47 PLS-00320: the declaration of the type of this expression is
incomplete or malformed
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
Installed ACS Mail, version 4.6.2.
Package enabled.
# Installing data model for ACS Messaging 4.5...
* Loading data model /home/ola/web/dotlrntest/packages/acs-messaging/sql/oracle/acs-messaging-create.sql...
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Mar 19 19:07:47 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (DOTLRNTEST.ACS_OBJECT_TYPES_SUPERTYPE_FK)
violated - parent key not found
ORA-06512: at "DOTLRNTEST.ACS_OBJECT_TYPE", line 28
ORA-06512: at line 3
No errors.
references cr_items (item_id) on delete cascade
*
ERROR at line 4:
ORA-00942: table or view does not exist
create index acs_messages_reply_to_idx on acs_messages (reply_to)
*
ERROR at line 1:
ORA-00942: table or view does not exist
create index acs_messages_sender_idx on acs_messages (sender)
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on table acs_messages is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.reply_to is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.sent_date is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.sender is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages.rfc822_id is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
references acs_messages (message_id) on delete cascade,
*
ERROR at line 4:
ORA-00942: table or view does not exist
comment on table acs_messages_outgoing is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages_outgoing.to_address is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages_outgoing.grouping_id is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
comment on column acs_messages_outgoing.wait_until is '
*
ERROR at line 1:
ORA-00942: table or view does not exist
from cr_items i, cr_revisions r, acs_messages m
*
ERROR at line 4:
ORA-00942: table or view does not exist
from cr_items i, cr_revisions r, acs_messages m
*
ERROR at line 4:
ORA-00942: table or view does not exist
Warning: Package created with compilation errors.
Errors for PACKAGE ACS_MESSAGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/5 PL/SQL: Declaration ignored
5/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
24/5 PL/SQL: Declaration ignored
25/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
37/5 PL/SQL: Declaration ignored
38/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
41/5 PL/SQL: Declaration ignored
42/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
45/5 PL/SQL: Declaration ignored
46/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
52/5 PL/SQL: Declaration ignored
LINE/COL ERROR
-------- -----------------------------------------------------------------
53/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
59/5 PL/SQL: Declaration ignored
60/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
70/5 PL/SQL: Declaration ignored
71/26 PLS-00201: identifier 'ACS_MESSAGES.MESSAGE_ID' must be declared
85/5 PL/SQL: Declaration ignored
86/26 PLS-00201: identifier 'CR_ITEMS.ITEM_ID' must be declared
97/5 PL/SQL: Declaration ignored
98/26 PLS-00201: identifier 'CR_ITEMS.ITEM_ID' must be declared
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY ACS_MESSAGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
1/14 PLS-00905: object DOTLRNTEST.ACS_MESSAGE is invalid
1/14 PLS-00304: cannot compile body of 'ACS_MESSAGE' without its
specification
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
Installed ACS Messaging, version 4.5.
Package enabled.
# Installing data model for ACS Subsite 4.6.2...
* Loading data model /home/ola/web/dotlrntest/packages/acs-subsite/sql/oracle/acs-subsite-create.sql...
SQL*Plus: Release 8.1.7.0.0 - Production on Wed Mar 19 19:07:51 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
PL/SQL procedure successfully completed.
No errors.
Table created.
begin
*
ERROR at line 1:
ORA-02291: integrity constraint (DOTLRNTEST.ACS_REL_TYPES_OBJ_TYPE_2_FK)
violated - parent key not found
ORA-06512: at "DOTLRNTEST.ACS_REL_TYPE", line 90
ORA-06512: at line 5
No errors.
PL/SQL procedure successfully completed.
No errors.
Table created.
Package created.
No errors.
Package body created.
No errors.
1 row created.
1 row created.
View created.
View created.
View created.
View created.
Table created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Comment created.
Package created.
No errors.
Package body created.
No errors.
Table created.
PL/SQL procedure successfully completed.
No errors.
View created.
SQL> Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
Installed ACS Subsite, version 4.6.2.
Package enabled.
Posted by
Ola Hansson
on 03/19/03 02:35 PM
Argh! The first errors that I get are these:
[19/Mar/2003:19:04:01][19910.16384][-main-] Error: Query dbqd.www.index-postgresql.site_nodes is *NOT* compatible ... [19/Mar/2003:19:07:24][19910.65541][-conn1-] Error: Query dbqd.acs-templating.www.doc.demo.form.get_user_id is *NOT* compatible
Posted by
Ola Hansson
on 03/20/03 02:23 PM
This problem is no longer present when I install from the tip of the "oacs-4-6" branch. I must have accidentaly touched a file or two causing this failure.
Sorry about the false alarm.
