Hi Thomas/ John
I am having the same issue as below. Appreciate if you can let me know if
you found a fix for it.
*"ERROR 15-12 11:46:08,590 - Load Customers, Loans and Savings - An error
occurred, processing will be stopped: *
*Couldn't execute SQL: call SPetl_customers_and_accounts()*
*Table 'smcswhlo.pretend_fallover_table' doesn't exist*
*ERROR 15-12 11:46:08,590 - Load Customers, Loans and Savings - Error
initializing step [Load Customers, Loans and Savings]*
*ERROR 15-12 11:46:08,590 - load_customer_loan_savings_dim - Step [Load
Customers, Loans and Savings.0] failed to initialize!*
*INFO 15-12 11:46:08,591 - Load Customers, Loans and Savings - Finished
reading query, closing connection.*
*ERROR 15-12 11:46:08,592 - Load dim_customer, dim_loan and dim_savings -
Unable to prepare for execution of the transformation*
*ERROR 15-12 11:46:08,592 - 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)*
*"*
Thanks in advance
Kalum
On Tuesday, July 30, 2013 4:19:56 AM UTC+5:30, John Woodlock wrote:
>
> Thomas
>
> This message should probably be on the mifos developers list.
>
> Anyway, the actual relevant error message to do with the stored procedure
> failing is a bit further down in the log file. It usually references a
> client or account id. if you search for the string "Actual Stored
> Procedure Message related" you will find it.
>
> The reason why there is a problem can vary and requires some
> troubleshooting which takes a bit of getting used to... typically it is due
> to client or accounts being created before their 'parents' or transacted
> against in an unreasonable order e.g. made active before creation.
>
> There is a troubleshooting link
> https://mifosforge.jira.com/wiki/display/MIFOS/Mifos+and+Data+Warehouse+Data+Health+Checks
> and
> the pre-etl check and the check if it fails are the main ones.
>
> However, if you want to send me a zip of your database dump I'll see if I
> can get you a data fix.
>
>
> John
>
>
> On Mon, Jul 29, 2013 at 11:08 PM, Thomas (Uganda)
> <[email protected]<javascript:>
> > wrote:
>
>> Hi Natalia,
>>
>> Yes I did Configure the mifosdw Database and followed these instructions,
>> uploaded all the sql scripts and set up the
>> main.database.dbPentahoDW=mifosdw in local.propeties file. However from the
>> *log.txt* file I attached earlier, I was not able to easily point out
>> why the mifosdw Database isn't populated with Data. Was hoping someone
>> could point out where I could be going wrong.
>>
>> Regards
>>
>> On Monday, 29 July 2013 10:40:03 UTC+3, Natalia Szprega wrote:
>>
>>> Hello Thomas,
>>>
>>> did you configure mifosdw database?
>>>
>>> Here are instructions: https://mifosforge.jira.com/
>>> secure/attachment/17280/
>>>
>>> In attachment you can find appropriate files.
>>>
>>> Regards,
>>> Natalia
>>>
>>> On 07/28/2013 06:31 PM, Thomas (Uganda) wrote:
>>>
>>> Hello
>>>
>>> I am trying to run the 11 Datawarehouse Reports. However they show no
>>> Data. When I look at the ETLReportDWTaskJob Batch Job it fails every time.
>>>
>>> From a quick look at the Log file for the ETL Job, something about
>>> ""*Table
>>> 'mifosdw.pretend_fallover_table' doesn't exist*"".
>>>
>>> Has someone been able to have these reports run with Data? Would like
>>> to have these with Data as well.
>>>
>>> Tx
>>>
>>>
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> See everything from the browser to the database with AppDynamics
>>> Get end-to-end visibility with application monitoring from AppDynamics
>>> Isolate bottlenecks and diagnose root cause in seconds.
>>> Start your free trial of AppDynamics Pro
>>> today!http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
>>>
>>>
>>>
>>> _______________________________________________
>>> Mifos-users mailing
>>> [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users
>>>
>>>
>>> --
>>> MifCloud support
>>>
>>> Website: www.mifcloud.com
>>> Facebook: www.facebook.com/MifCloud
>>> Twitter: www.twitter.com/mif_cloud
>>>
>>> Email: [email protected]
>>>
>>>
>>
>> ------------------------------------------------------------------------------
>> Get your SQL database under version control now!
>> Version control is standard for application code, but databases havent
>> caught up. So what steps can you take to put your SQL databases under
>> version control? Why should you start doing it? Read more to find out.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Mifos-users mailing list
>> [email protected] <javascript:>
>> https://lists.sourceforge.net/lists/listinfo/mifos-users
>>
>>
>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
