question

Upvotes
Accepted
5 8 12 12

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

tick-history-rest-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hello @,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Hello @ricardo.siguero

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
62 4 1 5

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.