Driver Compatibility with SQL SERVER 2012 database for 9.0.1

Driver Compatibility with SQL SERVER 2012 database for 9.0.1

book

Article ID: KB0081367

calendar_today

Updated On:

Products Versions
TIBCO MDM 9.0.1

Description

When we are trying to query records present in a repository,created via import or via webservice, the query web service is behaving in inconsistent manner.

For the first query call , it gives below error.

"DEBUG com.tibco.mdm.integration.webservice.dataservice.CatalogRecordServiceBroker - CRSB: failedĀ 
<MqException: BEGIN>
Code: GEN-7093: Fatal error during parsing of string as timestamp. Input timestamp string is = 2018-04-18 00:58:21 and Timestamp Format is :yyyy-MM-dd HH:mm:ss.S"

For the same request,If we query again it will give proper response.

Issue/Introduction

While querying a record through SOAP UI for a repository which has added through web service or import requests is behaving in inconsistent manner

Environment

MDM 9.0.1 + SQL SERVR 2012

Resolution

Replacing the driver sqljdbc4.jar has resolved the issue.