Database Migrations missing for image '2.3.7'

[yylian]

Current Behavior

When using the SDE image (tractusx/managed-simple-data-exchanger-backend:2.3.7) and visiting /provider/upload-history, the page fails to load. I tested this with both a completely new database and an existing one. While the migration appears to apply correctly, the log indicates that a column is missing.

The following is the complete log:

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::                (v3.1.6)

2024-06-03T12:18:25.181Z  INFO 1 --- [           main] o.eclipse.tractusx.sde.SdeApplication    : Starting SdeApplication v0.0.1 using Java 17.0.10 with PID 1 (/home/sdeuser/sdeapp/app.jar started by sdeuser in /home/sdeuser/sdeapp)
2024-06-03T12:18:25.185Z  INFO 1 --- [           main] o.eclipse.tractusx.sde.SdeApplication    : No active profile set, falling back to 1 default profile: "default"
2024-06-03T12:18:28.495Z  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2024-06-03T12:18:28.785Z  INFO 1 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 223 ms. Found 14 JPA repository interfaces.
2024-06-03T12:18:29.511Z  INFO 1 --- [           main] o.s.cloud.context.scope.GenericScope     : BeanFactory id=fff491bc-1e5f-3809-9e5e-cdde9f9493e7
2024-06-03T12:18:29.789Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.common.utils.ITokenUtilityProxy' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.791Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.portal.api.IPortalExternalServiceApi' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.793Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.portal.api.IPartnerPoolExternalServiceApi' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.854Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.edc.api.ContractApi' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.856Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.edc.api.ContractOfferCatalogApi' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.857Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.edc.api.EDRApiProxy' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.858Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.edc.api.EDCFeignClientApi' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.860Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.bpndiscovery.api.IBpndiscoveryExternalServiceApi' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.861Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.digitaltwins.gateways.external.EDCDigitalTwinProxyForLookUp' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.863Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.digitaltwins.gateways.external.DigitalTwinsFeignClient' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:29.864Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.eclipse.tractusx.sde.policyhub.api.IPolicyHubExternalServiceApi' of type [org.springframework.cloud.openfeign.FeignClientFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.269Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'methodSecurityConfig' of type [org.eclipse.tractusx.sde.configuration.role.MethodSecurityConfig$$SpringCGLIB$$0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.363Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpa.named-queries#0' of type [org.springframework.data.repository.config.PropertiesBasedNamedQueriesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.372Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpa.named-queries#0' of type [org.springframework.data.repository.core.support.PropertiesBasedNamedQueries] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.474Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.boot.autoconfigure.cache.CaffeineCacheConfiguration' of type [org.springframework.boot.autoconfigure.cache.CaffeineCacheConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.564Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.cloud.commons.config.CommonsConfigAutoConfiguration' of type [org.springframework.cloud.commons.config.CommonsConfigAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.580Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.cloud.client.loadbalancer.LoadBalancerDefaultMappingsProviderAutoConfiguration' of type [org.springframework.cloud.client.loadbalancer.LoadBalancerDefaultMappingsProviderAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.587Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'loadBalancerClientsDefaultsMappingsProvider' of type [org.springframework.cloud.client.loadbalancer.LoadBalancerDefaultMappingsProviderAutoConfiguration$$Lambda$529/0x00007f5cf5331968] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.652Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'defaultsBindHandlerAdvisor' of type [org.springframework.cloud.commons.config.DefaultsBindHandlerAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.671Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration' of type [org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.678Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'stringOrNumberMigrationVersionConverter' of type [org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration$StringOrNumberToMigrationVersionConverter] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.694Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'spring.cache-org.springframework.boot.autoconfigure.cache.CacheProperties' of type [org.springframework.boot.autoconfigure.cache.CacheProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.768Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration' of type [org.springframework.boot.autoconfigure.cache.CacheAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.776Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'cacheManagerCustomizers' of type [org.springframework.boot.autoconfigure.cache.CacheManagerCustomizers] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.789Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'cacheManager' of type [org.springframework.cache.caffeine.CaffeineCacheManager] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:30.860Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration$FlywayConfiguration' of type [org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration$FlywayConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.076Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'spring.flyway-org.springframework.boot.autoconfigure.flyway.FlywayProperties' of type [org.springframework.boot.autoconfigure.flyway.FlywayProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.095Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'flywayConnectionDetails' of type [org.springframework.boot.autoconfigure.flyway.FlywayAutoConfiguration$PropertiesFlywayConnectionDetails] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.164Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'resourceProviderCustomizer' of type [org.springframework.boot.autoconfigure.flyway.ResourceProviderCustomizer] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.189Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceConfiguration$Hikari] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.284Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'spring.datasource-org.springframework.boot.autoconfigure.jdbc.DataSourceProperties' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.354Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration$PooledDataSourceConfiguration' of type [org.springframework.boot.autoconfigure.jdbc.DataSourceAutoConfiguration$PooledDataSourceConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.363Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jdbcConnectionDetails' of type [org.springframework.boot.autoconfigure.jdbc.PropertiesJdbcConnectionDetails] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.656Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'dataSource' of type [com.zaxxer.hikari.HikariDataSource] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.765Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'flyway' of type [org.flywaydb.core.Flyway] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:31.778Z  INFO 1 --- [           main] o.f.c.internal.license.VersionPrinter    : Flyway Community Edition 9.16.3 by Redgate
2024-06-03T12:18:31.779Z  INFO 1 --- [           main] o.f.c.internal.license.VersionPrinter    : See release notes here: https://rd.gt/416ObMi
2024-06-03T12:18:31.779Z  INFO 1 --- [           main] o.f.c.internal.license.VersionPrinter    : 
2024-06-03T12:18:31.790Z  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2024-06-03T12:18:32.572Z  INFO 1 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Added connection org.postgresql.jdbc.PgConnection@37c2eacb
2024-06-03T12:18:32.576Z  INFO 1 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.
2024-06-03T12:18:32.595Z  INFO 1 --- [           main] o.f.c.i.database.base.BaseDatabaseType   : Database: jdbc:postgresql://cluster-stage-sovity-main.postgres.database.azure.com/sde-cofinity-preprod-01 (PostgreSQL 15.6)
2024-06-03T12:18:32.672Z  INFO 1 --- [           main] o.f.c.i.s.JdbcTableSchemaHistory         : Schema history table "public"."flyway_schema_history" does not exist yet
2024-06-03T12:18:32.677Z  INFO 1 --- [           main] o.f.core.internal.command.DbValidate     : Successfully validated 20 migrations (execution time 00:00.022s)
2024-06-03T12:18:32.757Z  INFO 1 --- [           main] o.f.c.i.s.JdbcTableSchemaHistory         : Creating Schema History table "public"."flyway_schema_history" ...
2024-06-03T12:18:32.875Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Current version of schema "public": << Empty Schema >>
2024-06-03T12:18:32.889Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "2 - Create auth table"
2024-06-03T12:18:33.059Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "3 - Create Tables"
2024-06-03T12:18:33.163Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "4 - Alter Tables"
2024-06-03T12:18:33.258Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "5 - Alter Tables"
2024-06-03T12:18:33.280Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "6 - Create Batch Table"
2024-06-03T12:18:33.360Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "7 - Drop Auth Table"
2024-06-03T12:18:33.382Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "8 - Alter Tables"
2024-06-03T12:18:33.457Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "9 - Create Contract Info Table"
2024-06-03T12:18:33.493Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "10 - Alter Tables"
2024-06-03T12:18:33.517Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "11 - Alter Tables"
2024-06-03T12:18:33.553Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "12 - Alter Tables"
2024-06-03T12:18:33.580Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "13 - Create role permission Tables"
2024-06-03T12:18:33.670Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "14 - Alter Tables"
2024-06-03T12:18:33.693Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "15 - Alter Tables"
2024-06-03T12:18:33.700Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "part_as_planned" does not exist, skipping
2024-06-03T12:18:33.701Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "part_site_information_as_planned" does not exist, skipping
2024-06-03T12:18:33.702Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "single_level_bom_as_planned" does not exist, skipping
2024-06-03T12:18:33.720Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "single_level_bom_as_planned" does not exist, skipping
2024-06-03T12:18:33.752Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "single_level_bom_as_planned" does not exist, skipping
2024-06-03T12:18:33.753Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "single_level_bom_as_planned" does not exist, skipping
2024-06-03T12:18:33.754Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "single_level_bom_as_planned" does not exist, skipping
2024-06-03T12:18:33.755Z  INFO 1 --- [           main] o.f.c.i.s.DefaultSqlScriptExecutor       : DB: relation "single_level_bom_as_planned" does not exist, skipping
2024-06-03T12:18:33.770Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "16 - Alter Tables"
2024-06-03T12:18:33.790Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "17 - Alter Tables"
2024-06-03T12:18:33.807Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "18 - Alter Tables"
2024-06-03T12:18:33.823Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "19 - Add Tables"
2024-06-03T12:18:33.856Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "20 - alter Contract Info Table"
2024-06-03T12:18:33.881Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Migrating schema "public" to version "21 - add new role"
2024-06-03T12:18:33.896Z  INFO 1 --- [           main] o.f.core.internal.command.DbMigrate      : Successfully applied 20 migrations to schema "public", now at version v21 (execution time 00:01.028s)
2024-06-03T12:18:33.906Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'flywayInitializer' of type [org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:33.915Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.boot.autoconfigure.sql.init.DataSourceInitializationConfiguration' of type [org.springframework.boot.autoconfigure.sql.init.DataSourceInitializationConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:33.983Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'spring.sql.init-org.springframework.boot.autoconfigure.sql.init.SqlInitializationProperties' of type [org.springframework.boot.autoconfigure.sql.init.SqlInitializationProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:33.992Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'dataSourceScriptDatabaseInitializer' of type [org.springframework.boot.autoconfigure.sql.init.SqlDataSourceScriptDatabaseInitializer] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.099Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'spring.jpa-org.springframework.boot.autoconfigure.orm.jpa.JpaProperties' of type [org.springframework.boot.autoconfigure.orm.jpa.JpaProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.153Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'eclipseLinkJpaConfiguration' of type [org.eclipse.tractusx.sde.configuration.EclipseLinkJpaConfiguration$$SpringCGLIB$$0] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.167Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpaVendorAdapter' of type [org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.173Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'entityManagerFactoryBuilder' of type [org.springframework.boot.orm.jpa.EntityManagerFactoryBuilder] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.189Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'persistenceManagedTypes' of type [org.springframework.orm.jpa.persistenceunit.SimplePersistenceManagedTypes] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.856Z  INFO 1 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'
2024-06-03T12:18:34.859Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'entityManagerFactory' of type [org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.870Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'entityManagerFactory' of type [jdk.proxy2.$Proxy93] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:34.887Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpaSharedEM_entityManagerFactory' of type [jdk.proxy2.$Proxy94] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[EL Info]: 2024-06-03 12:18:35.393--ServerSession(754592847)--EclipseLink, version: Eclipse Persistence Services - 3.0.3.v202208191135
2024-06-03T12:18:35.666Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpaMappingContext' of type [org.springframework.data.jpa.repository.config.JpaMetamodelMappingContextFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:35.671Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpaMappingContext' of type [org.springframework.data.jpa.mapping.JpaMetamodelMappingContext] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:35.989Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'roleRepository' of type [org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:36.058Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'roleRepository' of type [jdk.proxy2.$Proxy103] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:36.083Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpa.named-queries#5' of type [org.springframework.data.repository.config.PropertiesBasedNamedQueriesFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:36.086Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpa.named-queries#5' of type [org.springframework.data.repository.core.support.PropertiesBasedNamedQueries] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:36.268Z  INFO 1 --- [           main] o.s.d.j.r.query.QueryEnhancerFactory     : Hibernate is in classpath; If applicable, HQL parser will be used.
2024-06-03T12:18:36.952Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'rolePermissionRepository' of type [org.springframework.data.jpa.repository.support.JpaRepositoryFactoryBean] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:36.958Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'rolePermissionRepository' of type [jdk.proxy2.$Proxy109] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:36.976Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'jpaSharedEM_AWC_entityManagerFactory' of type [jdk.proxy2.$Proxy94] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:36.982Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'rolePermissionCustomRepository' of type [org.eclipse.tractusx.sde.core.role.repository.RolePermissionCustomRepository] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:37.059Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'roleManagementService' of type [org.eclipse.tractusx.sde.core.service.RoleManagementService] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:37.068Z  INFO 1 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'createExpressionHandler' of type [org.springframework.security.access.expression.method.DefaultMethodSecurityExpressionHandler] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2024-06-03T12:18:37.756Z  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2024-06-03T12:18:37.764Z  INFO 1 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2024-06-03T12:18:37.765Z  INFO 1 --- [           main] o.apache.catalina.core.StandardEngine    : Starting Servlet engine: [Apache Tomcat/10.1.16]
2024-06-03T12:18:37.876Z  INFO 1 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/api]    : Initializing Spring embedded WebApplicationContext
2024-06-03T12:18:37.877Z  INFO 1 --- [           main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 12508 ms
2024-06-03T12:18:40.260Z  INFO 1 --- [           main] o.e.t.s.c.DigitalTwinAssetProvider       : Digital twin asset exists in edc connector, so ignoring asset creation
... (Submodel creation left out due to github char restriction)
2024-06-03T12:18:45.564Z  INFO 1 --- [           main] o.s.s.web.DefaultSecurityFilterChain     : Will secure any request with [org.springframework.security.web.session.DisableEncodeUrlFilter@4de91056, org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@2404abe2, org.springframework.security.web.context.SecurityContextHolderFilter@7019d619, org.springframework.security.web.header.HeaderWriterFilter@55638165, org.springframework.web.filter.CorsFilter@16cf7fd0, org.springframework.security.web.authentication.logout.LogoutFilter@7b4b8199, org.springframework.security.oauth2.server.resource.web.authentication.BearerTokenAuthenticationFilter@17d76ebb, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@ff1f465, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@31f7eb8, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@7bc2bb58, org.springframework.security.web.session.SessionManagementFilter@377dbc50, org.springframework.security.web.access.ExceptionTranslationFilter@df7d1d4, org.springframework.security.web.access.intercept.AuthorizationFilter@3d71e10b]
2024-06-03T12:18:46.376Z  INFO 1 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path '/api'
2024-06-03T12:18:46.390Z  INFO 1 --- [           main] o.eclipse.tractusx.sde.SdeApplication    : Started SdeApplication in 23.409 seconds (process running for 24.613)
2024-06-03T12:18:46.394Z  INFO 1 --- [   scheduling-1] .p.u.MemberCompanyBPNCacheUtilityService : All member companies BPN cache removed
2024-06-03T12:18:50.789Z  INFO 1 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/api]    : Initializing Spring DispatcherServlet 'dispatcherServlet'
2024-06-03T12:18:50.789Z  INFO 1 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
2024-06-03T12:18:50.791Z  INFO 1 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 2 ms
2024-06-03T12:18:50.806Z  WARN 1 --- [nio-8080-exec-1] o.s.w.s.h.HandlerMappingIntrospector     : Cache miss for REQUEST dispatch to '/api/ping' (previous null). Performing MatchableHandlerMapping lookup. This is logged once only at WARN level, and every time at TRACE.
[EL Warning]: 2024-06-03 12:19:05.986--UnitOfWork(695498237)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 3.0.3.v202208191135): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "access_policies" does not exist
  Position: 20
Error Code: 0
Call: SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC
Query: ReadAllQuery(referenceClass=ProcessReportEntity sql="SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC")
2024-06-03T12:19:05.991Z ERROR 1 --- [nio-8080-exec-7] .e.t.s.c.e.GlobalDefaultExceptionHandler : Internal server error Exception [EclipseLink-4002] (Eclipse Persistence Services - 3.0.3.v202208191135): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "access_policies" does not exist
  Position: 20
Error Code: 0
Call: SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC
Query: ReadAllQuery(referenceClass=ProcessReportEntity sql="SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC")
[EL Warning]: 2024-06-03 12:19:24.062--UnitOfWork(1712547110)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 3.0.3.v202208191135): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "access_policies" does not exist
  Position: 20
Error Code: 0
Call: SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC
Query: ReadAllQuery(referenceClass=ProcessReportEntity sql="SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC")
2024-06-03T12:19:24.062Z ERROR 1 --- [nio-8080-exec-7] .e.t.s.c.e.GlobalDefaultExceptionHandler : Internal server error Exception [EclipseLink-4002] (Eclipse Persistence Services - 3.0.3.v202208191135): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "access_policies" does not exist
  Position: 20
Error Code: 0
Call: SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC
Query: ReadAllQuery(referenceClass=ProcessReportEntity sql="SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC")
[EL Warning]: 2024-06-03 12:19:31.881--UnitOfWork(1736524358)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 3.0.3.v202208191135): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "access_policies" does not exist
  Position: 20
Error Code: 0
Call: SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC
Query: ReadAllQuery(referenceClass=ProcessReportEntity sql="SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC")
2024-06-03T12:19:31.881Z ERROR 1 --- [nio-8080-exec-2] .e.t.s.c.e.GlobalDefaultExceptionHandler : Internal server error Exception [EclipseLink-4002] (Eclipse Persistence Services - 3.0.3.v202208191135): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: org.postgresql.util.PSQLException: ERROR: column "access_policies" does not exist
  Position: 20
Error Code: 0
Call: SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC
Query: ReadAllQuery(referenceClass=ProcessReportEntity sql="SELECT process_id, access_policies, csv_type, end_date, number_of_deleted_items, number_of_failed_items, number_of_items, number_of_succeeded_items, number_of_updated_items, policy_uuid, reference_process_id, start_date, status, usage_policies FROM process_report ORDER BY start_date DESC, start_date DESC")
2024-06-03T12:19:38.356Z ERROR 1 --- [nio-8080-exec-9] .e.t.s.c.e.GlobalDefaultExceptionHandler : Internal server error Cannot invoke "java.util.Map.get(Object)" because the return value of "org.eclipse.tractusx.sde.edc.entities.request.policies.PermissionRequest.getConstraint()" is null
2024-06-03T12:19:43.578Z ERROR 1 --- [nio-8080-exec-1] .e.t.s.c.e.GlobalDefaultExceptionHandler : Internal server error Cannot invoke "java.util.Map.get(Object)" because the return value of "org.eclipse.tractusx.sde.edc.entities.request.policies.PermissionRequest.getConstraint()" is null

Expected Behavior

To show the history as expected.

Steps To Reproduce

Run the SDE image (tractusx/managed-simple-data-exchanger-backend:2.3.7) and use anything that has something to do with the policy hub, see errors in log.

[adityagajbhiye9]

fix release v2.3.8,closing the issue.