Here are the steps we migrate data in excel to mifos through DMT: after data from the excel template localhost: 8080/dmt we download an excel template and then we fill it, we upload to succeed, after the migration process we upload and display an error message like the following :
INFO - Preparing a staging database for the DMTorg.mifos.dmt.workflowTasks.PrepStaging INFO - Prepearing stage1 schema to begin migration DEBUG - Stage 1 prep started with -> C:/kettle/prepStaging.bat localhost root enter stage1 C:/kettle/dest.sql 3306 INFO - Initialising DMT propertiesorg.mifos.dmt.workflowTasks.DMTParamInjection INFO - loading data from excel to DMT stagingorg.mifos.dmt.serviceFactory.GenericKettleJobService INFO - Executing CreateIdentifierColumns ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateCenters ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateGroups ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateClients ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateIndividualClients ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateMeetings ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateIndividualClientMeetings ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateClientFamily ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateLoanAccounts ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateGroupLoans ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing MigrateCustomFields ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Executing ExcelMigrateLoanFees ERROR - A serious error occurred during job execution: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist ERROR - org.pentaho.di.core.exception.KettleJobException: Unable to begin processing by logging start in logtable kettle_logs Couldn't execute SQL: LOCK TABLES kettle_logs WRITE Table 'log.kettle_logs' doesn't exist org.pentaho.di.job.Job.beginProcessing(Job.java:842) org.pentaho.di.job.Job.execute(Job.java:335) org.pentaho.di.job.Job.run(Job.java:282) INFO - Generating customer schedulesorg.mifos.dmt.workflowTasks.CustomerMigrationTask INFO - Generating loan schedulesorg.mifos.dmt.workflowTasks.LoanMigrationTask ERROR - Exception while generating loan scheduleUnknown column 'la.amount_paid' in 'field list' Thanks Before... Best Regard, On 22 Feb, 13:39, <[email protected]> wrote: > Safik, > > Can you send me what errors you are seeing ? Kindly attach a screenshot of > the errors you are facing so that I can help you resolve those. > > Thanks > Chetan > > > > > > > > -----Original Message----- > From: Safik Omara [mailto:[email protected]] > Sent: Wednesday, February 22, 2012 9:35 AM > To: [email protected] > Subject: Re: [Mifos-users] Download a database error of DMT system > > Thank you for your instructions, > now I've managed to download the Excel template from localhost: 8080/ > dmt. after i get the excel templates, I browse and upload via DMT. > The upload is successful, but when we migrated our data from excel > upload a printed info, debug, and quite a lot of errors. > > What other settings should I do, to be successful in migrating data > from excel to mifos system. > Thank you very much for his direction. > > I'm from Indonesia, n my account g-talk is [email protected] > On 21 Feb, 16:16, <[email protected]> wrote: > > Yes, you are right. The production database is indeed the Mifos database. > > Also you need to create 2 more databases of Mifos schema - named Stage1 and > > stage2. From MySql, just create 2 databases named stage1 and stage2 and run > > the Mifos schema and base data scripts. I hope this clarifies. > > No chat client is allowed on my company networks. Perhaps I chat over gtalk > > later today evening from home. Which country are located in ? > > > Thanks > > Chetan > > > -----Original Message----- > > From: Safik Omara [mailto:[email protected]] > > Sent: Tuesday, February 21, 2012 1:51 PM > > To: [email protected] > > Subject: Re: [Mifos-users] Download a database error of DMT system > > > I want to clarify, the production database is the database used to run > > mifos mifos, right? > > > then how to stage 1 and stage 2? do i have to create the database > > again and place it on the stage 1 and stage 2? > > > What about setting the log after stage 1 and stage 2? > > > whether we could possibly do via yahoo messenger chat, skype or > > something else? so that I could be more clear in asking about this > > configuration. > > > thanx a lotttt > > > On Feb 21, 1:10 pm, <[email protected]> wrote: > > > Safik, > > > > We need to set up 3 Mifos databases for the Migration toolkit to work. > > > > 1. Production Mifos database : This is your destination database which > > > you will eventually use the production/live Mifos system. > > > 2. Stage 1: It is a Mifos database which will be used as a staging > > > database for migrating the data from the excel sheet. > > > 3. Stage 2: this database will be used as a temporary copy of Mifos > > > production during migration so as to minimize production downtime. > > > > If you still have questions, can we discuss this over a call so that we > > > can sort out your queries ? . > > > > Thanks > > > Chetan > > > > -----Original Message----- > > > From: Safik Omara [mailto:[email protected]] > > > Sent: Tuesday, February 21, 2012 7:23 AM > > > To: [email protected] > > > Subject: Re: [Mifos-users] Download a database error of DMT system > > > > To answer your question: > > > 1 I've made changes to the configuration of the application, then > > > mifos I run and I can enjoy the features mifos. > > > 2 to file jdbc. That's all there in the kettle, which in my simple- > > > jndi,,, it is in the configuration database user and password already, > > > but the purpose of stage 1, stage 2 and the log is what? whether it be > > > replaced as well? replaced if anything changed? > > > Thanx very much > > > > On Feb 20, 5:42 pm, Safik Omara <[email protected]> wrote: > > > > Could you also include examples of the configurationdatabasesettings > > > > that are user ID and password? > > > > Thanx a lot.... > > > > > On 20 Feb, 17:24, Safik Omara <[email protected]> wrote: > > > > > > Could you provide details on thedatabaseconfiguration should I do? > > > > > Thanx a lot > > > > > > On 20 Feb, 10:19, Safik Omara <[email protected]> wrote: > > > > > > > hello, > > > > > > I want to ask a question, now I'm trying to use DMT (manual data > > > > > > toolkit) to migrate data from an excel file to mifos. when Idownload > > > > > > an excel template ofhttp://localhost:8080/dmt/, there is a > > > > > > description of thiserror: > > > > > >ERROR-Errorcreating the production connection: > > > > > > java.lang.NullPointerException > > > > > >ERROR- null > > > > > > Erro -Errorwhile generating an excel sheet sheeterrorwhile editing > > > > > > config null > > > > > > > And results are downloadable excel 0KB capacity. Why can this be. > > > > > > Can give a solution, > > > > > > Best regards > > > > > > > thanks before, > > > > > > > --------------------------------------------------------------------------- > > > > > > --- > > > > > > Try before you buy = See our experts in action! > > > > > > The most comprehensive online learning library for Microsoft > > > > > > developers > > > > > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, > > > > > > MVC3, > > > > > > Metro Style Apps, more. Free future releases when you subscribe > > > > > > now!http://p.sf.net/sfu/learndevnow-dev2 > > > > > > _______________________________________________ > > > > > > Mifos-users mailing list > > > > > > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > > --------------------------------------------------------------------------- > > > > > --- > > > > > Try before you buy = See our experts in action! > > > > > The most comprehensive online learning library for Microsoft > > > > > developers > > > > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, > > > > > MVC3, > > > > > Metro Style Apps, more. Free future releases when you subscribe > > > > > now!http://p.sf.net/sfu/learndevnow-dev2 > > > > > _______________________________________________ > > > > > Mifos-users mailing list > > > > > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > > --------------------------------------------------------------------------- > > > > --- > > > > Try before you buy = See our experts in action! > > > > The most comprehensive online learning library for Microsoft developers > > > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > > > > Metro Style Apps, more. Free future releases when you subscribe > > > > now!http://p.sf.net/sfu/learndevnow-dev2 > > > > _______________________________________________ > > > > Mifos-users mailing list > > > > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > --------------------------------------------------------------------------- > > > --- > > > Keep Your Developer Skills Current with LearnDevNow! > > > The most comprehensive online learning library for Microsoft developers > > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > > > Metro Style Apps, more. Free future releases when you subscribe > > > now!http://p.sf.net/sfu/learndevnow-d2d > > > _______________________________________________ > > > Mifos-users mailing list > > > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > > > --------------------------------------------------------------------------- > > > --- > > > Keep Your Developer Skills Current with LearnDevNow! > > > The most comprehensive online learning library for Microsoft developers > > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > > > Metro Style Apps, more. Free future releases when you subscribe > > > now!http://p.sf.net/sfu/learndevnow-d2d > > > _______________________________________________ > > > Mifos-users mailing list > > > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > > ------------------------------------------------------------------------------ > > Keep Your Developer Skills Current with LearnDevNow! > > The most comprehensive online learning library for Microsoft developers > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > > Metro Style Apps, more. Free future releases when you subscribe > > now!http://p.sf.net/sfu/learndevnow-d2d > > _______________________________________________ > > Mifos-users mailing list > > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > > ------------------------------------------------------------------------------ > > Keep Your Developer Skills Current with LearnDevNow! > > The most comprehensive online learning library for Microsoft developers > > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > > Metro Style Apps, more. Free future releases when you subscribe > > now!http://p.sf.net/sfu/learndevnow-d2d > > _______________________________________________ > > Mifos-users mailing list > > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > ------------------------------------------------------------------------------ > Virtualization & Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a > service.http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > Mifos-users mailing list > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users > > ------------------------------------------------------------------------------ > Virtualization & Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a > service.http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > Mifos-users mailing list > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
