Reporter, unable to create data source with external connections

[Fajfa]

https://forum.cortezaproject.org/t/reporter-unable-to-create-data-source/1533

[github-actions[bot]]

Stale issue message

[dcharpen]

Is there any other information needed for this issue to be worked?

[dcharpen]

Adding data here, from the forum post, so the description and repro steps are included with this issue.

Challenge: I am unable to create a data source in reporter for any module that is connected to a data source with an external connection. As in, the data source for the module is not the Primary database.

Steps to reproduce:

1. Navigate to Report builder
2. Open a report
3. Click Datasources
4. +Add -> Load
5. Source = Compose records
6. Namespace = Select option - The namespace I’m using is present
7. Module = The modules from that ns are listed.

When I select the module I receive an error:

• "Failed to describe datasource: model {0 0 map[moduleID:3487311123… namespaceID:348731234…]} does not exist”

The moduleID and namespaceID are correct for the ns and module selected and they do exist.

Database connection for modules are a MySQL db.

Originally reported for Corteza version 2023.3.4 but have verified the issue is still present in 2023.3.8

Versions tested: 2023.3.4, 2023.3.8

[dcharpen]

Confirmed this is still an issue in 2023.3.8

[dcharpen]

Is there some workaround for this issue?

Reporter not working at all for external connections seems important but understood it would be less important if there was a way to work around this issue.