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 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

[muralidharand]

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}

[johnpelquingua]

Hi Murali

Here is the error Alfresco.log generated:
http://forums.alfresco.com/sites/forums/files/alfresco_7.txt

[muralidharand]

Hi JP,
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)

Alfresco is unable to reach your database server. Make sure, your db connection informations are correct in the properties file.

[johnpelquingua]

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

[johnpelquingua]

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

[muralidharand]

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.

[johnpelquingua]

Hi Murali,

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

Thanks~
JP

[muralidharand]

No, shouldn't do that.