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.ja
va: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:  <mailto:[email protected]> [email protected]  

Website:  <http://www.fursaleo.com/> www.fursaleo.com 

 



<<image003.jpg>>

------------------------------------------------------------------------------
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

Reply via email to