Errors found in the AllowMissingComponents SQL migration script for the recreation of the DSD/DF views
During the deployment of the dotstatsuiteNET@v7.0.0 to staging, there were some errors found in the logs of the automatic upgrade of the data database (dbup). The recreation of the views for some dataflows/DSDs failed.
- Space OECD-design: OECD.SDD:NAMAIN_TEST(1.0.0), OECD.SDD:NASEC_TEST(1.0.0), OECD.ECO:DF_EO_O(1.2.0) both errors occur
- Space OECD-staging: OECD.SDD:NAMAIN(1.0.0), OECD.SDD:NASEC(1.0.0), OECD.SDD:NASU(1.0.0), OECD.ECO:DF_EO_O(1.2.0) both errors occur.
- Space staging:SIS-CC-stable: Many dataflows are afected by the second error only.
There are two errors found in the logs
- "2021-06-14-01.AllowMissingComponents.sql":
"logger": "2021-06-14-01.AllowMissingComponents.sql",
"message": "The following error was found while trying to create the Views for the DSD [OECD.SDD:NAMAIN(1.0.0)] (The creation of the view will be skiped): ErrorNumber:105 ErrorMessage:Unclosed quotation mark after the character string 'CL_'.\n ",
"exception": "Unclosed quotation mark after the character string 'CL_'."
- "2021-08-25-02-RecreateDataFlowViewsAddSID.sql"
"logger": "2021-08-25-02-RecreateDataFlowViewsAddSID.sql",
"message": "The following error was found while trying to recreate the DataFlow Views for the Dataflow [OECD.ECO:DF_EO_O(1.2.0)] (The creation of the view will be skiped): ErrorNumber:208 ErrorMessage:Invalid object name 'data.VI_CurrentDataDsd_1_A'.\n ",
"exception": "Invalid object name 'data.VI_CurrentDataDsd_1_A'."
The second issue, might or might not be caused by the fail of the first script.
Logs files produced by the dbup.
Edited by Pedro Carranza