Kalum,
It's a while ago but I'm sure we fixed it. It's a data issue. Below, I've
included the text I've included previously in this chain and all of it
still applies i.e. there is a trouble shooting process and if that isn't
successful you can send me a zipped mysqldump of your database (if its big
you can send a dropbox link or similar) and I'm make best endeavours to get
back to you soon.
John
----- copy of previous text
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.
-----
On Sun, Dec 15, 2013 at 6:45 AM, Kalum Palihawadana <[email protected]>wrote:
> 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/se
>>>>> cure/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
>
>
------------------------------------------------------------------------------
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
