sujaypillai / alfresco-business-reporting Goto Github PK

Hi,

This is a very good add-on to have but for some reasons the extraction of 
document is failing. I am using alfreco-4.1.1.3. The document extraction 
managed to reach 1085 documents but it fails intermittently and eventually 
running out of memory. I have allocated 4 GB of memory to the JVM but still get 
out of memory error.

The error I am getting is as follows;

05:24:18,140 ERROR [org.quartz.core.JobRunShell] Job 
DEFAULT.scheduledFillReportingDatabaseJob threw an unhandled Exception: 
org.alfresco.scripts.ScriptException: 02210290 Failed to execute script 
'alfresco/extension/scripts/fillReportingDatabase.js': 02210289 Java heap space
    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: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: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 $Proxy158.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: 02210289 Java heap space
    at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:516)
    at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:198)

Can you please advice?

Kind Regards,

Seedim

I am trying to run this in JBOSS/RedHat system. Added the <Resource> tag as 
explained to Context.xml. On startup of Alfresco, it created Reporting node 
etc. But I get error on log saying this:

15:15:17,960 INFO  [AlfrescoSchedulerFactory] Quartz scheduler version: 1.8.3
15:15:17,961 INFO  [QuartzScheduler] JobFactory set to: 
org.alfresco.repo.scheduler.AlfrescoJobFactory@7adc1ca7
15:15:23,997 ERROR [STDERR] javax.naming.NameNotFoundException: 
alfrescoReporting not bound
....
...
15:15:24,007 INFO  [STDOUT] 15:15:24,007  WARN  
[reporting.db.DatabaseHelperBean] Reporting table information could not be 
retrieved!!

Can you please let me know, what is causing this?

Thanks,
SR

What steps will reproduce the problem?
1. After executing "harvestDefinitionMoreFrequent" 
2. When I check the log files, I could see the message
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?
4.2.d CE , reporting-share-0.8.0.3.jar , reporting-share-0.8.0.3.jar

Please provide any additional information below.
I have installed Alfresco Business reporting, I can see the tables created 
mysql> show tables;
+-----------------------------+
| Tables_in_alfrescoreporting |
+-----------------------------+
| calendar                    |
| datalistitem                |
| document                    |
| folder                      |
| forum                       |
| lastsuccessfulrun           |
| link                        |
| reportingloginaudit         |
| site                        |
+-----------------------------+
9 rows in set (0.00 sec)

Person table has not been created, I am trouble shooting for the same 

What steps will reproduce the problem?
1. Default install Alfresco 4.2.c on russian language
2. Install ABR by instruction 
https://code.google.com/p/alfresco-business-reporting/wiki/Home#Installation
3. Try "Fill reporting database" from "/Домашняя страница 
компании/Словарь 
данных/Reporting/harvestDefinitionMoreFrequent"

What is the expected output? What do you see instead?
expected no error and some result
see error:
org.alfresco.error.AlfrescoRuntimeException: 04230109 Error during command 
servlet processing: Unable to resolve item Path: /Company Home/Data 
Dictionary/Scripts/reporting/harvestDatabaseAll.js
вызвано:
java.lang.IllegalArgumentException: Unable to resolve item Path: /Company 
Home/Data Dictionary/Scripts/reporting/harvestDatabaseAll.js


What version of the product are you using? On what operating system?
Alfresco 4.2.c (Russian localization)
Ubuntu 12.04.2 LTS 64bit

Please provide any additional information below.

Hi,

What steps will reproduce the problem?
1. Prepare a report in Pentaho with barcodes.
2. Execute in Alfresco.
3. Barcodes are not showing in Alfresco.

What is the expected output? What do you see instead?
I don't see Barcodes, only empty space (under Pentaho Report Designer is OK)

What version of the product are you using? On what operating system?
Ubuntu 12.04 / Alfresco 4.0e / alfresco-business-reporting-explorer-0.8.0.amp

How can I enable barcodes in Alfresco?

Thanks for your help and Best Regards,
David

Reporting actions don't work on French installation.

You should notice in the wiki that default configuration only works on English 
installations.

See attachments for French paths (need UTF-8 file encoding)

Regards.

Hi Tjarda,

I notice that if use harvesting in incremental way after a certain period the 
data are not full aligned with lucene index

I suggest to introduce a new harvesting (refreshHarvesting) or a check on 
lessFrequent harvesting (Refresh checkbox) able to drop tables, recreate it and 
execute at least a moreFrequent harvesting

Do you think that could be add on your product roadmap?

Best regards
Vincenzo

What steps will reproduce the problem?
1. Install business reporting 0.8.0.3
2. Enable audit in alfresco-global.properties
3. Enable Audit Export on moreFrequent harvesting and Execute 
FillReportingDatabase

What is the expected output? What do you see instead?
I've monitored the login audit table (reportingloginaudit) and I see that the 
rows's number reach 50.000 on about 200.000 audit entries.
In the scheduled moreFrequent harvesting the 50.000 rows will be recalculated 
each execution based on last date? (More precisely will be always the last 
50.000 row order in descending way?)

What version of the product are you using? On what operating system?
Alfresco 4.0e on Windows Server 2008

Please provide any additional information below.
Is possibile to define an audit filter to exclude login activities done from 
admin user?

Best Regards
Vincenzo

For a custom property in an aspect:

<property name="myns:someValue">
    <title>Some Value</title>
    <type>d:int</type>
    <mandatory>false</mandatory>
</property>

if there is no value set then harvesting logs the following FATAL message

 2013-05-02 09:39:54,173  FATAL [reporting.script.AlfrescoReporting] [http-8080-6] java.sql.SQLException: Incorrect integer value: '' for column 'myns_someValue' at row 1
 java.sql.SQLException: Incorrect integer value: '' for column 'myns_someValue' at row 1

The obvious work around is to set some well known value but that's not ideal

Hi,

In the LessFrequent harvesting I have the possibility to export the whole list 
of person in a table

Is possible to export only the persons that belong to a site?
Eventually Is there a possibility to do a query to permit this in MoreFrequent?

Best Regards
Vincenzo

Does the reporting add-on support PostgreSQL?

I used it to install with the base software installation.

I'm running into similar issues as other users that it's not creating the 
tables in the postgres alfrescoreporting database.

Hi,

'Execute reporting' failed if none of your users fail to login.

Exception:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 
'reportingloginaudit.reportinglogin_login_error_user' in 'field list'

After failing to login and re-execute 'Fill Reporting Database', reports are 
correctly generated.

Regards.

What steps will reproduce the problem?
1. Install Alfresco 4.2.c - Community versión
2. Create the reporting database in MySQL
3. Copy the file jar mysql-connector-java-5.1.25-bin.jar at the path 
<alfresco>\tomcat\lib
4. Install file alfresco-business-reporting-explorer-0.8.0.3.amp
java -jar alfresco-mmt.jar install 
C:\Alfresco\amps\alfresco-business-reporting-explorer-0.8.0.3.amp 
C:\Alfresco\tomcat\webapps\alfresco.war –force
5. Copy file alfresco-business-reporting-share-0.8.0.3.jar at the path 
<alfresco>/tomcat//webapps/alfresco/WEB-INF/lib
6.Configure of tomcat for JNDI
Configure of the file <alfresco>/tomcat/conf/Catalina/localhost/alfresco.xml
Configure of the file <alfresco>/tomcat/webapps/alfresco/WEB-INF/web.xml
Configure of the file <alfresco>/tomcat/webapps/alfresco/META-INF/context.xml
7. Copy the library of the file unzip-into-webapps-alfresco-lib-0.6.5.zip to 
the path <alfresco>/tomcat//webapps/alfresco/WEB-INF/lib

What is the expected output? What do you see instead?
See the reporting folder in Data Dictionary and see the reports

What version of the product are you using? On what operating system?
Alfresco4.2.c, Alfresco Business Reporting 0.8.3, MySQL 5.6.12, Windows 7

Please provide any additional information below.
I am using Alfresco Share to see the Data Dictionary and see the reports.
I test the configuration JNDI with Report Designer and the test was success.

Hi All
I am not sure this is the correct way to post here.
I am trying out Alfresco Business Reporting, I have some thing to post, it is 
not an issue with the software, but some difficulties which I would like to get 
help from.
Is there any forum for which we could post.
I think this area is only for reporting issues related to the software bugs and 
features. 
Can you please guide me where could I post, my challenges for Alfresco Buisness 
reporting
Guidance requested
thanks 
Joseph John

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

What steps will reproduce the problem?
1. installed amp forcefully to alfresco.war 
2. created databasereporting database and given proper permission to alfresco 
user
3. edited tomcat/webapps/alfresco/META-INF/context.xml added proper values

What is the expected output? What do you see instead?
In the explorer I should be seeing "Reporting" space under Data Dictionary

What version of the product are you using? On what operating system?
I am using CE 4.2.d on Centos Linux 64 bit

Please provide any additional information below.

Hi,

I can't able to get this add-on working. 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)

I see that the javascript file refers to standard English alfresco repository 
path.

I've tested it change the path for italian repository.
Moreover I've set connection for JasperReporting in order to generate rightly 
the jasper report that use connection on DB and change a part to compile reports

I am seeing this error during Alfresco startup when reporting tables are 
accessed:

10:41:17,415 INFO  [QuartzScheduler] JobFactory set to: 
org.alfresco.repo.scheduler.AlfrescoJobFactory@48f4d2c8

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in 
your SQL syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near ''�2<x�' at line 1

Do you have any recommendation to resolve this?

Thanks!

What steps will reproduce the problem?

1. Initially I had installed alfresco-business-reporting version 8.0.1 and 
wanted to install version 8.0.3 so firstly deleted the Reporting Folder from 
data dictionary and the Reporting Scripts folder from Scripts and deleted the 
reporting database as well.

2. Created a new db and then applied the alfresco-business-reporting version 
8.0.3 amp

3. Put in the JNDI configs and started alfresco.

What is the expected output? 
The Reporting folder should be created in data dictionary

What do you see instead?
No reporting Folder in data dictionary or reporting folder in scripts

What version of the product are you using? On what operating system?

Alfresco Business Reporting 8.0.3 
Alfresco Enterprise 4.1.1.3
Redhat 6.0
Tomcat 6
MySQL 5.5

Please provide any additional information below.

There is not errors in the log file

Kind Regards,

SeedIM

Thank you for this alfresco-business-reporting..

What steps will reproduce the problem?
1. Install Alfresco4.2.c - Community version - just install alfresco
2. install Alfresco business reporting 0.8.0
3. Make Data using harvestDefinitionMoreFrequent    harvestDefinitionMoreFrequent 
in /Data Dictionary/Reporting/
4. Generation report using script in /Data 
Dictionary/Reporting/Daily/siteInfo.prpt 

What is the expected output? What do you see instead?
Make PDF reporting file but 0kb
So I check the log 
-------
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 
'alfrescoreporting.document' doesn't exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
-------
 and check the table in MySQL

mysql> show tables;
+-----------------------------+
| Tables_in_alfrescoreporting |
+-----------------------------+
| groups                      |
| lastsuccessfulrun           |
| person                      |
| reportingloginaudit         |
| siteperson                  |
+-----------------------------+
5 rows in set (0.00 sec)

Just 5 tables is in the database.


What version of the product are you using? On what operating system?
Alfresco4.2.c / Alfresco business reporting 0.8.0 / MySQL 5.1


Please provide any additional information below.


Regards
Hunter

00070000 An IO error was encountered during deployment of the AMP into the WAR

Alfresco Community 4.2.f : On Mac OSX 10.8
Tried with all type of permissions

sh-3.2# java -jar bin/alfresco-mmt.jar install 
amps/alfresco-business-reporting-explorer-1.0.1.4.amp tomcat/webapps/alfresco 
-nobackup -force


   - WARNING: The file '/WEB-INF/lib/batik-anim-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c1c638b-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-awt-util-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c1dea2c-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-bridge-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c1e5f5d-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-css-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c1efb9e-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-dom-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c1f70cf-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-ext-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c1fbef0-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-gui-util-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c203421-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-gvt-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c208242-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-parser-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c20f773-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-script-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c214594-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-svg-dom-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c2193b5-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-util-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c222ff6-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/batik-xml-1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c227e17-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/commons-math-1.1.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c22cc38-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/ehcache-core-2.5.1.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c231a59-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/flute-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c2452da-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/groovy-1.8.0.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c24a0fb-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/groovy-all-1.5.6.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c2bf3fc-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/hsqldb-1.8.0.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3283ad-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/itext-2.1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c331fee-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/itext-rtf-2.1.7.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c34315f-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/jasperreports-4.0.2.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c347f80-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/jcommon-1.0.16.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3765b1-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/jfreechart-1.0.13.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c37b3d2-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libbase-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c393a73-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libdocbundle-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c398894-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libfonts-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c39d6b5-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libformat-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3a24d6-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libformula-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3a72f7-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libformula-ui-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3bf998-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libloader-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3c47b9-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libpixie-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3c95da-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/librepository-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3d0b0b-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libserializer-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3d592c-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libswing-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3d803d-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/libxml-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3df56e-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/mail-1.4.1.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3e1c7f-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-metadata-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3e91b0-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-platform-repository-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3f5501-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-registry-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c3ff142-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-classic-core-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c4150d3-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-classic-extensions-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c44fa54-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-classic-extensions-cda-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c454875-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-classic-extensions-mondrian-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c45e4b6-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-classic-extensions-xpath-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c4680f7-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-legacy-charts-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c46cf18-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-legacy-functions-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c471d39-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/pentaho-reporting-engine-wizard-core-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c47444a-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/poi-3.9.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c47926b-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/poi-ooxml-3.9.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c49672c-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/poi-ooxml-schemas-3.9.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c4a2a7d-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/report-designer-5.0.1-stable.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c4dfb0e-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/report-designer-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c5044ff-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/report-designer-ext-legacy-charts-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c5463b0-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/report-designer-ext-pentaho-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c54b1d1-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/report-designer-ext-toc-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c54fff2-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/report-designer-ext-wizard-5.1.0.0-752.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c554e13-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/sac-1.3.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c55ea54-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/simple-jndi-0.11.3.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c565f85-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/xml-apis-ext-1.3.04.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c56ada6-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/xmlParserAPIs-2.6.2.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c56fbc7-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/lib/alfresco-business-reporting-explorer-1.0.1.4.jar' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c5749e8-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/audit/alfresco-audit-login.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c5aa549-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/bootstrap/import_into_datadictionary.acp' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c5eeb0a-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/bootstrap/import_into_scripts.acp' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c5f874b-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/messages/reporting.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c5fd56c-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/messages/webclient.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c60238d-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mimetype/reporting-mimetype-custom-extensions.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6071ae-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/model/reporting-model.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c60bfcf-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.Dialect/reporting-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c613500-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.Dialect/reporting-model.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c618321-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.Dialect/workflow-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c61d142-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.MySQLInnoDBDialect/reporting-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c621f63-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.MySQLInnoDBDialect/reporting-model.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c626d84-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.MySQLInnoDBDialect/workflow-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c629495-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.OracleDialect/reporting-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6309c6-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.OracleDialect/reporting-model.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6357e7-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.OracleDialect/workflow-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c63a608-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.PostgreSQLDialect/reporting-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c63f429-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.PostgreSQLDialect/reporting-model.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c64424a-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.PostgreSQLDialect/sqlMapConfig.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c64695b-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/org.hibernate.dialect.PostgreSQLDialect/workflow-SqlMap.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c64906c-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/sqlAlfrescoMapConfig.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c64b77d-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/mybatis/sqlReportingMapConfig.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c65059e-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/executeReportingContainer.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c657acf-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerDaily.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c65a1e0-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerHourly.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c65c8f1-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerMonthly.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c661712-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerWeekly.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c66da63-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/executeReportingRoot.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c670174-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/executeReportingTemplate.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6776a5-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/getAllTableNames.js.not' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c679db6-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/harvestDatabase.lib.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c67c4c7-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/harvestDatabaseAll.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6812e8-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/harvestDatabaseLessFrequent.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6839f9-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/harvestDatabaseMoreFrequent.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c68fd4a-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/scripts/migrateTo1-0-2-0.js' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c69245b-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/templates/webscripts/org/alfresco/reportingstatus.get.desc.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c69998c-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/webscripts/org/alfresco/reportingstatus.get.desc.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6a0ebd-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/alfresco-global.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6a5cde-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/faces-config.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6a83ef-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/log4j.properties' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6aab00-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/reporting-model.properties.not' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6ad211-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/licenses/license.txt' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6b2032-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/context/mybatis-context.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6b6e53-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/context/reporting-beans-context.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6b9564-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/context/reporting-cron-context.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6bbc75-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/context/reporting-model-context.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6c0a96-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/module-context.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6c31a7-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/WEB-INF/classes/alfresco/module/org.alfresco.reporting/ui/web-client-config-custom.xml' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6c7fc8-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes/jasper.gif' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6d1c09-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes/jasper.png' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6d431a-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes/jrxml.gif' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6d6a2b-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes/jrxml.png' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6d913c-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes/prpt.gif' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6db84d-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes/prpt.png' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6ddf5e-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes32/jasper.gif' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6e2d7f-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes32/jasper.png' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6e5490-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes32/jrxml.gif' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6e7ba1-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes32/jrxml.png' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6ec9c2-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes32/prpt.gif' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6ef0d3-9650-11e4-b5e3-dbf57f79a936.bin'
   - WARNING: The file '/images/filetypes32/prpt.png' is being overwritten by this module. The original has been backed-up to '/WEB-INF/classes/alfresco/module/backup/1c6f8d14-9650-11e4-b5e3-dbf57f79a936.bin'
00070000 An IO error was encountered during deployment of the AMP into the WAR

What steps will reproduce the problem?
1. Enable less-frequent harvesting 
2. Verify siteperson table

What is the expected output? What do you see instead?
I see rightly all site members but any row do not include the enroll date

What version of the product are you using? On what operating system?
Alfresco 4.0.e - Windows 2008 Server R2

Please provide any additional information below.
Is possible to have in sitemember also the date when the user has been added to 
site?

Best Regards
Vincenzo

What steps will reproduce the problem?
1. Follow documentation steps on Alfresco 4.0d
2. Execute executeAllReport.js using Alfresco Command Servlet

What is the expected output? What do you see instead?
Execution of sample report using JasperReport at least
Obtain instead the following error:

Caused by: org.alfresco.error.AlfrescoRuntimeException: 00140017 
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


What version of the product are you using? On what operating system?
Alfresco 4.0d / MySQL 5.5.21 on Windows 2008 Server

Please provide any additional information below.

I've include all standard libraries of zip file 
unzip-into-webapps-alfresco-lib-0.6.5 (skipping xpp3-1.1.3_8.jar and 
xmlsec-1.4.1.jar that already existed). Probably the problem is related to some 
jar dependencies but I've used only standard alfresco jars

The Home page of the Wiki seems to be broken just after explaining how to 
define the JNDI source.

Bye

Hi,

It would be great if the parameters of the 'alfrescoReportingDatabaseHelper' 
bean could be externalise into a properties file.

It would be appreciate to be able to override 'database', 'username' and 
'password' directly from alfresco-global.properties file.

Regards.

1.Define a model that has folder subtype with over 132 text fields or several 
different types that have in total over 132 different text fields.
2.Create a couple of folders of this types
3.Install alfresco reporting
4.Try to harvest all data

The harvesting ends silently, but the "folder" table is not correctly populated 
because the maximum row size for Mysql was hit. This is a general problem, not 
"folder" specific.

I know the problem is row size because I debugged the module and I even managed 
to get the screenshot attached here, but the Alfresco log did not report 
anything.

So the first an easily fixable problem is that database exceptions shouldn't be 
swallowed like that, they should be at least logged and preferably the user 
should be notified. I think this error happens in line 750 of AlfrescoReporting 
class, when calling extendTable.

The second and not so easy to fix problem is the row limit itself.

This happens to me with around 60 fields, you don't need the 132 I stated but 
with 132 will happen for sure because each field is represented as a 
VARCHAR(500) and the row size limit in mysql is around 65500 bytes. I'm using 
UTF-8 so probably each field is already taking 1500bytes 
(http://dev.mysql.com/doc/refman/5.5/en/column-count-limit.html)

The only "easy" way I see to solve this problem is creating alfresco text  
fields as TEXT. TEXT fields take a fixed small size (12 bytes) in the row 
because the data itself is not in the row. With this change no limit should be 
hit until well over 5000 fields. Not sure though if there will be any 
significant performance drop due to this change.

Hi All,
I do not know, if my question is too basic. Before posting it here I tried 
doing it using pentahoo reporter, but was not success, my DB skills are not 
that great.
Now in alfrescoreporing I have tables

MariaDB [alfrescoreporting]> show tables;
+-----------------------------+
| Tables_in_alfrescoreporting |
+-----------------------------+
| calendar                    |
| datalistitem                |
| document                    |
| folder                      |
| forum                       |
| groups                      |
| lastsuccessfulrun           |
| link                        |
| person                      |
| reportingloginaudit         |
| site                        |
| siteperson                  |
+-----------------------------+
12 rows in set (0.00 sec)

From this tables, which table can I join to find the Top/Checking/Checking/ 
Document created users. I have tried lot with peron, document,site, but I think 
my join statement was not correct and I was never getting the proper result.

I request advice and guidance 
thanks 
Joseph John 

What steps will reproduce the problem?
1.Modify harvestMoreFrequent... such that search term is not valid
2.execute harvestMoreFrequent
3.

What is the expected output? What do you see instead?
I would expect search query to fail and the lastsuccessfulrun to have some 
state (even done) that allows processing to continue for other tables
I see the lastsuccessfulrun table left with a state of "Running" and then there 
does not appear to be a way to clear that table/row such that query can be 
fixed and job re-run
Is there some way to clear the status of a row lastsuccessfulrun 

What version of the product are you using? On what operating system?
1.0.0.3 - Windows

Please provide any additional information below.
I understand that Running in LastsuccessfulRun stops other harvesting from 
occurring. Makes sense. But if you have an issue/failure, I not sure how to 
clear that table or have it continue to next table short of dropping all tables 
vand re-running

What steps will reproduce the problem?
1. Install last Alfresco Business Reporting on Afresco
2. Configure it on Oracle (I've also add -Duser.timezone=CET to JAVA_OPTS)
3. Execute Harvesting More Frequent

What is the expected output? What do you see instead?

All table created instead, I receive an error on the follow lucene query:

TYPE:"cm:folder" AND NOT TYPE:"st:site" AND NOT TYPE:"dl:dataList" AND NOT 
TYPE:"bpm:package" AND NOT TYPE:"cm:systemfolder" AND NOT TYPE:"fm:forum" AND 
NOT TYPE:"fm:post" AND NOT TYPE:"fm:topic" AND NOT @cm:name:emplo* AND NOT 
@cm:name:persn* AND NOT @cm:creator:System AND 
@cm\:modified:[1970-01-01T01:00:00 TO NOW]

Note that I'm not able to run this query on Node Browser.
If I remove @cm\:modified:[1970-01-01T01:00:00 TO NOW] all work fine
In the same way seems works adding '' (@cm\:modified:['1970-01-01T01:00:00' TO 
NOW]

What version of the product are you using? On what operating system?
Alfresco 4.0.d
Alfresco Business Reporting 1.0.1.4
DB: Oracle 11g R2
OS: Linux Centos 7 x64


Please provide any additional information below.

The detailed error is:

SEVERE: org.apache.solr.common.SolrException: 
org.apache.lucene.queryParser.ParseException: Cannot parse 'TYPE:"cm:folder" 
AND NOT TYPE:"st:site" AND NOT TYPE:"dl:dataList" AND NOT TYPE:"bpm:package" 
AND NOT TYPE:"cm:systemfolder" AND NOT TYPE:"fm:forum" AND NOT TYPE:"fm:post" 
AND NOT TYPE:"fm:topic" AND NOT @cm:name:emplo* AND NOT @cm:name:persn* AND NOT 
@cm:creator:System AND @cm\:modified:[1970-01-01T01:00:00 TO NOW] ': 
Encountered " ":" ": "" at line 1, column 212.
Was expecting one of:
    <EOF> 
    <AND> ...
    <OR> ...
    <NOT> ...
    "+" ...
    "-" ...
    "(" ...
    "*" ...
    "^" ...
    <QUOTED> ...
    <TERM> ...
    <FUZZY_SLOP> ...
    <PREFIXTERM> ...
    <WILDTERM> ...
    "[" ...
    "{" ...
    <NUMBER> ...

    at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:108)
    at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:174)
    at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:131)
    at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)
    at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:338)
    at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.lucene.queryParser.ParseException: Cannot parse 
'TYPE:"cm:folder" AND NOT TYPE:"st:site" AND NOT TYPE:"dl:dataList" AND NOT 
TYPE:"bpm:package" AND NOT TYPE:"cm:systemfolder" AND NOT TYPE:"fm:forum" AND 
NOT TYPE:"fm:post" AND NOT TYPE:"fm:topic" AND NOT @cm:name:emplo* AND NOT 
@cm:name:persn* AND NOT @cm:creator:System AND 
@cm\:modified:[1970-01-01T01:00:00 TO NOW] ': Encountered " ":" ": "" at line 
1, column 212.
Was expecting one of:
    <EOF> 
    <AND> ...
    <OR> ...
    <NOT> ...
    "+" ...
    "-" ...
    "(" ...
    "*" ...
    "^" ...
    <QUOTED> ...
    <TERM> ...
    <FUZZY_SLOP> ...
    <PREFIXTERM> ...
    <WILDTERM> ...
    "[" ...
    "{" ...
    <NUMBER> ...

    at org.apache.lucene.queryParser.QueryParser.parse(QueryParser.java:205)
    at org.alfresco.solr.query.AlfrescoLuceneQParserPlugin$AlfrescoLuceneQParser.parse(AlfrescoLuceneQParserPlugin.java:102)
    at org.apache.solr.search.QParser.getQuery(QParser.java:131)

Installed amp and configured everything giving exception in alfresco.log

Caused by: org.alfresco.service.cmr.repository.ContentIOException: 11230045 
Failed to perform ImageMagick transformation: 
Execution result: 
   os:         Windows 7
   command:    E:\AlfrescoNew\imagemagick\convert.exe E:\ALFRES~3\tomcat\temp\Alfresco\ImageMagickContentTransformerWorker_source_3446350377537688753.pdf[0] -auto-orient -resize "100x100>" E:\ALFRES~3\tomcat\temp\Alfresco\ImageMagickContentTransformerWorker_target_2361059201049921732.png
   succeeded:  false
   exit code:  1
   out:        gs: Interpreter revision (906) does not match gs_init.ps revision (856).

   err:        convert.exe: `%s': %s "C:/Program Files (x86)/gs/gs9.06/bin/gswin32c.exe" -q -dQUIET -dPARANOIDSAFER -dBATCH -dNOPAUSE 


for more details please check attached file

What steps will reproduce the problem?
1. Installed AMP and Jars on Ubuntu 12.04 and restarted Alfresco
2. Navigated to Data Dictionary/Reporting and ran the "fill database script"
3. Received the following error:

org.alfresco.error.AlfrescoRuntimeException: 04140037 Error during command 
servlet processing: The transaction has already been marked for rollback
caused by:
javax.transaction.RollbackException: The transaction has already been marked 
for rollback

Hide Details

org.alfresco.error.AlfrescoRuntimeException: 04140037 Error during command 
servlet processing: The transaction has already been marked for rollback
at org.alfresco.web.app.servlet.CommandServlet.service(CommandServlet.java:194)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:305)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:210)
at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:68)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav
a:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at 
org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(C
hainingSubsystemProxyFactory.java:116)
at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM
ethodInvocation.java:172)
at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.j
ava:202)
at $Proxy246.doFilter(Unknown Source)
at 
org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java
:82)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:243)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:210)
at 
org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizatio
nFilter.java:61)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt
erChain.java:243)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.
java:210)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2
22)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1
23)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.jav
a:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118
)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at 
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor
.java:1002)
at 
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractPro
tocol.java:585)
at 
org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoin
t.java:1771)
at 
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at 
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)
Caused by: javax.transaction.RollbackException: The transaction has already 
been marked for rollback
at 
org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserT
ransaction.java:456)
at org.alfresco.web.app.servlet.CommandServlet.service(CommandServlet.java:159)

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.

I also did not get an "alfresco.xml" file.  I did edit the context.xml to look 
like this:

<?xml version="1.0" encoding="UTF-8"?>
<Context>
  <!-- Uncomment in $CATALINA_BASE/conf/[enginename]/[hostname]/alfresco.xml to define your own datasource. Add value attributes to each of the environment ta$
  <!-- Resource defaultTransactionIsolation="-1" defaultAutoCommit="false" maxActive="100" initialSize="10" password="alfresco" username="alfresco" url="jdbc:$
  <Environment override="false" type="java.lang.Boolean" name="properties/startup.enable" description="A flag that globally enables or disables startup of the$
  <Environment override="false" type="java.lang.String" name="properties/dir.root" description="The filesystem directory below which content and index data is$
  <Environment override="false" type="java.lang.String" name="properties/hibernate.dialect" description="The fully qualified name of a org.hibernate.dialect.D$
  <Environment override="false" type="java.lang.String" name="properties/hibernate.query.substitutions" description="Mapping from tokens in Hibernate queries $
  <Environment override="false" type="java.lang.Boolean" name="properties/hibernate.jdbc.use_get_generated_keys" description="Enable use of JDBC3 PreparedStat$
  <Environment override="false" type="java.lang.String" name="properties/hibernate.default_schema" description="Qualify unqualified table names with the given$

  <Resource defaultTransactionIsolation="-1" defaultAutoCommit="true"
                maxActive="10" maxIdle="3" initialSize="1"
                username="username" password="password"
                url="jdbc:mysql://servername:3306/alfrescosvn-reporting"
                driverClassName="org.gjt.mm.mysql.Driver"
                type="javax.sql.DataSource" auth="Container"
                name="jdbc/alfrescosvn-reporting"/>

</Context>

Where username/password and servername have the actual info.  I also tried 
changing the "name=" as shown above hoping it needed the database name but that 
didn't help...

Using Reporting/Daily/sitesPerUser.ppt

I changed the outputFormat in Reporting Properties to excel and Executed the 
report. (this is all I did)

The Reports/sitesPerUser.xls was created with the correct mime type however the 
actual file generated is a PDF

See attachments

The file looks fine if you open it as a PDF

Using Alfresco 4.0.e - alfresco-business-reporting-0.8.0.1

What steps will reproduce the problem?
1. Install Alfresco 4.2.c, start service
2. Create reporting database, install 0.8.0.2 amp, modify 
tomcat/conf/Catalina/localhost/alfresco.xml
3. look log-files, wait end update, restart alfresco, look log-files

What is the expected output? What do you see instead?

 2013-06-06 09:02:47,493  INFO  [repo.module.ModuleServiceImpl] [localhost-startStop-1] Starting module 'org_alfresco_reporting' version 0.8.0.2.
 2013-06-06 09:02:47,535  ERROR [repo.module.ModuleComponentHelper] [localhost-startStop-1] The component 'org_alfresco_reporting_bootstrapSpaces' belongs to a non-existent module 'org.alfresco.reporting'.

and i don't see "Reporting" folder in "Data Dictionary"

What version of the product are you using? On what operating system?
4.2.c, ubuntu 12.04 x64

Please provide any additional information below.

What steps will reproduce the problem?
1. My installation was smooth, was able to create tables, I could see 
information entering in to the tables


What is the expected output? What do you see instead?
Getting error in Catalaina.out

What version of the product are you using? On what operating system?
Using 0.6.5 on Alfresco CE 4.0.e , on CentOS

Please provide any additional information below.
I am getting error message such as 
[layout.output.AbstractReportProcessor] [DefaultScheduler_Worker-4] : Report 
processing failed.
 org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Failed at query: SELECT
      COUNT(*) AS numberOfDocs,
     `document`.`sys_archivedBy` as deletor
FROM
     `document`
WHERE
      `document`.`sys_store_protocol`="archive"
  AND `document`.`sys_archivedBy`IS NOT NULL
GROUP BY
     `document`.`sys_archivedBy`
ORDER BY
     numberOfDocs DESC
LIMIT 10
        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SimpleSQLReportDataFactory.queryData(SimpleSQLReportDataFactory.java:254)
        at org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory.queryData(SQLReportDataFactory.java:95)

I have added the catalina.out as attachment

What steps will reproduce the problem?
1. Install alfresco business reporting on Alfresco 4.0.e

I see that in tomcat/webapps/WEB-INF/lib there are some libraries that are in 
conflict on the Alfresco version:

poi-3.8-beta5-20111128.jar <-- Alfresco 4.0.e
poi-3.9.jar <-- Alfresco Busines Reporting 1.0.1.4

poi-ooxml-3.8-beta5-20111128.jar <-- Alfresco 4.0.e
poi-ooxml-3.9.jar <-- Alfresco Busines Reporting 1.0.1.4

mail.jar <-- Alfresco 4.0.e
mail-1.4.1.jar <-- Alfresco Busines Reporting 1.0.1.4

groovy-1.7.5.jar <-- Alfresco 4.0.e
groovy-1.8.0.jar <-- Alfresco Busines Reporting 1.0.1.4

Is correct that I must have both version?
Can it cause some malfunction?

Best Regards
Vincenzo

What steps will reproduce the problem?
1. Build amp and jar using source code (ant tasks: package-amp-explorer, 
package-jar-share)
2. Install alfresco-business-reporting-explorer-0.8.0.3.amp
3. Copy alfresco-business-reporting-share-0.8.0.3.jar in tomcat/shared/lib
4. Launch Reporting console from Repository link in Share 

What is the expected output? What do you see instead?
Expect to see Repository Console

What version of the product are you using? On what operating system?
Alfresco 4.0e on Windows 2008 Server R2 Standard
MySQL 5.5

Please provide any additional information below.
I see that in the alfresco-business-reporting-share-0.8.0.3.jar in download 
there is also the section org\......\reporting-admin-console-context.mxl that 
not exists when build using ant

Are missing the files starting from source code or I've wrong something?

Thanks
Vincenzo

What steps will reproduce the problem?
1.Did all the steps as shown in the wiki
2.checked the database tables
3.

What is the expected output? What do you see instead?
In the video "Rentaho Reporting - create parametrized report" , I could see 
more tables than what I have, I do not have tables such as "groups", "person", 
"site-person"

What version of the product are you using? On what operating system?
CE 4.2.e, on Fedora 19

Please provide any additional information below.

Database changed
MariaDB [alfrescoreporting]> show tables;
+-----------------------------+
| Tables_in_alfrescoreporting |
+-----------------------------+
| calendar                    |
| datalistitem                |
| document                    |
| folder                      |
| forum                       |
| lastsuccessfulrun           |
| link                        |
| reportingloginaudit         |
| site                        |
+-----------------------------+
9 rows in set (0.00 sec)

Login audit data is harvested, but not other auditing data.

I'm aware that auditing trails can vary from one installation to another and 
maybe that makes it quite difficult to harvest all audit related information 
but maybe audit trails generated by the default "alfresco-access" application 
could be achieved. That would open the door to make reports such:

- Usage history per path: To check who did what with a file or afolder.
- Usage history per user: To check what a user did to content.

Bye

What steps will reproduce the problem?
1. After installing the amp file using force option, then keeping the jar 
"alfresco-business-reporting-share-0.8.0.3.jar" file in 
"/opt/alfresco/tomcat/lib/"

2. restarted 
3. through web interface tried to access the report console

What is the expected output? What do you see instead?
It should be showing the report console

What version of the product are you using? On what operating system?
4.2.d CE 

Please provide any additional information below.

What steps will reproduce the problem?
1. install AMP 
2.restart the alfresco instcance 
3. check for the file 'alfresco.xml'  at tomcat/conf/Catalina/localhost/

What is the expected output? What do you see instead?
I was expecting the file "tomcat/conf/Catalina/localhost/alfresco.xml"  is 
there 

What version of the product are you using? On what operating system?
4.2.c on 64 bit Ubuntu 
using lfresco-business-reporting-explorer-0.8.0.1.amp
Please provide any additional information below.

What steps will reproduce the problem?
1. install extension
2. harvest
3. look in database for datetime fields in folder or document tables

What is the expected output? What do you see instead?
I have a file created at 17:30. In database i see 5:30.
So is AM or PM?


What version of the product are you using? On what operating system?
-alfresco-business-reporting v0.8.0.3
-fedora 18 / centos 6.4

Please provide any additional information below.
Standard instalation

Hy,

I am using Alfresco 4.0.0 and I am getting this error when the cron job runs:


ERROR [quartz.core.JobRunShell] [DefaultScheduler_Worker-8] Job 
DEFAULT.scheduledReportExecuterJob threw an unhandled Exception: 
 org.alfresco.scripts.ScriptException: 10120719 Failed to execute script 'alfresco/extension/scripts/executeAllReports.js': 10120718 org.codehaus.groovy.control.CompilationUnit$ClassgenCallback.call(Lorg/objectweb/asm/ClassVisitor;Lorg/co
dehaus/groovy/ast/ClassNode;)V
        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.GeneratedMethodAccessor937.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)


Manually running the script executeAllReports.js also get a similar error.

Can you help?

Regards,

What steps will reproduce the problem?
1. Change default presets.xml
2. Create a site
3. Create some folders
4. Execute Fill Reporting DB

What is the expected output? What do you see instead?
Only When I add query folder=TYPE:"cm:folder" AND NOT TYPE:"st:site" AND NOT 
TYPE:"dl:dataList" AND NOT TYPE:"bpm:package" AND NOT TYPE:"cm:systemfolder" 
AND NOT TYPE:"fm:forum" the result of the job remains in "Running" status (I 
see also the record registered in the reporting console). 

What version of the product are you using? On what operating system?
Alfresco 4.0e on Windows Server 2008 R2

Please provide any additional information below.
1) If I exclude folder query I haven't problem
2) In the log I not receive any errors so the lucene query works fine

- Have you an idea of the problem?
- Is there a possibility to run the job only to rows in "Done" status excluding 
rows in "Running" status?

P.S. If the users are > 50.000 the folder query return too many values so I 
receive readtimeout, so I've to refine the query excluding the folder that 
represent the users created

Thanks
Vincenzo

What steps will reproduce the problem?
1. Install standard Alfresco 4.0e 64 bit with windows installer
2. Install Alfresco business reporting amp
3. Copy alfresco-business-reporting-share-0.8.0.jar in tomcat\shared\lib

What is the expected output? What do you see instead?

Normal Execution 

What version of the product are you using? On what operating system?

Alfresco 4.0.e (64bit) / Windows Server 2008 R2

Please provide any additional information below.

2013-04-09 14:05:00,199  ERROR [quartz.core.JobRunShell] 
[DefaultScheduler_Worker-2] Job DEFAULT.scheduledReportExecuterJobHourly threw 
an unhandled Exception: 
 org.alfresco.scripts.ScriptException: 03090121 Failed to execute script 'alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerHourly.js': 03090120 Failed to execute search: PATH:"/app:company_home"
    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.proceedWithAudit(AuditMethodInterceptor.java:232)
    at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:199)
    at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:152)
    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 $Proxy133.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: 03090120 Failed to 
execute search: PATH:"/app:company_home"
    at org.alfresco.repo.jscript.Search.query(Search.java:821)
    at org.alfresco.repo.jscript.Search.query(Search.java:779)
    at org.alfresco.repo.jscript.Search.query(Search.java:738)
    at org.alfresco.repo.jscript.Search.luceneSearch(Search.java:326)
    at org.alfresco.repo.jscript.Search.luceneSearch(Search.java:311)
    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.call1(OptRuntime.java:66)
    at org.mozilla.javascript.gen.c11._c0(alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerHourly.js:20)
    at org.mozilla.javascript.gen.c11.call(alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerHourly.js)
    at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
    at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
    at org.mozilla.javascript.gen.c11.call(alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerHourly.js)
    at org.mozilla.javascript.gen.c11.exec(alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerHourly.js)
    at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:483)
    at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:191)
    ... 24 more
Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 
03090119 
    at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:364)
    at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:49)
    at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)
    at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:78)
    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.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
    at $Proxy13.query(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.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 net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
    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.proceed(AuditMethodInterceptor.java:175)
    at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:152)
    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 $Proxy13.query(Unknown Source)
    at org.alfresco.repo.jscript.Search.query(Search.java:801)
    ... 43 more
Caused by: java.net.SocketException: Software caused connection abort: recv 
failed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(SocketInputStream.java:129)
    at com.sun.net.ssl.internal.ssl.InputRecord.readFully(InputRecord.java:293)
    at com.sun.net.ssl.internal.ssl.InputRecord.read(InputRecord.java:331)
    at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:798)
    at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readDataRecord(SSLSocketImpl.java:755)
    at com.sun.net.ssl.internal.ssl.AppInputStream.read(AppInputStream.java:75)
    at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
    at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
    at org.apache.commons.httpclient.HttpParser.readRawLine(HttpParser.java:78)
    at org.apache.commons.httpclient.HttpParser.readLine(HttpParser.java:106)
    at org.apache.commons.httpclient.HttpConnection.readLine(HttpConnection.java:1116)
    at org.apache.commons.httpclient.MultiThreadedHttpConnectionManager$HttpConnectionAdapter.readLine(MultiThreadedHttpConnectionManager.java:1413)
    at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1973)
    at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1735)
    at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:1098)
    at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:398)
    at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:171)
    at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:397)
    at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:323)
    at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:318)
    ... 73 more
2013-04-09 14:05:00,215  ERROR [quartz.core.ErrorLogger] 
[DefaultScheduler_Worker-2] Job (DEFAULT.scheduledReportExecuterJobHourly threw 
an exception.
 org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.scripts.ScriptException: 03090121 Failed to execute script 'alfresco/module/org.alfresco.reporting/scripts/executeReportingContainerHourly.js': 03090120 Failed to execute search: PATH:"/app:company_home"]
    at org.quartz.core.JobRunShell.run(JobRunShell.java:227)

Have you any idea on error? I'm using standard SOLR installation over https

What steps will reproduce the problem?
1. Trying to access reporting console through share
2.
3.

What is the expected output? What do you see instead?
I should be getting the reporting console


What version of the product are you using? On what operating system?
tried with 4.2.d CE 4.2.e CE

Please provide any additional information below.
Apllied the amp and copied the jar files to the lib dir
restarted and when I try to access the reporting console, I am getting error no 
500
I have attached the error file in html format, Please do find it for your 
reference
thanks 
Joseph John 

Alfresco Version: Community 4.2e
Alfresco Business Reporting Plug-In Version: 1.0.1.4
Platform: Windows Server 2008 R2
Database: PostgreSQL 9.2.4

We have an Alfresco repository with over 700,000 current versions of documents 
(ACAD Drawings, MS Office Documents, image files, PDF's, etc) with 6 custom 
model types and 4 aspects.  When we run the full harvesting on the repository 
for the first time we notice that the number of records written to the 
"document" table in the reporting database (hosted on the same instance of 
PostgreSQL as the Alfresco database) drops dramatically over time.

For example during the first hour of processing the reporting database has over 
35,000 records added to it.  By the time 100,000 records have been loaded into 
the reporting database the rate has dropped to around 20,000 records per hour.  
By the time 300,000 records have been loaded into the reporting database the 
rate has dropped to around 4,000 per hour.

You state in your wiki that it will take a long time to harvest a big data set. 
 I calculate that the harvesting of our data would take at best another 4.5 
days to complete if the rate doesn't drop from the 1 per second (which I doubt 
would be the case).

I am looking for some help to get round this issue as we have a real 
requirement for reporting on the content stored in Alfresco and really like the 
solution provided by the Alfresco Business Reporting plug-in.

Thanks and regards
Ewan Ritchie

What steps will reproduce the problem?
1. login to localhost:8080/alfresco and go to company home > dictionary  (page 
2)
2. click on "fill reporting database" button under reporting folder
3. now, mysql db has data
4. upload a new document in alfresco share on any folder
5. repeat steps 1 and 2

What is the expected output? What do you see instead?
* expected output is lastsuccessfulrun must be latest date and new documents 
should show up in the reporting database. Instead, nothing is changed, date is 
still the first execution date and the new documents are not counted in the 
report.

What version of the product are you using? On what operating system?
* OS - windows xp 32 bit
* alfresco 4.0.e community edition