Error during import models when deploying standalone CDD consumer

Data Services
1

Hi there,
I’m using com.mgmtp.a12.dataservices/dataservices-cdd-job:36.3.9 to deploy multiple instances of the CDD consumer following my configs below:

apiVersion: v1
data:
  MGMTP_A12_DATASERVICES_ATTACHMENTS_ENABLED: 'false'
  MGMTP_A12_DATASERVICES_CDD_DIRTYDOCUMENTS_ASYNC_CONSUMER_ENABLED: 'true'
  MGMTP_A12_DATASERVICES_CDD_DIRTYDOCUMENTS_ASYNC_PRODUCER_ENABLED: 'false'
  MGMTP_A12_DATASERVICES_CDD_DIRTYDOCUMENTS_DIRTYDOCUMENTSQUEUE: dirtyDocuments
  MGMTP_A12_DATASERVICES_CDD_MODEL_MODIFICATIONAFTERINITIALIZATION_ENABLED: 'false'
  MGMTP_A12_DATASERVICES_CDD_SOLR_CLOUD_ENABLED: 'false'
  MGMTP_A12_DATASERVICES_CDD_SOLR_COLLECTION_NAME: A12CddCore
  MGMTP_A12_DATASERVICES_CDD_SOLR_EMBEDDED_ENABLED: 'false'
  MGMTP_A12_DATASERVICES_CDD_SOLR_URLS: [MY_SOLR_SERVER}
  MGMTP_A12_DATASERVICES_INITIALIZATION_IMPORT_MODELS_PATH: file:/opt/dpos-config/dposConfig/models
  SPRING_CACHE_TYPE: hazelcast
  SPRING_DATASOURCES_DATASERVICES_JPA_PROPERTIES_HIBERNATE_CACHE_HAZELCAST_INSTANCENAME: hazelcast-howea
  SPRING_DATASOURCES_DATASERVICES_JPA_PROPERTIES_HIBERNATE_CACHE_REGION_FACTORYCLASS: com.hazelcast.hibernate.HazelcastCacheRegionFactory
  SPRING_HAZELCAST_CONFIG: file:/app/hazelcast-networking.yaml
  SPRING_HAZELCAST_INSTANCE_NAME: hazelcast-howea
  SPRING_PROFILES_ACTIVE: no_jobs,jpa,cache,external_jms,uaa
kind: ConfigMap

apiVersion: v1
data:
  hazelcast-networking.yaml: |
    hazelcast:
      cluster-name: hazelcast-howea
      instance-name: hazelcast-howea
      network:
        join:
          multicast:
            enabled: false
          kubernetes:
            enabled: true
            service-dns: [MY_HAZELCAST]
            service-port: 5701
kind: ConfigMap

apiVersion: apps/v1
kind: Deployment
metadata:
  labels:
    app.kubernetes.io/component: dpos
    app.kubernetes.io/instance: cdd-consumer
    app.kubernetes.io/managed-by: Helm
    app.kubernetes.io/name: howea-ci-cdd-consumer
    argocd.argoproj.io/instance: howea-ci-cdd-consumer
    helm.sh/chart: howea-ci-cdd-consumer-1.0.0
  name: cdd-consumer-howea-ci-cdd-consumer
  namespace: howea-ci
spec:
  replicas: 1
  selector:
    matchLabels:
      app.kubernetes.io/instance: cdd-consumer
      app.kubernetes.io/name: howea-ci-cdd-consumer
  template:
    metadata:
      labels:
        app.kubernetes.io/instance: cdd-consumer
        app.kubernetes.io/managed-by: Helm
        app.kubernetes.io/name: howea-ci-cdd-consumer
        helm.sh/chart: howea-ci-cdd-consumer-1.0.0
    spec:
      containers:
        - env:
            - name: SPRING_ARTEMIS_USER
              valueFrom:
                secretKeyRef:
                  key: artemis-admin-username
                  name: howea-cdd-consumer-artemis-credentials
            - name: SPRING_ARTEMIS_PASSWORD
              valueFrom:
                secretKeyRef:
                  key: artemis-admin-password
                  name: howea-cdd-consumer-artemis-credentials
            - name: SPRING_ARTEMIS_MODE
              value: NATIVE
            - name: SPRING_ARTEMIS_BROKER_URL
              value: tcp://[MY_ARTEMIS]
          envFrom:
            - configMapRef:
                name: howea-ci-cdd-consumer-standalone
          image: >-
            <INTERNAL_LINK>
          imagePullPolicy: IfNotPresent
          name: data-services-cdd-job
          ports:
            - containerPort: 8080
              name: http
          resources:
            limits:
              memory: 2Gi
            requests:
              cpu: 50m
              memory: 1Gi
          securityContext:
            readOnlyRootFilesystem: false
            runAsNonRoot: true
            runAsUser: 1000
          volumeMounts:
            - mountPath: /app/hazelcast-networking.yaml
              name: hazelcast-networking-config
              subPath: hazelcast-networking.yaml
            - mountPath: /opt/dpos-config
              name: dpos-config
      imagePullSecrets:
        - name: howea-ci-cdd-consumer-artifactory-credentials
      initContainers:
        - args:
            - '-c'
            - |
              #!/usr/bin/env bash
              set -Eeuo pipefail
              cp -rv /opt/dpos/config/. /mnt/dpos-config
          command:
            - /bin/sh
          image: >-
            [MY_MODELS_IMAGE]
          imagePullPolicy: Always
          name: solution-config
          volumeMounts:
            - mountPath: /mnt/dpos-config
              name: dpos-config
      securityContext:
        fsGroup: 1000
      volumes:
        - configMap:
            name: howea-ci-cdd-consumer-hazelcast
          name: hazelcast-networking-config
        - emptyDir: {}
          name: dpos-config

But I got this error during start up phase:

2025-09-23 09:57:48,880 [main                ][INFO ][org.quartz.impl.StdSchedulerFactory     ][u:] - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
2025-09-23 09:57:48,880 [main                ][INFO ][org.quartz.impl.StdSchedulerFactory     ][u:] - Quartz scheduler version: 2.3.2
2025-09-23 09:57:48,880 [main                ][INFO ][org.quartz.core.QuartzScheduler         ][u:] - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@66bd7737
2025-09-23 09:57:49,340 [main                ][INFO ][k.scheduling.quartz.SchedulerFactoryBean][u:] - Starting Quartz Scheduler now
2025-09-23 09:57:49,344 [main                ][INFO ][org.quartz.core.QuartzScheduler         ][u:] - Scheduler quartzScheduler_$_cdd-consumer-howea-ci-cdd-consumer-565c57bd85-7kw7m1758621468865 started.
2025-09-23 09:57:49,362 [main                ][INFO ][ion.backend.BackendAuthenticationService][u:] - Using user [superUser] for backend authentication with strategy [InheritableThreadLocalSecurityContextHolderStrategy]
2025-09-23 09:57:49,367 [main                ][INFO ][.initialization.BusinessModelInitializer][u:] - Importing business models: file:/opt/dpos-config/dposConfig/models
2025-09-23 09:57:49,932 [main                ][WARN ][rnate.engine.jdbc.spi.SqlExceptionHelper][u:] - SQL Error: 23506, SQLState: 23506
2025-09-23 09:57:49,933 [main                ][ERROR][rnate.engine.jdbc.spi.SqlExceptionHelper][u:] - Referential integrity constraint violation: "FK_MODEL_ANNOTATIONS_MODEL_ID: PUBLIC.MODEL_ANNOTATIONS FOREIGN KEY(MODEL_ID) REFERENCES PUBLIC.MODEL_HEADERS(ID) ('Contract_form')"; SQL statement:
insert into model_annotations (model_id,name,annotation_value) values (?,?,?) [23506-220]
2025-09-23 09:57:49,940 [main                ][WARN ][model.bulkload.BulkImportProblemReporter][u:] - Error while importing models
org.springframework.dao.DataIntegrityViolationException: could not execute statement [Referential integrity constraint violation: "FK_MODEL_ANNOTATIONS_MODEL_ID: PUBLIC.MODEL_ANNOTATIONS FOREIGN KEY(MODEL_ID) REFERENCES PUBLIC.MODEL_HEADERS(ID) ('Contract_form')"; SQL statement:
insert into model_annotations (model_id,name,annotation_value) values (?,?,?) [23506-220]] [insert into model_annotations (model_id,name,annotation_value) values (?,?,?)]; SQL [insert into model_annotations (model_id,name,annotation_value) values (?,?,?)]; constraint [K_MODEL_ANNOTATIONS_MODEL_ID]
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:290)
	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:241)
	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:550)
	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)
	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:335)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:160)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:165)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:223)
	at jdk.proxy2/jdk.proxy2.$Proxy183.existsById(Unknown Source)
	at com.mgmtp.a12.dataservices.model.persistence.internal.DefaultModelRepository.exists(DefaultModelRepository.java:77)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.mgmtp.a12.dataservices.model.persistence.internal.DefaultModelRepository$$SpringCGLIB$$0.exists(<generated>)
	at com.mgmtp.a12.dataservices.model.internal.DefaultModelService.exists(DefaultModelService.java:178)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.mgmtp.a12.dataservices.model.internal.DefaultModelService$$SpringCGLIB$$0.exists(<generated>)
	at com.mgmtp.a12.dataservices.model.bulkload.ModelBulkImporter.saveModel(ModelBulkImporter.java:201)
	at com.mgmtp.a12.dataservices.model.bulkload.ModelBulkImporter.persistModelsAndExtractDocumentModels(ModelBulkImporter.java:124)
	at com.mgmtp.a12.dataservices.model.bulkload.ModelBulkImporter.doImport(ModelBulkImporter.java:97)
	at com.mgmtp.a12.dataservices.initialization.BusinessModelInitializer.lambda$importBusinessModels$0(BusinessModelInitializer.java:53)
	at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Unknown Source)
	at java.base/java.util.stream.ReferencePipeline$Head.forEach(Unknown Source)
	at com.mgmtp.a12.dataservices.initialization.BusinessModelInitializer.importBusinessModels(BusinessModelInitializer.java:50)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.mgmtp.a12.dataservices.initialization.BusinessModelInitializer$$SpringCGLIB$$0.importBusinessModels(<generated>)
	at com.mgmtp.a12.dataservices.initialization.DataServicesInitializationService.importModelsConditionally(DataServicesInitializationService.java:125)
	at com.mgmtp.a12.dataservices.initialization.DataServicesInitializationService.lambda$runInitialization$0(DataServicesInitializationService.java:74)
	at com.mgmtp.a12.uaa.authentication.backend.BackendAuthenticationService.executeWithBackendAuthentication(BackendAuthenticationService.java:52)
	at com.mgmtp.a12.dataservices.initialization.DataServicesInitializationService.runInitialization(DataServicesInitializationService.java:63)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:768)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:720)
	at com.mgmtp.a12.dataservices.initialization.DataServicesInitializationService$$SpringCGLIB$$0.runInitialization(<generated>)
	at com.mgmtp.a12.dataservices.initialization.DataServicesInitializationListener.onApplicationInitialization(DataServicesInitializationListener.java:46)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.context.event.ApplicationListenerMethodAdapter.doInvoke(ApplicationListenerMethodAdapter.java:365)
	at org.springframework.context.event.ApplicationListenerMethodAdapter.processEvent(ApplicationListenerMethodAdapter.java:237)
	at org.springframework.context.event.ApplicationListenerMethodAdapter.onApplicationEvent(ApplicationListenerMethodAdapter.java:168)
	at com.mgmtp.a12.dataservices.events.internal.DataServicesListenerMethodAdapter.onApplicationEvent(DataServicesListenerMethodAdapter.java:45)
	at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:185)
	at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:178)
	at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:156)
	at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:452)
	at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:385)
	at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:993)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:628)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:754)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:456)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:335)
	at com.mgmtp.a12.dataservices.job.CddDirtyDocumentsJob.main(CddDirtyDocumentsJob.java:26)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:91)
	at org.springframework.boot.loader.launch.Launcher.launch(Launcher.java:53)
	at org.springframework.boot.loader.launch.JarLauncher.main(JarLauncher.java:58)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement [Referential integrity constraint violation: "FK_MODEL_ANNOTATIONS_MODEL_ID: PUBLIC.MODEL_ANNOTATIONS FOREIGN KEY(MODEL_ID) REFERENCES PUBLIC.MODEL_HEADERS(ID) ('Contract_form')"; SQL statement:
insert into model_annotations (model_id,name,annotation_value) values (?,?,?) [23506-220]] [insert into model_annotations (model_id,name,annotation_value) values (?,?,?)]
	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:62)
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:58)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:108)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
	at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.performNonBatchedMutation(AbstractMutationExecutor.java:134)
	at org.hibernate.engine.jdbc.mutation.internal.MutationExecutorSingleNonBatched.performNonBatchedOperations(MutationExecutorSingleNonBatched.java:55)
	at org.hibernate.engine.jdbc.mutation.internal.AbstractMutationExecutor.execute(AbstractMutationExecutor.java:55)
	at org.hibernate.persister.collection.mutation.InsertRowsCoordinatorStandard.insertRows(InsertRowsCoordinatorStandard.java:117)
	at org.hibernate.persister.collection.BasicCollectionPersister.insertRows(BasicCollectionPersister.java:125)
	at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:86)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:632)
	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:499)
	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:371)
	at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:66)
	at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:127)
	at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1375)
	at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$2(ConcreteSqmSelectQueryPlan.java:138)
	at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:382)
	at org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:302)
	at org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:526)
	at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:423)
	at org.hibernate.query.spi.AbstractSelectionQuery.getSingleResult(AbstractSelectionQuery.java:555)
	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.existsById(SimpleJpaRepository.java:367)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker$RepositoryFragmentMethodInvoker.lambda$new$0(RepositoryMethodInvoker.java:277)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.doInvoke(RepositoryMethodInvoker.java:170)
	at org.springframework.data.repository.core.support.RepositoryMethodInvoker.invoke(RepositoryMethodInvoker.java:158)
	at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:516)
	at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:285)
	at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:628)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.doInvoke(QueryExecutorMethodInterceptor.java:168)
	at org.springframework.data.repository.core.support.QueryExecutorMethodInterceptor.invoke(QueryExecutorMethodInterceptor.java:143)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:70)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:379)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:138)
	... 103 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: Referential integrity constraint violation: "FK_MODEL_ANNOTATIONS_MODEL_ID: PUBLIC.MODEL_ANNOTATIONS FOREIGN KEY(MODEL_ID) REFERENCES PUBLIC.MODEL_HEADERS(ID) ('Contract_form')"; SQL statement:
insert into model_annotations (model_id,name,annotation_value) values (?,?,?) [23506-220]

I’m very sure that the models are located at my volume mounted to the container, see:

I have no name!@cdd-consumer-howea-ci-cdd-consumer-c5bf99b8d-scvrm:/opt$ cd dpos-config/dposConfig/models/
I have no name!@cdd-consumer-howea-ci-cdd-consumer-c5bf99b8d-scvrm:/opt/dpos-config/dposConfig/models$ ls
bapMobility  bindingOverviews  common  NewTenderModelGraph.diagram  outputModels  overview  partner  relationships  uwGuidelines
I have no name!@cdd-consumer-howea-ci-cdd-consumer-c5bf99b8d-scvrm:/opt/dpos-config/dposConfig/models$ cd bapMobility/
I have no name!@cdd-consumer-howea-ci-cdd-consumer-c5bf99b8d-scvrm:/opt/dpos-config/dposConfig/models/bapMobility$ ls
ALD_PreviousInsurers.json  ContractCDM.json   Contract_form.json  CoverageData.json  RiskCriteria.json  Tender_form.json  TenderRequestAndSummary_form.json  TotalPremium.json
CoInsured.json             ContractData.json  Contract.json       FleetData.json     TenderCDM.json     Tender.json       TenderRequest.json                 UwGuidelines.json
I have no name!@cdd-consumer-howea-ci-cdd-consumer-c5bf99b8d-scvrm:/opt/dpos-config/dposConfig/models/bapMobility$

Do we need to import the models to CDD consumer application?
Do you have an idea about it? Is there any detail documentation about this mode?

Best Regards,
Nhat

2

Hi there,

I fixed this problem by using another approach:

  • I deployed the CDD consumer containers so that they will use the same persistence database as my Dataservices server.

Addtional fixes:

  • Using default profiles provided in the job jar: "consumer", "no_liquibase", "no_jobs", "external_jms", "uaa"
  • I have to exclude Quartz, don’t know why this is required :), SPRING_AUTOCONFIGURE_EXCLUDE: org.springframework.boot.autoconfigure.quartz.QuartzAutoConfiguration because the key spring.quartz.auto-startup=false in consumer profile doesn’t help. I got:
2025-09-24 03:26:39,691 [main                ][INFO ][org.quartz.core.QuartzScheduler         ][u:] - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'cdd-consumer-howea-ci-cdd-consumer-74c48cb978-vz7nt1758684399676'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.springframework.scheduling.quartz.LocalDataSourceJobStore' - which supports persistence. and is clustered.
2025-09-24 03:26:39,691 [main                ][INFO ][org.quartz.impl.StdSchedulerFactory     ][u:] - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
2025-09-24 03:26:39,691 [main                ][INFO ][org.quartz.impl.StdSchedulerFactory     ][u:] - Quartz scheduler version: 2.3.2
2025-09-24 03:26:39,692 [main                ][INFO ][org.quartz.core.QuartzScheduler         ][u:] - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@4261e7b
2025-09-24 03:26:39,741 [main                ][INFO ][org.quartz.core.QuartzScheduler         ][u:] - Scheduler quartzScheduler_$_cdd-consumer-howea-ci-cdd-consumer-74c48cb978-vz7nt1758684399676 shutting down.
2025-09-24 03:26:39,741 [main                ][INFO ][org.quartz.core.QuartzScheduler         ][u:] - Scheduler quartzScheduler_$_cdd-consumer-howea-ci-cdd-consumer-74c48cb978-vz7nt1758684399676 paused.
2025-09-24 03:26:40,178 [main                ][INFO ][org.quartz.core.QuartzScheduler         ][u:] - Scheduler quartzScheduler_$_cdd-consumer-howea-ci-cdd-consumer-74c48cb978-vz7nt1758684399676 shutdown complete.
2025-09-24 03:26:40,179 [main                ][WARN ][ation.AnnotationConfigApplicationContext][u:] - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in class path resource [org/springframework/boot/autoconfigure/quartz/QuartzAutoConfiguration.class]: Couldn't retrieve trigger: Bad value for type long : \xaced0005737200156f72672e71756172747a2e4a6f62446174614d61709fb083e8bfa9b0cb020000787200266f72672e71756172747a2e7574696c732e537472696e674b65794469727479466c61674d61708208e8c3fbc55d280200015a0013616c6c6f77735472616e7369656e74446174617872001d6f72672e71756172747a2e7574696c732e4469727479466c61674d617013e62ead28760ace0200025a000564697274794c00036d617074000f4c6a6176612f7574696c2f4d61703b787001737200116a6176612e7574696c2e486173684d61700507dac1c31660d103000246000a6c6f6164466163746f724900097468726573686f6c6478703f4000000000000c77080000001000000001740014726571756573744964457870697265486f757273737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000002d07800
2025-09-24 03:26:40,180 [main                ][INFO ][com.zaxxer.hikari.HikariDataSource      ][u:] - howea_dpos_ci - Shutdown initiated...
2025-09-24 03:26:40,645 [main                ][INFO ][com.zaxxer.hikari.HikariDataSource      ][u:] - howea_dpos_ci - Shutdown completed.
2025-09-24 03:26:40,660 [main                ][INFO ][a.LocalContainerEntityManagerFactoryBean][u:] - Closing JPA EntityManagerFactory for persistence unit 'dsPersistenceUnit'
2025-09-24 03:26:40,662 [main                ][WARN ][rnate.instance.IHazelcastInstanceFactory][u:] - hibernate.cache.hazelcast.shutdown_on_session_factory_close property is set to 'false'. Leaving current HazelcastInstance active! (Warning: Do not disable Hazelcast hazelcast.shutdownhook.enabled property!)
2025-09-24 03:26:40,840 [main                ][INFO ][.logging.ConditionEvaluationReportLogger][u:] -
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2025-09-24 03:26:40,856 [main                ][ERROR][g.springframework.boot.SpringApplication][u:] - Application run failed
  • Then, I need to switch to solrClient: MGMTP_A12_DATASERVICES_SEARCH_SERVICE: solrClient

Best regards,
N