Skip to main content
Feedback

RVR-SF-RDBMS-305

  1. 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.

  2. Action 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 be set 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.

  3. External References:

If the issue persists or you need further assistance, please open a ticket with Data Integration support.