Hexagon Geospatial
MENU

ERDAS APOLLO & ECW/JP2

Wondering how others have configured their ERDAS APOLLO server or what data they are crawling? The ERDAS APOLLO Discussion board is a place to find information, share ideas and more. Join the community, connect, contribute and share.
Showing results for 
Search instead for 
Do you mean 
Reply
Super Contributor
Posts: 383
Registered: ‎10-12-2015
Accepted Solution

Crawling database - One of the identified items was in an invalid format

  • Apollo 15EP05
  • Deleted all content/aggregates from catalog, should be empty
  • Crawling SQL Server table Test01 - created by GeoMedia, linear feature in EPSG:2193

Loads into the catalog, but the WMS fails so won't generate the thumbnail. WMS won't work. e.g. add to map fails, can't see in Portal etc.

Bit lost as to where the issue might be sourced.

 

JBOSS-server.log:

17:25:17,724 INFO  [com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob] (quartzSchedulerFactory_Worker-2) Job CrawlerService#crawl-734723802 start time : 2016-06-02 17:25:17.724
17:25:18,335 INFO  [com.erdas.apollo.dmbl.tasks.RegisterResourceItemTask] (quartzSchedulerFactory_Worker-2) registered resource 'GeoTrainSpatial' for null
17:25:18,855 INFO  [org.jbpm.JbpmConfiguration] (quartzSchedulerFactory_Worker-2) using jbpm configuration resource 'jbpm.cfg.xml'
17:25:18,886 INFO  [org.jbpm.persistence.db.StaleObjectLogConfigurer] (quartzSchedulerFactory_Worker-2) stale object exceptions will be hidden from logging
17:25:19,284 INFO  [com.erdas.apollo.dmbl.tasks.RegisterResourceItemTask] (quartzSchedulerFactory_Worker-2) registered resource 'Test01' for null
17:25:25,247 ERROR [com.erdas.apollo.dmbl.tasks.GenerateThumbnailTask] (quartzSchedulerFactory_Worker-2) Error during Thumbnail Generation Task for Test01. WMS GetMap request failed. Exception: An unexpected error occurred. Original message: 'One or more errors occurred.'[An unexpected error occurred. Original message: 'One of the identified items was in an invalid format.']
17:25:25,264 ERROR [com.erdas.apollo.job.TaskContext] (quartzSchedulerFactory_Worker-2) Error during Thumbnail Generation Task for Test01. WMS GetMap request failed. Check the APOLLO Server WMS Service's operational state.
context: MSSql://GeoTrainSpatial?dataset#Test01: com.ionicsoft.api.wms.WMSException: An unexpected error occurred. Original message: 'One or more errors occurred.'[An unexpected error occurred. Original message: 'One of the identified items was in an invalid format.']
    at com.ionicsoft.wmtmap.client.remote.MapServerImpl.checkErrorResult(MapServerImpl.java:1071) [cots-wms-client.jar:]
    at com.ionicsoft.wmtmap.client.remote.MapServerImpl.processRequest(MapServerImpl.java:508) [cots-wms-client.jar:]
    at com.ionicsoft.wmtmap.client.remote.MapServerImpl.processRequest(MapServerImpl.java:413) [cots-wms-client.jar:]
    at com.ionicsoft.wmtmap.client.common.BaseMapServer.GetMap(BaseMapServer.java:289) [cots-wms-client.jar:]
    at com.erdas.apollo.dmbl.tasks.GenerateThumbnailTask.doExecute(GenerateThumbnailTask.java:249) [dmbl-core.jar:]
    at com.erdas.apollo.job.Task.execute(Task.java:104) [utils-common.jar:]
    at com.erdas.apollo.job.TaskAction.execute(TaskAction.java:60) [eaim-server-core.jar:]
    at com.erdas.apollo.job.ConditionalTaskAction.execute(ConditionalTaskAction.java:32) [eaim-server-core.jar:]
    at org.jbpm.graph.def.Action.execute(Action.java:122) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:264) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.execute(Node.java:339) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.enter(Node.java:319) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Transition.take(Transition.java:151) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:394) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:369) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.exe.ExecutionContext.leaveNode(ExecutionContext.java:128) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at com.erdas.apollo.job.TaskAction.execute(TaskAction.java:72) [eaim-server-core.jar:]
    at com.erdas.apollo.job.ConditionalTaskAction.execute(ConditionalTaskAction.java:32) [eaim-server-core.jar:]
    at org.jbpm.graph.def.Action.execute(Action.java:122) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:264) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.execute(Node.java:339) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.enter(Node.java:319) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Transition.take(Transition.java:151) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:394) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:369) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.exe.ExecutionContext.leaveNode(ExecutionContext.java:128) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at com.erdas.apollo.job.TaskAction.execute(TaskAction.java:72) [eaim-server-core.jar:]
    at com.erdas.apollo.job.ConditionalTaskAction.execute(ConditionalTaskAction.java:32) [eaim-server-core.jar:]
    at org.jbpm.graph.def.Action.execute(Action.java:122) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:264) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.execute(Node.java:339) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.enter(Node.java:319) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Transition.take(Transition.java:151) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:394) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:369) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.exe.ExecutionContext.leaveNode(ExecutionContext.java:128) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at com.erdas.apollo.job.TaskAction.execute(TaskAction.java:72) [eaim-server-core.jar:]
    at org.jbpm.graph.def.Action.execute(Action.java:122) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:264) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.execute(Node.java:339) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.enter(Node.java:319) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Transition.take(Transition.java:151) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:394) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:369) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.exe.ExecutionContext.leaveNode(ExecutionContext.java:128) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at com.erdas.apollo.job.TaskAction.execute(TaskAction.java:72) [eaim-server-core.jar:]
    at org.jbpm.graph.def.Action.execute(Action.java:122) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.GraphElement.executeAction(GraphElement.java:264) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.execute(Node.java:339) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.enter(Node.java:319) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Transition.take(Transition.java:151) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.def.Node.leave(Node.java:394) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.node.StartState.leave(StartState.java:70) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.exe.Token.signal(Token.java:195) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.exe.Token.signal(Token.java:140) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at org.jbpm.graph.exe.ProcessInstance.signal(ProcessInstance.java:271) [jpdl.jar:3.2.2 (date:12-Sep-2007 13:59)]
    at com.erdas.apollo.job.WorkflowTask.doExecute(WorkflowTask.java:91) [eaim-server-core.jar:]
    at com.erdas.apollo.job.Task.execute(Task.java:104) [utils-common.jar:]
    at com.erdas.apollo.dmbl.tasks.DecodeAndRegisterTask.doExecute(DecodeAndRegisterTask.java:293) [dmbl-core.jar:]
    at com.erdas.apollo.job.Task.execute(Task.java:104) [utils-common.jar:]
    at com.erdas.apollo.dmbl.crawling.process.db.CrawlVectorDatabaseProcess.crawl(CrawlVectorDatabaseProcess.java:185) [dmbl-core.jar:]
    at com.erdas.apollo.dmbl.crawling.process.db.CrawlVectorDatabaseProcess.execute(CrawlVectorDatabaseProcess.java:148) [dmbl-core.jar:]
    at com.erdas.apollo.dmbl.crawling.process.db.CrawlVectorDatabaseProcess.execute(CrawlVectorDatabaseProcess.java:52) [dmbl-core.jar:]
    at com.erdas.apollo.dmbl.crawling.process.db.VectorDatabaseCrawler.execute(VectorDatabaseCrawler.java:48) [dmbl-core.jar:]
    at com.erdas.apollo.dmbl.crawling.process.db.VectorDatabaseCrawler.execute(VectorDatabaseCrawler.java:19) [dmbl-core.jar:]
    at com.erdas.apollo.dmbl.crawling.CrawlerServiceImpl.crawl(CrawlerServiceImpl.java:49) [dmbl-core.jar:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_51]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_51]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_51]
    at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_51]
    at com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob.doExecute(ApolloServiceRunnerJob.java:365) [dmbl-core.jar:]
    at com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob.execute(ApolloServiceRunnerJob.java:130) [dmbl-core.jar:]
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199) [quartz-all.jar:]
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543) [quartz-all.jar:]

17:25:25,281 INFO  [com.erdas.apollo.dmbl.tasks.GenerateISOMetadataTask] (quartzSchedulerFactory_Worker-2) Generating ISO 19139 metadata document using the ISO template writer...
17:25:26,021 INFO  [com.erdas.apollo.dmbl.tasks.GenerateISOMetadataTask] (quartzSchedulerFactory_Worker-2) Generating ISO 19139 metadata document using the ISO template writer...
17:25:26,306 INFO  [com.erdas.apollo.dmbl.tasks.GenerateISOMetadataTask] (quartzSchedulerFactory_Worker-2) Generating ISO 19139 metadata document using the ISO template writer...
17:25:26,407 INFO  [com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob] (quartzSchedulerFactory_Worker-2) Job CrawlerService#crawl-734723802 end time : 2016-06-02 17:25:26.407
17:25:26,407 INFO  [com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob] (quartzSchedulerFactory_Worker-2) Job CrawlerService#crawl-734723802 completed in 00h:00m:08s

 

 

ApolloCatalogWMS\log\rol-log.txt:

2016-06-02 17:25:43,285 [11] ERROR Intergraph.Geospatial.Server.SDI.CommonPlatforms.MapRenderer.MapRenderer [(null)] - Map renderer internal error. One or more errors occurred.System.FormatException: One of the identified items was in an invalid format.
   at Microsoft.SqlServer.Types.GeoData.Read(BinaryReader r)
   at Microsoft.SqlServer.Types.SqlGeometry.Read(BinaryReader r)
   at Microsoft.SqlServer.Server.BinarySerializeSerializer.Deserialize(Stream s)
   at System.Data.SqlClient.SqlConnection.GetUdtValue(Object value, SqlMetaDataPriv metaData, Boolean returnDBNull)
   at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i)
   at Intergraph.Geoprocessing.SqlServerAccessor.SqlServerAccessorWorker.SqlServerAccessorDbPresenter.GetValue(String name, Boolean isGeometry)
   at Intergraph.Geoprocessing.SqlServerAccessor.SqlServerAccessorWorker.FillRow()
   at Intergraph.Geoprocessing.SqlServerAccessor.SqlServerAccessorWorker.MoveNext()
   at Intergraph.Geoprocessing.CoordinateTransformationProcessor.FeatureDataProvider.MoveNext()
   at Intergraph.Geometry.Extensions.MoveFirstKludge(IFeatureAccessor featureAccessor)
   at Intergraph.MapDisplay.Layer.Draw(IGRORenderConfig rendererConfig, IGROCanvasDraw targetCanvas, Rectangle drawRectangle)
   at Intergraph.MapDisplay.Renderer.DrawToolMgr.RenderCycle()
   at Intergraph.MapDisplay.Renderer.DrawToolMgr.Render()
   at System.Threading.Tasks.Task.Execute()

 

 

Technical Evangelist
Posts: 843
Registered: ‎07-30-2015

Re: Crawling database - One of the identified items was in an invalid format

Hi ShaunF,

 

Not sure I understand the workflow here. Can you provide more detail about your workflow?

 

Deleted all content/aggregates from catalog, should be empty

>do you mean you delete all aggregates/dataset using data manager?
After that you can still see aggregates/dataset in the catalog?

 

best
haiyan

Super Contributor
Posts: 383
Registered: ‎10-12-2015

Re: Crawling database - One of the identified items was in an invalid format

I deleted all content from the catalog using Data Manager so there is nothing in the catalog that could interfer with the database crawl or its results.

Database crawl succeeds.

Then trying to use the ApolloCatalogWMS or ApolloCatalogWMSPublic results in errors.

 

I have since built a new VM with fresh install. ApolloCatalogWMS or ApolloCatalogWMSPublic both still fail, this time with error

"Unable to load DLL 'SqlServerSpatial.dll': The specified module could not be found."

 

2016-06-07 09:30:51,419 INFO  (quartzSchedulerFactory_Worker-1)[com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob] Job ProvisioningService#generateThumbnails-256231314 start time : 2016-06-07 09:30:51.419
2016-06-07 09:31:05,215 ERROR (quartzSchedulerFactory_Worker-1)[com.erdas.apollo.dmbl.tasks.GenerateThumbnailTask] Error during Thumbnail Generation Task for NZ_Primary_Road_Parcels. WMS GetMap request failed. Exception: An error occurred.[An unexpected error occurred. Original message: 'One or more errors occurred.'[An unexpected error occurred. Original message: 'Unable to load DLL 'SqlServerSpatial.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)']]
2016-06-07 09:31:05,231 ERROR (quartzSchedulerFactory_Worker-1)[com.erdas.apollo.job.TaskContext] Error during Thumbnail Generation Task for NZ_Primary_Road_Parcels. WMS GetMap request failed. Check the APOLLO Server WMS Service's operational state.
context: MSSql://VER15_0?tableNameFilter=NZ_P*#NZ_Primary_Road_Parcels
com.ionicsoft.api.wms.WMSException: An error occurred.[An unexpected error occurred. Original message: 'One or more errors occurred.'[An unexpected error occurred. Original message: 'Unable to load DLL 'SqlServerSpatial.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)']]
    at com.ionicsoft.wmtmap.client.remote.MapServerImpl.checkErrorResult(MapServerImpl.java:1071)
    at com.ionicsoft.wmtmap.client.remote.MapServerImpl.processRequest(MapServerImpl.java:508)
    at com.ionicsoft.wmtmap.client.remote.MapServerImpl.processRequest(MapServerImpl.java:413)
    at com.ionicsoft.wmtmap.client.common.BaseMapServer.GetMap(BaseMapServer.java:289)
    at com.erdas.apollo.dmbl.tasks.GenerateThumbnailTask.doExecute(GenerateThumbnailTask.java:252)
    at com.erdas.apollo.job.Task.execute(Task.java:104)
    at com.erdas.apollo.job.CompositeTask.doExecute(CompositeTask.java:65)
    at com.erdas.apollo.job.Task.execute(Task.java:104)
    at com.erdas.apollo.dmbl.provisioning.ProvisioningServiceImpl.runThumbnailTask(ProvisioningServiceImpl.java:764)
    at com.erdas.apollo.dmbl.provisioning.ProvisioningServiceImpl.generateThumbnails(ProvisioningServiceImpl.java:662)
    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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy74.generateThumbnails(Unknown Source)
    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 com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob.doExecute(ApolloServiceRunnerJob.java:365)
    at com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob$1.perform(ApolloServiceRunnerJob.java:107)
    at com.erdas.rsp.babel.util.tx.SimpleTransactionManagerImpl.performInASeparateTransaction(SimpleTransactionManagerImpl.java:28)
    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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy55.performInASeparateTransaction(Unknown Source)
    at com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob.execute(ApolloServiceRunnerJob.java:102)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
2016-06-07 09:31:05,231 ERROR (quartzSchedulerFactory_Worker-1)[com.erdas.apollo.dmbl.tasks.GenerateThumbnailTask] Error during Thumbnail Generation Task for NZ_Primary_Road_Parcels. WMS GetMap request failed.
com.erdas.apollo.exception.ApolloException: Error during Thumbnail Generation Task for NZ_Primary_Road_Parcels. WMS GetMap request failed.
    at com.erdas.apollo.dmbl.tasks.GenerateThumbnailTask.doExecute(GenerateThumbnailTask.java:265)
    at com.erdas.apollo.job.Task.execute(Task.java:104)
    at com.erdas.apollo.job.CompositeTask.doExecute(CompositeTask.java:65)
    at com.erdas.apollo.job.Task.execute(Task.java:104)
    at com.erdas.apollo.dmbl.provisioning.ProvisioningServiceImpl.runThumbnailTask(ProvisioningServiceImpl.java:764)
    at com.erdas.apollo.dmbl.provisioning.ProvisioningServiceImpl.generateThumbnails(ProvisioningServiceImpl.java:662)
    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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy74.generateThumbnails(Unknown Source)
    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 com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob.doExecute(ApolloServiceRunnerJob.java:365)
    at com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob$1.perform(ApolloServiceRunnerJob.java:107)
    at com.erdas.rsp.babel.util.tx.SimpleTransactionManagerImpl.performInASeparateTransaction(SimpleTransactionManagerImpl.java:28)
    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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy55.performInASeparateTransaction(Unknown Source)
    at com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob.execute(ApolloServiceRunnerJob.java:102)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:543)
2016-06-07 09:31:05,231 INFO  (quartzSchedulerFactory_Worker-1)[com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob] Job ProvisioningService#generateThumbnails-256231314 end time : 2016-06-07 09:31:05.231
2016-06-07 09:31:05,231 INFO  (quartzSchedulerFactory_Worker-1)[com.erdas.apollo.dmbl.scheduling.job.ApolloServiceRunnerJob] Job ProvisioningService#generateThumbnails-256231314 completed in 00h:00m:13s

 

I'm currently doing a few more checks before logging an SR

Technical Evangelist
Posts: 843
Registered: ‎07-30-2015

Re: Crawling database - One of the identified items was in an invalid format

Hi Shaun,

 

This is known issue for APOLLO 2015 EP05 crawling SQL geometry/geography spatial data:
CR 1-L556LZ APOLLO failed to crawl some valid geometry and geographic data from MS SQL server

 

Also Apollo doesn't support Intergraphy GDO data type, only SQL server native Geometry and Geography data type.

 

best
haiyan

Super Contributor
Posts: 383
Registered: ‎10-12-2015

Re: Crawling database - One of the identified items was in an invalid format

Thanks Haiyan,

 

To clarify 'Also Apollo doesn't support Intergraphy GDO data type, only SQL server native Geometry and Geography data type'.

  • I assume you are referring to databases maintained using the pre-SQL Server 2008 GeoMedia GDO data server that only populates the Intergraph GDO column as not being supported.
  • I assume if using a databased maintained using the post SQL Server 2008 GeoMedia 'SQL Server Spatial' data server that maintains both SQL Server native Geometry and GDO columns it will work.
    • In the 'SQL Server Spatial' scenario is the GDO field completely ignored by Apollo?
      e.g. if have rotated point maintained in GeoMedia where the rotated point is represented in the GDO column and non-rotated point represented in the native geometry field, will the point rotation be lost when portrayed by Apollo WMS as rotated points are not supported in SQL Server native geometry data type?

 

I'd run a test to verify the rotated point but can't get any crawled SQL Server database content to display in the WMS ;<

 

 

Super Contributor
Posts: 383
Registered: ‎10-12-2015

Re: Crawling database - One of the identified items was in an invalid format

Retested with Apollo 2016 with new 'WMS Core' option.

ApolloCatalogWMSPublic and ApolloCatalogWMS both worked with SQL Server crawled database.

Have not tried ver 2016 with legacy WMS option.

 

Also tried crawling some orientated points to see if the GeoMedia orientation would come through. Orientation did not.

So implies crawled SQL Server table can have both the geometry (GDO) and geometry_SPA columns, but looks like only the geometry_SPA is used. Interestingly though, the generated thumbnail did show the points orientated which suggests some part of the system uses both geometry (GDO) and geometry_SPA fields. Workaround would be to populate the point orientation into a db column and then apply orientation against oints using Attribute Based Symbology - additional maintenance step required though to populate the orientation into the db.

Staff inactive
Posts: 57
Registered: ‎10-12-2015

Re: Crawling database - One of the identified items was in an invalid format

Shaun,

 

Legacy should work as well as WMS Core is more ratster/grid based.  When working with Vector, it internally (for crawling) falls back to Legacy.

Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.