Indexer, Frame of Reference, DateTime conversion
Can you please share a working example of DataTime conversion?
Load manifest (JSON) showing actual data and also matching "meta" block for a date field.
I tried the following in Load Manifest (AWS R3M8 Preship environment) -
Data has this line -
"ProjectEndDate": "2008-02-01T14:00:00.000+03:00",
Meta block has this for DateTime conversion -
{
"kind": "DateTime",
"name": "UTC-ISO8601",
"persistableReference": "{\"format\":\"yyyy-MM-ddTHH:mm:ss.fffZ\",\"timeZone\":\"UTC\",\"type\":\"DTM\"}",
"propertyNames": [
"ProjectEndDate ]
}
I see this error when I query for troubleshooting (Search service) .
For now, we can simply discuss problem of DateTime conversion.
{
"kind": "osdu:wks:master-data--SeismicAcquisitionSurvey:1.0.0",
"query": "id: \"osdu:master-data--SeismicAcquisitionSurvey:ST0202R08-DC-23Oct\"",
"returnedFields": [
"id",
"index"
]
}
Response
{
"results": [
{
"index": {
"trace": [
"Unit conversion: persistableReference not valid",
"Unit conversion: persistableReference not valid",
"DateTime conversion: Frame of reference does not match given data for property ProjectEndDate, no conversion applied."
],
"statusCode": 400,
"lastUpdateTime": "2021-10-23T10:13:21.496Z"
},
"id": "osdu:master-data--SeismicAcquisitionSurvey:ST0202R08-DC-23Oct"
}
],
"totalCount": 1
}
Thanks for your help.
cc - @gehrmann for information
cc - @jingdongsun , @anujgupta and @shamazum (since some work was done by IBM resources in this area, as far as I remember)