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?