search

patilgs / tarantino

Automatically exported from code.google.com/p/tarantino
0 stars 0 forks source link

There is insufficient system memory to run this query. #3

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Run a query with many inserts
2.
3.

What is the expected output? What do you see instead?

Internal Error: Microsoft.SqlServer.Management.Common.ExecutionFailureException
An exception occurred while executing a Transact-SQL statement or batch.

   at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
sqlCommand, ExecutionTypes executionType)
   at
Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String
sqlCommand)
   at
Tarantino.DatabaseManager.NAntTasks.Services.Impl.QueryExecutor.ExecuteNonQuery(
ConnectionSettings
settings, String sql)
   at
Tarantino.DatabaseManager.NAntTasks.Services.Impl.ChangeScriptExecutor.Execute(S
tring
fullFilename, ConnectionSettings settings, ITaskObserver taskObserver)
   at
Tarantino.DatabaseManager.NAntTasks.Services.Impl.DatabaseUpgrader.Upgrade(Strin
g
scriptDirectory, String server, String database, Boolean integrated, String
username, String password, DatabaseAction action, ITaskObserver
taskObserver, String databaseVersionPropertyName)
   at
Tarantino.DatabaseManager.NAntTasks.Services.Impl.ManageSqlDatabaseTask.ExecuteT
ask()
   at NAnt.Core.Task.Execute()
   at NAnt.Core.Target.Execute()
   at NAnt.Core.Project.Execute(String targetName, Boolean forceDependencies)
   at NAnt.Core.Tasks.CallTask.ExecuteTask()
   at NAnt.Core.Task.Execute()
   at NAnt.Core.Target.Execute()
   at NAnt.Core.Project.Execute(String targetName, Boolean forceDependencies)
   at NAnt.Core.Tasks.CallTask.ExecuteTask()
   at NAnt.Core.Task.Execute()
   at NAnt.Core.Target.Execute()
   at NAnt.Core.Project.Execute(String targetName, Boolean forceDependencies)
   at NAnt.Core.Project.Execute()
   at NAnt.Core.Project.Run()

What version of the product are you using? On what operating system?

Windows XP

Please provide any additional information below.

I have a sql file with a large number of insert statements.  When the
database is created the database has these rows inserted put the database
in it's starting state.

By a large number, I'm talking 42,745 (all the zip codes in the united states).

Original issue reported on code.google.com by TimBa...@gmail.com on 6 Nov 2008 at 5:52

GoogleCodeExporter commented 9 years ago 
Tim, did this get fixed?

Original comment by ferventc...@gmail.com on 24 Mar 2009 at 1:06

GoogleCodeExporter commented 9 years ago 
No it did not, I am looking at issues #1 and #2 currently and would like to
eventually hit #3.

Original comment by TimBa...@gmail.com on 24 Mar 2009 at 1:08

GoogleCodeExporter commented 9 years ago 
have you retried this since I upgraded the framework to run against the sql 
2008 
binaries?

Original comment by Eric.Hex...@gmail.com on 24 Mar 2009 at 1:26

GoogleCodeExporter commented 9 years ago 
I have not, will these binaries work even if I am on 2005?

Original comment by TimBa...@gmail.com on 24 Mar 2009 at 1:34