 |
|
|
What does 'General Network Error' mean?
This error message is usually a result of particularly high server load. It is not a direct result of your query.
A resubmit will usually fix this.
What does 'Column names in each table must be unique.' mean?
SQL requires that all columns within a table contain a unique name. This error usually occurs when a user inadvertantly tries to create a table with duplicate column names. For example, views 'iracCatalog' and 'mips24' both contain an 'ra' column, so if one tried a select * from both of these into a single table this error would occur. The fix is to explicity name the conflicting column as something else, so instead of doing 'select ra from iracCatalog' you could do 'select ra as ra2 from iracCatalog'.
What does 'Query results exceed memory limitations' mean?
This means the result of the query which you've submitted is
greater than the memory buffer will allow. This message only applies to 'quick'
queries; queries using 'submit' do not have any memory restrictions.
The easiest thing to do is just use submit instead of quick.
How may I check how many jobs are waiting in a given queue?
Go to the Queues page by clicking on the link here or in the menu-bar.
(How) can I bump up my MYDB size limit?
You may request additional space - you do not automatically get more space. Mail to
shiao@stsci.edu.
What happens if my query does not complete ?
We strictly limit the length of queries for up to eight hours. If your query fails to complete
in this amount of time you should ask for it to be analyzed and we will attempt to make your query more efficient.
Who do I notify if my job doesn't run for a long time (the queue appears to be stuck)?
Occasionally the service running the jobs hangs (although we hope to have fixed it in this version). If you see many waiting jobs and none executing mail B. Shiao.
Why can't I drop or create tables outside the MyDB context?
This is due to CasJobs' distributed operation and because SQL Server does not allow tables to be dropped or created remotely (from a
different server via a linked server connection). For more information, please see the CasJobs Limitations
due to Distributed Execution section in the Help page.
Why can't I run user-defined functions from outside the context of the DB in which they are defined?
This is due to CasJobs' distributed operation and because SQL Server does not allow user-defined functions to be executed remotely (from a
different server via a linked server connection). For more information, please see the CasJobs Limitations
due to Distributed Execution section in the Help page.
Contact MAST
CASJobs is made possible by the Sloan Digital Sky Survey Collaboration
$Name: v2_8_3 $
,$Revision: 1.11 $, Last modified: Wednesday, December 14, 2005 at 10:15:16 AM
