Alfresco Business Reporting

[johnpelquingua]

Hi All,

I downloaded this add-on: https://code.google.com/p/alfresco-business-reporting/downloads/list and I followed this Installation steps: https://code.google.com/p/alfresco-business-reporting/wiki/HowToInstall with no errors and it seems that nothing has changed on my Alfresco interface I mean I can't tell if I did it successfully or I'm missing something?

Need your help on this.

Your reply is much appreciated.

Thanks~
JP

[johnpelquingua]

Hi Murali,

I've tried:

First Stop tomcat.
Place the jar file in web-inf/lib folder
Start the tomcat.

Every time I do this the Alfresco site gives me an HTTP Status error but the Alfresco folder under tomcat/webapps/alfresco is still there and the alfresco.war is still there. What should I do now? I've done almost five times now and still it gives me the same error..

Thanks~
JP

[muralidharand]

Hi JP,
Are you able to see other folders like jsp,images,scripts,css etc inside tomcat/webapps/alfresco folder.

[johnpelquingua]

Hi Murali,

Yes, All of the folders are there the cmisfs, images, jsp etc..
Still have no idea what's happening here..

Thanks~
JP

[muralidharand]

Hi JP,
Can you please share your alfresco.log and share.log files?

[johnpelquingua]

Hi Murali,

All I can find is the Catalina log files under tomcat/logs Im using Alfresco 4.0.e hope this helps I've attached the log files
Here it is: https://forums.alfresco.com/sites/forums/files/catalina.2013-03-01.txt

Thanks~
JP

[muralidharand]

Hi JP,
Can you please try the below one ?
Just move the share.war and share expanded folder outside alfresco installation folder. Now you will have alfresco, solr and other folders except share
Start the tomcat now.

Generally you will have alfresco.log and share.log in the

 c:\<alfresco_installed_folder>\ ‍

http://localhostortnumber/alfresco this should work.
Are you using alfresco 4.0.3 enterprise edition or community edition?

[johnpelquingua]

Hi Murali,

I moved the share.war and share expanded folder outside of Alfresco installation folder so it's now at C:/  is that where it's supposed to be?
And the alfresco and share.log files did not appear to the C:/Alfresco

I'm using 4.0.e community edition for now so that I can replicate everything at Enterprise edition

Thanks~
JP

[tpeelen]

Hi All,

Thanks for trying out my Alfresco Business Reporting Module.

The jar file should be placed in the %tomcat%/webapps/alfresco/WEB-INF/lib indeed. It is a tool working against the repository, therefore it does most of its work in the repository layer, not in Share. Also, it works against MySQL only For now. You can try against Postgresql, but as far as I am aware of, you cannot get it to work. As long as you try against Postgresql there is not much hope I think.
So, start with a fresh install of your Community Edition. Create a MySQL database on forehand, just like you could create this manually with MySQL (old-style)
<blockcode>
create database alfrescoreporting default character set utf8 collate utf8_bin;
grant all on alfrescoreporting.* to 'alfresco'@'localhost' identified by 'alfresco' with grant option;
grant all on alfrescoreporting.* to 'alfresco'@'localhost.localdomain' identified by 'alfresco' with grant option;
</blockcode>

Put the jar files in %tomcat%/webapps/alfresco/WEB-INF/lib. The big zip-file of Jar's is initially not required. It is needed to generate Pentaho/JasperReporting reports once you have some data in your reporting database (so you can delegate this to 'later'…)

This should not break starting Alfresco. The thing that can break starting-up is a missing database, or a missing cron-definitions in your alfresco-global.properties. See https://code.google.com/p/alfresco-business-reporting/wiki/HowToInstall for the set of properties to add…

Please note one of my latest posts: http://tpeelen.wordpress.com/2013/02/23/alfresco-business-reporting-alive-and-kicking/

There will be a 0.8 release soon. It is AMP-based. This means smoother install. You do need to create a database first, that is something only a root account should be able to do. Apart from that, everything will be better!

Please let me know if you get it running with the info in this thread. I will be watching it from now…

[johnpelquingua]

Hi Sir Tjarda,

Thank you for the reply I'll go ahead and do your recommendations and I'll give an update whether or not I get it running or not.

Thanks~
JP

[bisana]

Hi Tpleen
Thanks for the add-on, I would also like to try it out as soon as I finish my existing project.
I have one doubt:-
this addon does make entry to the DB, but for reporting we has to depend on the any other business reporting toll. Is it so