Error: Cannot Open Log File Path C:/<path>/tde/cwallet.sso

Issue

While configuring a connection to use the Binary Log Reader sync method, setup tests fail with the following error:

Cannot open log file path C:/<path>/tde/cwallet.sso

Environment

• Connector: Oracle
• Operating system: Windows
• Incremental sync method: Binary Log Reader

Resolution

To resolve the issue, grant the Oracle service account, typically named OracleService<SID>, Full Control permissions for the C:/<path>/tde/ folder in Windows.

Cause

This issue occurs when we encounter the following database error during setup tests:

ORA-22288: file or LOB operation FILEOPEN failed

This indicates that the Oracle service account lacks permission to access the cwallet.sso wallet file, located in the C:/<path>/tde/ folder.