Troubleshooting
Problem
When trying to open the last opened iBase Database from iBase User or from Analyst's Notebook, this error message is displayed :
"Sequence contains no elements"
Details :
System.InvalidOperationException: Sequence contains no elements.
at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
at i2.iBase.CoreSystem.idDBSystem.OpenDB(Boolean InternalOnly,Boolean NoPrompt, String& DatabaseFile, String SecurityFile,String Username, String Password, Boolean Exclusive, BooleanConnectLater, Boolean IgnoreDatabaseUsage, Boolean iBaseLogonOnly,Boolean blnRememberUserSelection)
at i2.iBase.CoreSystem.idDBSystem.OpenDatabaseEx(Boolean NoPrompt,String DatabaseFile, String SecurityFile, String Username, StringPassword, Boolean Exclusive, Boolean ConnectLater, BooleaniBaseLogonOnly, Boolean RememberUserSelection)
at i2.iBase.CoreSystem.idDBSystem.OpenDatabase(Boolean NoPrompt,String DatabaseFile, String SecurityFile, String Username, StringPassword, Boolean Exclusive, Boolean ConnectLater)
atSystem.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSitesite, T0 arg0, T1 arg1, T2 arg2)
at i2.iBase.Apps.User.FMain2.MobjAppCommands_DoCommand(Objectsource, DoCommandEventArgs e)
ati2.iBase.CoreSystem.Interfaces.DoCommandEventHandler.Invoke(Objectsource, DoCommandEventArgs e)
at i2.iBase.CoreSystem.idCommands.RaiseCommandEvents(String commandName, String databaseName, Object[]& varParameters)
at i2.iBase.CoreSystem.idCommands.doCommand(String CommandName,String DatabaseName, Object[] Parameters)
at i2.iBase.Apps.User.FMain2.AutoOpenDatabase()
ati2.iBase.Apps.User.FMain2.<OnStartDelayTimerTick>b__99_0()
"Sequence contains no elements"
Details :
System.InvalidOperationException: Sequence contains no elements.
at System.Linq.Enumerable.First[TSource](IEnumerable`1 source)
at i2.iBase.CoreSystem.idDBSystem.OpenDB(Boolean InternalOnly,Boolean NoPrompt, String& DatabaseFile, String SecurityFile,String Username, String Password, Boolean Exclusive, BooleanConnectLater, Boolean IgnoreDatabaseUsage, Boolean iBaseLogonOnly,Boolean blnRememberUserSelection)
at i2.iBase.CoreSystem.idDBSystem.OpenDatabaseEx(Boolean NoPrompt,String DatabaseFile, String SecurityFile, String Username, StringPassword, Boolean Exclusive, Boolean ConnectLater, BooleaniBaseLogonOnly, Boolean RememberUserSelection)
at i2.iBase.CoreSystem.idDBSystem.OpenDatabase(Boolean NoPrompt,String DatabaseFile, String SecurityFile, String Username, StringPassword, Boolean Exclusive, Boolean ConnectLater)
atSystem.Dynamic.UpdateDelegates.UpdateAndExecute3[T0,T1,T2,TRet](CallSitesite, T0 arg0, T1 arg1, T2 arg2)
at i2.iBase.Apps.User.FMain2.MobjAppCommands_DoCommand(Objectsource, DoCommandEventArgs e)
ati2.iBase.CoreSystem.Interfaces.DoCommandEventHandler.Invoke(Objectsource, DoCommandEventArgs e)
at i2.iBase.CoreSystem.idCommands.RaiseCommandEvents(String commandName, String databaseName, Object[]& varParameters)
at i2.iBase.CoreSystem.idCommands.doCommand(String CommandName,String DatabaseName, Object[] Parameters)
at i2.iBase.Apps.User.FMain2.AutoOpenDatabase()
ati2.iBase.Apps.User.FMain2.<OnStartDelayTimerTick>b__99_0()
Cause
The IDS and IDB files are not in the same folder.
Resolving The Problem
An APAR (PO09162) has been raised for this problem. A fix should be available.
Meanwhile, to solve this problem, you simply have to first connect to the Security file (IDS), and then connect to the actual iBase database (the IDB file).
If you follow this order, then the error message is not displayed, and the connection to the iBase database works.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB24","label":"Security Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSXW43","label":"i2 iBase"},"ARM Category":[{"code":"a8m50000000Caw4AAC","label":"i2 iBase and i2 Analyst's WorkStation->General"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.0.x"}]
Was this topic helpful?
Document Information
Modified date:
25 January 2021
UID
ibm16407816