With a subscription version of Talend MDM 5.2 using a Microsoft SQL Server 2005, you might encounter an exception when deploying a new data container. This error states that the RDBMS "Cannot find data type datetime2".
This issue only occurs with a subscription version of Talend MDM 5.2.x, using RDBMS persistence with Microsoft SQL Server 2005.
This error occurs when you deploy a data container bound to a data model using some "xsd:date" elements. Talend MDM tries to map it to the SQL Server type "datetime2", which exists only in SQL Server 2008.
The following message is shown to the user in the Studio, when deploying a new Data Container to Talend MDM.
On the server side, the following exception is added to the server.log file:
You can also use proprietary DDL to carry out the previous operations: