SAP Knowledge Base Article - Preview

3788479 - KB export uses login user as schema causing "invalid table name [259]" when tables are in another schema – Solution Sales Configuration

Symptom

  • When exporting Knowledge Bases with individual user ids, the connection uses the login user name as the schema name.
  • The required SSC KB tables reside in a different schema.
  • Export fails with: "com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [259]: invalid table name: Could not find table/view COMM_CFGKB in schema : line 1 col 20 (at pos 19)"


Read more...

Environment

Solution Sales Configuration

Product

SAP Solution Sales Configuration all versions

Keywords

schema, default schema, hana, jdbc 259, invalid table name, comm_cfgkb, kb export, ssc, solution sales configuration, cross-schema access, schema qualification, databaseName property, sme connection, user id as schema, table not found , KBA , CRM-SLC , Solution Sales Configuration , Problem

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.