6 Replies Latest reply on Dec 31, 2005 1:18 AM by Roy Russo

    portal 2.2 / sqlserver

    TT Newbie

      Hi,
      The versions are Jboss 4.0.3SP1, portal 2.2 (binary download), sqlserver 2000SP3. I created the database from scratch. Datasource is setup properly. Portal 2.0 has been successfully installed.

      The error is when startup portal2.2 it fails to load default-object.xml file. You may see the error below.
      ================================

      15:49:46,471 INFO [STDOUT] Hibernate: insert into JBP_OBJECT_NODE (PATH, NAME,
      PARENT_KEY) values (?, ?, ?)
      15:49:46,487 INFO [STDOUT] Hibernate: insert into JBP_PORTAL_OBJECT (LISTENER,
      PK) values (?, ?)
      15:49:46,487 INFO [STDOUT] Hibernate: insert into JBP_PORTAL (PK) values (?)
      15:49:46,503 INFO [STDOUT] Hibernate: insert into JBP_OBJECT_NODE (PATH, NAME,
      PARENT_KEY) values (?, ?, ?)
      15:49:46,518 WARN [JDBCExceptionReporter] SQL Error: 2627, SQLState: 23000
      15:49:46,518 ERROR [JDBCExceptionReporter] Violation of UNIQUE KEY constraint 'U
      Q__JBP_OBJECT_NODE__02084FDA'. Cannot insert duplicate key in object 'JBP_OBJECT
      _NODE'.
      15:49:46,518 ERROR [MainDeployer] Could not start deployment: file:/C:/jboss-4.0
      .3SP1/server/default/deploy/jboss-portal.sar/conf/data/default-object.xml
      org.jboss.deployment.DeploymentException: could not insert: [org.jboss.portal.co
      re.impl.model.portal.ObjectNode]; - nested throwable: (org.hibernate.exception.C
      onstraintViolationException: could not insert: [org.jboss.portal.core.impl.model
      .portal.ObjectNode])
      at org.jboss.portal.core.deployment.jboss.ObjectDeployment.start(ObjectD
      eployment.java:292)
      at org.jboss.portal.server.deployment.jboss.ServerDeployer.start(ServerD
      eployer.java:222)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      =============================

      I wonder if anyone has a similar experience.

      Thanks,
      T