LOCALIZED tables for countries missing

[maxstreifeneder]

CF Basic deployment worked out fine but once the application UI needs to be used: (step 3.4 "switch to the cicularity metrics on the assesements UI)

2024-09-02T15:40:52.95+0200 [APP/PROC/WEB/0] OUT {"level":"info","logger":"odata","correlation_id":"6ff9b314-e126-4e2f-4537-38ac5fb68697","tenant_id":"36a29521-73da-45e8-b826-24e5f2f6e4c3","timestamp":"2024-09-02T13:40:52.958Z","layer":"cds","component_type":"application","container_id":"10.32.3.6","component_id":"525379b1-e7d7-4557-a366-d2c96656af1f","component_name":"susaas-srv-dev","component_instance":0,"source_instance":0,"organization_name":"62a988c6trial","organization_id":"477c0c9d-3117-4d6a-9aa5-e6fb458d895e","space_name":"dev","space_id":"e8fb6f8d-376a-44b1-90d1-adc079c24690","msg":"> READ /Assessments(ID=fb640ed9-953d-4d7a-8c09-5ddbe4739b6b,IsActiveEntity=true)/circularityMetrics {\n  '$count': 'true',\n  '$select': 'HasActiveEntity,ID,IsActiveEntity,countryRecyclability_code,eoLRecyclability',\n  '$expand': 'countryRecyclability($select=code,name)',\n  '$skip': '0',\n  '$top': '10'\n}","type":"log"}
   2024-09-02T15:40:52.96+0200 [APP/PROC/WEB/0] ERR {"level":"error","logger":"cds","correlation_id":"6ff9b314-e126-4e2f-4537-38ac5fb68697","tenant_id":"36a29521-73da-45e8-b826-24e5f2f6e4c3","timestamp":"2024-09-02T13:40:52.969Z","msg":"invalid table name:  Could not find table/view LOCALIZED_PUBLICSERVICE_COUNTRIES in schema CB78E9EB2510436D9BF473193C704A6F: line 1 col 226 (at pos 225)","message":"invalid table name:  Could not find table/view LOCALIZED_PUBLICSERVICE_COUNTRIES in schema CB78E9EB2510436D9BF473193C704A6F: line 1 col 226 (at pos 225)","code":259,"sqlState":"HY000","position":0,"query":"SELECT T1.ID AS \"T1_ID\", T1.countryRecyclability_code AS \"T1_countryRecyclability_code\", T1.eoLRecyclability AS \"T1_eoLRecyclability\", b.code AS \"b_code\", b.name AS \"b_name\" FROM PublicService_CircularityMetrics T1 LEFT JOIN localized_PublicService_Countries b ON ( b.code = T1.countryRecyclability_code ) WHERE EXISTS ( SELECT 1 FROM PublicService_Assessments T0 WHERE T0.ID = ? AND ( T0.ID = T1.assessment_ID ) ) ORDER BY T1.ID ASC LIMIT 10 OFFSET ?  with parameters ('LOCALE' = 'en')","values":["***"],"layer":"cds","component_type":"application","container_id":"10.32.3.6","component_id":"525379b1-e7d7-4557-a366-d2c96656af1f","component_name":"susaas-srv-dev","component_instance":0,"source_instance":0,"organization_name":"62a988c6trial","organization_id":"477c0c9d-3117-4d6a-9aa5-e6fb458d895e","space_name":"dev","space_id":"e8fb6f8d-376a-44b1-90d1-adc079c24690","#cf":{"string":[{"k":"query","v":"SELECT T1.ID AS \"T1_ID\", T1.countryRecyclability_code AS \"T1_countryRecyclability_code\", T1.eoLRecyclability AS \"T1_eoLRecyclability\", b.code AS \"b_code\", b.name AS \"b_name\" FROM PublicService_CircularityMetrics T1 LEFT JOIN localized_PublicService_Countries b ON ( b.code = T1.countryRecyclability_code ) WHERE EXISTS ( SELECT 1 FROM PublicService_Assessments T0 WHERE T0.ID = ? AND ( T0.ID = T1.assessment_ID ) ) ORDER BY T1.ID ASC LIMIT 10 OFFSET ?  with parameters ('LOCALE' = 'en')","i":0}]},"type":"log"}
   2024-09-02T15:40:52.97+0200 [APP/PROC/WEB/0] ERR {"level":"error","logger":"error","correlation_id":"6ff9b314-e126-4e2f-4537-38ac5fb68697","tenant_id":"36a29521-73da-45e8-b826-24e5f2f6e4c3","timestamp":"2024-09-02T13:40:52.970Z","layer":"cds","component_type":"application","container_id":"10.32.3.6","component_id":"525379b1-e7d7-4557-a366-d2c96656af1f","component_name":"susaas-srv-dev","component_instance":0,"source_instance":0,"organization_name":"62a988c6trial","organization_id":"477c0c9d-3117-4d6a-9aa5-e6fb458d895e","space_name":"dev","space_id":"e8fb6f8d-376a-44b1-90d1-adc079c24690","msg":"500 > { code: '500', message: 'Internal Server Error' }","type":"log"}

reverse engineering:

• subscriber hdi container doesn't show any table/view in fact
• cds compile db -2 sql of the data model also doesn't bring up any localized table for that entity..