Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Parameter "-disabledResources" does not work with BLOB mapping #1789

Open
julianzz98 opened this issue Mar 10, 2025 · 0 comments
Open

Parameter "-disabledResources" does not work with BLOB mapping #1789

julianzz98 opened this issue Mar 10, 2025 · 0 comments
Labels
bug error issue and bug (fix) tools deegree command line tools (CLI)

Comments

@julianzz98
Copy link
Contributor

Used deegree version:

  • 3.5-RC1

Used data:

Used commands to set up:

docker run -d --name deegree_blob_35 -v /home/julian/.deegree:/root/.deegree -p 8080:8080 deegree/deegree3-docker:v3.5-RC1

docker exec -w /opt deegree_blob_35 java -jar deegree-tools-gml.jar SqlFeatureStoreConfigCreator -format=all -idtype=uuid -mapping=blob -dialect=postgis -schemaUrl=https://inspire.ec.europa.eu/schemas/so/4.0/Soil.xsd

julian@latlon-zilz:~/Downloads$ sudo docker cp deegree_blob_35:/opt/Soil.sql Soil_Blob/
julian@latlon-zilz:~/Downloads$ sudo docker cp deegree_blob_35:/opt/Soil.xml Soil_Blob/
julian@latlon-zilz:~/Downloads$ sudo chown -R julian:julian Soil_Blob/

docker run -d --name postgis_soil_blob -p 5432:5432 -e POSTGRES_PASSWORD=postgres -e POSTGRES_USER=postgres -v /home/julian/Downloads/Soil_Blob/:/root/ postgis/postgis:12-3.2

docker exec -it postgis_soil_blob psql -U postgres -c 'CREATE DATABASE inspire_soil;' -c '\c inspire_soil' -c 'CREATE EXTENSION postgis;' -f /root/Soil.sql

docker cp Soil.gml deegree_blob_35:/

Calling the GmlLoader with:

docker exec -w /opt deegree_blob_35 java -Xmx16g -jar deegree-tools-gml.jar GmlLoader -pathToFile=/Soil.gml -workspaceName=inspire_soil_blob_v35 -sqlFeatureStoreId=inspire_soil_blob_fs -disabledResources=https://inspire.ec.europa.eu/codelist/

Output:

2023-06-26 16:49:07 [main] ERROR o.d.f.p.s.SQLFeatureStoreTransaction - Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
2023-06-26 16:49:07 [main] ERROR o.d.f.p.s.SQLFeatureStoreTransaction - Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
2023-06-26 16:49:07 [main] ERROR o.d.f.p.s.SQLFeatureStoreTransaction - Error inserting feature: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
2023-06-26 16:49:07 [main] ERROR o.d.f.p.s.SQLFeatureStoreTransaction - Error inserting feature: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
2023-06-26 16:49:07 [main] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step gmlLoaderStep in job gmlLoaderJob
org.deegree.feature.persistence.FeatureStoreException: Error inserting feature: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:688)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter.write(FeatureStoreWriter.java:77)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter$$FastClassBySpringCGLIB$$4630f152.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter$$EnhancerBySpringCGLIB$$1917060e.write(<generated>)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:193)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:159)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:294)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:217)
	at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:77)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy26.execute(Unknown Source)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:152)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:413)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:136)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:320)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:149)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:140)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:128)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy21.run(Unknown Source)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:199)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:173)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:160)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:155)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:150)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:749)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:314)
	at org.deegree.tools.featurestoresql.loader.GmlLoaderApp.run(GmlLoaderApp.java:48)
	at org.deegree.tools.featurestoresql.GmlToolsApp.main(GmlToolsApp.java:23)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: java.sql.SQLException: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.encodeFeatureBlob(SQLFeatureStoreTransaction.java:828)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.insertFeatureBlob(SQLFeatureStoreTransaction.java:717)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:640)
	... 75 common frames omitted
Caused by: org.deegree.commons.tom.ReferenceResolvingException: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.commons.tom.Reference.getReferencedObject(Reference.java:155)
	at org.deegree.gml.reference.FeatureReference.getReferencedObject(FeatureReference.java:161)
	at org.deegree.gml.reference.FeatureReference.getReferencedObject(FeatureReference.java:60)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:226)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:215)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:256)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:558)
	... 75 common frames omitted
2023-06-26 16:49:07 [main] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step gmlLoaderStep in job gmlLoaderJob
org.deegree.feature.persistence.FeatureStoreException: Error inserting feature: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:688)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter.write(FeatureStoreWriter.java:77)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter$$FastClassBySpringCGLIB$$4630f152.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter$$EnhancerBySpringCGLIB$$1917060e.write(<generated>)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:193)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:159)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:294)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:217)
	at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:77)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy26.execute(Unknown Source)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:152)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:413)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:136)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:320)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:149)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:140)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:128)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy21.run(Unknown Source)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:199)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:173)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:160)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:155)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:150)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:749)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:314)
	at org.deegree.tools.featurestoresql.loader.GmlLoaderApp.run(GmlLoaderApp.java:48)
	at org.deegree.tools.featurestoresql.GmlToolsApp.main(GmlToolsApp.java:23)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: java.sql.SQLException: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.encodeFeatureBlob(SQLFeatureStoreTransaction.java:828)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.insertFeatureBlob(SQLFeatureStoreTransaction.java:717)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:640)
	... 75 common frames omitted
Caused by: org.deegree.commons.tom.ReferenceResolvingException: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.commons.tom.Reference.getReferencedObject(Reference.java:155)
	at org.deegree.gml.reference.FeatureReference.getReferencedObject(FeatureReference.java:161)
	at org.deegree.gml.reference.FeatureReference.getReferencedObject(FeatureReference.java:60)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:226)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:215)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:256)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:558)
	... 75 common frames omitted
2023-06-26 16:49:07 [main] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step gmlLoaderStep in job gmlLoaderJob
org.deegree.feature.persistence.FeatureStoreException: Error inserting feature: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:688)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter.write(FeatureStoreWriter.java:77)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter$$FastClassBySpringCGLIB$$4630f152.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
	at org.deegree.tools.featurestoresql.loader.FeatureStoreWriter$$EnhancerBySpringCGLIB$$1917060e.write(<generated>)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:193)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:159)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:294)
	at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:217)
	at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:77)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407)
	at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331)
	at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
	at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273)
	at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
	at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
	at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
	at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
	at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258)
	at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137)
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy26.execute(Unknown Source)
	at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:152)
	at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:413)
	at org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:136)
	at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:320)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:149)
	at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
	at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:140)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:128)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
	at com.sun.proxy.$Proxy21.run(Unknown Source)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:199)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:173)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:160)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:155)
	at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:150)
	at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:759)
	at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:749)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:314)
	at org.deegree.tools.featurestoresql.loader.GmlLoaderApp.run(GmlLoaderApp.java:48)
	at org.deegree.tools.featurestoresql.GmlToolsApp.main(GmlToolsApp.java:23)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: java.sql.SQLException: Error encoding feature for BLOB: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.encodeFeatureBlob(SQLFeatureStoreTransaction.java:828)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.insertFeatureBlob(SQLFeatureStoreTransaction.java:717)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:640)
	... 75 common frames omitted
Caused by: org.deegree.commons.tom.ReferenceResolvingException: Unable to resolve reference to 'https://inspire.ec.europa.eu/codelist/SoilProfileParameterNameValue/biologicalParameter'.
	at org.deegree.commons.tom.Reference.getReferencedObject(Reference.java:155)
	at org.deegree.gml.reference.FeatureReference.getReferencedObject(FeatureReference.java:161)
	at org.deegree.gml.reference.FeatureReference.getReferencedObject(FeatureReference.java:60)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:226)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:215)
	at org.deegree.feature.Features.findFeaturesAndGeometries(Features.java:256)
	at org.deegree.feature.persistence.sql.SQLFeatureStoreTransaction.performInsert(SQLFeatureStoreTransaction.java:558)
	... 75 common frames omitted
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler - Unresolvable references detected:
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler - Unresolvable references detected:
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221581000100
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221581000100
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_1000536281000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_1000536281000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700220921000200
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700220921000200
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700220931000100
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700220931000100
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221391000100
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221391000100
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221561000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221561000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221391000300
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221391000300
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221401000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221401000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221581000200
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_0700221581000200
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_1200620741000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler -    - DerivedSoilProfile_1200620741000000
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler - Rollback transaction.
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.TransactionHandler - Rollback transaction.
2023-06-26 16:49:07 [main] INFO o.s.batch.core.step.AbstractStep - Step: [gmlLoaderStep] executed in 16s274ms
2023-06-26 16:49:07 [main] INFO o.s.batch.core.step.AbstractStep - Step: [gmlLoaderStep] executed in 16s274ms
2023-06-26 16:49:07 [main] INFO o.s.batch.core.step.AbstractStep - Step: [gmlLoaderStep] executed in 16s274ms
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.GmlReader - Finished file Soil.gml
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.GmlReader - Finished file Soil.gml
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.GmlReader - Finished file Soil.gml
2023-06-26 16:49:07 [main] INFO o.d.t.f.loader.GmlReader - Finished file Soil.gml
2023-06-26 16:49:07 [main] INFO o.s.b.c.l.support.SimpleJobLauncher - Job: [SimpleJob: [name=gmlLoaderJob]] completed with the following parameters: [{pathToFile=/Soil.gml, workspaceName=inspire_soil_blob_v35, run.id=1, disabledResources=https://inspire.ec.europa.eu/codelist/, sqlFeatureStoreId=inspire_soil_blob_fs}] and the following status: [FAILED] in 16s329ms
2023-06-26 16:49:07 [main] INFO o.s.b.c.l.support.SimpleJobLauncher - Job: [SimpleJob: [name=gmlLoaderJob]] completed with the following parameters: [{pathToFile=/Soil.gml, workspaceName=inspire_soil_blob_v35, run.id=1, disabledResources=https://inspire.ec.europa.eu/codelist/, sqlFeatureStoreId=inspire_soil_blob_fs}] and the following status: [FAILED] in 16s329ms
2023-06-26 16:49:07 [main] INFO o.s.b.c.l.support.SimpleJobLauncher - Job: [SimpleJob: [name=gmlLoaderJob]] completed with the following parameters: [{pathToFile=/Soil.gml, workspaceName=inspire_soil_blob_v35, run.id=1, disabledResources=https://inspire.ec.europa.eu/codelist/, sqlFeatureStoreId=inspire_soil_blob_fs}] and the following status: [FAILED] in 16s329ms
@julianzz98 julianzz98 added bug error issue and bug (fix) tools deegree command line tools (CLI) labels Mar 10, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug error issue and bug (fix) tools deegree command line tools (CLI)
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@julianzz98