search

Alfresco-Business-Reporting / alfresco-business-reporting

Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against 'plain tables' containing your Alfresco business objects. The second feature is to generate reports against these reporting database and store the reports back into Alfresco. Reports can be designed using Pentaho Reporting. But feel free to use any BusinessObjects, Cognos, Clickview.
9 stars 4 forks source link

Postgres DB - Alfresco Business reporting is not working for Latest community 5.1f. #6

Open shivasakthi18 opened 8 years ago

shivasakthi18 commented 8 years ago

We tried today with default DB of alfresco, Following are the steps we tried.

  1. Copied the files (org.alfresco.reporting.share.amp & org.alfresco.reporting.amp)
  2. executed the apply_amps with -force option.
  3. Verified that both of them installed into alfresco.war
  4. Edited the context.xml to add the DS for Posgresql & added the jndi in web.xml
  5. Restarted the service.

Attached files are the errors that we are facing while starting or accessing the /share or /alfrescoo

alfrescotomcat-stdout.2016-05-02.txt alfrescotomcat-stderr.2016-05-02.txt

tpeelen commented 8 years ago

Please, do NOT install both amps into alfresco.war... one needs to go to share.war...

Please rename context.xml into alfresco.xml. Thename matches the context. Usually you have the /alfresco context (repository) and the /share context (the UI)

Cannot create JDBC driver of class '' for connect URL 'null' suggests that the driver class name in the XML is empty, or non-existent in tomcat/lib. The postgres JDBC database driver libraries (jar file) must exist in tomcat/lib. This jar file contains the class file as defined in the alfresco.xml driverClassName="org.gjt.mm.mysql.Driver" property.... (This one defines MySQL, for Postgres use "org.postgresql.Driver")