• State Not Answered
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 96 subscribers
  • Views 358 views
  • Users 0 members are here
Options
Related

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

ievgenii melnyk
26 days ago

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?

Parents
  • 0 22 days ago

    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

Reply
  • 0 22 days ago

    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

Children
  • 0 21 days ago in reply to erick ogai

    Thanks for your 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).


  • 0 21 days ago in reply to erick ogai 

    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)