SQL error code = -901 Implementation limit exceeded

Issue #18 resolved
datta created an issue

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.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action3 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.ObjectQuery1.<>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.ObjectQuery1.<>c__DisplayClass3.<GetResults>b__1() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func1 operation) at System.Data.Entity.Core.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0() at System.Data.Entity.Internal.LazyEnumerator1.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 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, IList1 operations, List1 items) in C:\Projects\Romcenter4\Engine\Controler\controler.cs:line 74 at RomCenter.Logic.Model.RwDatabase.Fix(IList1 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)

  1. datta 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.

  2. Eric Bole-Feysot 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.

  3. Log in to comment