How to fix "Unable to execute DROP TABLE [sandbox].[sandbox].[cache_tracking]" when creating status and tracking tables.

The complete error in Studio is as follows:
"Unable to execute DROP TABLE [sandbox].[sandbox].[cache_tracking] in data source /shared/sandbox/de_database/DataSource/sqlserver_sandbox. SQL State = S0005 SQL Error Code = 3701 [data-3911071]" error.
Cause: Cannot drop the table 'demomsdb.dbo.cache_status', because it does not exist or you do not have permission.

Steps to generate this error:
1. Open the SQL Server 19 data source in the studio.
2. Click on 'Browse' for status and tracking tables.
3. In the Pop-up window, navigate to the data source and click on 'Create'.
4. The DDL should fail.

Note: This error only occurs if we set the Microsoft SQL Server Management Studio(2019) to 'Japanese'.

This article focuses on how to fix the 'DROP TABLE' error when running the DDL statement against the Microsoft SQL Server 2019 database

All supported OS

The issue occurs when trying to create cache_status and cache_tracking tables against a Microsoft SQL database with the user language set to 'Japanese' (or any non-alphabetic language) in Microsoft SQL Server Management Studio.

To resolve the issue, users need to add the following line to <TDV_INSTALL_DIR>/apps/dlm/cis_ds_mssql/conf/microsoft_sql_server_<year>.sqlserver.capabilities file.
jdbcds.ddl_drop_table_if_exists: true