Forum .LRN Q&A: .LRN Installation : ERROR: Relation "apm_package_db_types" does not exist. ]

Collapse
1: .LRN Installation : ERROR: Relation "apm_package_db_types" does not exist. ]
Posted by MOUNIR LALLALI on 11/29/04 04:15 PM
Hi
I have download .LRN package 2.1 to install. I'm running Debian 2.4.27-1-686, AolServer 4.0.5, Postgresql 7.3.4 and Tcl 8.4.6.

I followed the exact steps in the installation. But it came scanning of packages, it says it can't find "apm_package_db_types"
does anyone know how to fix this?

ERROR:  Relation "apm_package_db_types" does not exist

Does anyone know how to fix this?

Thanks,
Mounir

The full message :

[29/Nov/2004:15:14:28][2105.16384][-main-] Notice: nssock: listening on 127.0.0.1:8000
[29/Nov/2004:15:14:28][2105.131081][-driver-] Notice: starting
[29/Nov/2004:15:14:28][2105.131081][-driver-] Notice: driver: accepting connections
[29/Nov/2004:15:14:32][2105.81926][-conn:service0::2] Error: Ns_PgExec: result status: 7 message: ERROR:  relation "apm_package_db_types" does not exist

[29/Nov/2004:15:14:32][2105.81926][-conn:service0::2] Error: Error sourcing /var/lib/aolserver/service0/packages/acs-bootstrap-installer/installer/install.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  relation "apm_package_db_types" does not exist

SQL:
        select case when count(*) = 0 then 0 else 1 end from apm_package_db_types
    while executing
"ns_pg_bind 0or1row nsdb0 {
        select case when count(*) = 0 then 0 else 1 end from apm_package_db_types}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    ("postgresql" arm line 2)
    invoked from within
"switch $driverkey {
                oracle {
                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
                }
      ..."
    invoked from within
"db_exec 0or1row $db $full_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
        set selection [db_exec 0or1row $db $full_name $sql]
    }"
    (procedure "db_string" line 8)
    invoked from within
"db_string db_types_exists "
        select case when count(*) = 0 then 0 else 1 end from apm_package_db_types""
    (procedure "install_do_data_model_install" line 16)
    invoked from within
"install_do_data_model_install"
    invoked from within
"if { ![install_good_data_model_p] } {
    install_do_data_model_install
} else {
    ns_write "Kernel data model already installed."
    # If kernel i..."
    (file "/var/lib/aolserver/service0/packages/acs-bootstrap-installer/installer/install.tcl" line 37)
    invoked from within
"source $__file "
[29/Nov/2004:15:14:40][2105.114696][-conn:service0::4] Error: Ns_PgExec: result status: 7 message: ERROR:  relation "apm_packages" does not exist

[29/Nov/2004:15:14:40][2105.114696][-conn:service0::4] Error: Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  relation "apm_packages" does not exist

SQL:

    select package_id from apm_packages
    where package_key = 'acs-kernel'

Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  relation "apm_packages" does not exist

SQL:

    select package_id from apm_packages
    where package_key = 'acs-kernel'


    while executing
"ns_pg_bind 0or1row nsdb0 {

    select package_id from apm_packages
    where package_key = 'acs-kernel'

      }"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    ("postgresql" arm line 2)
    invoked from within
"switch $driverkey {
                oracle {
                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
                }
      ..."
    invoked from within
"db_exec 0or1row $db $full_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
        set selection [db_exec 0or1row $db $full_name $sql]
    }"
    (procedure "db_string" line 8)
    invoked from within
"db_string acs_kernel_id_get {} -default 0"
    (procedure "ad_acs_kernel_id_mem" line 2)
    invoked from within
"ad_acs_kernel_id_mem"
    (procedure "ad_acs_kernel_id" line 2)
    invoked from within
"ad_acs_kernel_id"
    (procedure "rp_serve_concrete_file" line 25)
    invoked from within
"rp_serve_concrete_file [ad_conn file]"
    (procedure "rp_serve_abstract_file" line 60)
    invoked from within
"rp_serve_abstract_file $path"
    ("uplevel" body line 2)
    invoked from within
"uplevel $code"
    invoked from within
"ad_try {
        rp_serve_abstract_file $path
    } notfound val {
        install_return 404 "Not found" "
        The file you've requested, doesn't exist. Plea..."
    (procedure "install_file_serve" line 6)
    invoked from within
"install_file_serve "[acs_root_dir]/packages/acs-core-docs/www[join $doc_urlv /]""
    (procedure "install_handler" line 8)
    invoked from within
"install_handler cns4 {} preauth"
[29/Nov/2004:15:15:02][2105.49156][-conn:service0::0] Error: Ns_PgExec: result status: 7 message: ERROR:  relation "dual" does not exist

[29/Nov/2004:15:15:02][2105.49156][-conn:service0::0] Error: Error sourcing /var/lib/aolserver/service0/www/SYSTEM/dbtest.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  relation "dual" does not exist

SQL:
    select sysdate from dual

    while executing
"ns_pg_bind 0or1row nsdb0 {
    select sysdate from dual
}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    ("postgresql" arm line 2)
    invoked from within
"switch $driverkey {
                oracle {
                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
                }
      ..."
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
        set selection [db_exec 0or1row $db $full_statement_name $sql]
    }"
    (procedure "db_0or1row" line 23)
    invoked from within
"db_0or1row date_check {
    select sysdate from dual
}"
    (file "/var/lib/aolserver/service0/www/SYSTEM/dbtest.tcl" line 1)
[29/Nov/2004:15:15:12][2105.65541][-conn:service0::1] Error: Ns_PgExec: result status: 7 message: ERROR:  relation "dual" does not exist

[29/Nov/2004:15:15:12][2105.65541][-conn:service0::1] Error: Error sourcing /var/lib/aolserver/service0/www/SYSTEM/dbtest.tcl:
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  relation "dual" does not exist

SQL:
    select sysdate from dual

    while executing
"ns_pg_bind 0or1row nsdb0 {
    select sysdate from dual
}"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
    ("postgresql" arm line 2)
    invoked from within
"switch $driverkey {
                oracle {
                    return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
                }
      ..."
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"set selection [db_exec 0or1row $db $full_statement_name $sql]"
    ("uplevel" body line 2)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle -dbn $dbn db {
        set selection [db_exec 0or1row $db $full_statement_name $sql]
    }"
    (procedure "db_0or1row" line 23)
    invoked from within
"db_0or1row date_check {
    select sysdate from dual
}"
    (file "/var/lib/aolserver/service0/www/SYSTEM/dbtest.tcl" line 1)