Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Alfresco Business Reporting

johnpelquingua
Champ in-the-making
Champ in-the-making

‎02-25-2013 08:53 AM

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
Labels:
0 Kudos
31 REPLIES 31

grg021
Champ in-the-making
Champ in-the-making
In response to tpeelen

‎03-07-2013 02:57 AM

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.
0 Kudos

santoshbaradwaj
Champ in-the-making
Champ in-the-making
In response to grg021

‎03-07-2013 04:40 AM

Can you please share steps to install Alfresco Bossiness Reporting..
Thanks In advance.
0 Kudos

grg021
Champ in-the-making
Champ in-the-making
In response to santoshbaradwaj

‎03-07-2013 05:00 AM

Hi santoshbaradwaj,

Just follow this steps here — https://code.google.com/p/alfresco-business-reporting/wiki/HowToInstall
Just make sure to place the correct mysql driver in the tomcat/lib folder. (org.gjt.mm.mysql.Driver)
0 Kudos

johnpelquingua
Champ in-the-making
Champ in-the-making

‎03-03-2013 09:29 PM

Hi Tjarda,

It is still giving me errors Smiley Sad

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

johnpelquingua
Champ in-the-making
Champ in-the-making

‎03-04-2013 01:16 AM

Hi All,

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

Thanks~
JP
0 Kudos

johnpelquingua
Champ in-the-making
Champ in-the-making

‎03-05-2013 09:07 PM

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

muralidharand
Star Contributor
Star Contributor
In response to johnpelquingua

‎03-06-2013 12:38 AM

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  ‍
in 
 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/reporti...
Refer line numbers from 146 to 150.
0 Kudos

johnpelquingua
Champ in-the-making
Champ in-the-making
In response to muralidharand

‎03-06-2013 01:40 AM

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 Smiley Happy
I was able to generate tables onto the database.

Thank you again Murali for your generous help! Smiley Happy

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

Thanks~
JP
0 Kudos

johnpelquingua
Champ in-the-making
Champ in-the-making

‎03-06-2013 05:54 AM

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)
0 Kudos

muralidharand
Star Contributor
Star Contributor
In response to johnpelquingua

‎03-06-2013 05:56 AM

Hi JP,
Can you please post your complete alfresco.log file?
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2025 Khoros, LLC