Re: [Mifos-users] Error while executing etl job

2011-11-17 Thread info
John, It was yesterdays comment and got posted today. On Thu, Nov 17, 2011 at 9:40 PM, John Woodlock wrote: > Not sure what you mean. You appear to have sent the same files as > yesterday. > > Have you run the fix sql? > > If so what is your Operating System and such details as it ran fine for m

Re: [Mifos-users] Error while executing etl job

2011-11-17 Thread John Woodlock
Not sure what you mean. You appear to have sent the same files as yesterday. Have you run the fix sql? If so what is your Operating System and such details as it ran fine for me. John On Thu, Nov 17, 2011 at 3:14 AM, HT Team wrote: > John > > Please find attached the log file and db dump. >

Re: [Mifos-users] Error while executing etl job

2011-11-16 Thread John Woodlock
Attached is an update script which, if you run it against your mifos database, will allow you to run the ETL without data errors. Moving dates forward and backward will cause problems as the ETL builds an historical database e.g. doesn't like loans created before clients or loans being cancelled b

Re: [Mifos-users] Error while executing etl job

2011-11-16 Thread HT Team
Hi John Please find attached the log file. Load_LoanRepayments_log_error.rar Description: application/rar -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, appli

Re: [Mifos-users] Error while executing etl job

2011-11-16 Thread John Woodlock
Hello HT Team, The ETL creates an output log... can you send that to me. Also, feel free to send me a zipped mysqldump of your mifos database and I'll run it. John On Wed, Nov 16, 2011 at 11:59 PM, info wrote: > Hello John > > We are getting an error > > Unparseable date: "${MAINENDTRANSACTIO