SQL error code = -901 Implementation limit exceeded
Fixing around 6700 roms from an old set to test more. New error, full log attached.
SQL error code = -901
Implementation limit exceeded
Too many values (more than 1500) in member list to match against ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -901
Implementation limit exceeded
Too many values (more than 1500) in member list to match against
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in C:\Projects\FirebirdSql.Data.FirebirdClient-4.8.1.0\FirebirdSql.Data.FirebirdClient-4.8.1.0\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:line 420
at FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText) in C:\Projects\FirebirdSql.Data.FirebirdClient-4.8.1.0\FirebirdSql.Data.FirebirdClient-4.8.1.0\NETProvider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 305
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Projects\FirebirdSql.Data.FirebirdClient-4.8.1.0\FirebirdSql.Data.FirebirdClient-4.8.1.0\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1178
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Projects\FirebirdSql.Data.FirebirdClient-4.8.1.0\FirebirdSql.Data.FirebirdClient-4.8.1.0\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1199
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Projects\FirebirdSql.Data.FirebirdClient-4.8.1.0\FirebirdSql.Data.FirebirdClient-4.8.1.0\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 525
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Projects\FirebirdSql.Data.FirebirdClient-4.8.1.0\FirebirdSql.Data.FirebirdClient-4.8.1.0\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 531
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\Projects\FirebirdSql.Data.FirebirdClient-4.8.1.0\FirebirdSql.Data.FirebirdClient-4.8.1.0\NETProvider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 637
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext1 c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher
1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action
3 executing, Action3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
at System.Data.Entity.Core.Objects.ObjectQuery
1.<>c__DisplayClass3.<GetResults>b__2()
at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)
at System.Data.Entity.Core.Objects.ObjectQuery
1.<>c__DisplayClass3.<GetResults>b__1()
at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func1 operation)
at System.Data.Entity.Core.Objects.ObjectQuery
1.GetResults(Nullable1 forMergeOption)
at System.Data.Entity.Core.Objects.ObjectQuery
1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()
at System.Data.Entity.Internal.LazyEnumerator1.MoveNext()
at System.Collections.Generic.List
1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable
1 source)
at RomCenter.DataAccess.Firebird.EF5.Ef.GetSingleFilesToRemove(List1 selectedItems) in C:\Projects\Romcenter4\DataAccess\Firebird\EF5\EF.cs:line 2443
at RomCenter.Engine.Controler.Controler.RunOperations(IFixableDb db, IList
1 operations, List1 items) in C:\Projects\Romcenter4\Engine\Controler\controler.cs:line 74
at RomCenter.Logic.Model.RwDatabase.Fix(IList
1 operations, List`1 items) in C:\Projects\Romcenter4\Logic\Model\RwDatabase.cs:line 299]]></log4net:exception></log4net:event>
<log4net:event logger="RomCenter" timestamp="2016-12-11T15:44:33.2876017-05:00" level="INFO" thread="UiThread1" domain="RomCenter.exe" username="upstairs\dpd"><log4net:message>Duration: 00:16:48</log4net:message><log4net:properties><log4net:data name="context" value="RomCenter.Global" /><log4net:data name="log4net:Identity" value="" /><log4net:data name="log4net:UserName" value="upstairs\dpd" /><log4net:data name="log4net:HostName" value="upstairs" /></log4net:properties></log4net:event>
Comments (8)
-
repo owner -
repo owner -
assigned issue to
-
assigned issue to
-
reporter I selected the files.
I don't need to actually clean this collection so I am using it for testing the app. I will leave it alone until you want/need another test.
-
repo owner If you select files, you are currently limited to 1500 items. This is a database limitation on the query. I will try to split the query in several parts to stay below 1500.
-
repo owner - edited description
- changed status to open
-
repo owner - changed status to resolved
-
repo owner - changed version to 4.0.0b09
-
repo owner - removed version
Removing version: 4.0.0b09 (automated comment)
- Log in to comment
Did you select all 6700 files before fixing, or only the rom path ?