Skip to Content

Text Data processing twitter data extraction error.

Hi ,

I am trying to extract the tweets and apply the sentiment analysis using text data processing.

I am using the TDP Blueprints job to extract the data from twitter. But I am getting the below error.

5340    5836    PRINTFN    10/23/2015 11:56:02 AM    https://api.twitter.com/1.1/search/tweets.json?q=uae&count=100&lang=en&result_type=recent

5340    5836    PRINTFN    10/23/2015 11:56:02 AM    Failed to reach the https://api.twitter.com/1.1/search/tweets.json?q=uae&count=100&lang=en&result_type=recent server due to

5340    5836    PRINTFN    10/23/2015 11:56:02 AM    [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581).

Please help me how to resolve this issue.

Thanks & Regards,

Venkata Ramana Paidi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 26, 2015 at 01:23 PM

    Hi Venkata,

    Did you read page 14 of the TDP Language Blueprints User's Guide?

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50537531-3d9d-3010-939e-f2ce09de4d07?QuickLink=index&overridelayout=true&58540404288308

    The Twitter API has authorization restrictions. You have to generate certain keys and put them into your search.cfg.

    https://dev.twitter.com/oauth/overview/authentication-by-api-family

    Good luck!
    Julie

    Add comment
    10|10000 characters needed characters exceeded

  • May 31, 2016 at 02:23 PM

    Same problem here.

    We are using Data Services 4.2 Rapid Deployment Package together with SAP Hybris Marketing. Use Case is to import twitter posts as interactions into Hybris Marketing.

    We are getting the same error.

    Failed to reach the https://api.twitter.com/1.1/search/tweets.json?q=SomeSearchText&count=100&result_type=recent server due to [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:581)

    Has anoyone found a solution for that?

    Tanks, Peter

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I found a note on how to install the certificate in BODS server and in my case its salesforce certificate to be downloaded, same way you can download the certificate and install it in BODS Job server.

      2243129 - How to install new Salesforce certificates on a host running Data Services job server?

      Regards,

      Vignesh G