topic Alfresco 3.0, query problem in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-3-0-query-problem/m-p/247444#M200574 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>select aspects0_.node_id as node1_0_, aspects0_.qname_id as qnam@e2_0_ from alf_node_aspects aspects0_ where aspects0_.node_id=:1<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>that return this exception </SPAN><STRONG>ORA-01403: no data found</STRONG><SPAN>.</SPAN><BR /><BR /><SPAN>Someone knows what is the problem and how to solve it?</SPAN><BR /><SPAN>There is some jobs that can I stopped to have better performance?</SPAN><BR /><BR /><SPAN>Thank you</SPAN></BODY></HTML> Tue, 06 Nov 2012 18:05:44 GMT ant_bat 2012-11-06T18:05:44Z Alfresco 3.0, query problem https://connect.hyland.com/t5/alfresco-archive/alfresco-3-0-query-problem/m-p/247444#M200574 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 queryselect aspects0_.node_id as no Tue, 06 Nov 2012 18:05:44 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-3-0-query-problem/m-p/247444#M200574 ant_bat 2012-11-06T18:05:44Z Re: Alfresco 3.0, query problem https://connect.hyland.com/t5/alfresco-archive/alfresco-3-0-query-problem/m-p/247445#M200575 <HTML><HEAD></HEAD><BODY><SPAN>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</SPAN></BODY></HTML> Wed, 07 Nov 2012 13:28:17 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-3-0-query-problem/m-p/247445#M200575 ant_bat 2012-11-07T13:28:17Z