topic Re: Alfresco Business Reporting in Alfresco Archive

Alfresco Business Reporting

johnpelquingua — Mon, 25 Feb 2013 13:53:47 GMT

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

Re: Alfresco Business Reporting

johnpelquingua — Tue, 26 Feb 2013 00:56:30 GMT

Hi All,

Can someone help me on this? My problem is I can't find the result that I have installed is successfully. There's no Business Reporting Tool anywhere on my Alfresco Share.

Thanks~
JP

Re: Alfresco Business Reporting

muralidharand — Tue, 26 Feb 2013 17:54:54 GMT

Hi JP,
I'm also not succeeded.
First,you just need to placed the reporting jar and the supporting jar.
Add the following information in the alfresco-global.properties file.

Create a database called "alfrescoreporting" in your db server.


reporting.db.name=alfrescoreporting
reporting.db.username=alfresco
reporting.db.password=admin
reporting.db.host=localhost
reporting.db.port=5430
reporting.db.driver=org.postgresql.Driver
reporting.cron.filldatabase=0 0/5 * * * ?
reporting.cron.generatereports=0 0/30 * * * ?
reporting.enabled=true
reporting.db.url=jdbc:postgresql://${reporting.db.host}:${reporting.db.port}/${reporting.db.name}
‍‍‍‍‍‍‍‍‍‍‍‍

Enable logging by adding the following line [log4j.properties]

 log4j.logger.org.alfresco.reporting=debug,warn,error ‍

I'm getting the following error.

 
23:08:48,437 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Creating table. Query: CREATE TABLE IF NOT EXISTS post (id INT AUTO_INCREMENT PRIMARY KEY, sys_node_uuid VARCHAR(100));
23:10:02,000 DEBUG [org.alfresco.reporting.AlfrescoReporting] processRepositoryUpdate: post (insertOnly = false)
23:10:02,000 DEBUG [org.alfresco.reporting.AlfrescoReporting] Table Description found 28 lines
23:10:02,000 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Starting getTableDescription
23:10:02,000 DEBUG [org.alfresco.reporting.AlfrescoReporting] Got the description 
23:10:02,000 DEBUG [org.alfresco.reporting.AlfrescoReporting] 
23:10:02,000 DEBUG [org.alfresco.reporting.AlfrescoReporting] type~|~VARCHAR(100)
23:10:02,000 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Executing Query: ALTER TABLE post ADD type VARCHAR(100)
23:10:02,000 ERROR [org.alfresco.reporting.AlfrescoReporting] org.postgresql.util.PSQLException: ERROR: relation "post" does not exist
‍‍‍‍‍‍‍‍‍‍‍

The project installation document is configured for the mysql database. So,I'm hoping, it will work only with the mysql database. If you've mysql database, please try with the below configuration.

https://code.google.com/p/alfresco-business-reporting/source/browse/documentation/readme-install.txt

Add to alfresco-global.properties
===================================
reporting.db.name=alfrescoreporting
reporting.db.username=alfresco
reporting.db.password=alfresco
reporting.db.host=localhost
reporting.db.port=3306
reporting.db.driver=org.gjt.mm.mysql.Driver
reporting.cron.filldatabase=0 0/5 * * * ?
reporting.cron.generatereports=0 0/30 * * * ?
reporting.enabled=true

reporting.db.url=jdbc:mysql://${reporting.db.host}:${reporting.db.port}/${reporting.db.name}

Re: Alfresco Business Reporting

johnpelquingua — Wed, 27 Feb 2013 02:10:33 GMT

Hi Murali,

I did exactly what you did with the PostgreSQL database but not with the MySQL. Maybe it will work with MySQL. I'll send all the logs using MySQL.
And let you know where I have gone so far.

Thanks~
JP

Re: Alfresco Business Reporting

johnpelquingua — Thu, 28 Feb 2013 02:48:31 GMT

Hi Murali,

Whenever I tried to place the alfresco-business-reporting-0.6.5.jar file to C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/lib I'm getting the message of HTTP Status 404. All I did was stop tomcat then place the .jar file then start tomcat after I did that a status of 404 shows up on the Alfresco Explorer.

I followed your Approach 1 method

Thanks~
JP

Re: Alfresco Business Reporting

muralidharand — Thu, 28 Feb 2013 03:44:08 GMT

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

Before stopping tomcat, have you deleted the alfresco.war file? In that case only, tomcat will try to clear the alfresco exploded directory.

Re: Alfresco Business Reporting

johnpelquingua — Thu, 28 Feb 2013 03:52:52 GMT

Hi Murali,

No I haven't deleted the alfresco.war file. Should I delete it first before I stop the tomcat?

Thanks~
JP

Re: Alfresco Business Reporting

muralidharand — Thu, 28 Feb 2013 03:54:20 GMT

No, shouldn't do that.

Re: Alfresco Business Reporting

johnpelquingua — Fri, 01 Mar 2013 06:48:04 GMT

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

Re: Alfresco Business Reporting

muralidharand — Fri, 01 Mar 2013 07:17:28 GMT

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

Re: Alfresco Business Reporting

johnpelquingua — Fri, 01 Mar 2013 07:21:53 GMT

Hi Murali,

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

Thanks~
JP

Re: Alfresco Business Reporting

muralidharand — Fri, 01 Mar 2013 07:23:11 GMT

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

Re: Alfresco Business Reporting

johnpelquingua — Fri, 01 Mar 2013 07:42:00 GMT

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

Re: Alfresco Business Reporting

muralidharand — Fri, 01 Mar 2013 08:27:42 GMT

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?

Re: Alfresco Business Reporting

johnpelquingua — Fri, 01 Mar 2013 08:59:47 GMT

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

Re: Alfresco Business Reporting

tpeelen — Sun, 03 Mar 2013 20:52:16 GMT

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…

Re: Alfresco Business Reporting

johnpelquingua — Mon, 04 Mar 2013 00:34:16 GMT

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

Re: Alfresco Business Reporting

johnpelquingua — Mon, 04 Mar 2013 02:29:27 GMT

Hi Tjarda,

It is still giving me errors

Here's what I did:

*I did anothere fresh install of the Alfresco Community 4.0.e

1. I created the MySQL Database
2. Add the definitions to the alfresco-global.properties
3. Then copy the .jar files to the tomcat/webapps/alfresco/WEB-INF/lib
   - I first stop tomcat
   - Then place the .jar files to the ../WEB-INF/lib
   - Start tomcat

After I've done all of this Im still getting the Alfresco HTTP Status 404 error. And when I remove the .jar file on ../WEB-INF/lib path everything seems to be back on normal again.

Thanks~
JP

Re: Alfresco Business Reporting

bisana — Mon, 04 Mar 2013 04:58:10 GMT

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

Re: Alfresco Business Reporting

johnpelquingua — Mon, 04 Mar 2013 06:16:32 GMT

Hi All,

And also I'm using XAMPP as the source of my MySQL Database is that alright?

Thanks~
JP