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.
© 2023 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center