Bug 793668 (JBEPP-745) - Unknown error when trying to save html document
Summary: Unknown error when trying to save html document
Keywords:
Status: CLOSED NEXTRELEASE
Alias: JBEPP-745
Product: JBoss Enterprise Portal Platform 5
Classification: JBoss
Component: Site Publisher
Version: 5.1.0.GA
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.1.1.CR01
Assignee: Default User
QA Contact:
URL: http://jira.jboss.org/jira/browse/JBE...
Whiteboard: ContentExplorerPortlet eXo-JCR
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-12-16 17:11 UTC by Viliam Rockai
Modified: 2015-09-01 03:31 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2011-08-03 16:42:29 UTC
Type: Bug

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBEPP-745 0 Major Closed Unknown error when trying to save html document 2013-02-15 08:51:08 UTC

Description Viliam Rockai 2010-12-16 17:11:34 UTC 
project_key: JBEPP

How to reproduce:
login as root
click on content manager
click on drive acme/ acme news 1/ default.html
click on edit document
change something
click on save draft


sp is running on default HSQL database


log:

18:10:32,809 ERROR [portal:UIPortalApplication] Error during the processAction phase
javax.jcr.ItemExistsException: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.perform(TxIsolatedOperation.java:227)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.save(CacheableWorkspaceDataManager.java:526)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.ACLInheritanceSupportedWorkspaceDataManager.save(ACLInheritanceSupportedWorkspaceDataManager.java:225)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspaceDataManager.java:244)
	at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.save(TransactionableDataManager.java:366)
	at org.exoplatform.services.jcr.impl.core.NodeImpl.lock(NodeImpl.java:1564)
	at org.exoplatform.ecm.webui.component.explorer.control.action.EditDocumentActionComponent.editDocument(EditDocumentActionComponent.java:154)
	...
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
	at java.lang.Thread.run(Thread.java:619)
Caused by: javax.jcr.ItemExistsException: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.exoplatform.services.jcr.impl.storage.jdbc.SQLExceptionHandler.handleAddException(SQLExceptionHandler.java:129)
	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:667)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.doAdd(WorkspacePersistentDataManager.java:662)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager$ChangesLogPersister.save(WorkspacePersistentDataManager.java:387)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.save(WorkspacePersistentDataManager.java:165)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.access$101(CacheableWorkspaceDataManager.java:54)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.action(CacheableWorkspaceDataManager.java:262)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.txAction(TxIsolatedOperation.java:92)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.txAction(CacheableWorkspaceDataManager.java:268)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.perform(TxIsolatedOperation.java:210)
	... 124 more
Caused by: java.sql.SQLException: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.hsqldb.jdbc.Util.throwError(Unknown Source)
	at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
	at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:96)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
	at org.exoplatform.services.jcr.impl.storage.jdbc.optimisation.db.SingleDbJDBCConnection.addPropertyRecord(SingleDbJDBCConnection.java:232)
	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:629)
	... 132 more
javax.jcr.ItemExistsException: [collaboration] ADD PROPERTY. Item already exists. Condition: parent ID, name, index. []:1[]sites content:1[]live:1[]acme:1[]web contents:1[]News:1[]News1:1[]default.html:1[http://www.jcp.org/jcr/1.0]lockOwner:1, ID: f029625e0a2201f22fb41e6202afb969, ParentID: 39977cd27f0000010018d531d78b4342. Cause >>>> Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]: Violation of unique index JCR_IDX_SITEM_PARENT: duplicate value(s) for column(s) CONTAINER_NAME,PARENT_ID,NAME,I_INDEX,I_CLASS,VERSION in statement [insert into JCR_SITEM(ID, PARENT_ID, NAME, CONTAINER_NAME, VERSION, I_CLASS, I_INDEX, P_TYPE, P_MULTIVALUED) VALUES(?,?,?,?,?,2,?,?,?)]
	at org.exoplatform.services.jcr.impl.storage.jdbc.SQLExceptionHandler.handleAddException(SQLExceptionHandler.java:129)
	at org.exoplatform.services.jcr.impl.storage.jdbc.JDBCStorageConnection.add(JDBCStorageConnection.java:667)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.doAdd(WorkspacePersistentDataManager.java:662)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager$ChangesLogPersister.save(WorkspacePersistentDataManager.java:387)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.WorkspacePersistentDataManager.save(WorkspacePersistentDataManager.java:165)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.access$101(CacheableWorkspaceDataManager.java:54)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.action(CacheableWorkspaceDataManager.java:262)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.txAction(TxIsolatedOperation.java:92)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager$SaveInTransaction.txAction(CacheableWorkspaceDataManager.java:268)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.TxIsolatedOperation.perform(TxIsolatedOperation.java:210)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.CacheableWorkspaceDataManager.save(CacheableWorkspaceDataManager.java:526)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.ACLInheritanceSupportedWorkspaceDataManager.save(ACLInheritanceSupportedWorkspaceDataManager.java:225)
	at org.exoplatform.services.jcr.impl.dataflow.persistent.VersionableWorkspaceDataManager.save(VersionableWorkspaceDataManager.java:244)
	at org.exoplatform.services.jcr.impl.dataflow.session.TransactionableDataManager.save(TransactionableDataManager.java:366)
	at org.exoplatform.services.jcr.impl.core.NodeImpl.lock(NodeImpl.java:1564)
...
Comment 1 Tomas Kyjovsky 2010-12-16 23:16:20 UTC 
Labels: Added: ContentExplorerPortlet eXo-JCR
Comment 2 Tomas Kyjovsky 2011-03-08 19:52:42 UTC 
Related support issue: https://jira.exoplatform.org/browse/SPREDHAT-30
Comment 3 Scott Mumford 2011-07-11 07:05:02 UTC 
This issue is resolved in eXo https://jira.exoplatform.org/browse/ECMS-1940.
Marking the Release Notes as "Not Yet Documented" pending the resolution of this JIRA.
Comment 4 Scott Mumford 2011-07-11 07:05:02 UTC 
Release Notes Docs Status: Added: Not Yet Documented
Release Notes Text: Added: An 'Unknown error' encountered when attempting to save an HTML page has been resolved in this release.
Comment 5 Scott Mumford 2011-08-05 04:48:28 UTC 
Release Notes Docs Status: Removed: Not Yet Documented Added: Documented as Resolved Issue
Note You need to log in before you can comment on or make changes to this bug.