|
Hello Marco,
your batch jobs are not running, because their previous start is on a future date. While it is possible to remove all batch job instances from the database and run them again, this will not solve your problem, as the batch job in question cannot undo any changes it has made. The only solution to your problem that I can see is to restore a full database backup, if you have any. If not, I'm afraid the only way to fix this is to redo all of the loans manually. I have attached an SQL file that should let you run batch jobs again, but once again, this will not solve your current issue, and the best way forward is to restore a previously saved database backup. I'm providing this in case you have to manually restore all loan accounts, as otherwise you would not be able to run any batch jobs until 04-07-2013. To run it you would normally type "mysql -u<username> -p<password> <mifos database name> < resetBatchJobs.sql". Remember to substitute the values with your own database details. Regards Lech On 06/10/2013 05:44 PM, Marco Vergaray wrote:
| ||||
DELETE FROM BATCH_JOB_EXECUTION_CONTEXT; DELETE FROM BATCH_STEP_EXECUTION_CONTEXT; DELETE FROM BATCH_STEP_EXECUTION; DELETE FROM BATCH_JOB_EXECUTION; DELETE FROM BATCH_JOB_PARAMS; DELETE FROM BATCH_JOB_INSTANCE;
------------------------------------------------------------------------------ This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev
_______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
