Problem in error message

Problem in error message

Post by CBTa » Thu, 21 Nov 2002 12:24:24

I came across this error message
"CLI0119E Unexpected system failure.  "
when running INSERT INTO SQL to insert CLOB and VARCHAR type data into
a table.
does anyone know what does this mean ? what is the problem that cause
this error ? pls advise.thanks

1. Problem: strange error message

I've got strange problem

When i'm running following query

      convert(varchar(10), dbs.creation_date, 103),
      convert(varchar(10), dbs.preview_date, 103),
      convert(varchar(10), dbs.final_review_date, 103),

it generates an error:

Server: Msg 1038, Level 15, State 3, Line 7
Cannot use empty object or column names. Use a single space if necessary.
Server: Msg 1038, Level 15, State 1, Line 8
Cannot use empty object or column names. Use a single space if necessary.

In most cases it works ok and such expresion(isnull(Field,"")) is even used
in many stored procedures
But sometimes it starts to generate that error message. After waiting some
time and trying to apply change again it applies it successfuly and after it
works ok.
But i just started to generate similar query dynamicaly and pass to server
from COM object and it always generates that error in that case.

What is a problem, is there any real restriction on using empty string?
if yes why it usually allow to use it in stored procedures?
What can i do with it?

I know i can put single space instead of empty string, but in that case i
need to make changes in other places where empty string is expected now.
I could use space from the begining but it worked ok with empty string.

Problem is the same on SQL2000 and SQL7.0

I would be happy to receive any idea/suggestion why it works this way

Thank you


2. Problem in Query against TEXT datatype

3. Problem Decoding Error Message

4. Timestamp-Column in SQL-Server + ADO + VC

5. Problem with Error Message in VB 3.0 Applications

6. DTS problem...

7. DoEvents

8. Connect from Win32 to Informix-SE on Linux problem (-951 error message)

9. Problem getting error messages on Solaris using Informix7.2

10. Help:Record/Key Deleted message and Error message Numbers