Natu,
There was only one issue to deal with. I popped an update script in the
dropbox. After applying that the ETL ran thru cleanly.
I put a note in the update script about the issue (loan officer created
after the customers is was assigned to).
John
On Mon, May 16, 2011 at 9:27 PM, Natu Lauchande <[email protected]>wrote:
> 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
>
>
------------------------------------------------------------------------------
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
