*Hi Safik,
You can use the following command to avoid permgen out of memory,
For ubuntu:you can start jetty using java -Xms768M -Xmx768M
-XX:MaxPermSize=256m -jar start.jar instead of java -jar start.jar
For windows you need to set environmental variable for JAVA_OPTS as -Xms768M
-Xmx768M -XX:MaxPermSize=256m
Hope this helps you.*
Thanks and Regards,
Jaya
On Thu, Feb 23, 2012 at 9:27 AM, Safik Omara <[email protected]> wrote:
> thanks for attachment instructions, I have another question, namely:
> how to cope with out of memory on a jetty server, because we currently
> use a web server jetty-7.3.1 and 2.2.3 versions mifos. When we run
> mifos sometimes occur message: permgen out of memory ..
> what could be a solution to solve this problem.
> Many thanks.
>
> On 22 Feb, 16:53, <[email protected]> wrote:
> > Safik,
> >
> > Looks like you have not created the log database. Kindly follow the
> instructions in the attached DMT user manual. As part of the instructions,
> we have mentioned the various databases and other configurations required
> to be done before using the DMT. Creating the log database is required to
> enable the Kettle tool to log error and status messages.
> >
> > Thanks
> > Chetan
> >
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Safik Omara [mailto:[email protected]]
> > Sent: Wednesday, February 22, 2012 1:17 PM
> > To: [email protected]
> > Subject: Re: [Mifos-users] Download a database error of DMT system
> >
> > 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
> >
> > ...
> >
> > baca lainnya »
> >
> > DMT User Manual Ver 1.2.doc
> > 1121KTampilkanUnduhan
> >
> >
> ------------------------------------------------------------------------------
> > 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]://
> 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
>
--
Thanks and Regards,
Jaya Desai Software Engineer @ ConfluxTechnologies | Address :#412, 20th
Main,Chord Road 1st Block Rajajinagar Bengaluru,Karnataka-560010 | Email :
[email protected] | website:
www.Confluxtechnologies.com<http://www.confluxtechnologies.com/>|
Contact Number - Mob : +918867725929.
------------------------------------------------------------------------------
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
