Problem Note 65602: Importing data from Twitter or Facebook to SAS® Cloud Analytic Services on SAS® Viya® fails with an error

Importing data from Twitter or Facebook to SAS Cloud Analytic Services (CAS) fails. This issue impacts all releases of SAS^® Visual Analytics, SAS^® Event Stream Processing, and SAS^® Data Explorer including the embedded Data Explorer in SAS^® Environment Manager, SAS^® Model Manager, and other SAS Viya applications. These errors occur because the social media connectors are no longer supported.

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.

The hot fix for SAS^® Viya^® 3.5 removes the Facebook and Twitter import functionality from the user interface. Users who wish to import Twitter or Facebook data are encouraged to use third-party tools to extract the data into CSV format and then import the CSV file.

Note: SAS Visual Analytics on SAS^® 9.4 continues to show the social media connectors in the Import Data dialog box even though they are no longer supported.

Twitter Import Errors

The following errors occur as soon as you click the Obtain Access Code button when selecting to import Twitter data:

SAS Visual Analytics on SAS® 9.4

HTTP 500 - Internal Server Error

SAS Data Explorer on SAS Viya and SAS Event Stream Processing

{"errorCode":0,"message":"401:Authentication credentials (https://dev.twitter.com/pages/auth) were missing or incorrect. Ensure that you have set valid consumer key/secret, access token/secret, and the system clock is in sync.\nmessage - Could not authenticate you.\ncode - 32\n","details":["correlator: 507dc0c4-841a-4b7e-bdb7-9b2188944d42","traceId: bf4355ef19e00a88","path: /webDataAccess/providers/twitter/consumers/VA/users/@currentUser/redirect"],"links":[],"version":2,"httpStatusCode":400}

Facebook Import Errors

The following errors occur as soon as you click the Import Item or the Import All button when selecting to import Facebook data:

The physical table could not be loaded into the session-based table in the destination library.

The error message is followed by a View Details link. Clicking View Details will show an error similar to the following examples:

ERROR: (#10) This endpoint requires the 'manage_pages' or 'pages_read_engagement' permission or the 'Page Public Content Access' feature or the 'Page Public Metadata Access' feature. Refer to https://developers.facebook.com/docs/apps/review/login-permissions#manage-pages, https://developers.facebook.com/docs/apps/review/feature#reference-PAGES_ACCESS and https://developers.facebook.com/docs/apps/review/feature#page-public-metadata-access for details. [code :10] [HTTP Status :400] ERROR: Facebook search return with error response.

ERROR: (#10) To use 'Page Public Content Access', your use of this endpoint must be reviewed and approved by Facebook. To submit this 'Page Public Content Access' feature for review please read our documentation on reviewable features: https://developers.facebook.com/docs/apps/review. [code :10] [HTTP Status :400]

ERROR: Facebook search return with error response.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
Product Family	Product	System	Reported	Fixed*	Reported	Fixed*
SAS System	SAS Visual Analytics	Microsoft® Windows® for x64	7.4		9.4 TS1M6
SAS System	SAS Visual Analytics	Linux for x64	7.4		9.4 TS1M6
SAS System	SAS Viya	Microsoft® Windows® for x64	3.4		Viya
SAS System	SAS Viya	Linux for x64	3.4	2020.1	Viya	Viya
SAS System	SAS Event Stream Processing Engine	Microsoft® Windows® for x64	5.2
SAS System	SAS Event Stream Processing Engine	Linux for x64	5.2

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

Type:	Problem Note
Priority:	high

Date Modified:	2022-12-08 12:50:44
Date Created:	2020-02-24 15:29:51

Support