John,
Fantastic!!! Thank you for your invaluable help. It is working perfect now
and the reports look ok.
Cheers,
Natu
On Mon, May 16, 2011 at 6:57 AM, John Woodlock <[email protected]>wrote:
> 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
>
>
------------------------------------------------------------------------------
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
