cancel
Showing results for 
Search instead for 
Did you mean: 

integrity violation with discussion topics

ndwpgd
Champ in-the-making
Champ in-the-making
Dear all,

Did I do something wrong, or is it a bug?  :roll:

I created a discussion topic on a document
I 'checked-out' the document to the current space
I created a discussion topic on the working copy
I tried to 'check-in' the working copy:
  "Unable to check in Content Node due to system error:Transaction didn't commit: Integrity failure"
  on the alfreco.log:
11:17:11,218 ERROR [org.alfresco.repo.node.integrity.IntegrityChecker] Found 1 integrity violations:
Invalid property value:
   Node: workspace: //SpacesStore/0f72f2aa-a226-11db-acf7-ad6d5b968130
   Type: {http://www.alfresco.org/model/forum/1.0}topic
   Property: {http://www.alfresco.org/model/content/1.0}name
   Constraint: Value 'Warning - Fri Jan 12 11:17:08 CET 2007' matches regular expression: .*[\"\*\\\>\<\?\/\:\|\xA3\xAC\%\&\+\;]+.*
11:17:11,406 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Transaction didn't commit
org.alfresco.repo.node.integrity.IntegrityException: Integrity failure
11:17:11,515 ERROR [org.alfresco.web.ui.common.Utils] Unable to check in Content Node due to system error:Transaction didn't commit: Integrity failure
javax.transaction.RollbackException: Transaction didn't commit: Integrity failure

Deleting the Topic on the work document solves this (I didnt have to delete the forum itself)

I run 1.4 on MySQL 5.0.27 on XP SP2


OldNick
3 REPLIES 3

gavinc
Champ in-the-making
Champ in-the-making
It sounds like you attempted to enter a topic with an illegal character in it's name i.e a ? (question mark).

Try just alphanumeric characters and see if that makes a difference.

The client should have stopped you from continuing if there was an illegal character, so the fact that the error occurred on the server means there is a bug in that regard, pleas raise this on JIRA.

ndwpgd
Champ in-the-making
Champ in-the-making
Hi Gavin

i was just following the tutorial, page 36

it is about system-overview.html in
Bob Smith > Documentation > Published

OldNick

gavinc
Champ in-the-making
Champ in-the-making
Fair enough! The documentation can get out of date with the product in some cases, this is one of them!

To resolve your issue just create the topic without the ? at the end.

Thanks for reporting this.