Text Data processing twitter data extraction error.

[venkataramana_paidi]

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

[Peter_ITA]

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

[former_member229018]

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

[former_member18162]

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-f2ce09de4...

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