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.
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.
Issue/Introduction
This article summarizes the steps to be followed to work with UNIQUEIDENTIFIER columns in TIBCO Data Virtualization,
Feedback
Yes
No
Powered by
