Return
-
Title
Oracle DB Error: "No known schema detected" -
Description
Oracle DB Error: "No known schema detected"
Also:
missing dialog to select a template for the workflows and mappings. -
Cause
The message about "No known schema found" is related to the OneIM schema.It is a message that informs the end-user that there is no known OneIM schema in the database. -
Resolution
Please check following steps:1. Check instructions under..\Modules/DSI/dvd/documentation/en-US/OneIM_DatabaseSystemsIntegration_Administration.pdf2. Clear application cachea. Enable "expert mode" in the SynchronizationEditor (under menu Database | Settings)b, Clear application cache (take backup first):"%localappdata%\One Identity\One Identity Manager\Cache""%localappdata%\One Identity\One Identity Manager\AssemblyCache""%localappdata%\One Identity\One Identity Manager\IntelliCache"c. Compile DB.d. Run the sync wizard again.3. Check the templateWhile creating a generic db connection, enter "oracle" in the System CategoryCheck if the oracle template shows up in the template selection.4. Check if the query is being used internallyCreate a generic db connection to oracle target system with a blank templateGo to Target System of the project (Expert mode should be enabled for this first) and select Schema browser5. Check also Guide online calledadministration-guide-for-connecting-to-native-databases-through-database-systems-integration-module