Skip to Content
0
Former Member
Jul 21, 2017 at 05:28 AM

SAP Data Services for Social Media Load from Twitter

599 Views

Dear all,

We are currently trying to load social media posts from twitter into SAP hybris marketing 1605 on-premise. We are using SAP Data services 4.2 SP9 and SAP IPS 4.2 SP4. We followed the Rapid Data Load guide, and "Load social media data for SAP Hybris Marketing (DI6)".

During the execution of the job, we are currently getting the following errors:

  |Data flow DF_Map_Twitter_Data_NoCust|Loader Get_T_MaxID_STG_TW_MAXID
SQL submitted to ODBC data source <xx.xxx.xx.xxx> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;362
invalid schema name: <RDS_DS_STAGE>: line 1 col 21 (at pos 20)>. The SQL submitted is <CREATE COLUMN TABLE
<RDS_DS_STAGE>."STG_TW_MAXID" ( "CHANNEL" VARCHAR (4)  not null ,  "LANGUAGE" VARCHAR (4)  not null ,  "SEARCH_TERM" VARCHAR
(50)  not null ,  "MAX_ID" VARCHAR (50) ,   primary key ( "CHANNEL", "LANGUAGE", "SEARCH_TERM") ) >.
|Data flow DF_Map_Twitter_Data_NoCust|Loader Get_T_MaxID_STG_TW_MAXID
SQL submitted to ODBC data source <xx.xxx.xx.xxx> resulted in error <[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;362
invalid schema name: <RDS_DS_STAGE>: line 1 col 21 (at pos 20)>. The SQL submitted is <CREATE COLUMN TABLE
<RDS_DS_STAGE>."STG_TW_MAXID" ( "CHANNEL" VARCHAR (4)  not null ,  "LANGUAGE" VARCHAR (4)  not null ,  "SEARCH_TERM" VARCHAR
(50)  not null ,  "MAX_ID" VARCHAR (50) ,   primary key ( "CHANNEL", "LANGUAGE", "SEARCH_TERM") ) >.

When I look into HANA though, the schema is present.

Also, I did make some changes to the repositories as following (to add the users due to "hana server is unknown" error).

Did anyone encounter this error before? Do I need to actually change something in the SAP Data Services job itself?

Attachments

rds-ds-stage.png (9.2 kB)
sd-stg-obj.png (17.0 kB)