Symptom
Getting the below error, when remote user has single quotations in its password, and the issue situation has been shown while trying to create the remote access on the HANA Studio:
It seemed it works with the CREATE REMOTE SOURCE SQL while there are single quotations in passwords for the users if another single quotation is enclosed with the quotations. Hence, please try to add another single quotation with the single quotation used in the password, and share the result after trying the SQLs. (e.g., ' to '')
https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/275839492fef49318d92d0e31656ea0a.html?version=2.0.05
Read more...
Environment
SAP HANA DB Version 2.0
Keywords
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.