row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission

Can you please help us to understand what this error means? Our daily process runs fine but one day we saw these errors repeating for many RICs for which We are downloading TRTH intraday price summary. The details are as below -


WH0 : Request failed = {"@odata.context":"https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#RawExtractionResults/$entity","JobId":"0x06439435ab9b3026","Notes":["Extraction Services Version 12.1.39202 (f3a5974597fc), Built Jul 18 2018 22:27:40\nUser ID: 9014963\nExtraction ID: 2000000035448367\nSchedule: 0x06439435ab9b3026 (ID = 0x0000000000000000)\nInput List (15 items): (ID = 0x06439435ab9b3026) Created: 07/23/2018 05:49:38 Last Modified: 07/23/2018 05:49:38\nReport Template (16 fields): _OnD_0x06439435ab9b3026 (ID = 0x06439435af5b3026) Created: 07/23/2018 05:49:18 Last Modified: 07/23/2018 05:49:18\nSchedule dispatched via message queue (0x06439435ab9b3026)\nSchedule Time: 07/23/2018 05:49:20\nProcessing started at 07/23/2018 05:49:20\nProcessing completed successfully at 07/23/2018 05:49:38\nExtraction finished at 07/23/2018 05:49:38 UTC, wit! h servers: x04q13\nInstrument expanded to 1 RIC: WH0.\nInstrument expanded to 1 RIC: WH1.\nInstrument expanded to 1 RIC: WH9.\nInstrument expanded to 1 RIC: WK0.\nInstrument expanded to 1 RIC: WK1.\nInstrument expanded to 1 RIC: WK9.\nInstrument expanded to 1 RIC: WN0.\nInstrument expanded to 1 RIC: WN1.\nInstrument expanded to 1 RIC: WN9.\nInstrument expanded to 1 RIC: WU0.\nInstrument expanded to 1 RIC: WU8.\nInstrument expanded to 1 RIC: WU9.\nInstrument expanded to 1 RIC: WZ0.\nInstrument expanded to 1 RIC: WZ8.\nInstrument expanded to 1 RIC: WZ9.\nTotal instruments after instrument expansion = 15\n(RIC,WH0,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WH1,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,W! H9,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WK0,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WK1,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WK9,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WN0,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WN1,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WN9,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WU0,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WU8,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WU9,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD)! , CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WZ0,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WZ8,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\n(RIC,WZ9,CBT) row suppressed for lack of 'CBT-WB (CBOT-WALLBOARD), CBT (CHICAGO BOARD OF TRADE)' permission.\nReport suppressed because no instruments are permitted\n"]}

Best Answer

  • zoya faberov
    zoya faberov ✭✭✭✭✭
    Answer ✓

    Further update from support:

    "... we have found that there was an Alert raised on 23/07/2018 (around the same time the
    client did the extraction) that was resolved as per below:-
    Resolved

    SERVICE ALERTS

    Subject: DataScope Select - Data for Certain
    Instruments - Was Unavailable



    Issue Description:

    Some users were unable to access selected data on DataScope Select GUI and
    Extractions until 08:40 GMT.



    This was due to a permissioning issue at Thomson Reuters.



    Customers globally were affected by this incident.



    The major incident management process was invoked at Thomson Reuters to aid
    service restoration.



    Status at 09:01 GMT: The services were restored at 08:40 GMT.

    Alert ID176443Alert StatusResolved
    First Reported23-July-2018
    06:20 GMT
    Outage Start23-July-2018
    00:00 GMT
    Actual
    Resolution
    23-July-2018
    08:40 GMT

    "

    Please confirm that you are not currently seeing this, it has been resolved.

    Thanks,

    -AHS

Answers

  • zoya faberov
    zoya faberov ✭✭✭✭✭

    Hello @rahul_srivastava,

    Please include the complete request that has caused this error.

    I have understood, that your daily extraction process has been running this extraction request successfully, no permission errors were reported, and only this specific run of that same request has failed with "lack of CBT ... permissions",

    I have created support case# 06775422 to properly investigate this incident. We will need to add the request information to it.

    In the future, if you are observing an issue, rather then have a question, it will be more efficient to open a support incident directly via myaccount.thomsonreuters.com.

  • zoya faberov
    zoya faberov ✭✭✭✭✭

    From support :

    "... the client has no permission to extract
    the values for CHICAGO BOARD OF TRADE hence the error arises as row
    suppressed due to lack of permission.

    To discuss adding the required
    permissions, please contact your Thomson Reuters account manager ..."

  • This is the request body -

    Request Body : OrderedDict([('ExtractionRequest', OrderedDict([('@odata.type', '#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryIntradaySummariesExtractionRequest'), ('ContentFieldNames', ['Open', 'High', 'Low', 'Last', 'Volume', 'No. Trades', 'Open Bid', 'High Bid', 'Low Bid', 'Close Ask', 'Close Bid', 'High Ask', 'Low Ask', 'No. Asks', 'No. Bids', 'Open Ask']), ('Condition', OrderedDict([('MessageTimeStampIn', 'GmtUtc'), ('ReportDateRangeType', 'Range'), ('QueryStartDate', '2018-07-20T00:00:00.000-05:00'), ('QueryEndDate', '2018-07-20T23:59:59.999-05:00'), ('SummaryInterval', 'OneMinute'), ('TimebarPersistence', 'true'), ('DisplaySourceRIC', 'true')])), ('IdentifierList', OrderedDict([('@odata.type', '#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList'), ('InstrumentIdentifiers', [{'Identifier': 'WH0', 'IdentifierType': 'Ric'}, {'Identifier': 'WH1', 'IdentifierType': 'Ric'}, {'Identifier': 'WH9', 'IdentifierType': 'Ric'}, {'Identifier': 'WK0', 'IdentifierType': 'Ric'}, {'Identifier': 'WK1', 'IdentifierType': 'Ric'}, {'Identifier': 'WK9', 'IdentifierType': 'Ric'}, {'Identifier': 'WN0', 'IdentifierType': 'Ric'}, {'Identifier': 'WN1', 'IdentifierType': 'Ric'}, {'Identifier': 'WN9', 'IdentifierType': 'Ric'}, {'Identifier': 'WU0', 'IdentifierType': 'Ric'}, {'Identifier': 'WU8', 'IdentifierType': 'Ric'}, {'Identifier': 'WU9', 'IdentifierType': 'Ric'}, {'Identifier': 'WZ0', 'IdentifierType': 'Ric'}, {'Identifier': 'WZ8', 'IdentifierType': 'Ric'}, {'Identifier': 'WZ9', 'IdentifierType': 'Ric'}]), ('UseUserPreferencesForValidationOptions', 'false')]))]))])

    Please note that every day we are running the extraction for same RIC and it works fine. The problem happened only for

    ('QueryStartDate', '2018-07-20T00:00:00.000-05:00'), ('QueryEndDate', '2018-07-20T23:59:59.999-05:00'),

    And when we reran the process for same date, it again worked fine. It just failed in one occasion.

    The user detail is as follows -

    'UserId': 9014963, 'UserName': 'SSGA TRTHbatch'

  • @rahul_srivastava, as an added comment:

    For the support team to investigate a specific query, the user name is insufficient. It requires a unique Client-Session-Id, specific to that query (i.e. each query you make should have a different and unique one), and the Request-Execution-Correlation-Id which the server returns to you. For details on these Ids, see here: https://hosted.datascopeapi.reuters.com/RestApi.Help/Home/Diagnostics