search

minhtu307 / alfresco-business-reporting

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

Reporting cron in Running status #22

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
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

Original issue reported on code.google.com by vincenzo...@gmail.com on 14 Jun 2013 at 6:25

GoogleCodeExporter commented 8 years ago 
Hi Vincenzo,

I see the 50.000 user issue. I guess that clashes when collecting child 
noderefs. I will try to fix that tonight.

For the sitepreset.xml, what happens here? You create a new preset. Does it 
include a custom site model too? Mandatory aspects? Or just new settings in 
pages and dashlets?

The status running blocks further harvesting. You can update it manually 
(although i thought there is a webscript for that, definitely a javascript 
call, now away from laptop and spare time....)

If you add to your log4j.properties:
log4j.logger.org.alfresco.reporting.script.AlfrescoReporting=debug
log4j.logger.org.alfresco.reporting.db.DatabaseHelperBean=debug
You will be flooded with log statements. Can you provide me with that info of a 
(failing) harvesting run? You can send it directly by email if it contains info 
not meant to be published publicly...

Original comment by tjarda.p...@incentro.com on 14 Jun 2013 at 6:54

GoogleCodeExporter commented 8 years ago 
As far as resetting a "Running" state of a table, I added a section to the 
Wiki: 
https://code.google.com/p/alfresco-business-reporting/wiki/AdvancedHarvesting#Re
set_the_dates_last-run

Original comment by tjarda.p...@incentro.com on 16 Jun 2013 at 9:45