Metadata table migration of DSDs having uncoded dimension fails
After the execution of the fixed DbUp script, the following tables were spotted in the database with the old name format:
META_9480_A_DF META_9480_B_DF META_9480_A META_9480_B
It turned out that the tables of the related DSD (9480 - OECD.CTP.TPS:DSD_TAX_REV(1.0)) were deleted on 20th Oct, after the release of the related change. This first version was not able to properly migrate the metadata tables to the new name format, however the transfer service already started using the new table names, including the new metadata table name format. As a result, the cleanup attempted to cleanup the metadata tables with the new names and did not touch the tables with the old name. At the end the cleanup of DSD was successful, just without removing the meta table with the old names. This issue is a direct consequence of the bug in the migration script and cannot occur on any other installation after the fix on the related DbUp script was applied in this ticket.