Sorry . I forgot to tell. My MIFOS version is 2.6.2. and trying to
configure the data warehouse coming bundled with said version.
On Sunday, December 15, 2013 12:09:27 PM UTC+5:30, Kalum Palihawadana wrote:
>
> 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]>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]
>>> 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
