topic Re: Integrity Violation Problem in Alfresco Archive

Integrity Violation Problem

ivo_costa — Wed, 01 Apr 2009 13:46:24 GMT

HiI've implemented some custom behavior that manipulates Open Office files by inserting data and extracting data, but unfortunately check-in stopped working and I cannot find any link to my code on the logs Thanks for the help and sorry for the long postLOG:14:34:24,572 ERROR [org.alfresco.web.ui.co

Re: Integrity Violation Problem

ivo_costa — Wed, 01 Apr 2009 13:59:58 GMT

Before this last error I had problems with the behavior running against the checked-out documents both working copy, and locked copy

since then I've stopped the code from working against those files, and managed to remove a few errors…

unfortunately I can't get any further as I have no reference to any line from my own code

Thanks for the help

Edit:

Some explanation to what the code does

right now this code is getting a template file made in openoffice from the data dictionary, and inserting data into different spots of the document in order to generate a pre-filled-in file for the user

What is done right now is some kind of proof that it works (kinda works)… I'm getting data into the documents and data out of the documents into the meta-data. If you get to the generated node you can read the metadata, and if you change the metadata, that change will be put into the document…

You can also update the document it self, as long as you don't check-out the document, from that point on, you can't do anything at all to the documents, maybe you can still change the metadata, but I didn't really try it

So I'm looking into a problem during the check-in / check-out process…

So far what I'm left to test is what gets differente by checking in the file… and the only errors I'm getting are related to the db part that I never touched.
Right now the tests are on Derby, but I'll be checking it with MySQL during the afternoon

Steps done by the code

find the type of the node that was created
find the template for that type
open the document with openoffice by using the appropriate api similarly to the metadate extracter code for openoffice files
insert the data needed into the template
save the resulting document into de content properties of the node

Re: Integrity Violation Problem

wabson — Mon, 06 Apr 2009 13:35:06 GMT

Hi Ivo,

Take a look at the JavaDoc for AssociationExistsException, and you should see the following description:

"Thrown when an operation could not be performed because a named association already exists between two nodes "

It sounds like an issue with your model definitions, have you defined these in a custom model?

Cheers,
Will.

Re: Integrity Violation Problem

ivo_costa — Mon, 06 Apr 2009 16:09:14 GMT

Hi Will

thanks for your reply

I do have some associations on my custom model, but I was expecting that it would throw an error inside my code without getting all the way to the DB as it looks to be the case.

as you can see, it is only a simple aspect that provides an association capability:

   <aspects>
      <aspect name="me:processo">
         <title>Processo</title>
         <properties>
            <property name="me:proc">
               <type>d:int</type>
            </property>
         </properties>
         
         <associations>
            <association name="me:relatedDocs">
               <source>
                  <mandatory>false</mandatory>
                  <many>true</many>
               </source>
               <target>
                  <class>me:doc</class>
                  <mandatory>false</mandatory>
                  <many>true</many>
               </target>
            </association>
         </associations>
      </aspect>
   </aspects>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I'll take a look at the code and see if I'm missing any error catching or some unnecessary "linking"

Thanks for your help

Re: Integrity Violation Problem

ivo_costa — Thu, 23 Apr 2009 11:10:00 GMT

Hi

Just solved the problem, by stopping the behaviour from running on checked-out documents,
had to check for lock status and some other properties, on the "before" and on the "after" properties change.

this was solved for the pencil Icon, and that's fine, but now when using "check-out" from the action menu I get a different error

I just did this test on 3.1, I'll check it out with other versions later

Error log:

12:00:41,359 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: Failed to execute transaction-level behaviour public abstract void org.alfresco.repo.node.NodeServicePolicies$OnUpdatePropertiesPolicy.onUpdateProperties(org.alfresco.service.cmr.repository.NodeRef,java.util.Map,java.util.Map) in transaction df488f74-73a3-4aaa-8ca6-1a702bdac2ca
org.alfresco.error.AlfrescoRuntimeException: Failed to execute transaction-level behaviour public abstract void org.alfresco.repo.node.NodeServicePolicies$OnUpdatePropertiesPolicy.onUpdateProperties(org.alfresco.service.cmr.repository.NodeRef,java.util.Map,java.util.Map) in transaction df488f74-73a3-4aaa-8ca6-1a702bdac2ca
at org.alfresco.repo.policy.TransactionBehaviourQueue.execute(TransactionBehaviourQueue.java:201)
…