Data query returns "Error executing generated SQL and populating SDMX model"
Many dataflows in OECD staging recently (within the last week) stopped displaying data in the visualisation table as the NSI WS behind returns the error "Error executing generated SQL and populating SDMX model".
For example:
- http://nsi-staging-oecd.redpelicans.com/rest/data/OECD.ECO,DF_EO_O,1.1/all
- http://nsi-staging-oecd.redpelicans.com/rest/data/OECD.ECO,DF_EO_O,1.2/AU...A?startPeriod=2012&endPeriod=2020&dimensionAtObservation=AllDimensions
The issue disappears when data is re-uploaded to the dataflow. Might be related to the recent updated of the NSI WS or running the "cleanup orphans" against the data in the design and staging spaces?
The issue also occurs in other .Stat instances: https://data.un.org/WS_TEST/rest/data/WB,DF_UNDATA_WDI,1.0/all