topic Re: Query retrives the deleted contents in Alfresco Archive

Query retrives the deleted contents

jeyaa — Fri, 17 Dec 2010 11:49:06 GMT

Hi all,I have written the query that will populate the nodes according to its created dates. var qdate = "@cm\\:created:["+ tdate + " TO "+ fdate +"]‍Now the problem is, the above query populates also the deleted nodes. So that If I iterate the nodes, the following error occurs.Node does not exist:

Re: Query retrives the deleted contents

patil — Mon, 20 Dec 2010 10:13:12 GMT

Restart the server.
Do the reindexing

Thanks,
Patil
Cignex Technologies
Bangalore

Re: Query retrives the deleted contents

jeyaa — Wed, 22 Dec 2010 05:42:24 GMT

thanks for ur reply dude. Whats meant by reindexing? How to do that?

Re: Query retrives the deleted contents

patil — Wed, 22 Dec 2010 07:09:09 GMT

# Recovery types are:
#    NONE:     Ignore
#    VALIDATE: Checks that the first and last transaction for each store is represented in the indexes
#    AUTO:     Validates and auto-recovers if validation fails
#    FULL:     Full index rebuild, processing all transactions in order. The server is temporarily suspended.
index.recovery.mode=VALIDATE

Inside your repository.properties you can see the above properties.
Make
index.recovery.mode=VALIDATE to
index.recovery.mode=AUTO

then restart server

Thanks,
Patil
Cignex Technologies
Bangalore

Re: Query retrives the deleted contents

jeyaa — Thu, 23 Dec 2010 08:25:48 GMT

Patil,
I have tried as you said. But still the problem persists. I think the query is retriving also the archived contents. So I have modified the above query like this.

@cm\\:created:["+ tdate + " TO "+ fdate +"]  -ASPECT:\"sys:archived\"";‍

Still the problem stays. I dont have any solution for the above problem.
Shall I use archive://SpacesStore?
If so how to post it in the query?
Please help me in this issue.

Jeya A
Bangalore

Re: Query retrives the deleted contents

patil — Thu, 23 Dec 2010 11:00:23 GMT

index.recovery.mode=VALIDATE

1. try by making AUTO and FULL

2. The temporary fix is after getting the node you check the existence of the node by using
nodeService.exists(nodeRef)

Thanks,
Patil
Cignex Technologies
Bangalore

Re: Query retrives the deleted contents

jeyaa — Thu, 23 Dec 2010 11:18:53 GMT

Patil, I am getting the nodes while executing the query, how could I get the instance of nodeService?

Re: Query retrives the deleted contents

jeyaa — Fri, 24 Dec 2010 06:40:14 GMT

Hi Patil,
I didn't found any service same like nodeService. Still stuck in there. I hope this would work populating the archived nodes and then omitting it. Do you have any idea how to write a query to populate archived nodes.

Thanks,
Jeya