No extraction files got from HistoricalReferenceReportTemplates data accesses

Hi,

We are retrieving no data from the data access:

1.Report Template

Endpoint:

/Extractions/HistoricalReferenceReportTemplates

Report template definition is:

{
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.HistoricalReferenceReportTemplate",
"CompressionType": "GZip",
"ShowColumnHeaders": true,
"Name": "E41890_REQUEST_SYMBOL_MARKET_INFO_373_TEMPL_74383",
"Headers": [],
"Trailers": [],
"ContentFields": [{
"Format": null,
"FieldName": "RIC"
}, {
"Format": null,
"FieldName": "Exchange Code"
}, {
"Format": null,
"FieldName": "Asset Category"
}, {
"Format": null,
"FieldName": "Security Description"
}, {
"Format": null,
"FieldName": "Inverse Rate Marker"
}, {
"Format": null,
"FieldName": "Expiration Date"
}, {
"Format": null,
"FieldName": "Trading Status"
}],
"Condition": {
"StartDate": "2017-09-14T23:59:59.999",
"EndDate": "2017-09-14T00:00:00.000"
}
}

Its reponse is:

{
"Condition": {
"EndDate": "2017-09-14T00:00:00.000Z",
"StartDate": "2017-09-14T23:59:59.999Z"
},
"Headers": [],
"LastChangedDate": "2017-10-27T11:17:48.167Z",
"ReportFieldCount": 7,
"OutputFormat": "CommaSeparatedValues",
"ContentFields": [{
"Justification": "Center",
"Format": {
"Capitalization": "None",
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldTextFormat"
},
"WidthStyle": "VariableWidth",
"FieldName": "RIC"
}, {
"Justification": "Center",
"Format": {
"Capitalization": "None",
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldTextFormat"
},
"WidthStyle": "VariableWidth",
"FieldName": "Exchange Code"
}, {
"Justification": "Center",
"Format": {
"Capitalization": "None",
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldTextFormat"
},
"WidthStyle": "VariableWidth",
"FieldName": "Asset Category"
}, {
"Justification": "Center",
"Format": {
"Capitalization": "None",
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldTextFormat"
},
"WidthStyle": "VariableWidth",
"FieldName": "Security Description"
}, {
"Justification": "Center",
"Format": {
"Capitalization": "None",
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldTextFormat"
},
"WidthStyle": "VariableWidth",
"FieldName": "Inverse Rate Marker"
}, {
"Justification": "Center",
"Format": {
"DateFormat": "dd/MM/yyyy",
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldDateFormat"
},
"WidthStyle": "VariableWidth",
"FieldName": "Expiration Date"
}, {
"Justification": "Center",
"Format": {
"ThousandSeparator": "Comma",
"UseThousandSeparator": true,
"IntegerPlaces": 1,
"DecimalPlaces": 0,
"NegativeSignPosition": "Before",
"DecimalSeparator": "Period",
"UseLeadingZero": false,
"UseTrailingZero": false,
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ReportTemplates.ContentFieldNumberFormat"
},
"WidthStyle": "VariableWidth",
"FieldName": "Trading Status"
}],
"Trailers": [],
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#HistoricalReferenceReportTemplates/$entity",
"ReportTemplateId": "0x05ed1a04807b3036",
"CreateDate": "2017-10-27T11:17:48.167Z",
"Name": "E41890_REQUEST_SYMBOL_MARKET_INFO_373_TEMPL_74383",
"DeliveryType": "None",
"Delimiter": "None",
"CompressionType": "GZip",
"TemplateTypeCode": "HRD",
"ShowColumnHeaders": true
}

2.Schedule

{
"TimeZone": "GMT Standard Time",
"Name": "E41890_REQUEST_SYMBOL_MARKET_INFO_373_SCHED_77425",
"Recurrence": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.SingleRecurrence",
"ExtractionDateTime": "2017-10-27T13:17:57Z",
"IsImmediate": true
},
"Trigger": {
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.ImmediateTrigger",
"LimitReportToTodaysData": false
},
"ListId": "0x05ed1a033ccb3036",
"ReportTemplateId": "0x05ed1a04807b3036"
}

Resuts for the above is:

{
"Name": "E41890_REQUEST_SYMBOL_MARKET_INFO_373_SCHED_77425",
"ScheduleId": "0x05ed1a053f8b3036",
"ListId": "0x05ed1a033ccb3036",
"LastChangeDate": "2017-10-27T11:17:51.224Z",
"UserId": 9013852,
"TimeZone": "GMT Standard Time",
"ReportTemplateId": "0x05ed1a04807b3036",
"CreateDate": "2017-10-27T11:17:51.224Z",
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Schedules/$entity",
"Trigger": {
"LimitReportToTodaysData": false,
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.ImmediateTrigger"
},
"Recurrence": {
"IsImmediate": true,
"ExtractionDateTime": "2017-10-27T00:00:00Z",
"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.Schedules.SingleRecurrence"
}
}


We are not getting today any of the extraction files we used to retrieve in previous days...

The loop where the data access is checking for the completeness of the extraction never ends:

Waiting 60 seconds... Retry #1

Waiting 60 seconds... Retry #18

Waiting 60 seconds... Retry #24

...

Any idea about what is happenning?

Thanks

Regards

Ricardo

Best Answer

  • Hi, it looks like there's a problem on Tick History 2 today, although in the alert it mentions only the Elektron Timeseries report :

    SERVICE ALERTS FOR INFORMATION PRODUCTS ALERU30


    Tick History v2 Custom Delayed

    ALERT STATUS = Confirmed

    Checkpoints (All Times are GMT)
    Outage Start: 08:40 27 Oct 2017
    First Reported: 10:20 27 Oct 2017 Last Updated: 11:09 27 Oct 2017
    Next Update: 12:20 27 Oct 2017 Estimated Resolution: Not Yet Available
    Some Thomson Reuters Tick History version 2.0 custom extractions are delayed.
    Customers are globally impacted.
    Affected Report Template: Elektron TimeSeries


    Status at 11:09 GMT: Investigations continues to establish the cause of the
    incident.
    The next update is at 12:20 GMT.

    http://www.gva.rapid.reuters.com/a/alerts/servicealerts/Alert/Alerts.aspx