Hi Natu,
would you be willing to send me a zipped up mysqldump of your mifos database
(say in dropbox and invite me to the folder)?
I can then check out what is causing the problem and hopefully fix the data.
Its probably some date related problem and unfortunately the 'messages'
aren't very useful.
John
On Mon, May 16, 2011 at 8:44 PM, Natu Lauchande <[email protected]>wrote:
> 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
>
>
------------------------------------------------------------------------------
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
