PSQLException when trying to access Management API

[scode-cpu]

Hi
I am working on tractusx-connector. I consider this Readme file for reference: https://github.com/eclipse-tractusx/tractusx-edc/tree/main/charts/tractusx-connector. As mentioned here, I entered client-secret, private-key, and public-key inside HashiCorp Vault. Then I configure chart with

• iatp.sts.oauth.token_url: the token endpoint of DIM
• iatp.sts.oauth.client.id: the client ID of your tenant in DIM
• iatp.sts.oauth.client.secret_alias: alias under which you saved your DIM client secret in the vault
• iatp.sts.dim.url: the base URL for DIM
• controlplane.bdrs.server.url: base URL of the BPN-DID Resolution Service ("BDRS")

After that I install the helm chart with new name space. And the deployment works completely fine (STATUS:deployed). I also checked the pods, and I can see four pods:

1. postgress pod
2. control plane pod
3. data plane pod
4. vault pod

All four pods are running. I checked the logs for control pod, and it looks fine.

Now I am trying to access management api. I checked on which port management api is working, then I did port forwarding and tried to access management api via curl. But I got 404 error.

Then I again checked the log for control plan pod. But it gives me error:
SEVERE 2024-09-13T00:04:56.936960005 JerseyExtension: Unexpected exception caught org.eclipse.edc.spi.persistence.EdcPersistenceException: org.postgresql.util.PSQLException: ERROR: relation "edc_data_plane_instance" does not exist Position: 15 at org.eclipse.edc.sql.SqlQueryExecutor.query(SqlQueryExecutor.java:97) at org.eclipse.edc.sql.SqlQueryExecutor.single(SqlQueryExecutor.java:65) at org.eclipse.edc.connector.dataplane.selector.store.sql.SqlDataPlaneInstanceStore.findByIdInternal(SqlDataPlaneInstanceStore.java:205) at org.eclipse.edc.connector.dataplane.selector.store.sql.SqlDataPlaneInstanceStore.lambda$save$7(SqlDataPlaneInstanceStore.java:178) at org.eclipse.edc.transaction.local.LocalTransactionContext.lambda$execute$0(LocalTransactionContext.java:57) at org.eclipse.edc.transaction.local.LocalTransactionContext.execute(LocalTransactionContext.java:74) at org.eclipse.edc.transaction.local.LocalTransactionContext.execute(LocalTransactionContext.java:56) at org.eclipse.edc.connector.dataplane.selector.store.sql.SqlDataPlaneInstanceStore.save(SqlDataPlaneInstanceStore.java:176) at org.eclipse.edc.connector.dataplane.selector.store.sql.SqlDataPlaneInstanceStore.save(SqlDataPlaneInstanceStore.java:48) at org.eclipse.edc.connector.dataplane.selector.service.EmbeddedDataPlaneSelectorService.lambda$addInstance$4(EmbeddedDataPlaneSelectorService.java:77) at org.eclipse.edc.transaction.local.LocalTransactionContext.execute(LocalTransactionContext.java:74) at org.eclipse.edc.connector.dataplane.selector.service.EmbeddedDataPlaneSelectorService.addInstance(EmbeddedDataPlaneSelectorService.java:75) at org.eclipse.edc.connector.dataplane.selector.control.api.DataplaneSelectorControlApiController.registerDataplane(DataplaneSelectorControlApiController.java:71) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(Unknown Source) at java.base/java.lang.reflect.Method.invoke(Unknown Source) at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)

So it seem that something went wrong with postgresql installation. Can anyone please help me in this situation?

[scode-cpu]

Hi.

To solve this problem we made some manual changes to the deployment-controlplane.yaml and deployment-dataplane.yaml files.

Specifically, we modified the following things:

deployment-controlplane.yaml:

# ASSET datasource
            - name: "EDC_DATASOURCE_ASSET_NAME"
              value: {{ .Values.asset.auth.name | required ".Values.asset.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_ASSET_USER"
              value: {{ .Values.asset.auth.username | required ".Values.asset.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_ASSET_PASSWORD"
              value: {{ .Values.asset.auth.password | required ".Values.asset.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_ASSET_URL"
              value: {{ tpl .Values.asset.jdbcUrl . | quote }}
 
            # CONTRACTDEFINITION datasource
            - name: "EDC_DATASOURCE_CONTRACTDEFINITION_NAME"
              value: {{ .Values.contractdefinition.auth.name | required ".Values.contractdefinition.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_CONTRACTDEFINITION_USER"
              value: {{ .Values.contractdefinition.auth.username | required ".Values.contractdefinition.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_CONTRACTDEFINITION_PASSWORD"
              value: {{ .Values.contractdefinition.auth.password | required ".Values.contractdefinition.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_CONTRACTDEFINITION_URL"
              value: {{ tpl .Values.contractdefinition.jdbcUrl . | quote }}
 
            # CONTRACTNEGOTIATION datasource
            - name: "EDC_DATASOURCE_CONTRACTNEGOTIATION_NAME"
              value: {{ .Values.contractnegotiation.auth.name | required ".Values.contractnegotiation.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_CONTRACTNEGOTIATION_USER"
              value: {{ .Values.contractnegotiation.auth.username | required ".Values.contractnegotiation.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_CONTRACTNEGOTIATION_PASSWORD"
              value: {{ .Values.contractnegotiation.auth.password | required ".Values.contractnegotiation.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_CONTRACTNEGOTIATION_URL"
              value: {{ tpl .Values.contractnegotiation.jdbcUrl . | quote }}
 
            # POLICY datasource
            - name: "EDC_DATASOURCE_POLICY_NAME"
              value: {{ .Values.policy.auth.name | required ".Values.policy.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_POLICY_USER"
              value: {{ .Values.policy.auth.username | required ".Values.policy.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_POLICY_PASSWORD"
              value: {{ .Values.policy.auth.password | required ".Values.policy.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_POLICY_URL"
              value: {{ tpl .Values.policy.jdbcUrl . | quote }}
 
            # TRANSFERPROCESS datasource
            - name: "EDC_DATASOURCE_TRANSFERPROCESS_NAME"
              value: {{ .Values.transferprocess.auth.name | required ".Values.transferprocess.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_TRANSFERPROCESS_USER"
              value: {{ .Values.transferprocess.auth.username | required ".Values.transferprocess.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_TRANSFERPROCESS_PASSWORD"
              value: {{ .Values.transferprocess.auth.password | required ".Values.transferprocess.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_TRANSFERPROCESS_URL"
              value: {{ tpl .Values.transferprocess.jdbcUrl . | quote }}
 
            # POLICY_MONITOR datasource
            - name: "EDC_DATASOURCE_POLICY-MONITOR_NAME"
              value: {{ .Values.policy_monitor.auth.name | required ".Values.policy_monitor.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_POLICY-MONITOR_USER"
              value: {{ .Values.policy_monitor.auth.username | required ".Values.policy_monitor.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_POLICY-MONITOR_PASSWORD"
              value: {{ .Values.policy_monitor.auth.password | required ".Values.policy_monitor.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_POLICY-MONITOR_URL"
              value: {{ tpl .Values.policy_monitor.jdbcUrl . | quote }}
 
            # BPN datasource
            - name: "EDC_DATASOURCE_BPN_NAME"
              value: {{ .Values.bpn.auth.name | required ".Values.bpn.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_BPN_USER"
              value: {{ .Values.bpn.auth.username | required ".Values.bpn.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_BPN_PASSWORD"
              value: {{ .Values.bpn.auth.password | required ".Values.bpn.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_BPN_URL"
              value: {{ tpl .Values.bpn.jdbcUrl . | quote }}
 
            # EDR datasource
            - name: "EDC_DATASOURCE_EDR_NAME"
              value: {{ .Values.edr.auth.name | required ".Values.edr.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_EDR_USER"
              value: {{ .Values.edr.auth.username | required ".Values.edr.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_EDR_PASSWORD"
              value: {{ .Values.edr.auth.password | required ".Values.edr.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_EDR_URL"
              value: {{ tpl .Values.edr.jdbcUrl . | quote }}
 
            # POLICYMONITORMANAGERIMPL datasource
            - name: "EDC_DATASOURCE_POLICYMONITORMANAGERIMPL_NAME"
              value: {{ .Values.policymonitormanagerimpl.auth.name | required ".Values.policymonitormanagerimpl.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_POLICYMONITORMANAGERIMPL_USER"
              value: {{ .Values.policymonitormanagerimpl.auth.username | required ".Values.policymonitormanagerimpl.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_POLICYMONITORMANAGERIMPL_PASSWORD"
              value: {{ .Values.policymonitormanagerimpl.auth.password | required ".Values.policymonitormanagerimpl.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_POLICYMONITORMANAGERIMPL_URL"
              value: {{ tpl .Values.policymonitormanagerimpl.jdbcUrl . | quote }}
 
            # DATAPLANESELECTORMANAGERIMPL datasource
            - name: "EDC_DATASOURCE_DATAPLANESELECTORMANAGERIMPL_NAME"
              value: {{ .Values.dataplaneselectormanagerimpl.auth.name | required ".Values.dataplaneselectormanagerimpl.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANESELECTORMANAGERIMPL_USER"
              value: {{ .Values.dataplaneselectormanagerimpl.auth.username | required ".Values.dataplaneselectormanagerimpl.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANESELECTORMANAGERIMPL_PASSWORD"
              value: {{ .Values.dataplaneselectormanagerimpl.auth.password | required ".Values.dataplaneselectormanagerimpl.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANESELECTORMANAGERIMPL_URL"
              value: {{ tpl .Values.dataplaneselectormanagerimpl.jdbcUrl . | quote }}
 
            # DATAPLANEINSTANCE datasource
            - name: "EDC_DATASOURCE_DATAPLANEINSTANCE_NAME"
              value: {{ .Values.dataplaneinstance.auth.name | required ".Values.dataplaneinstance.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANEINSTANCE_USER"
              value: {{ .Values.dataplaneinstance.auth.username | required ".Values.dataplaneinstance.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANEINSTANCE_PASSWORD"
              value: {{ .Values.dataplaneinstance.auth.password | required ".Values.dataplaneinstance.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANEINSTANCE_URL"
              value: {{ tpl .Values.dataplaneinstance.jdbcUrl . | quote }}

deployment-dataplane.yaml:

# EDR datasource
            - name: "EDC_DATASOURCE_EDR_NAME"
              value: {{ .Values.edr.auth.name | required ".Values.edr.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_EDR_USER"
              value: {{ .Values.edr.auth.username | required ".Values.edr.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_EDR_PASSWORD"
              value: {{ .Values.edr.auth.password | required ".Values.edr.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_EDR_URL"
              value: {{ tpl .Values.edr.jdbcUrl . | quote }}
 
            # DATAPLANE datasource
            - name: "EDC_DATASOURCE_DATAPLANE_NAME"
              value: {{ .Values.dataplane.auth.name | required ".Values.dataplane.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANE_USER"
              value: {{ .Values.dataplane.auth.username | required ".Values.dataplane.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANE_PASSWORD"
              value: {{ .Values.dataplane.auth.password | required ".Values.dataplane.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANE_URL"
              value: {{ tpl .Values.dataplane.jdbcUrl . | quote }}
 
            # ACCESSTOKENDATA datasource
            - name: "EDC_DATASOURCE_ACCESSTOKENDATA_NAME"
              value: {{ .Values.accesstokendata.auth.name | required ".Values.accesstokendata.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_ACCESSTOKENDATA_USER"
              value: {{ .Values.accesstokendata.auth.username | required ".Values.accesstokendata.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_ACCESSTOKENDATA_PASSWORD"
              value: {{ .Values.accesstokendata.auth.password | required ".Values.accesstokendata.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_ACCESSTOKENDATA_URL"
              value: {{ tpl .Values.accesstokendata.jdbcUrl . | quote }}
 
            # DATAPLANEMANAGERIMPL datasource
            - name: "EDC_DATASOURCE_DATAPLANEMANAGERIMPL_NAME"
              value: {{ .Values.dataplanemanagerimpl.auth.name | required ".Values.dataplanemanagerimpl.auth.name is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANEMANAGERIMPL_USER"
              value: {{ .Values.dataplanemanagerimpl.auth.username | required ".Values.dataplanemanagerimpl.auth.username is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANEMANAGERIMPL_PASSWORD"
              value: {{ .Values.dataplanemanagerimpl.auth.password | required ".Values.dataplanemanagerimpl.auth.password is required" | quote }}
            - name: "EDC_DATASOURCE_DATAPLANEMANAGERIMPL_URL"
              value: {{ tpl .Values.dataplanemanagerimpl.jdbcUrl . | quote }}