minhtu307 / alfresco-business-reporting

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

2nd manual execution of harvesting data does not run #15

Closed GoogleCodeExporter closed 8 years ago

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

Original issue reported on code.google.com by greg.he...@gmail.com on 23 Apr 2013 at 6:42

GoogleCodeExporter commented 8 years ago
Hi Greg,

I am looking into it later next week. It is my best guess right now that it can 
be caused by issues with Lucene. From memory, there were issues with Lucene and 
storing timestamp in these modified date properties. These can be changed 
(configured), but there are some Alfresco releases that contain bugs in this 
area. I have no time today to find out the details, so please bear with me. 

Alternatively, until then, accept to harvest not more than once a day, you 
should be safe then. If the new item still not shows-up, there sure is a 
problem... (remind that the system does record your last harvesting run as 
being successful. You have to wait until time runs into the next day...)
(I have a route for an automatic check on this in my head, but no time to 
execute soon...)

Original comment by tjarda.p...@incentro.com on 23 Apr 2013 at 7:26

GoogleCodeExporter commented 8 years ago
Are you on Lucene or Solr?
See also 
* https://issues.alfresco.com/jira/browse/MNT-5883
* http://blogs.alfresco.com/wp/developer/2011/02/01/whats-in-a-date/
I put in webclient.properties:
d_dictionary.datatype.d_datetime.analyzer=org.alfresco.repo.search.impl.lucene.a
nalysis.DateTimeAnalyser
(Downside: if it overrides your settings in dataTypeAnalyzers.properties, you 
do need to reindex your Lucene indexes... Not sure if Solr is impacted in a 
similar manner. The dateTimeAnalysers in the Solr folder are configured as 
dateTimeAnayser for a dateTime field. That should do...

Original comment by tjarda.p...@incentro.com on 23 Apr 2013 at 8:57

GoogleCodeExporter commented 8 years ago
Since no response, I assume this issue can be closed... Please feel free to 
re-open if needed...

Tjarda

Original comment by tjarda.p...@incentro.com on 6 Apr 2014 at 10:25