exception while creating remote source in SDA

[Former Member]

Hi

I am trying to create a remote data source in hana studio using following script

CREATE REMOTE SOURCE hivedb

ADAPTER "odbc"

CONFIGURATION 'DSN=REMOTEHDB'

WITH CREDENTIAL TYPE 'PASSWORD'

USING 'user=SYSTEM;password=Cloud123'

and following exception is occurring

Could not execute 'CREATE REMOTE SOURCE hivedb ADAPTER "odbc" CONFIGURATION 'DSN=REMOTEHDB' WITH CREDENTIAL TYPE ...' in 589 ms 383 µs .

[129]: transaction rolled back by an internal error: exception 301109: Storing credential to the persistency failed - encryption failure: decryptFinal: wrong or inconsistent padding decrypted!

exception 1000013: decryptFinal: wrong or inconsistent padding decrypted!

Any suggestion?

Thanks

[Former Member]

Hi Khalid,

can you check this

SAP Note 2078117 - CREATE REMOTE SOURCE fails with error "Storing credential to the persistency failed" aes_decrypt_end: wrong or inconsistent padding decrypted

Regards,

Pavan Gunda

[Former Member]

Hi Pavan,

I can no longer access the Note you have referenced. Is there other information that I might find useful?

(i am getting the same error as above but with HANA ODBC)

[Former Member]

Hi Khalid,

I don't have experience in connecting the Hadoop with HANA using SDA, however I can refer you some of the SCN documentation to make sure you followed all the steps.

Please have a look at the following content.

http://scn.sap.com/community/developer-center/hana/blog/2013/08/22/smart-data-access-and-hadoop

SAP HANA Smart Data Access - YouTube

Regards,

Venkat N.