How to work with UNIQUEIDENTIFIER columns in TIBCO Data Virtualization?
Article ID: KB0072402
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All Supported Versions |
Description
When a user tries to query a table that contains a UNIQUEIDENTIFIER column and the data source(MSSQL) is configured to be used with the BCP (Bulk Copy Program) utility, the following error may be encountered:
Screenshot for reference-
The reason for coming across this error is that the native data type is not supported for insert/update operations in TDV.
Screenshot for reference-
The reason for coming across this error is that the native data type is not supported for insert/update operations in TDV.
Issue/Introduction
This article summarizes the steps to be followed to work with UNIQUEIDENTIFIER columns in TIBCO Data Virtualization,
Environment
All Supported OS
Resolution
To work around this issue, the user will have to follow the steps given below:
1. Navigate to the capabilities file for the data source.
<TDV_Install_Dir>\apps\dlm\cis_ds_mssql\conf\sqlserver.capabilities
Note: The above location provided is to the capabilities file for a SQL Server data source.
2. Comment or remove the line:
3. Restart the TDV server
Now, the user should be able to query the tables and retrieve the results successfully.
1. Navigate to the capabilities file for the data source.
<TDV_Install_Dir>\apps\dlm\cis_ds_mssql\conf\sqlserver.capabilities
Note: The above location provided is to the capabilities file for a SQL Server data source.
2. Comment or remove the line:
jdbcds.update_not_supported_native_datatype: UNIQUEIDENTIFIER
3. Restart the TDV server
Now, the user should be able to query the tables and retrieve the results successfully.
Feedback
Yes
No
Powered by
