*** ERROR => Connect to database failed, rc=1, rcSQL=10 when starting applicatiion server

[wkies]

Hello,

This is coming from a new installation in AWS to get rid of our last on premise Sandbox environment. The aws system was installed with the same system ID for the application server (SS1) and Hana Server (SH1) with hosts names being different. After the installation was completed I was able to login in client 000 using DDIC

A backup of the on premise Sandbox was done and used for the restore of the AWS System. The default schema of the new barebone aws was SAPHANADB and was replaced with the schema SAPABAP1 from the source backup. The Profiles were adjusted to reflect the change.

After investigating the the error I used the hdbuserstore command to delete the existing Key and created a new one with the following command

hdbuserstore SET sbox "<AWS Host Name>.local:30015@SH1" SAPABAP1 <password for user SAPABAP1>

After rebooting the application server I started the instance and eventually the dispatcher service would go gray

Although I ran the hdbuserstore the trace would show the same error:

C connect to SAPHANADB/<pwd>@<AWS Host Name>.local:30015 on connection 0 ...
C *** ERROR => Connect to database failed, rc=1, rcSQL=10

For some  reason it is still picking up the old connection string of the original schema before the restore. I'm not sure where it's getting it from. I have looked at bunch of notes but to no avail. Any help would be great.

Thank you