Hi Alla, adoro wrote:
Hi Marius,
thanks for your reply.
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.
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
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