[
http://mifosforge.jira.com/browse/MIFOSBI-47?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lukasz Chudy reopened MIFOSBI-47:
---------------------------------
John,
Incremental etl job is not working on my local machine. I've tried to use that
sctipt with default connection configuration (localhost) and also after
defining port number and in both cases I was getting this error:
[DS]Getting Connection for url:
jdbc:mysql://127.0.0.1:3306/mifos_dw?useUnicode=true&characterEncoding=UTF-8
ERROR 13-07 12:05:10,152 - Check DestinationDB connection Exists - Cannot
connect to database [DestinationDB] (connection [DestinationDB]). Exception :
[org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Invalid JNDI connection DestinationDB : Unknown database 'mifos_dw'
I'm dropping mifos_dw database before running incremental script.
After script ends with above error, mifos_dw database is created but is empty.
I have access to it using this command: mysql -uUSER -pPASSWORD mifos_dw -h
127.0.0.1 --port=3306
> Create ETL Job that updates DW incrementally
> --------------------------------------------
>
> Key: MIFOSBI-47
> URL: http://mifosforge.jira.com/browse/MIFOSBI-47
> Project: mifos business intelligence
> Issue Type: Bug
> Affects Versions: Mifos BI 1.0 - Iteration 11, Mifos BI 1.0
> Reporter: johnwoodlock
> Assignee: johnwoodlock
> Priority: Major
> Fix For: Mifos BI 1.3
>
>
> Create/amend Data Warehouse ETL work so that a job can be run to update the
> data warehouse incrementally.
> It should add data that has been created or changed since the last successful
> run.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues