RVR-SF-RDBMS-305

Issue summary

Error Code: RVR-SF-RDBMS-305 with the description "Failed to get the private key bytes" indicates an issue related to Key-Pair Authentication, possibly not retrieving or accessing the necessary private key bytes for the RDBMS (Relational Database Management System) data connector within Data Integration.
This kind of error is typically associated with issues in properly handling or accessing the private key used for authentication, most likely in the context of a Snowflake database connection.

Action steps

To resolve the error, follow these steps:

Verify Key-Pair Configuration: Ensure that the private key file is correctly generated and formatted. Key-Pair authentication in Data Integration requires a PEM format private key.
Generate Private Key:
- On a compatible platform (Mac/Linux), generate an unencrypted private key using the command:
```
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8 -nocrypt
```
- Make sure the private key is accessible and correctly referenced in your Data Integration connection configuration.
Assign Public Key: The public key derived from this private key should configure correctly in your Snowflake account using SQL commands such as:
```
alter user `<Username>` set rsa_public_key='`<public_key_content>`';
```
Test Connection: Use the Test Connection feature in Data Integration to verify that the connection attributes work correctly. This will help ensure that both the private and public key configurations are correct.
Re-upload and Reference the Key: Ensure the .p8 file (your private key) is correctly uploaded to Data Integration and referenced in your Snowflake connection settings in Data Integration.

External references

note

If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.