16 Feb
2010
16 Feb
'10
8:55 a.m.
Hi Alla,
adoro wrote:
Hi Marius,
thanks for your reply.
Can you try this velocity code in a new page:
{{velocity}}
$xwiki.search("select doc from XWikiDocument doc where
doc.author='XWiki.Admin'").size()
{{/velocity}}
and tell me if the same exception is thrown? And then try:
{{velocity}}
$xwiki.searchDocuments("where doc.author='XWiki.Admin'").size()
{{/velocity}}
Maybe it's a problem with the way Hibernate translates HQL to Oracle's
SQL dialect.
Hope this helps,
Marius
Does your wiki work fine besides this? The sql
that produces the
exception is pretty basic and I suspect that other features don't work
properly because of the same problem.
I haven't tested all features yet, but on the first view it looks pretty
well - I can administrate Wiki, create new groups and users and edit
dokuments. AllDocs works fine too.
I'm not sure, but could it be due to the basic problem with our
installalation, exactly speaking - with the filling tables while importing
.xar archiv. We had some error messages in JBoss and xwiki log files -
- Exception while reading document XWiki.XWikiPreferences
Wrapped Exception: a different object with the same identifier value was
already associated with the session:
[com.xpn.xwiki.doc.XWikiDocument#104408758]
and
- ORA-01400: ORA-01400: cannot insert NULL into in
("XWIKI"."XWIKILARGESTRINGS"."XWL_ID")
I reproduced this today again (S. attached).
Despite of these errors it looked like as all documents from xar archiv were
imported and I could open and edit existing pages - except of creating links
using new WYSIWYG editor.
Best Regards,
Alla
http://n2.nabble.com/file/n4561415/xwiki.log xwiki.log
http://n2.nabble.com/file/n4561415/server.log server.log