The select is actually looking for a value in a column called DATA_TYPE in a
table called ALL_TAB_COLUMNS. I don't know SYBase, but I'd venture to guess
that ALL_TAB_COLUMNS is a system table in Sybase that contains all the
information about all the columns in all the tables in the sybase database.
In short, it's not a query running against the object database. It's a query
running against a sybase system table which is trying to determine what the
data type is of the objectdata column in the objects table.
>>-----Original Message-----
>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>Sent: Friday, June 01, 2001 8:45 AM
>>To: Spectra-Talk
>>Subject: strange error message in application.log
>>
>>
>>Does anyone have an idea of what is causing this error
>>message that has
>>been showing up repeatedly in the application.log ever since
>>I upgraded to
>>Spectra 1.5? I'm not concerned about the Sybase error code;
>>what I don't
>>understand is why Cold Fusion or Spectra would be trying to query the
>>ALL_TAB_COLUMNS in the OBJECT table when I see no sign that
>>ALL_TAB_COLUMNS
>>exists in the OBJECTS table.
>>
>>I upgraded 3 servers to SPectra 1.5 and this error message
>>only appears on
>>2 of them. It seems to occur most every time someone logs in
>>and also at
>>other random times.
>>
>>
>>
>>Error Message:
>>
>>"Error","TID=2608","06/01/01","06:38:23","Sybase Error Code =
>>208<P>ALL_TAB_COLUMNS not found. Specify owner.objectname or
>> use sp_help to check whether the object exists (sp_help may
>>produce lots of output). <P> <P> SQL = "select DATA_TYPE
>>from ALL_TAB_COLUMNS
>> where TABLE_NAME = 'objects' and COLUMN_NAME = 'objectdata'" "
>>
>>
>>
>>Thanks for any assistance,
>>
>>Jeffrey White
>>
>>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
