Query Record Palette with Timestamp attribute
Article ID: KB0078308
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM | 9.0.1 and 9.1.0 |
Description
While Querying a Record of MDM From Tibco Business Works using Query Record Palette with timestamp attribute it may give an error as "SVC-11023: Invalid value '2019-03-29 2:23:36.626 GMT' specified for attribute of type 'timestamp', repository 'XXXXX'.
Issue/Introduction
Query Record activity with Timestamp Value from Tibco BW 5.13 to Tibco MDM via plugin
Environment
ALL
Resolution
This issue occurs,If the timestamp format of User account on MDM WebUI is set to YYYY-MM-DD HH-mm-ss.S or YYYY-MM-DD HH-mm-ss.S AM/PM, or YYYY-MM-DD HH-mm-ss.S AM/PM z.BW Plugin for MDM (5.x and 1.0 or 2.0) supports only YYYY-MM-DD HH:mm:ss.Sz format for Timestamp attributes to add/modify/Query records.
To resolve this issue,We need to set Timestamp Format as YYYY-MM-DD HH:mm:ss.Sz in user profile of MDM user accounts.
To resolve this issue,We need to set Timestamp Format as YYYY-MM-DD HH:mm:ss.Sz in user profile of MDM user accounts.
Additional Information
https://docs.tibco.com/pub/activematrix_businessworks_plugin_for_mdm/2.0.0/TIB_bwpluginmdm_2.0.0_relnotes.pdf,01731876
Feedback
Yes
No
Powered by
