/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
After a system copy, BW processes (for example RSA1, DTP, or RSDS_DATASOURCE_ACTIVATE_ALL) fail when accessing a remote IBM DB2 database via SAP HANA Smart Data Access (SDA).
In SAP HANA indexserver traces, for example in SDA-related trace entries, errors such as the following can be observed:
- DB2 error SQL0204N / SQLSTATE 42704
- unixODBC errors indicating DSN or driver configuration issues
The issue can occur even if the remote source definition and credentials appear to be maintained.
Read more...
Environment
SAP HANA DB Version 2.0
Product
SAP HANA, platform edition 2.0
Keywords
SAP HANA, Smart Data Access, SDA, DB2, SQL0204N, SQLSTATE 42704, unixODBC, DSN, system copy, BW, RSA1, DTP, DB2 CLI, schema resolution, ODBC , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , 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.
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)