How to resolve TIBCO Data Virtualization cache error:"Unable to execute DROP TABLE" when executing DDL when setting external cache for Microsoft SQL Server 2019?
Article ID: KB0071427
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
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'.
Environment
Resolution
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
Issue/Introduction
Feedback
