AnsweredAssumed Answered

alfresco business reporting, installation problem

Question asked by bisana on Apr 14, 2013
Latest reply on Apr 15, 2013 by abarisone
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

Outcomes