Forum OpenACS Q&A: Problem in installing packages -- Workflow-create.sql

Hi all
I am facing this weird problem while installing packages.
It give this messy Request Error and stops
Can someone plz help me out.

This is the error log entry.

01/Mar/2003:01:00:15][14278.32773][-conn1-] Error: POST http://10.7.2.81:8000/acs-admin/apm/packages-install-4?
referred by "http://10.7.2.81:8000/acs-admin/apm/packages-install-3"
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
    while executing
"ns_pg_bind 0or1row nsdb0 {
            select acs_sc_binding__new(
                      :contract_name,
                      :impl_name
        ..."
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
    invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
            db_qd_log QDDebug "PLPGSQL: bypassed anon function"
          set selection [db_..."
    ("uplevel" body line 6)
    invoked from within
"uplevel 1 $code_block "
    invoked from within
"db_with_handle db {
        # plsql calls that are simple selects bypass the plpgsql
        # mechanism for creating anonymous functions (OpenACS - ..."
    (procedure "db_exec_plsql" line 22)
    invoked from within
"db_exec_plsql binding_new {}"
    (procedure "acs_sc::impl::binding::new" line 3)
    invoked from within
"acs_sc::impl::binding::new  -contract_name $impl(contract_name)  -impl_name $impl(name)"
    ("uplevel" body line 6)
    invoked from within
"uplevel 1 $transaction_code "
    (procedure "db_transaction" line 1)
    invoked from within
"db_transaction {
        set impl_id [new  -contract_name $impl(contract_name)  -name $impl(name)  -owner $impl(owner)]

        acs_sc::impl:..."
    (procedure "acs_sc::impl::new_from_spec" line 6)
    invoked from within
"acs_sc::impl::new_from_spec -spec $spec"
    (procedure "workflow::install::register_notification_impl" line 14)
    invoked from within
"workflow::install::register_notification_impl"
    ("uplevel" body line 11)
    invoked from within
"uplevel 1 $transaction_code "
    (procedure "db_transaction" line 39)
    invoked from within
"db_transaction {

        workflow::install::register_default_assignees_creation_user_impl
"db_transaction {
        set impl_id [new  -contract_name $impl(contract_name)  -name $impl(name)  -owner $impl(owner)]

        acs_sc::impl:..."
    (procedure "acs_sc::impl::new_from_spec" line 6)
    invoked from within
"acs_sc::impl::new_from_spec -spec $spec"
    (procedure "workflow::install::register_notification_impl" line 14)
    invoked from within
"workflow::install::register_notification_impl"
    ("uplevel" body line 11)
    invoked from within
"uplevel 1 $transaction_code "
    (procedure "db_transaction" line 39)
    invoked from within
"db_transaction {

        workflow::install::register_default_assignees_creation_user_impl
-----------
Some more ...

Collapse
Posted by Lars Pind on
Sharad,

Sorry, workflow is still under development.

There are some changes to acs-service-contract, which are required, but not yet committed to CVS.

Everything necessary will be committed over the coming week.
/Lars