Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

The query has been canceled !!

 
Sherif Shehab
Ranch Hand
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,

i'm getting this error when i'm trying to run a query on MS SQL 2000 :

i cant understand what is this error and i googled but i cant find anything explaing this

Any recommendation ?
 
Vinod K Singh
Ranch Hand
Posts: 198
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The query has been canceled because the estimated cost of this query (14616) exceeds the configured threshold of 30. Contact the system administrator.

The error message says that SQLServer is configured to not to run any query, which is supposed to take more than 30 (not sure if that is seconds or minutes ;) ) and the query you are trying to execute may take up to 14616.
 
Paul Campbell
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Sherif Shehab:
Hi all,

i'm getting this error when i'm trying to run a query on MS SQL 2000 :

i cant understand what is this error and i googled but i cant find anything explaing this

Any recommendation ?


Could you post your query... perhaps it could be made more efficient and you can get under the 30 sec exectution limit.
 
Sherif Shehab
Ranch Hand
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
actually it's very simple select query..
 
Paul Clapham
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So it doesn't have a WHERE clause, for example?
 
Sherif Shehab
Ranch Hand
Posts: 485
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Guys , i figured what caused this error , the DB admin is doing some maintenance to the db so he is canceling any requests for the db , so i'll try after this maintenance finish and i'll see...

Thanks much for your help guys
Merry Christmas to all
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic