I have successfully installed Collect Earth on a Mac OS X .

When Collect Earth opens its window is showing without problems but in Google Earth the list of plots is not showing up. What is going on?

These are the latest messages from the Application Log ( that I copied from Help->Open Application Log dialog)

Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.openforis.collect.earth.app.service.EarthSurveyService org.openforis.collect.earth.app.server.CollectDataAccessor.earthSurveyService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'earthSurveyService': Invocation of init method failed; nested exception is org.jooq.exception.DataAccessException: SQL [select max(ofc_code_list.id) from ofc_code_list]; [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:506)    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:284)   ... 81 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'earthSurveyService': Invocation of init method failed; nested exception is org.jooq.exception.DataAccessException: SQL [select max(ofc_code_list.id) from ofc_code_list]; [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)  at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:135)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1448)    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)  at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:848)     at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:790)    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:707)  at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:478)    ... 83 more Caused by: org.jooq.exception.DataAccessException: SQL [select max(ofc_code_list.id) from ofc_code_list]; [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)     at org.jooq.impl.Util.translate(Util.java:562)  at org.jooq.impl.DefaultExecuteContext.sqlException(DefaultExecuteContext.java:360)     at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:176)  at org.jooq.impl.AbstractResultQuery.fetch(AbstractResultQuery.java:252)    at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:386)     at org.jooq.impl.AbstractResultQuery.fetchOne(AbstractResultQuery.java:354)     at org.jooq.impl.AbstractDelegatingSelect.fetchOne(AbstractDelegatingSelect.java:182)   at org.openforis.collect.persistence.jooq.DialectAwareJooqFactory.nextId(DialectAwareJooqFactory.java:91)   at org.openforis.collect.persistence.jooq.MappingJooqFactory.nextId(MappingJooqFactory.java:115)    at org.openforis.collect.persistence.CodeListItemDao$JooqFactory.nextId(CodeListItemDao.java:787)   at org.openforis.collect.persistence.CodeListItemDao.nextSystemId(CodeListItemDao.java:563)     at org.openforis.collect.persistence.CodeListItemDao$$FastClassByCGLIB$$89050352.invoke(<generated>)    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)  at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)    at org.openforis.collect.persistence.CodeListItemDao$$EnhancerByCGLIB$$f4868923.nextSystemId(<generated>)   at org.openforis.collect.manager.CodeListManager.importCodeLists(CodeListManager.java:62)   at org.openforis.collect.manager.CodeListManager.importCodeLists(CodeListManager.java:77)   at org.openforis.collect.manager.CodeListManager$$FastClassByCGLIB$$72c1af0e.invoke(<generated>)    at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)  at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)    at org.openforis.collect.manager.CodeListManager$$EnhancerByCGLIB$$aa1a7e37.importCodeLists(<generated>)    at org.openforis.collect.manager.SurveyManager.importModel(SurveyManager.java:206)  at org.openforis.collect.manager.SurveyManager$$FastClassByCGLIB$$f98f0bff.invoke(<generated>)  at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)  at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)    at org.openforis.collect.manager.SurveyManager$$EnhancerByCGLIB$$3221f792.importModel(<generated>)  at org.openforis.collect.earth.app.service.EarthSurveyService.init(EarthSurveyService.java:194)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:606)     at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:346)     at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:299)     at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:132)     ... 95 more Caused by: java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)     at org.sqlite.DB.newSQLException(DB.java:383)   at org.sqlite.DB.newSQLException(DB.java:387)   at org.sqlite.DB.execute(DB.java:342)   at org.sqlite.PrepStmt.execute(PrepStmt.java:65)    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)    at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)    at org.jooq.impl.DataSourcePreparedStatement.execute(DataSourcePreparedStatement.java:86)   at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:172)  at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:172)  ... 138 more ERROR 2014-11-12 16:44:12,495 [AWT-EventQueue-0] org.openforis.collect.earth.app.view.CollectEarthWindow: Error while setting the ServerController org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataImportExportService': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.openforis.collect.earth.app.service.EarthSurveyService org.openforis.collect.earth.app.service.DataImportExportService.earthSurveyService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'earthSurveyService': Invocation of init method failed; nested exception is java.lang.IndexOutOfBoundsException: Index: 0, Size: 0   at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:287)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1106)  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)  at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:265)    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1101)     at org.openforis.collect.earth.app.view.CollectEarthWindow.setServerController(CollectEarthWindow.java:98)  at org.openforis.collect.earth.app.desktop.EarthApp$2.run(EarthApp.java:436)    at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:312)    at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:733)   at java.awt.EventQueue.access$200(EventQueue.java:103)  at java.awt.EventQueue$3.run(EventQueue.java:694)   at java.awt.EventQueue$3.run(EventQueue.java:692)   at java.security.AccessController.doPrivileged(Native Method)   at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)   at java.awt.EventQueue.dispatchEvent(EventQueue.java:703)   at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)    at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)   at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)    at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)    at java.awt.EventDispatchThread.run(EventDispatchThread.java:91) Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private org.openforis.collect.earth.app.service.EarthSurveyService org.openforis.collect.earth.app.service.DataImportExportService.earthSurveyService; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'earthSurveyService': Invocation of init method failed; nested exception is java.lang.IndexOutOfBoundsException: Index: 0, Size: 0     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:506)    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)     at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:284)   ... 25 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'earthSurveyService': Invocation of init method failed; nested exception is java.lang.IndexOutOfBoundsException: Index: 0, Size: 0    at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:135)     at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1448)    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)     at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)   at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)  at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:848)     at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:790)    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:707)  at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:478)    ... 27 more Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0   at java.util.ArrayList.rangeCheck(ArrayList.java:635)   at java.util.ArrayList.get(ArrayList.java:411)  at org.jooq.impl.ResultImpl.get(ResultImpl.java:1566)   at org.jooq.impl.ResultImpl.get(ResultImpl.java:92)     at org.openforis.collect.persistence.SurveyDao.getSurveyId(SurveyDao.java:165)  at org.openforis.collect.persistence.SurveyDao.updateModel(SurveyDao.java:144)  at org.openforis.collect.persistence.SurveyDao$$FastClassByCGLIB$$dda46d6.invoke(<generated>)   at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)  at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)    at org.openforis.collect.persistence.SurveyDao$$EnhancerByCGLIB$$f0679bcf.updateModel(<generated>)  at org.openforis.collect.manager.SurveyManager.updateModel(SurveyManager.java:275)  at org.openforis.collect.manager.SurveyManager.updateModel(SurveyManager.java:240)  at org.openforis.collect.manager.SurveyManager$$FastClassByCGLIB$$f98f0bff.invoke(<generated>)  at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)  at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)    at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)    at org.openforis.collect.manager.SurveyManager$$EnhancerByCGLIB$$3221f792.updateModel(<generated>)  at org.openforis.collect.earth.app.service.EarthSurveyService.init(EarthSurveyService.java:196)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:606)     at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:346)     at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:299)     at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:132)     ... 39 more

(Question added on behalf of one of our users)

asked 12 Nov '14, 17:23

Open%20Foris's gravatar image

Open Foris ♦♦
2905612
accept rate: 7%

edited 14 Nov '14, 14:03


So according to this error message it seems that there is a problem with the SQLite database file.

... 95 more Caused by: java.sql.SQLException: [SQLITE_CORRUPT]  The database disk image is malformed (database disk image is malformed)     at org.sqlite.DB.newSQLException(DB.java:383) at org.sqlite.DB.newSQLException(DB.java:387) at org.sqlite.DB.execute(DB.java:342)  at org.sqlite.PrepStmt.execute(PrepStmt.java:65) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172) at

My guess is that something went wrong during the installation...the fix is rather simple, remove the database file ( WARNING: this is in case you have not collected any data! )

When the database file is removed and Collect Earth is started again this database file is recreated, and hopefully this time without any data corruption issues!


You can find the database file here ( from this other answer ) :

Windows : C:\Users\USER_NAME\AppData\Roaming\CollectEarth

Linux : ~/CollectEarth

Mac OS X : ~/Library/Application Support/Collect Earth

  • Tip , to get to this folder : Open Finder, Click Apple Key + Shift + G, you get a dialog, type ~ in the text field and click Ok (this will take you to your User’s home folder) Then browse to Library->Application Support->Collect Earth )
permanent link

answered 14 Nov '14, 14:11

collectearth's gravatar image

collectearth ♦
64015
accept rate: 16%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×159

question asked: 12 Nov '14, 17:23

question was seen: 3,415 times

last updated: 14 Nov '14, 14:11