nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

Find more posts tagged with

Comments

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,

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.

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

catalina.2013-03-01.txt.zip

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://localhost

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

johnpelquingua

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

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

johnpelquingua

Hi All,

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

Thanks~
JP

johnpelquingua

Hi Murali

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

alfresco_7.txt.zip

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've tried it all the steps again and this time I think I've successfully connect it to the database but still there is an error..

<code>
12:47:03,808 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
12:47:03,887 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
12:47:17,652 WARN [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Starting getTableDescription
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Key=reporting.db.host
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Key=reporting.db.port
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Key=reporting.db.name
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Enabled    : true
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] DatabaseURL: jdbc:mysql://127.0.0.1:3306/alfrescoreporting
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] JDBC Driver: org.gjt.mm.mysql.Driver
12:47:25,621 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Username   : alfresco
12:47:25,996 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]
12:47:26,012 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]
12:47:26,027 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'alfrescoReportingDatabaseHelper' defined in URL [jar:file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/lib/alfresco-business-reporting-0.6.5.jar!/alfresco/extension/reporting-beans-context.xml]: Invocation of init method failed; nested exception is java.lang.NullPointerException
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.lang.NullPointerException
   at org.alfresco.reporting.DatabaseHelperBean.init(Unknown Source)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1544)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1485)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
   … 37 more
12:47:42,543 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Starting 'sysAdmin' subsystem, ID: [sysAdmin, default]
12:47:42,637 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Startup of 'sysAdmin' subsystem, ID: [sysAdmin, default] complete
12:47:57,933 WARN [org.alfresco.util.AbstractTriggerBean] Job ehCacheTracerJob is not active/enabled
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Starting getTableDescription
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Key=reporting.db.host
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Key=reporting.db.port
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Key=reporting.db.name
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Enabled    : true
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] DatabaseURL: jdbc:mysql://127.0.0.1:3306/alfrescoreporting
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] JDBC Driver: org.gjt.mm.mysql.Driver
12:48:10,183 DEBUG [org.alfresco.reporting.DatabaseHelperBean] Username   : alfresco
12:48:11,012 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopping 'sysAdmin' subsystem, ID: [sysAdmin, default]
12:48:11,012 INFO [org.alfresco.repo.management.subsystems.ChildApplicationContextFactory] Stopped 'sysAdmin' subsystem, ID: [sysAdmin, default]
12:48:11,043 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'alfrescoReportingDatabaseHelper' defined in URL [jar:file:/C:/Alfresco/tomcat/webapps/alfresco/WEB-INF/lib/alfresco-business-reporting-0.6.5.jar!/alfresco/extension/reporting-beans-context.xml]: Invocation of init method failed; nested exception is java.lang.NullPointerException
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1420)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
   at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
   at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
   at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
   at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
   at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:63)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
   at org.apache.catalina.core.StandardService.start(StandardService.java:519)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: java.lang.NullPointerException
   at org.alfresco.reporting.DatabaseHelperBean.init(Unknown Source)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1544)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1485)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
   … 37 more

muralidharand

Hi JP,
Please enable logging for "org.alfresco.reporting" package then we'll come to know why exactly it is failing.

Add

 log4j.logger.org.alfresco.reporting =debug,info  ‍

 log4j.properties ‍

file.

It looks like DatabaseHelperBean is failed while connecting to the mysql database.

https://code.google.com/p/alfresco-business-reporting/source/browse/source/java/org/alfresco/reporting/DatabaseHelperBean.java
Refer line numbers from 146 to 150.

johnpelquingua

Hi Murali,

The problem was resolved by putting the MySQL Driver in the tomcat/lib folder
Based on the 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
# frequency the reporting database is filled
reporting.cron.filldatabase=0 0/5 * * * ?
# Frequency & timing the reports are generated.
# Should not be more frequent nor before the reporting database is filled
reporting.cron.generatereports=0 0/30 * * * ?
reporting.enabled=true

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

I've found out that you need a driver to make it go run and so it did

I was able to generate tables onto the database.

Thank you again Murali for your generous help!

Resources:
MySQL Driver: http://www.jarfinder.com/index.php/jars/versionInfo/34449

Thanks~
JP

johnpelquingua

Hi all,

So, I've successfully installed this addon and run the scripts but unfortunately I'm receiving this error:

This error occurs when I run the scripts of Business Reporting addon.

Hope someone can help me with this error.

<code>
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: First transaction was not found with the correct timestamp.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: SOLR has successfully connected to your repository however the SOLR indexes and repository database do not match.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: First transaction was not found with the correct timestamp.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: If this is a new or rebuilt database you SOLR indexes also need to be re-built to match the database.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: SOLR has successfully connected to your repository however the SOLR indexes and repository database do not match.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: You can also check your SOLR connection details in solrcore.properties.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: If this is a new or rebuilt database you SOLR indexes also need to be re-built to match the database.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 02060026 Initial transaction not found with correct timestamp
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1243)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:491)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: You can also check your SOLR connection details in solrcore.properties.
Mar 6, 2013 6:49:45 PM org.alfresco.solr.tracker.CoreTracker trackRepository
SEVERE: Tracking failed
org.alfresco.error.AlfrescoRuntimeException: 02060027 Initial transaction not found with correct timestamp
   at org.alfresco.solr.tracker.CoreTracker.trackRepository(CoreTracker.java:1243)
   at org.alfresco.solr.tracker.CoreTracker.updateIndex(CoreTracker.java:491)
   at org.alfresco.solr.tracker.CoreTrackerJob.execute(CoreTrackerJob.java:45)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)

muralidharand

Hi JP,
Can you please post your complete alfresco.log file?

grg021

Hi Sir,

Thank you very much for the add-on. works great!

How and when do you plan to support multi-value properties? Tags and categories missing…
Also, document's with categories are not logged in the mysql database (document table).

Hope you can shine some light on this.

Cheers.

bisana

Hi
I checked the link, it is "Page "HowToInstall" Not Found"
Thanks

abarisone

Hi,
this just to inform you that on May 1st there is an official tech talk with the author of Alfresco Business Reporting http://www.alfresco.com/events/webinars/tech-talk-live-alfresco-business-reporting-episode-65

Hope this will help.

Regards,
Andrea