alfresco-support-tools icon indicating copy to clipboard operation
alfresco-support-tools copied to clipboard

Error in getting Active Sessions

Open mail2hemant opened this issue 9 years ago • 5 comments

We faced this error, which installing it on Alfresco One 5.1 Enterprise

An error has occured in the API: /alfresco/s/enterprise/admin/admin-activesessions. It responded with a status of 500 - Internal Error. Error Code Information: 500 - An error inside the HTTP server which prevented it from fulfilling the request. Error Message: 08110029 Wrapped Exception (with status template): 08110014 Failed to execute script 'classpath*:alfresco/enterprise/webscripts/org/alfresco/enterprise/repository/admin/support-tools/admin-activesessions.get.js': Error creating bean with name 'scriptableMBeanOperations' defined in URL [jar:file:/opt/alfresco-one/tomcat/webapps/alfresco/WEB-INF/lib/alfresco-enterprise-repository-5.1.0.5.jar!/alfresco/enterprise/jmx/jmx-script-context.xml]: Invocation of init method failed; nested exception is java.lang.NoSuchMethodError: org.apache.commons.collections.CollectionUtils.removeAll(Ljava/util/Collection;Ljava/util/Collection;)Ljava/util/Collection; Server: Alfresco Enterprise v5.1.0 (.5 r127092-b59) schema 9,018

Kindly advise solution.

mail2hemant avatar Sep 11 '16 09:09 mail2hemant

Hi, I'm doing some testing with that precise version and I cannot reproduce the issue. Could you please confirm the environment: -Version of SupportTools 1.10 or 1.11 SNAPSHOT? -JVM

  • Application server version (Tomcat?, Websphere?... Jboss? ...)

AntonioSoler avatar Sep 22 '16 10:09 AntonioSoler

Hi Antonio,

Please find the answers below:

-Version of SupportTools 1.10 or 1.11 SNAPSHOT?- 1.10 -JVM - 32 GB

Application server version (Tomcat?, Websphere?... Jboss? ...) -  **Tomcat 7.0.28**

mail2hemant avatar Sep 22 '16 12:09 mail2hemant

Hi again Hemant, I'm checking the code of this webscript and the only reason I can find for this error is that in the line 20 the query does not retrieve any Mbeans from the JMX, so in the line 21 matchingBeans[0] is null and therefore it does not have any methods.

Would it be possible to have a look at the full alfresco log file?

You can send it to me at my email account: antonio.soler(at)alfresco.com

Also if you like we could do some debugging together on this script.

AntonioSoler avatar Sep 22 '16 13:09 AntonioSoler

Hi Antonio,

The error seems to to be coming from the solr query. The query is trying to retrieve 2000 rows and our server is throwing a http 500 error.

The query works if we manually execute it in the node browser and restricting the rows to 500. Please note that we are using a sharded instance of Solr.

Please let us know if we can configure the solr query rows in your tool. You may also point us to the code where it can be changed. The error log is given below.

Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 1109260328 Request failed 500 /solr4/alfresco-5//alfresco?wt=json&fl=DBID%2Cscore&shards=10.29.16.32:8080%2Fsolr4%2Falfresco-2%2F,10.29.16.31:8080%2Fsolr4%2Falfresco-1%2F,DDMS2_IDX_06:8080%2Fsolr4%2Falfresco-0%2F,10.29.16.34:8080%2Fsolr4%2Falfresco-5%2F,10.29.16.33:8080%2Fsolr4%2Falfresco-4%2F,10.29.16.32:8080%2Fsolr4%2Falfresco-3%2F&rows=2000&df=TEXT&start=0&locale=en_US&alternativeDic=DEFAULT_DICTIONARY&sort=firstName+asc&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON&fq=%7B%21afts%7D%7Bhttp%3A%2F%2Fwww.alfresco.org%2Fmodel%2Fsecuritymarks%2F1.0%7Dclassification%3A%22TS%22+OR+%7Bhttp%3A%2F%2Fwww.alfresco.org%2Fmodel%2Fsecuritymarks%2F1.0%7Dclassification%3A%22S%22+OR+%7Bhttp%3A%2F%2Fwww.alfresco.org%2Fmodel%2Fsecuritymarks%2F1.0%7Dclassification%3A%22C%22+OR+%7Bhttp%3A%2F%2Fwww.alfresco.org%2Fmodel%2Fsecuritymarks%2F1.0%7Dclassification%3A%22U%22+OR+-ASPECT%3A%7Bhttp%3A%2F%2Fwww.alfresco.org%2Fmodel%2Fclassifiedcontent%2F1.0%7Dclassified

Thanks & Regards Kichenin

kichenin avatar Dec 09 '16 04:12 kichenin

Weird, I dont use lucene at all in this page, I only do internal requests to the People API (getperson method) to get details of the given usernames, see:

https://github.com/Alfresco/alfresco-support-tools/search?utf8=%E2%9C%93&q=getperson&type=Code

`
   for (i=0; i<=(listUserNamesNonExpired.length-1); i++)
   {
       ActiveUsers[i]= people.getPerson(listUserNamesNonExpired[i]) ;
   } 
   
   model.listUserNamesNonExpired = ActiveUsers;
        
}
main();
`

AntonioSoler avatar Dec 14 '16 12:12 AntonioSoler