Error: "[1777005] Error reloading x system objects" when executing/simulating Native DB Connector project for Oracle Server or IBM DB2 (4294965)

When executing or simulating a Native Database Connector project in the Synchronization Editor the following errors appear:

"[1777005] Error reloading x system objects"

"[2415015] Error executing the following statement "Select columnName1, columnName2, columnName3... from schemaName.viewName where (nvl(uniqueColName1, '#null-value'), nvl(uniqueColName2, '#null-value')) in (('row1Col1Value', 'row1Col2Value', 'row2Col1Value', 'row2Col2Value', 'row3Col1Value', 'row3Col2Value', ...))".

There is also an error shown which comes from the target Database, in this case a Oracle Server:

"ORA-00920: invalid relational operator."

The problem is cause by defect 26057.  There are brackets missing in the SQL statements.

WORKAROUND

None

STATUS

Issue fixed in version 7.0.3. The latest version of Identity Manager can be downloaded here.  A Hotfix for version 7.0.2 can be requested via a Service Request.