Hi John,
Already shared with you the file. Just to remind you, i have cleaned the
database according to info outputted by : *
http://mifos.git.sourceforge.net/git/gitweb.cgi?p=mifos/bi;a=blob;f=ETL/Scripts/mifosPreCheck.sql;h=df604e10f0fe06a868b85c7735e966cec8728ece;hb=HEAD
*
Thanks,
Natu
On Mon, May 16, 2011 at 4:14 AM, John Woodlock <[email protected]>wrote:
> 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
>
>
------------------------------------------------------------------------------
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
