Symptoms:

Reading fields from the Oracle Data Source returns no values, and the specified owner name has the correct permissions. 

Error Message:

None.

Underlying Cause:

Unlike Microsoft SQL Server's default setting, Oracle databases are case-sensitive.  Even if the owner name is spelled correctly and has the right permissions, using the wrong character cases will prevent the owner from being recognized.  This in turn will cause the permissions check to fail.

Note that capitalization can affect user-specified additional connection string properties as well.

Solution:

Double-check capitalization of the owner name, or remove the owner name if your configuration allows it.  Note that removing the owner name may result in longer synching times; see this article.

Return to Oracle Troubleshooting Hub

Author: Doug Wynkoop