[
http://mifosforge.jira.com/browse/MIFOSBI-115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sumit Shah updated MIFOSBI-115:
-------------------------------
Attachment: data_integration.sh.out
data_integration.sh.err
after loading digambers 1.6.1 data dump and upgrading it to 2.0 and running the
kettle job, it failed early on (see attached files for full output):
INFO 22-01 06:07:07,193 - Extract Product Data - Finished processing (I=6,
O=0, R=0, W=6, U=0, E=0)
INFO 22-01 06:07:07,193 - Insert / Update dw_account_action - Finished
processing (I=20, O=20, R=20, W=20, U=0, E=0)
ERROR 22-01 06:07:07,275 - Insert / Update dw_fee - Unexpected error :
INFO 22-01 06:07:07,280 - Insert / Update dw_mfi_configuration - Finished
processing (I=1, O=0, R=1, W=1, U=1, E=0)
ERROR 22-01 06:07:07,391 - Insert / Update dw_fee -
org.pentaho.di.core.exception.KettleStepException:
Error in step, asking everyone to stop because of:
Error inserting/updating row
Duplicate entry 'Loan Cover Fee' for key 'fee_name'
org.pentaho.di.trans.steps.insertupdate.InsertUpdate.processRow(InsertUpdate.java:307)
org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
java.lang.Thread.run(Thread.java:662)
ERROR 22-01 06:07:07,391 - load dw_fee - Errors detected!
ERROR 22-01 06:07:07,391 - load dw_fee - Errors detected!
INFO 22-01 06:07:07,468 - Insert / Update dw_fee - Finished processing
> Data Quality Check for Digamber data prior to setting up DW schedule
> --------------------------------------------------------------------
>
> Key: MIFOSBI-115
> URL: http://mifosforge.jira.com/browse/MIFOSBI-115
> Project: mifos business intelligence
> Issue Type: Story
> Components: Data Warehouse
> Affects Versions: Mifos BI 1.0 - Iteration 12, Mifos BI 1.0
> Reporter: johnwoodlock
> Assignee: johnwoodlock
> Fix For: Mifos BI 1.0 - Iteration 12, Mifos BI 1.0
>
> Attachments: data_integration.sh.err, data_integration.sh.out,
> ETLDigamberNotesOnInitialLoad.txt
>
> Original Estimate: 3 hours
> Remaining Estimate: 3 hours
>
> Run Digamber data through the ETL process to see if anything needs to be done
> prior to creating a data warehouse and scheduling the ETL.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
