3 Replies Latest reply on Jul 27, 2006 6:45 AM by Ryszard Kozmik

    Jboss Forum 2.2.1-SP3 Bug?

    John Cena Newbie

      I've tried deploying the jboss-forum-2.2.1.-SP3 to the jboss portal 2.2.1-SP3, and when I tried to go to the forum, I get a blank page. So, I've tried logging in as admin and I got this Edit Preference icon where I can see two default forums under a Dummy demo category (First and Second Forums). I tried to edit the category name and forum names but again when I go to http://localhost:8080/portal/../forum I get a blank page again!

      Is this a bug or do I need more setup? I just followed the Forum docs, and it didnt work. Better... do you have a more detailed instructions for this? Please advise...

        • 1. Re: Jboss Forum 2.2.1-SP3 Bug?
          Ryszard Kozmik Master

          I have deployed the same packages as you and they are working fine. I can think off two possibilities why this may happen to you.
          First is that ForumsModule MBean didn't deploy properly. You should see this in log at the end of starting AS.
          Second is that you may have some errors in your database. Like having topics without any posts what could cause similar efect.
          Nevertheless, check AS logs. It should give you some clue.

          • 2. Re: Jboss Forum 2.2.1-SP3 Bug?
            John Cena Newbie

            I did re-install and re-deployment of Jboss-forum... Now I can view the Dummy Demo Cat > 2 Forums... I've tried editing the names and posted my first topic under one forum. It added successfully. But when I browsed port 8080 again and logging out as admin.. when clicked on the Forum nav link I got a blank page again.

            Now i get these error messages....

            12:11:46,203 WARN [JDBCExceptionReporter] SQL Error: 932, SQLState: 42000
            12:11:46,204 ERROR [JDBCExceptionReporter] ORA-00932: inconsistent datatypes: expected - got CLOB

            12:11:46,204 ERROR [ForumsPortlet] The portlet threw an exception
            org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.jboss.portlet.forums.impl.PostImpl.attachments#6]
            at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
            at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
            at org.hibernate.loader.Loader.loadCollection(Loader.java:1926)
            at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
            at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:541)
            at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
            at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1705)
            at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
            at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
            at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:109)
            at org.hibernate.collection.PersistentBag.size(PersistentBag.java:222)
            at org.jboss.portlet.forums.ForumsPortlet.fillShowTopicContext(ForumsPortlet.java:5851)
            at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:425)
            at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:230)
            at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:217)
            at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:360)
            at org.jboss.portal.portlet.PortletContainer.invokeRender(PortletContainer.java:521)
            at org.jboss.portal.portlet.PortletContainer.dispatch(PortletContainer.java:433)
            at org.jboss.portal.server.app.ComponentInvocation.dispatch(ComponentInvocation.java:79)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:140)
            at org.jboss.portal.core.aspects.component.TransactionInterceptor.invoke(TransactionInterceptor.java:72)
            at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
            at org.jboss.portal.core.aspects.component.HeaderInterceptor.invoke(HeaderInterceptor.java:50)
            at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
            at org.jboss.portal.server.aspects.component.NavigationInterceptor.invoke(NavigationInterceptor.java:76)
            at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
            at org.jboss.portal.server.aspects.component.CacheInterceptor.invoke(CacheInterceptor.java:167)
            at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
            at org.jboss.portal.server.aspects.component.ModesInterceptor.invoke(ModesInterceptor.java:88)
            at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
            at org.jboss.portal.server.aspects.component.WindowStatesInterceptor.invoke(WindowStatesInterceptor.java:87)
            at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
            at org.jboss.portal.bridge.BridgeInterceptor.invoke(BridgeInterceptor.java:49)
            at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
            at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
            at org.jboss.portal.portlet.aspects.component.SessionPostDispatchInterceptor.invoke(SessionPostDispatchInterceptor.java:65)


            How come? at first it was working fine... and now it doesn't? Is there something wrong with the configuration? is there a way to make it stable? .. on first timers point of view, what are the loopholes?

            • 3. Re: Jboss Forum 2.2.1-SP3 Bug?
              Ryszard Kozmik Master

              I should ask about database first. From the log I see that you are using Oracle database. There is an issue with mapping hibernate objects with CLOB. The solution is to change datatype in tables JBP_FORUMS_POSTS, JBP_FORUMS_ATTACHMENTS from clob to varchar2 and it should work.