[2186001] The template (Oracle Database Template) could not be applied successfully!

Hi, I have a problem creating a Generic database connector for Oracle DB.

On a step select project template I have following execption:

[2186001] The template (Oracle Database Template) could not be applied successfully!
[2186015] Error preparing the target systems.
Index was outside the bounds of the array

For other types of DB it works fine.

Version: One Identity Manager 9.3

I also tried a fresh installation OIM9.2.1 and got the same error.

Can someone advise how to be?

  • Try using the XML configuration from version 9.2:


    ...\OneIdentityManager.9.2\Modules\DSI\configuration

    Also, remember to follow these steps:

    Data source: Please use the sample connection string below to form your data source:

    (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = {server})(PORT = {port})) (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = {service name})))
    • Server: Provide the hostname.

    • Port: Provide the port to the database. By default, the port is 1521.

    • Service name: Provide the service name of the Oracle database.

    • Username: SYS

    • Password: Provide the password created during the Oracle installation.

      Click Extended and set DBA Privilege to SYSDBA

  • Thanks for the reply.

    Problem is not in the XML configuration and not with DB user rights.

    I checked your recommendation, but without success.

    Problem with choosing a project template (not XML configuration).


  • Full stack trace
    
    2025-04-30 15:30:12.4865 ERROR (VI.FormBase.ExceptionMgr  ) : The template (Oracle Database Template) could not be applied successfully! VI.Base.ViException: The template (Oracle Database Template) could not be applied successfully!
     ---> VI.Base.ViException: Error preparing the target systems.
     ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
       at VI.Projector.Scripting.GeneratedShellTemplate.OnPreProcessing()
       at VI.Projector.Templates.ShellScriptTemplate.OnApply(IProjectorShell shell, Predicate`1 filter)
       --- End of inner exception stack trace ---
       at VI.Projector.Templates.ShellScriptTemplate.OnApply(IProjectorShell shell, Predicate`1 filter)
       at VI.Projector.Templates.ScriptTemplate`1.Apply(TTarget target, Predicate`1 phaseFilter)
       --- End of inner exception stack trace ---
       at VI.Projector.Templates.ScriptTemplate`1.Apply(TTarget target, Predicate`1 phaseFilter)
       at VI.Projector.Editor.Wizards.ShellWizard._CreateShell(Boolean doNotApplyTemplate, Boolean forceNewSchema)
       at VI.Projector.Editor.Wizards.ShellWizard.<.ctor>b__30_1(String key)
       at VI.UI.Wizards.WizardData.Get[T](String key, T defaultValue)
       at VI.Projector.Editor.Wizards.ShellWizard.OnDataChanged(WizardDataEventArgs e)
       at VI.UI.Wizards.WizardData._SignalChanged(String key, Object newValue, Object oldValue)
       at VI.UI.Wizards.WizardData.Set[T](String key, T value)
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFoundView.OnSaveData(IWizardData data)
       at VI.UI.Wizards.GuiWizardPageView.SaveData(IWizardData data)
       at VI.UI.Wizards.WizardPage.SaveData()
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFound.OnComplete()
       at VI.UI.Wizards.WizardPage.Complete()
       at VI.UI.Wizards.Wizard._HandlePageFinished(IWizardPage page)    at VI.Projector.Templates.ScriptTemplate`1.Apply(TTarget target, Predicate`1 phaseFilter)
       at VI.Projector.Editor.Wizards.ShellWizard._CreateShell(Boolean doNotApplyTemplate, Boolean forceNewSchema)
       at VI.Projector.Editor.Wizards.ShellWizard.<.ctor>b__30_1(String key)
       at VI.UI.Wizards.WizardData.Get[T](String key, T defaultValue)
       at VI.Projector.Editor.Wizards.ShellWizard.OnDataChanged(WizardDataEventArgs e)
       at VI.UI.Wizards.WizardData._SignalChanged(String key, Object newValue, Object oldValue)
       at VI.UI.Wizards.WizardData.Set[T](String key, T value)
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFoundView.OnSaveData(IWizardData data)
       at VI.UI.Wizards.GuiWizardPageView.SaveData(IWizardData data)
       at VI.UI.Wizards.WizardPage.SaveData()
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFound.OnComplete()
       at VI.UI.Wizards.WizardPage.Complete()
       at VI.UI.Wizards.Wizard._HandlePageFinished(IWizardPage page)
    2025-04-30 15:30:12.4865 ERROR (ExceptionHandler 7a64dd20-6b03-4fba-abb2-da0ed2d8cc33 ) : The template (Oracle Database Template) could not be applied successfully! VI.Base.ViException: The template (Oracle Database Template) could not be applied successfully!
     ---> VI.Base.ViException: Error preparing the target systems.
     ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
       at VI.Projector.Scripting.GeneratedShellTemplate.OnPreProcessing()
       at VI.Projector.Templates.ShellScriptTemplate.OnApply(IProjectorShell shell, Predicate`1 filter)
       --- End of inner exception stack trace ---
       at VI.Projector.Templates.ShellScriptTemplate.OnApply(IProjectorShell shell, Predicate`1 filter)
       at VI.Projector.Templates.ScriptTemplate`1.Apply(TTarget target, Predicate`1 phaseFilter)
       --- End of inner exception stack trace ---
       at VI.Projector.Templates.ScriptTemplate`1.Apply(TTarget target, Predicate`1 phaseFilter)
       at VI.Projector.Editor.Wizards.ShellWizard._CreateShell(Boolean doNotApplyTemplate, Boolean forceNewSchema)
       at VI.Projector.Editor.Wizards.ShellWizard.<.ctor>b__30_1(String key)
       at VI.UI.Wizards.WizardData.Get[T](String key, T defaultValue)
       at VI.Projector.Editor.Wizards.ShellWizard.OnDataChanged(WizardDataEventArgs e)
       at VI.UI.Wizards.WizardData._SignalChanged(String key, Object newValue, Object oldValue)
       at VI.UI.Wizards.WizardData.Set[T](String key, T value)
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFoundView.OnSaveData(IWizardData data)
       at VI.UI.Wizards.GuiWizardPageView.SaveData(IWizardData data)
       at VI.UI.Wizards.WizardPage.SaveData()
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFound.OnComplete()
       at VI.UI.Wizards.WizardPage.Complete()
       at VI.UI.Wizards.Wizard._HandlePageFinished(IWizardPage page)    at VI.Projector.Templates.ScriptTemplate`1.Apply(TTarget target, Predicate`1 phaseFilter)
       at VI.Projector.Editor.Wizards.ShellWizard._CreateShell(Boolean doNotApplyTemplate, Boolean forceNewSchema)
       at VI.Projector.Editor.Wizards.ShellWizard.<.ctor>b__30_1(String key)
       at VI.UI.Wizards.WizardData.Get[T](String key, T defaultValue)
       at VI.Projector.Editor.Wizards.ShellWizard.OnDataChanged(WizardDataEventArgs e)
       at VI.UI.Wizards.WizardData._SignalChanged(String key, Object newValue, Object oldValue)
       at VI.UI.Wizards.WizardData.Set[T](String key, T value)
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFoundView.OnSaveData(IWizardData data)
       at VI.UI.Wizards.GuiWizardPageView.SaveData(IWizardData data)
       at VI.UI.Wizards.WizardPage.SaveData()
       at VI.Projector.Editor.Wizards.PageShell07_ManyTemplatesFound.OnComplete()
       at VI.UI.Wizards.WizardPage.Complete()
       at VI.UI.Wizards.Wizard._HandlePageFinished(IWizardPage page)