Multiple Shared Dimension Issues: Hierarchy Creation, Viewing, and Publishing Failures (Test environment)

[timvonfelten]

Describe the bug
There are multiple issues related to shared dimensions in the Cube Creator in the test environment:

1. Unable to create a hierarchy: The selection of root dimensions works, but when trying to select the root element, there are no suggestions and no results when typing into the field. The server responds with a 414 (URI Too Long) error.
2. Shared Dimensions can be imported but not viewed: When attempting to display the entries, an "Error: URI Too Long" appears.
3. Cube Projects with linked Shared Dimensions cannot be published: Although they could be published in the past with the same configuration and data, the publication job now exits with a Connect Timeout Error, likely related to the shared dimension. Removing all links to shared dimensions allows the Cube Project to be published again.

Affected functionalities

• CSV Mapping
• Transformation
• Publishing
• Other (Shared Dimensions functionality)

Relevant links

• Test environment: test.cube-creator.lindas.admin.ch

To Reproduce Issue 1

1. Go to the test environment at test.cube-creator.lindas.admin.ch
2. Attempt to create a hierarchy
3. Select any root dimension
4. Attempt to select any root element

To Reproduce Issue 2

1. Go to the test environment at test.cube-creator.lindas.admin.ch
2. Attempt to view the elements of any shared dimension

To Reproduce Issue 3

1. Go to the test environment at test.cube-creator.lindas.admin.ch
2. Attempt to publish a cube project with a linked shared dimension

Expected behavior

1. Creating a hierarchy should work properly, with suggestions and results when selecting the root element.
2. Shared Dimensions should be viewable after import without any errors.
3. Cube Projects with linked Shared Dimensions should publish successfully, as they did in the past.

Versions:

• Cube-Creator version: 1.13.8 (5e6a9a6)
• OS: Windows 11
• Browser: Microsoft Edge for Business Version 129.0.1792.79
  
  

@Rdataflow

[timvonfelten]

Update
After switching to the INT environment and uploading several shared dimensions with .trig files the issue with the root selection No. 1 is now also present in the INT environment. Yesterday, I was still able to select a root element, however today I can't anymore on the same hierarchy as yesterday. Here are the shared dimensions that I imported. I'm not sure if it is related to my uploads, but it seems likely.

eudr_20241016_092405.txt
jahrbuch_20241016_092405.txt
jq2_20241016_092405.txt