Hybris Marketing Facebook Integration via SAP Data Services Error

[former_member355106]

Dear Experts,

yesterday I have changed the search terms in Hybris Marketing:

Afterwards I triggered the job Job_Facebook_Data_Load_ODATA in SAP Data Services Designer.

First effect was that 1278 Posts of Facebook were loaded we never heard of. Normally only posts of our facebook account associated to the Facebook Developer App were loaed (from one facebook account). Why is this happening?

Moreover when I now trigger the job no new post are loaded. I attach the log (token was manually modified by me) of the sap data services. I assume it has to do with the following message:

Total 9 task to search. -> There are 9 search terms defined in Hybris Marketing

Failed to reach the https://graph.facebook.com/v2.2/Mastercard ... [] due to bad request.

Does anybody understand what I have to do here? What is the meaning of the error message? Why I could load so many posts into Facebook?

[Former Member]

Dear Oliver,

Using On-Premise 1702, we directly uploaded the search terms into the HANA using Job_Load_Social_Media_Search_Query. After which the other jobs like Job_Twitter_Data_Load pick up these search terms from the HANA table STG_SMI_SEARCH_QUERY.

You can check whether the search term has been loaded by checking the following:

Job_Facebook_Data_Load -> Con_Map_Facebook_Data -> DF_Map_Facebook_Data_NoCust -> STG_SMI_SEARCH_QUERY

With regards,

Akil

[former_member355106]

Dear Akil,

thank you for your reply and the answer. As I found out the search terms which I entered above are just for finding the correct facebook account (fan page) or to identify the correct twitter account.

Anyway. I think by SAP HANA Text Analysis the posts are searched and more tags are added. THis seams not to work at the moment. Do you know what we can do here?

[Former Member]

Dear Oliver,

"The regular background job CUAN_IA_TA_EXTR_DELTA that is scheduled during technical configuration ensures that the imported interactions are updated by sentiments and tags according to the results of SAP HANA Text Analysis."

Please check whether that background job is scheduled, or run report CUAN_IC_MASTERDATA_EXTR_DELT with text analysis selected:

With regards,

Akil

[former_member355106]

Dear Akil, thank you again. Just a question. Report CUAN_IA_TA_EXTR_DELTA does not exist. What is the ID of the report? Or is CUAN_IA_TA_EXTR_DELTA = CUAN_IC_MASTERDATA_EXTR_DELT ?

[Former Member]

Dear Oliver,

The job CUAN_IA_TA_EXTR_DELTA ( in my system it is called SAP_CUAN_IA_TA_EXTR_DELTA ) runs the report CUAN_IC_MASTERDATA_EXTR_DELT.

In SM37, for the job selection input CUAN_IC_MASTERDATA_EXTR_DELT into the ABAP Program Name when searching to see whether this report is running already. If not, you should run the job, or run the report manually after you import SNS posts.

With regards,

Akil

[former_member355106]

Dear Akil,

I have checked that. In our yM System this job is running already (with flag set in Extractions from SAP HANA Text Analysis):

The reason for the missing tags must be another one. Any more ideas maybe? How we can modify the logic of SAP HANA Text Analysis?

Cheers,

[Former Member]

Please check your settings in SPRO:

SAP Customizing Implementation Guide->Cross-Application Components->Processes and Tools for Enterprise Applications->Social Intelligence->Text Analysis

• Generating Text Analysis Index
• Selecting Entity Types to Process for Sentiment Assignment
• Assigning Sentiment to Entity

Settings should have been maintained there.

With regards,

Akil

[former_member355106]

Hi Akil,

settings have been maintained here.

1. Settings for Index Generation

Problem: It says in description "The full text index is created for the SOCIALPOSTTEXT column of the SOCIALDATA table with text analysis option EXTRACTION_CORE_VOICEOFCUSTOMER". The problem is, that our SOCIALDATA table is completely empty.

-> Might this be the problem?

Cheers,

[Former Member]

Dear Oliver,

My SOCIALDATA table is completely empty too, and I have everything running. Typically the tag type entries in table CUANC_CE_IA_TT, can be seen in tables CUAND_CE_IA_TAG / CUANL_CE_IA_TAG when tags are created.

I think you might need to create an SAP OSS incident to get them to have a look at your system.

With regards,

Akil

[former_member355106]

Dear Christopher,

you write here about a Facebook Fan Page. We just have created a normal Facebook Account

https://www.facebook.com/margaret.hawkins.3720

and this was working until friday. Anyway does recommend SAP only use a Facebook Fan Page?

Cheers,

[former_member201769]

Hi Oliver,

I am trying to load the facebook data to my Ymkt .Can you please help me with the process ,so that it will help me to configure it.

Regards

Rashmi Ranjan

[chrigu1]

Hi Oliver,

in case you haven't done yet have a look into "rapid data load for SAP Hybris Marketing". Have a look in item DI6 and there in the user guide. It's described there that for facebook data load you need to define the facebook fan page name as a Search Text Term e.g.

Your Seach Query's would then looks like:

So for twitter you define real search terms, while for facebook you define the name of the fanpage. So I assume that your fanpages "Mastercard", etc. might not exist, hence the error. Maybe one of them existed and that's where you got your 1278 posts from you never heard of 😉

hope this helps.

Regards Christopher.

[former_member201769]

Hi Christopher,

Is there any way to access DI5 and DI6 as i am not able to look into the docs ,its showing me as Error.

Regards

Rashmi Ranjan

[chrigu1]

Hi Rashmi,

this link goes directly to the docx.

Regards Christopher.

[former_member201769]

Hi Christopher,

Thanks a ton.Is there any DI5 document that talks about configuration ?

I was going through the document and in the page no 6 "Configuration Guide Load social media data for SAP Hybris Marketing (DI5), enables you to set up or change the technical environment in the SAP Data Services if required."

It will be very helpful if you can provide me the DI5 also.

Thanks in advance.

Regards

Rashmi Ranjan