3 Replies Latest reply on Oct 5, 2008 9:15 PM by Prabhat Jha

    JBOSS PORTAL CMS Issue - Urgen Help Appreciated

    user Java Newbie

      Hi,

      I am having issues with JBOSS 2.6.5 portal with CMS. When i log in as ADMIN and create a Folder inside the CMS. First foder is created and while creating any child folders under it is throwing error.

      Stack Trace-- Any help/work around ???


      008-10-02 12:06:38,212 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK6_, wspprop0_.PROP_ID as PROP2_6_, wspprop0_.PROP_DATA as PROP3_6_ from PRTLJBOS.jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=?
      2008-10-02 12:06:38,228 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK6_, wspprop0_.PROP_ID as PROP2_6_, wspprop0_.PROP_DATA as PROP3_6_ from PRTLJBOS.jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=?
      2008-10-02 12:06:38,228 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK6_, wspprop0_.PROP_ID as PROP2_6_, wspprop0_.PROP_DATA as PROP3_6_ from PRTLJBOS.jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=?
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: insert into PRTLJBOS.jbp_cms_wsp_prop (PK, PROP_ID, PROP_DATA) values (default, ?, ?)
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK6_, wspprop0_.PROP_ID as PROP2_6_, wspprop0_.PROP_DATA as PROP3_6_ from PRTLJBOS.jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=?
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: insert into PRTLJBOS.jbp_cms_wsp_prop (PK, PROP_ID, PROP_DATA) values (default, ?, ?)
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK6_, wspprop0_.PROP_ID as PROP2_6_, wspprop0_.PROP_DATA as PROP3_6_ from PRTLJBOS.jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=?
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: insert into PRTLJBOS.jbp_cms_wsp_prop (PK, PROP_ID, PROP_DATA) values (default, ?, ?)
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK6_, wspprop0_.PROP_ID as PROP2_6_, wspprop0_.PROP_DATA as PROP3_6_ from PRTLJBOS.jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=?
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: insert into PRTLJBOS.jbp_cms_wsp_prop (PK, PROP_ID, PROP_DATA) values (default, ?, ?)
      2008-10-02 12:06:38,244 INFO [STDOUT] Hibernate: select wspnode0_.PK as PK5_, wspnode0_.NODE_ID as NODE2_5_, wspnode0_.NODE_DATA as NODE3_5_ from PRTLJBOS.jbp_cms_wsp_node wspnode0_ where wspnode0_.NODE_ID=?
      2008-10-02 12:06:38,259 INFO [STDOUT] Hibernate: insert into PRTLJBOS.jbp_cms_wsp_node (PK, NODE_ID, NODE_DATA) values (default, ?, ?)
      2008-10-02 12:06:38,259 INFO [STDOUT] Hibernate: select wspnode0_.PK as PK5_, wspnode0_.NODE_ID as NODE2_5_, wspnode0_.NODE_DATA as NODE3_5_ from PRTLJBOS.jbp_cms_wsp_node wspnode0_ where wspnode0_.NODE_ID=?
      2008-10-02 12:06:38,259 INFO [STDOUT] Hibernate: select wspprop0_.PK as PK6_, wspprop0_.PROP_ID as PROP2_6_, wspprop0_.PROP_DATA as PROP3_6_ from PRTLJBOS.jbp_cms_wsp_prop wspprop0_ where wspprop0_.PROP_ID=?
      2008-10-02 12:06:38,259 INFO [STDOUT] Hibernate: update PRTLJBOS.jbp_cms_wsp_node set NODE_ID=?, NODE_DATA=? where PK=?
      2008-10-02 12:06:38,275 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: -302, SQLState: 22001
      2008-10-02 12:06:38,275 ERROR [org.hibernate.util.JDBCExceptionReporter] DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=3.52.95
      2008-10-02 12:06:38,275 ERROR [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session
      org.hibernate.exception.DataException: could not update: [org.jboss.portal.cms.hibernate.state.WSPNode#5]
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2425)
      at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2307)
      at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2607)
      at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:92)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
      at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
      at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
      at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)