Forum .LRN Q&A: Error when upgrading from DotLRN 1.0.1Final to dotLRN 2.0.0rc1

I try to upgrade my Testserver from DotLRN 1.0.1Final to dotLRN 2.0.0rc1.

When I come to load the acs-lang data model with the command

psql -f /var/lib/aolserver/dotlearn/packages/acs-lang/sql/postgresql/acs-lang-create.sql -d dotlearn

I get the following errors:

BEGIN
psql:ad-locales.sql:44: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'ad_locale_abbrev_pk' for table 'ad_locales'
psql:ad-locales.sql:44: NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'ad_locale_name_unq' for table 'ad_locales'
psql:ad-locales.sql:44: ERROR:  Relation 'ad_locales' already exists
psql:ad-locales.sql:56: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:60: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:72: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:84: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:90: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:96: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:102: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:108: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:114: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:120: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:126: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:131: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:136: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:141: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:146: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:151: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:156: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:161: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:166: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:171: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:176: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:181: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:186: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:191: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:196: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:201: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:206: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:211: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:216: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:221: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:226: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:231: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:236: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:241: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:ad-locales.sql:246: ERROR:  current transaction is aborted, queries ignored until end of transaction block
COMMIT
BEGIN
psql:message-catalog.sql:18: NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE TABLE
psql:message-catalog.sql:33: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'lang_message_keys_pk' for table 'lang_message_keys'
psql:message-catalog.sql:33: NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
CREATE TABLE
psql:message-catalog.sql:66: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 'lang_messages_pk' for table 'lang_messages'
psql:message-catalog.sql:66: NOTICE:  CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s)
psql:message-catalog.sql:66: ERROR:  Relation 'lang_messages' already exists
psql:message-catalog.sql:102: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:130: ERROR:  current transaction is aborted, queries ignored until end of transaction block
psql:message-catalog.sql:148: ERROR:  current transaction is aborted, queries ignored until end of transaction block
COMMIT

What ist wrong here?

Thanks for help.
Best regards
Holger

Hi Holger!

I've got the same error message for the "psql -f acs-lang-create.sql" as you.  Were you able to figure this out?

For those keeping up the documentation.

For the Upgrade ACS Service Contracts manually section, the file is "contract" not "contracts", and I found I had first to cd to the directory before running the psql command, thus:
cd /var/lib/aolserver/service0/packages/acs-service-contract/sql/postgresql/upgrade/
psql -f upgrade-4.7d2-4.7d3.sql service0

For the Load acs-authentication data model I also had to cd to the directory, thus:
cd /var/lib/aolserver/service0/packages/acs-authentication/sql/postgresql/
psql -f acs-authentication-create.sql service0

I've also got a bunch of other errors to sort through, and I list excerpts.

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "enabled_p" not found

Error: Error sourcing /var/lib/aolserver/service0/packages/acs-templating/tcl/acs-templating-init.tcl:
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

Error: apm_load_queries: Unable to locate /var/lib/aolserver/service0/packages/acs-content/*.
packages/monitoring/*.
packages/openfts-driver/*.
packages/schema-browser/*.
packages/simple-survey/*.

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "locale" not found

Error: Error sourcing /var/lib/aolserver/service0/packages/acs-lang/tcl/acs-lang-init.tcl:
Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") ERROR:  Attribute "locale" not found.

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "enabled_p" not found ... [16/Mar/2004:10:13:22][3730.1074087520][-main-] Error: Error sourcing /var/lib/aolserver/service0/packages/acs-templating/tcl/acs-templating-init.tcl: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR:  Attribute "enabled_p" not found

Warning: Gettings dicts and default_lang for aspell failed with error message: "Error: Unknown Action: dump dicts"
[16/Mar/2004:10:13:22][3730.1074087520][-main-] Notice: You might want to upgrade to a more recent version of Aspell ... http://aspell.sourceforge.net/

Warning: keepalive: insufficient maxkeepalive 0:
keepalive disabled

Error: Ns_PgExec: result status: 7 message: ERROR:  No such attribute bulk_mail_messages.status ... Error: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR:  No such attribute bulk_mail_messages.status

Error: Ns_PgExec: result status: 7 message: ERROR:  Attribute "notif_user" not found ... Error: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.") ERROR:  Attribute "notif_user" not found

Does anything look familiar to you/anyone?  I'll appreciate any tips!  Thanks!