search

xornand / alfresco-business-reporting

Automatically exported from code.google.com/p/alfresco-business-reporting
0 stars 0 forks source link

cannot populate data into reporting database #1

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Hi,

This is a great addon. But I got below error message after I installed it. I 
use Alfresco 4.0.c community version. There has only one table 'siteusers' in 
the reporting database. Please help tell me what was wrong. Many thanks.

14:30:01,768 ERROR [org.alfresco.reporting.AlfrescoReporting] 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'reporting.document' doesn't exist
14:30:02,593 ERROR [org.alfresco.reporting.AlfrescoReporting] 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'reporting.folder' doesn't exist
14:30:02,967 ERROR [org.alfresco.reporting.AlfrescoReporting] 
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'reporting.site' doesn't exist
14:30:06,635 ERROR [org.alfresco.reporting.JasperReporting] Cannot close 
connection after generating report...
14:30:16,481 ERROR [org.quartz.core.JobRunShell] Job 
DEFAULT.scheduledReportExecuterJob threw an unhandled Exception: 
org.alfresco.scripts.ScriptException: 06020012 Failed to execute script 
'alfresco/extension/scripts/executeAllReports.js': 06020011 
org.codehaus.groovy.control.CompilationUnit$ClassgenCallback.call(Lorg/objectweb
/asm/ClassVisitor;Lorg/codehaus/groovy/ast/ClassNode;)V
    at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:195)
    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:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    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:147)
    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 $Proxy140.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: 06020011 
org.codehaus.groovy.control.CompilationUnit$ClassgenCallback.call(Lorg/objectweb
/asm/ClassVisitor;Lorg/codehaus/groovy/ast/ClassNode;)V
    at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:499)
    at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:191)
    ... 22 more
Caused by: java.lang.AbstractMethodError: 
org.codehaus.groovy.control.CompilationUnit$ClassgenCallback.call(Lorg/objectweb
/asm/ClassVisitor;Lorg/codehaus/groovy/ast/ClassNode;)V
    at org.codehaus.groovy.control.CompilationUnit$11.call(CompilationUnit.java:747)
    at org.codehaus.groovy.control.CompilationUnit.applyToPrimaryClassNodes(CompilationUnit.java:932)
    at org.codehaus.groovy.control.CompilationUnit.doPhaseOperation(CompilationUnit.java:509)
    at org.codehaus.groovy.control.CompilationUnit.processPhaseOperations(CompilationUnit.java:487)
    at org.codehaus.groovy.control.CompilationUnit.compile(CompilationUnit.java:464)
    at net.sf.jasperreports.compilers.JRGroovyCompiler.compileUnits(JRGroovyCompiler.java:97)
    at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:188)
    at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:215)
    at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:148)
    at org.alfresco.reporting.JasperReporting.processReport(Unknown Source)
    at org.alfresco.reporting.AlfrescoReporting.processReport(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
    at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)
    at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:86)
    at org.mozilla.javascript.gen.c8._c0(alfresco/extension/scripts/executeAllReports.js:136)
    at org.mozilla.javascript.gen.c8.call(alfresco/extension/scripts/executeAllReports.js)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
    at org.mozilla.javascript.gen.c8.call(alfresco/extension/scripts/executeAllReports.js)
    at org.mozilla.javascript.gen.c8.exec(alfresco/extension/scripts/executeAllReports.js)
    at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:483)
    ... 23 more

Original issue reported on code.google.com by chew.a...@gmail.com on 2 Jul 2012 at 6:51

GoogleCodeExporter commented 8 years ago 
Hi,

I too have the same issue. After deploying all the files as per the 
instructions, I get the below error after starting the alfresco instance. Could 
you please advise why this would be.

Thanks
Karthick 

11:10:01,484 User:System ERROR [alfresco.reporting.AlfrescoReporting] com.mysql.
jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alfrescoreporting.folder
' doesn't exist
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'alfrescoreport
ing.folder' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1605)
        at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1524)
        at org.alfresco.reporting.DatabaseHelperBean.extendTable(Unknown Source)

        at org.alfresco.reporting.AlfrescoReporting.processRepositoryUpdate(Unkn
own Source)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)
        at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:24
3)
        at org.mozilla.javascript.optimizer.OptRuntime.callN(OptRuntime.java:86)

        at org.mozilla.javascript.gen.c45._c10(alfresco/extension/scripts/fillRe
portingDatabase.js:369)
        at org.mozilla.javascript.gen.c45.call(alfresco/extension/scripts/fillRe
portingDatabase.js)
        at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java
:108)
        at org.mozilla.javascript.gen.c45._c0(alfresco/extension/scripts/fillRep
ortingDatabase.js:459)
        at org.mozilla.javascript.gen.c45.call(alfresco/extension/scripts/fillRe
portingDatabase.js)
        at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:3
93)
        at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:283
4)
        at org.mozilla.javascript.gen.c45.call(alfresco/extension/scripts/fillRe
portingDatabase.js)
        at org.mozilla.javascript.gen.c45.exec(alfresco/extension/scripts/fillRe
portingDatabase.js)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(Rhin
oScriptProcessor.java:472)
        at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptPro
cessor.java:190)
        at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptSer
viceImpl.java:254)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterc
eptor.invoke(AlwaysProceedMethodInterceptor.java:34)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethod
Interceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(Audit
MethodInterceptor.java:225)
        at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInt
erceptor.java:192)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInte
rceptor.java:145)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:107)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:202)
        at $Proxy128.executeScript(Unknown Source)
        at org.alfresco.repo.jscript.ExecuteScriptJob.execute(ExecuteScriptJob.j
ava:80)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.j
ava:549)

Original comment by bsabat...@gmail.com on 31 Jul 2012 at 1:16

GoogleCodeExporter commented 8 years ago 
Sorry for the late response...

Good news and Bad news. 

The good news is that you seem to have a database (alfrescoreporting) and 
connection.
The bad news seems that you have no tables. What do you see when you open an 
mysql connection to the database and ask: 
show tables;

My bet is that there are no tables (yet). The solution is you need to manually 
create the tables by a script. In the Data Dictionary/Scripts/reporting space 
is a script createTables.js. If you select a details page, select Run Action, 
select Execute Script, select createTables.js, you create the tables needed for 
the tool to actually run.  It creates the tables as defined in 
alfresco-business-reporting.lib.js  If your tables/queries are different than 
mine: feel free to do so.

I hope this helps you further...

Tjarda

Original comment by tpee...@gmail.com on 25 Sep 2012 at 1:13

GoogleCodeExporter commented 8 years ago 
For me /reporting space there is script named 'createTables.js', I selected 
details page, I select Run Action, select execute script. 
Here I am not not able to see 'createTables.js'
Screen shot attached for reference
Advice requested

Original comment by jjk.s...@gmail.com on 2 Oct 2012 at 12:16

Attachments:

GoogleCodeExporter commented 8 years ago 
Do not import the zip file to the script directory,unzip it and then one by one 
import to the script directory. In this way you will be able to see the '*.js' 
file when you want to execute

Original comment by jjk.s...@gmail.com on 2 Oct 2012 at 12:34

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
Thanks for sharing the solution with us!

Please stay tuned for the new release somewhere end of March 2013!

Original comment by tjarda.p...@incentro.com on 13 Mar 2013 at 9:58