Hi All,
I am using Mifos BI, i am having problems running the ETL job,
initialise_datawarehouse.bat . I also run the healthy checks
*sql*available at git repository. I looked at logs and extracted the
error
components below:
ERROR 16-05 03:17:50,718 - Load Customers, Loans and Savings - An error
occurred, processing will be stopped:
Couldn't execute SQL: call SPetl_customers_and_accounts()
Table 'mifos_dw.fallover' doesn't exist
ERROR 16-05 03:17:50,718 - Load Customers, Loans and Savings - An error
occurred, processing will be stopped:
Couldn't execute SQL: call SPetl_customers_and_accounts()
Table 'mifos_dw.fallover' doesn't exist
ERROR 16-05 03:17:50,718 - Load Customers, Loans and Savings - Error
initializing step [Load Customers, Loans and Savings]
ERROR 16-05 03:17:50,718 - load_customer_loan_savings_dim - Step [Load
Customers, Loans and Savings.0] failed to initialize!
INFO 16-05 03:17:50,718 - Load Customers, Loans and Savings - Finished
reading query, closing connection.
ERROR 16-05 03:17:50,734 - Load dim_customer, dim_loan and dim_savings -
Unable to prepare for execution of the transformation
ERROR 16-05 03:17:50,734 - Load dim_customer, dim_loan and dim_savings -
org.pentaho.di.core.exception.KettleException:
We failed to initialize at least one step. Execution can not begin!
org.pentaho.di.trans.Trans.prepareExecution(Trans.java:737)
org.pentaho.di.trans.Trans.execute(Trans.java:351)
org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:960)
org.pentaho.di.job.Job.execute(Job.java:471)
org.pentaho.di.job.Job.execute(Job.java:600)
org.pentaho.di.job.Job.execute(Job.java:344)
org.pentaho.di.job.Job.run(Job.java:282)
INFO 16-05 03:17:50,734 - Load Customer And Loan And Savings Dimensions -
Finished job entry [Load dim_customer, dim_loan and dim_savings]
(result=[false])
INFO 16-05 03:17:50,734 - Load Customer And Loan And Savings Dimensions -
Job execution finished
INFO 16-05 03:17:50,734 - Create Data Warehouse - Finished job entry [Load
Customer And Loan And Savings Dimensions] (result=[false])
INFO 16-05 03:17:50,734 - Create Data Warehouse - Finished job entry [Load
Staging Tables] (result=[false])
INFO 16-05 03:17:50,734 - Create Data Warehouse - Finished job entry [Load
Personnel Dimension] (result=[false])
INFO 16-05 03:17:50,734 - Create Data Warehouse - Job execution finished
INFO 16-05 03:17:50,765 - Data Warehouse Initial Load - Finished job entry
[Create Data Warehouse] (result=[false])
INFO 16-05 03:17:50,765 - Data Warehouse Initial Load - Finished job entry
[Set Date Parameters for Initial Load] (result=[false])
INFO 16-05 03:17:50,765 - Data Warehouse Initial Load - Job execution
finished
INFO 16-05 03:17:50,765 - Kitchen - Kitchen
ERROR 16-05 03:17:50,765 - Kitchen - Kitchen
INFO 16-05 03:17:50,765 - Kitchen - Kitchen
INFO 16-05 03:17:50,765 - Kitchen - Kitchen
Cheers,
Natu
------------------------------------------------------------------------------
Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
