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; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

alfresco business reporting, installation problem

bisana

Hi
I am trying to install Alfresco Buisness reporting add one, I have downloaded "alfresco-business-reporting-0.6.5.jar " and copied it on "/opt/alfresco/tomcat/webapps/alfresco/WEB-INF/lib/"

did the necessary changes in alfresco-global.properties

reporting.db.name=alfrescoreporting
reporting.db.username=root
reporting.db.password=mypassword
reporting.db.host=localhost
reporting.db.port=3306
reporting.db.driver=org.gjt.mm.mysql.Driver
reporting.cron.filldatabase=0 0/5 * * * ?
reporting.cron.generatereports=0 0/30 * * * ?
reporting.enabled=true

#reporting.db.url=jdbc:mysql://${reporting.db.host}:${reporting.db.port}/${reporting.db.name}
reporting.db.url=jdbc:mysql://localhost/alfrescoreporting

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I have mysql library jar files in the lib directory
refered advanced installation steps at
"https://code.google.com/p/alfresco-business-reporting/wiki/AdvancedInstallation"
and followed the steps, did necessary changes

Restarted the service and I am not getting any tables created in 'alfrescoreporting' and I am getting the following error message in the log files

3-04-14 15:35:00,074  ERROR [quartz.core.JobRunShell] [DefaultScheduler_Worker-1] Job DEFAULT.scheduledFillReportingDatabaseJob threw an unhandled Exception: 
 org.alfresco.scripts.ScriptException: 03140011 Failed to execute script 'alfresco/extension/scripts/fillReportingDatabase.js': 03140010 Unable to load included script repository resource: /Company Home/Data Dictionary/Scripts/reporting/alfresco-business-reporting.lib.js
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:202)
   at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)
   at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:164)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:601)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:159)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy144.executeScript(Unknown Source)
   at org.alfresco.repo.jscript.ExecuteScriptJob.execute(ExecuteScriptJob.java:80)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 03140010 Unable to load included script repository resource: /Company Home/Data Dictionary/Scripts/reporting/alfresco-business-reporting.lib.js
   at org.alfresco.repo.jscript.RhinoScriptProcessor.loadScriptResource(RhinoScriptProcessor.java:389)
   at org.alfresco.scripts.ScriptResourceHelper.recurseScriptImports(ScriptResourceHelper.java:144)
   at org.alfresco.scripts.ScriptResourceHelper.resolveScriptImports(ScriptResourceHelper.java:60)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.resolveScriptImports(RhinoScriptProcessor.java:305)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:167)
   … 22 more
2013-04-14 15:35:00,095  ERROR [quartz.core.ErrorLogger] [DefaultScheduler_Worker-1] Job (DEFAULT.scheduledFillReportingDatabaseJob threw an exception.
 org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.scripts.ScriptException: 03140011 Failed to execute script 'alfresco/extension/scripts/fillReportingDatabase.js': 03140010 Unable to load included script repository resource: /Company Home/Data Dictionary/Scripts/reporting/alfresco-business-reporting.lib.js]
   at org.quartz.core.JobRunShell.run(JobRunShell.java:227)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.alfresco.scripts.ScriptException: 03140011 Failed to execute script 'alfresco/extension/scripts/fillReportingDatabase.js': 03140010 Unable to load included script repository resource: /Company Home/Data Dictionary/Scripts/reporting/alfresco-business-reporting.lib.js
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:202)
   at org.alfresco.repo.processor.ScriptServiceImpl.execute(ScriptServiceImpl.java:212)
   at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:164)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:601)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:159)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy144.executeScript(Unknown Source)
   at org.alfresco.repo.jscript.ExecuteScriptJob.execute(ExecuteScriptJob.java:80)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   … 1 more
Caused by: org.alfresco.error.AlfrescoRuntimeException: 03140010 Unable to load included script repository resource: /Company Home/Data Dictionary/Scripts/reporting/alfresco-business-reporting.lib.js
   at org.alfresco.repo.jscript.RhinoScriptProcessor.loadScriptResource(RhinoScriptProcessor.java:389)
   at org.alfresco.scripts.ScriptResourceHelper.recurseScriptImports(ScriptResourceHelper.java:144)
   at org.alfresco.scripts.ScriptResourceHelper.resolveScriptImports(ScriptResourceHelper.java:60)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.resolveScriptImports(RhinoScriptProcessor.java:305)
   at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:167)
   … 22 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Please guide me
Advice requested
thanks

Find more posts tagged with

Comments

abarisone

Hi,
according to this https://forums.alfresco.com/forum/developer-discussions/add-ons/buisness-reporting-reporting-folder-not-found-04152013-1013 this issue seems to be resolved…
Which was the problem?

Regards,
Andrea

bisana

Hi Andrea
you had given me the reply with a link to my previous post and telling that issue is solved.
Was it a mistake from your side.
Or did some one posted a solution which I was not able to see and issue is closed.

I have posted different thread in order to segerate my issues. my each post have differet objectives and issues
Thanks
Joseph John

abarisone

Hi,
it was my fault, I didn't notice they were posted into the same forum group…

Regards,
Andrea