![\"\"](\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/02\/Alf_JMX_Settings-1.png\")
<\/a><\/p>\n <\/p>\n So, what to do when JMX Settings cannot be Reverted like that? There is always the possibility to clean the Database directly (while Alfresco isn’t running) but the DB tables that store the JMX Settings are rather complex. It’s not impossible but it’s definitively not the recommended option if you can avoid it. Of course, if Alfresco cannot start at all anymore, you will have to go through the Database and remove things in there, so look at the following tables: alf_prop_link<\/em>, alf_prop_value<\/em>, alf_prop_string_value<\/em>, alf_prop_root<\/em> and alf_prop_unique_ctx<\/em>. However, if Alfresco can start, then you have a much nicer and much safer way to remove JMX Settings: using the AttributeService<\/em>!<\/p>\n The AttributeService<\/em><\/a> is an interface of the Alfresco Java API to manage attributes. There isn’t much documentation about it but there are a few technical presentations: Alfresco\u2019s Attribute Service Primer<\/a> (June 2013) & Alfresco Tech Talk Live (Episode 75)<\/a> (April 2014). The idea to use this service actually came initially from Bindu Wavell<\/a> while we were discussing this topic on the Alfresco Discord (don’t hesitate to join us there<\/a>) with other members of the Alfresco Community.<\/p>\n This AttributeService<\/em> if very good for specific purposes but it’s initially part of the Java API, meaning that you would need to write a piece of Java to use it. That might be a problem for some customers or for you directly, if you aren’t really proficient in development. Fortunately, there is something, that (almost?) everybody in the Alfresco Community knows, called the JavaScript Console<\/em><\/a>. It’s an addon that allows you to use the Alfresco JavaScript API on the Repository directly, by executing the code in the Share UI (i.e. in your browser). This addon also allows to do JavaScript-Java interoperability, meaning that you can use the Java API through the JavaScript Console<\/em>. Here is an example of how to use the AttributeService.getAttributes<\/em> method in the JavaScript Console<\/em>:<\/p>\n The first 2 lines above are related to the interoperability and the rest simply list all Attributes that share the same key(s) (in the above example, the key is: [“keyCheck”]<\/em>). Using the AttributeService<\/em> in this way is really simple and it might be harder to find the correct key(s) to use because there is no documentation on it. Obviously, if it’s related to your custom attributes, then you should know the keys since you created them, but what about the Alfresco OutOfTheBox ones? Alfresco made it so that it is unfortunately impossible (as far as I could see) to retrieve and list all attributes in one go. You would need to first find at least the top-level key for the attribute you are looking for before you can retrieve the associated value(s). It took me some time but, in the end, I was able to find what I was looking for inside the alf_prop_string_value<\/em> DB table. The key(s) and its associated values are stored on this table and therefore to find them, you can just list its content. Most of the Alfresco OOTB keys appear to have a alf_prop_string_value.string_value<\/em> starting with a dot. It’s not always the case as you can see above (it’s not [“.keyCheck”]<\/em> but simply [“keyCheck”]<\/em>) but it does gives already a certain list of keys to go through. Here is an example:<\/p>\n <\/p>\n For the JMX Settings specifically, the top-level key to be used is [“.PropertyBackedBeans”]<\/em>. It is also possible to filter the list of attributes to retrieve by specifying a sub-level key. Going back to my customer case, even if the Alfresco Administration Console showed only one MBean (Alfresco:Category=Search,Type=Configuration,id1=managed,id2=solr<\/em>), the AttributeService<\/em> returned two set of Attributes stored on the DB, as I said before, one for Solr and one for Lucene:<\/p>\n<\/a><\/p>\n2022-02-03 20:15:14,962 DEBUG [jscript.RhinoScriptProcessor.calls] [exec-6] admin-systemsummary.get.js Start\n2022-02-03 20:15:15,052 DEBUG [jscript.RhinoScriptProcessor.calls] [exec-6] admin-systemsummary.get.js End 90 ms\n2022-02-03 20:15:18,165 DEBUG [jscript.RhinoScriptProcessor.calls] [exec-4] admin-jmx-settings.get.js Start\n2022-02-03 20:15:18,185 DEBUG [jscript.RhinoScriptProcessor.calls] [exec-4] admin-jmx-settings.get.js End 19 ms\n2022-02-03 20:15:37,373 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Resolving and compiling script path: jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-enterprise-remote-api-11.153.jar!\/alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/support-tools\/admin-jmx-settings.post.js\n2022-02-03 20:15:37,373 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Found script resource import: classpath:alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/admin-common.lib.js\n2022-02-03 20:15:37,374 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Succesfully located script 'classpath:alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/admin-common.lib.js'\n2022-02-03 20:15:37,374 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Found script resource import: classpath:alfresco\/templates\/webscripts\/org\/alfresco\/repository\/admin\/admin-common.lib.js\n2022-02-03 20:15:37,374 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Succesfully located script 'classpath:alfresco\/templates\/webscripts\/org\/alfresco\/repository\/admin\/admin-common.lib.js'\n2022-02-03 20:15:37,374 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Imports resolved, adding resource 'classpath:alfresco\/templates\/webscripts\/org\/alfresco\/repository\/admin\/admin-common.lib.js\n2022-02-03 20:15:37,374 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Imports resolved, adding resource 'classpath:alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/admin-common.lib.js\n2022-02-03 20:15:37,374 DEBUG [repo.jscript.RhinoScriptProcessor] [exec-1] Imports resolved, adding resource '_root\n2022-02-03 20:15:37,383 DEBUG [jscript.RhinoScriptProcessor.calls] [exec-1] admin-jmx-settings.post.js Start\n2022-02-03 20:15:37,384 DEBUG [repo.jscript.ScriptLogger] [exec-1] beanName: Alfresco_Category=Search,Type=Configuration,id1=managed,id2=solr\n2022-02-03 20:15:37,415 INFO [management.subsystems.ChildApplicationContextFactory] [exec-1] Starting 'Search' subsystem, ID: [Search, managed, solr]\n2022-02-03 20:15:37,735 WARN [management.subsystems.ChildApplicationContextFactory$ChildApplicationContext] [exec-1] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'search.solrIndexCheckService' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-enterprise-repository-11.153.jar!\/alfresco\/subsystems\/Search\/solr\/solr-jmx-context.xml]: Cannot resolve reference to bean 'solrAdminClient' while setting bean property 'solrAdminClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'solrAdminClient' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-repository-11.140.jar!\/alfresco\/subsystems\/Search\/solr\/solr-search-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\n2022-02-03 20:15:38,237 WARN [management.subsystems.ChildApplicationContextFactory] [exec-1] Startup of 'Search' subsystem, ID: [Search, managed, solr] failed\norg.springframework.beans.factory.BeanCreationException: Error creating bean with name 'search.solrIndexCheckService' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-enterprise-repository-11.153.jar!\/alfresco\/subsystems\/Search\/solr\/solr-jmx-context.xml]: Cannot resolve reference to bean 'solrAdminClient' while setting bean property 'solrAdminClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'solrAdminClient' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-repository-11.140.jar!\/alfresco\/subsystems\/Search\/solr\/solr-search-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\n at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:342)\n at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:113)\n at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1689)\n ...\nCaused by: org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\n at org.springframework.beans.BeanWrapperImpl.createNotWritablePropertyException(BeanWrapperImpl.java:243)\n at org.springframework.beans.AbstractNestablePropertyAccessor.processLocalProperty(AbstractNestablePropertyAccessor.java:432)\n at org.springframework.beans.AbstractNestablePropertyAccessor.setPropertyValue(AbstractNestablePropertyAccessor.java:278)\n ...\n2022-02-03 20:15:38,238 ERROR [management.subsystems.PropertyBackedBeanAdapter] [exec-1] java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'search.solrIndexCheckService' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-enterprise-repository-11.153.jar!\/alfresco\/subsystems\/Search\/solr\/solr-jmx-context.xml]: Cannot resolve reference to bean 'solrAdminClient' while setting bean property 'solrAdminClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'solrAdminClient' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-repository-11.140.jar!\/alfresco\/subsystems\/Search\/solr\/solr-search-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\n2022-02-03 20:15:38,239 DEBUG [jscript.RhinoScriptProcessor.calls] [exec-1] admin-jmx-settings.post.js Exception\norg.mozilla.javascript.WrappedException: Wrapped javax.management.RuntimeMBeanException: java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'search.solrIndexCheckService' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-enterprise-repository-11.153.jar!\/alfresco\/subsystems\/Search\/solr\/solr-jmx-context.xml]: Cannot resolve reference to bean 'solrAdminClient' while setting bean property 'solrAdminClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'solrAdminClient' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-repository-11.140.jar!\/alfresco\/subsystems\/Search\/solr\/solr-search-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter? (classpath*:alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/support-tools\/admin-jmx-settings.post.js#486)\n at org.alfresco.enterprise.repo.management.script.ScriptableMBeanOperations$4.call(ScriptableMBeanOperations.java:398)\n at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:98)\n at org.mozilla.javascript.gen.classpath__alfresco_enterprise_webscripts_org_alfresco_enterprise_repository_admin_support_tools_admin_jmx_settings_post_js_20._c_main_17(classpath*:alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/support-tools\/admin-jmx-settings.post.js:486)\n ...\nCaused by: org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\n at org.springframework.beans.BeanWrapperImpl.createNotWritablePropertyException(BeanWrapperImpl.java:243)\n at org.springframework.beans.AbstractNestablePropertyAccessor.processLocalProperty(AbstractNestablePropertyAccessor.java:432)\n at org.springframework.beans.AbstractNestablePropertyAccessor.setPropertyValue(AbstractNestablePropertyAccessor.java:278)\n ...\n2022-02-03 20:15:38,240 DEBUG [jscript.RhinoScriptProcessor.calls] [exec-1] admin-jmx-settings.post.js End 857 ms\n2022-02-03 20:15:38,242 ERROR [extensions.webscripts.AbstractRuntime] [exec-1] Exception from executeScript: 01030006 Wrapped Exception (with status template): 01030131 Failed to execute script 'classpath*:alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/support-tools\/admin-jmx-settings.post.js': java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'search.solrIndexCheckService' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-enterprise-repository-11.153.jar!\/alfresco\/subsystems\/Search\/solr\/solr-jmx-context.xml]: Cannot resolve reference to bean 'solrAdminClient' while setting bean property 'solrAdminClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'solrAdminClient' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-repository-11.140.jar!\/alfresco\/subsystems\/Search\/solr\/solr-search-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\norg.springframework.extensions.webscripts.WebScriptException: 01030006 Wrapped Exception (with status template): 01030131 Failed to execute script 'classpath*:alfresco\/enterprise\/webscripts\/org\/alfresco\/enterprise\/repository\/admin\/support-tools\/admin-jmx-settings.post.js': java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'search.solrIndexCheckService' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-enterprise-repository-11.153.jar!\/alfresco\/subsystems\/Search\/solr\/solr-jmx-context.xml]: Cannot resolve reference to bean 'solrAdminClient' while setting bean property 'solrAdminClient'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'solrAdminClient' defined in URL [jar:file:\/opt\/alfresco\/tomcat\/webapps\/alfresco\/WEB-INF\/lib\/alfresco-repository-11.140.jar!\/alfresco\/subsystems\/Search\/solr\/solr-search-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\n at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1139)\n at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)\n at org.alfresco.repo.web.scripts.RepositoryContainer.lambda$transactionedExecute$2(RepositoryContainer.java:556)\n ...\nCaused by: org.springframework.beans.NotWritablePropertyException: Invalid property 'solrHost' of bean class [org.alfresco.repo.solr.SOLRAdminClient]: Bean property 'solrHost' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?\n at org.springframework.beans.BeanWrapperImpl.createNotWritablePropertyException(BeanWrapperImpl.java:243)\n at org.springframework.beans.AbstractNestablePropertyAccessor.processLocalProperty(AbstractNestablePropertyAccessor.java:432)\n at org.springframework.beans.AbstractNestablePropertyAccessor.setPropertyValue(AbstractNestablePropertyAccessor.java:278)\n ...<\/pre>\n
var context = Packages.org.springframework.web.context.ContextLoader.getCurrentWebApplicationContext();\nvar attributeService = context.getBean(\"attributeService\", Packages.org.alfresco.repo.attributes.AttributeServiceImpl);\n\nattributeService.getAttributes(function(id, value, keys) {\n print(' > id: ' + id);\n print(' >> key: [\"' + keys[0] + '\", \"' + keys[1] + '\"]');\n print(' >> value: ' + value);\n print('');\n return true;\n}, [\"keyCheck\"]);<\/pre>\n<\/a><\/p>\nSQL> SELECT id, string_value\n 2 FROM alf_prop_string_value\n 3 WHERE string_value like '.%'\n 4 ORDER BY 1 ASC;\n id string_value\n------ ---------------------------------\n 21 .PropertyBackedBeans\n 46 .ChainingUserRegistrySynchronizer\n 55 .empty\n 58 .repoUsages\n 62 .SHARD_STATE\n 1372 .clusterInfo\n 1373 .cluster_name\n 1375 .clusterMembers\n 1377 .host_name\n 1379 .ip_address\n 1381 .port\n 1382 .clustering_enabled\n 1383 .last_registered\n 1384 .cluster_node_type<\/pre>\n
<\/a><\/p>\n