Forum OpenACS Development: Bootstraping error

Collapse
1: Bootstraping error
Posted by Gilbert Wong on 07/11/01 10:49 PM
I got the following error. Is there any way to get a more detailed error message? Thanks. 
[11/Jul/2001:16:39:07][4604.1][-main-] Notice: Loading QUERIES!! 
OpenACS - ben
[11/Jul/2001:16:39:07][4604.1][-main-] Notice: Querying '
        select distinct package_key
        from apm_package_versions
        where enabled_p='t';'
[11/Jul/2001:16:39:07][4604.1][-main-] Notice: dbinit: sql
(localhost::openacs-4): '
        select distinct package_key
        from apm_package_versions
        where enabled_p='t'
    '
[11/Jul/2001:16:39:18][4604.1][-main-] Error: Server startup failed: 
Error during bootstrapping
Entity: line 18: error: Extra content at the end of the document
</queryset>
^
document was not well formed
error while parsing XML
    while executing
"ns_xml parse -persist $stuff_to_parse"
    (procedure "db_qd_internal_parse_init" line 4)
    invoked from within
"db_qd_internal_parse_init $whole_file $file_tag"
    (procedure "db_qd_internal_load_queries" line 15)
    invoked from within
"db_qd_internal_load_queries $stream $file_path"
    (procedure "db_qd_internal_load_cache" line 9)
    invoked from within
"db_qd_internal_load_cache $file_path"
    (procedure "db_qd_load_query_file" line 2)
    invoked from within
"db_qd_load_query_file $file"
    (procedure "apm_load_queries" line 25)
    invoked from within
"apm_load_queries"
[11/Jul/2001:16:39:18][4604.1][-main-] Notice: Sourcing files for 
postload...
[11/Jul/2001:16:39:18][4604.1][-main-] Notice: Done.
Collapse
2: Response to Bootstraping error (response to 1)
Posted by Dan Wickstrom on 07/11/01 11:16 PM
It appears that might have a duplicate set of </queryset> tags - maybe resulting from a cut-n-past operation.

Try looking backwards in the log file and see if you can find another error message. If I recall correctly, there will be an error message associated with particular query file that failed to parse. This will be in addition to the error that you see at the end of startup.

The first error message should indicate which .xql file failed to load correctly.

Collapse
3: Response to Bootstraping error (response to 1)
Posted by Don Baccus on 07/11/01 11:17 PM
You mean like the file name that caused the XML parser to choke?

Yeah, we should be able to provide that ... I'll look into it.

Collapse
4: Response to Bootstraping error (response to 1)
Posted by Gilbert Wong on 07/11/01 11:44 PM
Dan - This was the only error message in the log file.  I'll poke around the files I changed to see if I can find the mistake.

Don - Yes it would be helpful if file that produced the error was logged.

Collapse
5: Response to Bootstraping error (response to 1)
Posted by Bart Teeuwisse on 07/12/01 12:45 AM
I have seen a similar problem caused by /openacs-4/packages/cms/tcl/form-procs.xql. The first fullquery of this file has a typo in the closing tag <fulllquery>.

The best way to find out in which file the error ocures is to set the parameter debug to true in the ns_section ns/parameters of your configuration file.

Restart your server and tail the log file. Almost everything is now being logged. If this is not enough then also enable query logging by setting the Verbose parameter to On in the ns/db/pool/log section.

Collapse
6: Response to Bootstraping error (response to 1)
Posted by Don Baccus on 07/12/01 12:46 AM
I think providing the file name will be the best that I can do.  The actual error is coming from nsxml, and apparently the parser's not kind enough to tell you which tag's not been closed, which I would assume is the cause of the problem.

That's OK, though, these queryfiles are simple enough so that once you
know which one's failing, finding the problem should be simple.

Collapse
7: Response to Bootstraping error (response to 1)
Posted by Gilbert Wong on 07/12/01 12:50 AM
Don - providing the file name would perfect.  Thanks.
Collapse
8: Response to Bootstraping error (response to 1)
Posted by Gilbert Wong on 07/12/01 01:19 AM
Bart - Thanks.  Your suggestion helped me find the problem.  I was missing the &lt;queryset&gt; tag.
Collapse
9: Response to Bootstraping error (response to 1)
Posted by Roberto Mello on 07/12/01 02:00 AM
Bart, the CMS is not ported yet, so you loaded at your own risk. I'm halfway through the tcl procs for CMS, and I am the culprit for that "fulll" typo there.

My apologies, and thanks for letting me know.