ConnectALL automation with Universal Adapter throws Date Format Error
book
Article ID: 399908
calendar_today
Updated On:
Products
ConnectALLConnectAll On-Prem
Issue/Introduction
When running the automation with Universal Adapter, the automation fails to sync with Date Format Error below.
om.go2group.connectall.model.transformer.model.api.SearchForIssuesTransformer: Illegal pattern character 'T'
java.lang.IllegalArgumentException: Illegal pattern character 'T'
at java.base/java.text.SimpleDateFormat.compile(SimpleDateFormat.java:849) ~[?:?]
Environment
3.8.x
Cause
The issue is due to the incorrect Datetime format in the _descriptor.json file.
Resolution
Correct the _descriptor.json file to update datetime format FROM "dateTimeFormat": "yyyy-MM-dd'T'HH:mm:ss.SSSSSS’Z’" (the quotes around Z does not seemed to be right) TO yyyy-MM-dd'T'HH:mm:ss.SSSSSS'Z' and import the UA configuration.
OR Edit the UA and configuration to update dateTimeFormat value. See below.