Forum OpenACS Q&A: Re: SOAP Gateway Package ready

Hello William,

First, thanks a lot for contributing this package...

I downloaded this version, installed the APM and mounted the application on a folder called soap. When I try to access the service, I get this error:

06/May/2003:14:46:42][742.45288448][-sched:16-] Notice: Running scheduled proc sg_boot_libraries...
[06/May/2003:14:46:42][742.45288448][-sched:16-] Debug: NO FULLQUERY FOR dbqd.soap-gateway.tcl.soap-gateway-db-procs.sg_library_get_paths. --> using default SQL
[06/May/2003:14:46:42][742.45288448][-sched:16-] Notice: Querying '
                select path
                from sg_libraries;'
[06/May/2003:14:46:42][742.45288448][-sched:16-] Error: Ns_PgExec: result status: 7 message: ERROR:  Relation "sg_libraries" does not exist

[06/May/2003:14:46:42][742.45288448][-sched:16-] Error: dbinit: error(localhost::development,ERROR:  Relation "sg_libraries" does not exist
): '
                select path
                from sg_libraries;
        '
[06/May/2003:14:46:42][742.45288448][-sched:16-] Error: Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  Relation "sg_libraries" does not exist

SQL: 
                select path
                from sg_libraries;

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

ERROR:  Relation "sg_libraries" does not exist

SQL: 
                select path
                from sg_libraries;

    while executing
"ns_pg_bind select nsdb0 {
                select path
                from sg_libraries;
        }"
    ("uplevel" body line 1)
    invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql"
    invoked from within

For the record, I am using OpenACS 4.6.2/PostgreSQL on Mac OS X ... all the rest works fine ... Have you released a new version btw?

Thanks.

Bruno,

  I missed your messages. Sorry for the late reply. I installed the APM a few times and haven't experienced your symptoms; though, the OS was Linux. Any ideas as to why create.sql gave you a problem the first time around?