Alfresco 3.0, query problem

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

ant_bat

Hi,

I have a problem with Alfresco 3.0 installed in cluster mode that use Oracle DB. Alfresco when there is a lot of traffic is very slowly. We have noted that there are some queries that are executed more and more times with some errors. In particular we hase this query

select aspects0_.node_id as node1_0_, aspects0_.qname_id as qnam@e2_0_ from alf_node_aspects aspects0_ where aspects0_.node_id=:1‍

that return this exception ORA-01403: no data found.

Someone knows what is the problem and how to solve it?
There is some jobs that can I stopped to have better performance?

Thank you

ant_bat

We have another problem… the direct access to the contents (in particular image: jpg, fig, etc) is very very slowly. To display the contents takes 45 seconds/1 minute