Hi Thomas,
This issue occurs only when you are using mifos CF war. If you use
normal Mifos 2.4.0 war and Tomcat 7, then reports should work properly,
but you need to configure Tomcat:
Add the following JNDI items for a pentaho reports at
<GlobalNamingResources> section in file server.xml located in
TOMCAT/conf directory (remember to modify SourceDB and DestinationDB
parameters accordingly to your databases configuration):
/<Resource type="javax.sql.DataSource"
name="jdbc/SourceDB"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mifos"
username="mifos"
password="mifos"
initialSize="3"
maxActive="20"
maxIdle="15"
minIdle="3"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;ResetAbandonedTimer"
/>/
/<Resource type="javax.sql.DataSource"
name="jdbc/DestinationDB"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mifos_dw"
username="mifos"
password="mifos"
initialSize="3"
maxActive="20"
maxIdle="15"
minIdle="3"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="60000"
logAbandoned="true"
suspectTimeout="60"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;ResetAbandonedTimer"
/>/
Also, you need to make sure that '/tomcat-jdbc.jar///' file is in the
TOMCAT/lib directory. If not, then you download it from here
http://dev.mysql.com/downloads/connector/j/.
After completing above steps, restart Tomcat and Pentaho reports should
be working properly.
Issue in Mifos 2.4.0-CF will be fixed in the maintenance release.
Regards,
Lukasz
On 06/20/2012 12:58 PM, Lukasz Chudy wrote:
Hi Thomas,
I created Jira ticket for this issue
http://mifosforge.jira.com/browse/MIFOS-5682 and I will let you know
once this issue is resolved.
Regards,
Lukasz
On 06/20/2012 09:06 AM, Thomas (Uganda) wrote:
Hi Pawel, am currently using Tomcat 7 on mifos 2.4. However I cannot
generate the integrated reports. I get error below.
Is there any changes i need to make to Tomcat to view these reports.
Tx
************************************************************************************************************************************************
(org.mifos.core.MifosRuntimeException:
java.lang.NullPointerException:
Key data must not be null.
at
org.mifos.reports.pentaho.service.PentahoReportsServiceImpl.loadReport(PentahoReportsServiceImpl.java:
207)
Caused by: java.lang.NullPointerException: Key data must not be null.
*************************************************************************************************************************************************
On May 31, 5:50 pm, Paweł Gesek<[email protected]> wrote:
Hello everyone,
we have included over 20 Pentaho reports from Mifos-BI in the standard
Mifos distribution. These will be included in the next Mifos release,
but you can test them even now on the test
servers:http://ci.mifos.org:8085/mifos/. It is also possible to
upload your own
Pentaho reports, the same way as you upload Birt reports.
Regards
Paweł Gesek
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond.
Discussions
will include endpoint security, mobile security and the latest in
malware
threats.http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
[email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond.
Discussions
will include endpoint security, mobile security and the latest in
malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
