"Error executing generated SQL and populating SDMX model" when visualizing data for content constraint on attribute against ref metadata query - SDMXRI-1935 - NSI WS v8.12.1
The same symptomps as described in #86 (closed) can be experienced in OECD-staging after the recent deployment.
I cannot visualise the page after having deleted and re-uploaded the DSD and data: https://de-demo-oecd.siscc.org/vis?lc=en&df[ds]=OECD-staging&df[id]=FDI_DSD%40FDI_FLOW_IND&df[ag]=OECD.DAF.INV&df[vs]=1.0&av=true&pd=2020%2C&dq=ISR..USD_EXC......W...A&vw=tb
DE says "Whoops, something went wrong on our side. We are working to solve this. Please try again later.", the query error says "Error executing generated SQL and populating SDMX model"
Strangely when you open the data query URL https://nsi-demo-oecd-staging.siscc.org/rest/data/OECD.DAF.INV,FDI_DSD@FDI_FLOW_IND,1.0/ISR..USD_EXC......W...A?startPeriod=2020&dimensionAtObservation=AllDimensions in the browser, it will return the data. Is it only the JSON query issue?
Might it be related to the fact that I have added a reference to MSD from a DSD that was not there before?
Related ticket at ESTAT: SDMXRI-1935