DPAgent New Remote Source FileAdapter error : SAP DBTech JDBC: [403]:

[otto_frost4]

I'm on hana express trial binary version on SUSE SLES SAP special ´setup in Azure VM

I had the JDBC: [257]: problem below and found the solution

restart dpagent

make sure that all previous steps are successful

2 all stuff started

7 connection ok and not has stopped working

8 agent registration successfull

9 should now work to register FileAdapter

Next step is to use HANA Studio and register remote source

Provisioning - Remote Sources - New Remote Source

Filled in source name "zhanatrialFileAdapter" and select "FileAdapter"

error : Parameter "Password" cannot be empty

All password fields filled in but still error

Closing all the open "dropdowns" and selecting Crednetials mode None but then error below

SAP DBTech JDBC: [403]: internal error: Connection failed for remote source zhanatrialFileAdapter. Reason: not supported

window is displayed where to fill in

connection properties

adapter version 1.0

server

port

authentication mode

ssl mode

credentials

credentials mode none

Any idea?

************************************************************

DPAgent Configuration Tool

************************************************************

1. Agent Status

2. Start or Stop Agent

3. Agent Preferences

4. Remote Source Credentials

5. SSL Keystores & Settings

6. Configure DPAgent HTTP(S) Proxy Authentication

7. SAP HANA Connection

8. Agent Registration

9. Adapter Registration

10. Custom Adapters

11. Agent & Adapter Versions

q. Quit

b. Back

************************************************************

Enter Option:9

************************************************************

Adapter Registration

************************************************************

1. Display Adapters

2. Register Adapter

3. Unregister Adapter

q. Quit

b. Back

************************************************************

Enter Option:2

Enter adapter name:

FileAdapter

Failed to register adapter.

Context: Executing SQL statement "create adapter "FileAdapter" at location agent """ failed with SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near """: line 1 col 48 (at pos 48)

2023-02-24 09:32:06,656 [ERROR] SocketConnector.read - Executing SQL statement "create adapter "FileAdapter" at location agent """ failed with SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near """: line 1 col 48 (at pos 48)

2023-02-24 09:32:06,659 [ERROR] AgentConnection.submitRequest - Request Failed for ADMIN_REGISTER_ADAPTER Context: Executing SQL statement "create adapter "FileAdapter" at location agent """ failed with SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near """: line 1 col 48 (at pos 48)

[jeffrey_kresse · Accepted solution]

Hello Otto,

HANA Studio is not very effective for editing SDI remote sources. Not sure if there is a Database Explorer app in your HANA Express, that would be a better UI for this purpose. In HANA Studio there can be misinterpreted configuration; and all unnecessary credential options are displayed even though only one is really used. You will have to use Technical User for the credentials instead of None, and enter the AccessToken in each mandatory credential field.

Not sure if you have already set up an AccessToken & root dirs for FileAdapter on your agent. Do those first, then fill out all of the credential/password entries HANA Studio is asking you for with the same AccessToken you created.

1. agentcli --setSecureProperty
2. Choose the option "Set FileAdapter Access Token", enter and confirm a password of your own design
3. agentcli --configAdapters
4. Choose "Set Adapter Preferences" -> "Set FileAdapter preferences"
5. Choose the root and file format root directory (FileAdapter is not allowed to access files at a higher level than the chosen directory)
6. Choose a PGP key directory, or skip it if you don't use PGP encryption on your files.
7. Enter the AccessToken set in #2 above.
8. Now in HANA Studio make the remote source, use credential mode 'Technical User' and fill out all of the password fields with the AccessToken.

Best regards,
Jeff

[otto_frost4 · Accepted solution]

Many Thanks for the advice

I have done the steps "Set FileAdapter Access Token" and "Set FileAdapter preferences"

I'm not using PGP

In SAP HANA Studio :

When selecting 'Technical User' and pressing the "save this editor" button then there is a popup with text "You have selected 'technical user' as the credentials mode, but only 'NONE' credentials can be used at this moment"

[otto_frost4 · Accepted solution]

1 - do not give up easily

^^^^^^^^^^^^^^^^^^^^^^^^

SAP HANA Database Explorer - connection type SAP HANA Database port 39015 where 90 is the instance number

I managed to create RemoteResource from here for the fileAdapter

and it was necessary to use the steps Jeff described!

[otto_frost4]

Next steps :

_

Replicate "Change Data Capture" (CDC) from HANA table to the below destinations

_

Write to File on local file system

_

Write to HDFS file system

_

Write to Hive

_

Update to Hive

_

Delete from Hive

__

__

All good tips will be appreciated

[otto_frost4]

Thanks for the answer - will try that with accesstoken
*************************

I have a problem with the "Database Explorer app"

SQL Console could not connect to the database.

Error: There was a problem making a connection to the database (ID C44_0): SQL_ERROR

SQL Error: Connection failed (RTE:[89006] System call 'recv' failed, rc=104:Connection reset by peer {10.3.0.4:62398 -> 10.3.0.4:39015} (10.3.0.4:62398 -> zhanatrial.westeurope.cloudapp.azure.com:39015))

*************************

Connecting from hana studio works using the same hostname and port

I have been able to create a database table and do insert, update and delete from the sql console in hana studio so something is working.

[otto_frost4]

I had selected type = Cockpit Database but it should be type = SAP HANA Database