• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

The query has been canceled !!

 
Ranch Hand
Posts: 493
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ?
 
Ranch Hand
Posts: 198
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
S Shehab
Ranch Hand
Posts: 493
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
actually it's very simple select query..
 
Marshal
Posts: 28193
95
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
So it doesn't have a WHERE clause, for example?
 
S Shehab
Ranch Hand
Posts: 493
Android Eclipse IDE Oracle
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic