nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

AAAR_Extract Data Quality

diwakarm

Hi Franc,

Whatever the extraction I do, it seems that Nodes Staging Failed, I guess which in turn affects the Data Quality.

Do i have to enable any other properties from alfresco side?

####alfresco-property file#######

audit.enabled = true
audit.alfresco-access.enabled=true

AAAR.log attached,show few errors relating to getCounters.

Attached AAAR.log

What understanding am missing? Kindly teach me!

AAAR.log.zip

Find more posts tagged with

Alfresco Content Services

Accepted answers

fcorti

Hi Divakar,

Which Alfresco version are you using?
If you use an Alfresco version 5.2+, please use Alflytics instead of AAAR.

If you are using a previous version of Alfresco, did you install the AAAR AMP on the Alfresco side?
The error 400 says that the services is not there.
Please follow the documentation below.
Alfresco AMP to A.A.A.R. dashboards, reports and analysis.

All comments

fcorti

Hi Divakar,

Which Alfresco version are you using?
If you use an Alfresco version 5.2+, please use Alflytics instead of AAAR.

diwakarm

Franc,

Am using Alfresco 5.1 and i have installed the corresponding amp in it.

When i hit these URL's through by browser, I get the respective errors:

1. https://dms-stage.htcindia.com:443/alfresco/service/AAAR/getCounters?counter=auditTrail&application=alfresco-access

{     "status" :    {     "code" : 400,     "name" : "Bad Request",     "description" : "Request sent by the client was syntactically incorrect."   },        "message" : "01140054 FATAL: database \"${db.name}\" does not exist",     "exception" : "org.springframework.extensions.webscripts.WebScriptException - 01140054 FATAL: database \"${db.name}\" does not exist",      "callstack" :    [           ""      ,"org.springframework.extensions.webscripts.WebScriptException: 01140054 FATAL: database \"${db.name}\" does not exist"       ,"com.fcorti.aaar.GetCountersWebScript.executeImpl(GetCountersWebScript.java:98)"       ,"org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:512)"       ,"org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:580)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:649)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:421)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:301)"       ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)"       ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)"       ,"org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)"       ,"javax.servlet.http.HttpServlet.service(HttpServlet.java:727)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)"       ,"org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)"       ,"org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)"       ,"org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)"       ,"org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)"       ,"org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)"       ,"org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)"       ,"org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)"       ,"org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:188)"       ,"org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)"       ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2466)"       ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2455)"       ,"java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)"       ,"java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)"       ,"org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)"       ,"java.lang.Thread.run(Thread.java:745)"     ],      "server" : "Community v5.1.0 (r122274-b3) schema 9,016",   "time" : "Feb 14, 2018 10:15:16 AM" }

2. https://dms-stage.htcindia.com:443/alfresco/service/AAAR/getCounters?counter=workflowInstances

{     "status" :    {     "code" : 400,     "name" : "Bad Request",     "description" : "Request sent by the client was syntactically incorrect."   },        "message" : "01140055 FATAL: database \"${db.name}\" does not exist",     "exception" : "org.springframework.extensions.webscripts.WebScriptException - 01140055 FATAL: database \"${db.name}\" does not exist",      "callstack" :    [           ""      ,"org.springframework.extensions.webscripts.WebScriptException: 01140055 FATAL: database \"${db.name}\" does not exist"       ,"com.fcorti.aaar.GetCountersWebScript.executeImpl(GetCountersWebScript.java:98)"       ,"org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:512)"       ,"org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:580)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:649)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:421)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:301)"       ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)"       ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)"       ,"org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)"       ,"javax.servlet.http.HttpServlet.service(HttpServlet.java:727)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)"       ,"org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)"       ,"org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)"       ,"org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)"       ,"org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)"       ,"org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)"       ,"org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)"       ,"org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)"       ,"org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:188)"       ,"org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)"       ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2466)"       ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2455)"       ,"java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)"       ,"java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)"       ,"org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)"       ,"java.lang.Thread.run(Thread.java:745)"     ],      "server" : "Community v5.1.0 (r122274-b3) schema 9,016",   "time" : "Feb 14, 2018 10:18:59 AM" }

3. https://dms-stage.htcindia.com:443/alfresco/service/AAAR/getCounters?counter=workflowTasks

{     "status" :    {     "code" : 400,     "name" : "Bad Request",     "description" : "Request sent by the client was syntactically incorrect."   },        "message" : "01140056 FATAL: database \"${db.name}\" does not exist",     "exception" : "org.springframework.extensions.webscripts.WebScriptException - 01140056 FATAL: database \"${db.name}\" does not exist",      "callstack" :    [           ""      ,"org.springframework.extensions.webscripts.WebScriptException: 01140056 FATAL: database \"${db.name}\" does not exist"       ,"com.fcorti.aaar.GetCountersWebScript.executeImpl(GetCountersWebScript.java:98)"       ,"org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:512)"       ,"org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:457)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:580)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:649)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:421)"       ,"org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:301)"       ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)"       ,"org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)"       ,"org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)"       ,"javax.servlet.http.HttpServlet.service(HttpServlet.java:727)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)"       ,"org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)"       ,"org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)"       ,"org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)"       ,"org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)"       ,"org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504)"       ,"org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)"       ,"org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)"       ,"org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)"       ,"org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)"       ,"org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)"       ,"org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:188)"       ,"org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)"       ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2466)"       ,"org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2455)"       ,"java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)"       ,"java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)"       ,"org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)"       ,"java.lang.Thread.run(Thread.java:745)"     ],      "server" : "Community v5.1.0 (r122274-b3) schema 9,016",   "time" : "Feb 14, 2018 10:20:02 AM" }

fcorti

Mmm... really strange.
Can you please check (and share) the error you find into the catalina.out on Alfresco?

The issue seems to be into the AMP on Alfresco side.

diwakarm

Franc,

Am using Alfresco AMP AAAR-Alfresco-CE-v5.1--v4.5.amp's

There seems to be no error in Catalina.out other the below one,

Error getting input stream for dependency saikuWidget/SaikuWidgetComponent.js. Skipping..
java.io.IOException: Stream closed