SAP Knowledge Base Article - Preview

3369662 - Table Producer "invalid schema name" to DWC HANA - SAP Data Intelligence

Symptom

Graph using Table Producer operator to write to Data Warehouse Cloud (DWC) HANA fails with the following error when the schema name contains a special character (hash '#'):

2023-08-23 06:24:29.849874|+0000|FATAL|Graph execution terminated abnormally: Graph failure: tableproducer1 failed with the following error:
SQL submitted to database <> resulted in error <General error;362 invalid schema name: DI_SUPPORT%2523HANA_USER: line 1 col 21 (at pos 20)>. The SQL submitted is <CREATE COLUMN TABLE "DI_SUPPORT%2523HANA_USER"."Table_Data"


Read more...

Environment

  • SAP Data Intelligence
  • SAP Data Intelligence Cloud

Product

SAP Data Intelligence Cloud all versions ; SAP Data Intelligence all versions

Keywords

Table Producer, hash, DWC, DataSphere, invalid schema, encoding , KBA , CA-DI , Data Intelligence , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.