Re: [Mifos-users] ETL Execution Error

Lukasz Chudy Tue, 17 Jan 2012 06:56:36 -0800

Hi Zayyad,

Could you run scripts from that page: http://mifosforge.jira.com/wiki/display/MIFOS/Mifos+and+Data+Warehouse+Data+Health+Checks and send the results?

Regards,
Lukasz

W dniu 09.01.2012 10:24, Zayyad A. Said pisze:

Hello;

We ran initialise_datawarehouse.bat this morning but generated this error.

ERROR 09-01 10:34:27,526 - Create Loan Disbursals - Unexpected batch update error committing the database connection.

ERROR 09-01 10:34:27,526 - Create Loan Disbursals - org.pentaho.di.core.exception.KettleDatabaseBatchException:

Error updating batch

Column 'loan_account_key' cannot be null

org.pentaho.di.core.database.Database.emptyAndCommit(Database.java:1459)

org.pentaho.di.trans.steps.tableoutput.TableOutput.dispose(TableOutput.java:625)

org.pentaho.di.trans.step.RunThread.run(RunThread.java:69)

java.lang.Thread.run(Unknown Source)

ERROR 09-01 10:34:27,527 - Load_LoanDisbursals - Errors detected!

ERROR 09-01 10:34:27,527 - Load_LoanDisbursals - Errors detected!

----------------------

ERROR 09-01 10:34:38,965 - Create Loan Repayments - Because of an error, this step can't continue:

ERROR 09-01 10:34:38,965 - Create Loan Repayments - org.pentaho.di.core.exception.KettleException:

Error batch inserting rows into table [fact_loan_repayments].

Errors encountered (first 10):

Column 'loan_account_key' cannot be null

Error updating batch

Column 'loan_account_key' cannot be null

org.pentaho.di.trans.steps.tableoutput.TableOutput.writeToTable(TableOutput.java:390)

org.pentaho.di.trans.steps.tableoutput.TableOutput.processRow(TableOutput.java:116)

org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)

java.lang.Thread.run(Unknown Source)

ERROR 09-01 10:34:38,966 - Load_LoanRepayments - Errors detected!

ERROR 09-01 10:34:38,966 - Load_LoanRepayments - Errors detected!

---------

ERROR 09-01 10:34:46,123 - Kitchen – Kitchen

Kindly assist on how to resolve the errors. Mifos Version 2.1.3 and Pentaho 1.3

Regards;

***

Zayyad A. Said

Manager - ICT

Fursa Leo Limited

Tel: +254 (0)41 2312807/808 I Cell: 0716 615 274

P. O. Box 83321 - 80100

Moi Avenue. Mombasa, Kenya

Email: [email protected]

Website: www.fursaleo.com
------------------------------------------------------------------------------
Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex
infrastructure or vast IT resources to deliver seamless, secure access to
virtual desktops. With this all-in-one solution, easily deploy virtual 
desktops for less than the cost of PCs and save 60% on VDI infrastructure 
costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d

_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users

Re: [Mifos-users] ETL Execution Error

Reply via email to