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?
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
