BUG: Error 403 or 602 on Table Insert of UNION of Views

ID: Q133089

The information in this article applies to:
BUG# NT: 9377 (4.21a)

SYMPTOMS

An INSERT into a table of a SELECT on a view/UNION/view may fail with either an error 403 or an error 602.

An INSERT into a table (temporary or permanent) of a UNION ALL of two or more views may fail with the error:

Msg 403, Level 16, State 1:
Invalid operator for datatype op: UNKNOWN TOKEN type: <datatype>

A message will be generated for many, but not all, datatypes used in the column definitions.

An INSERT into a table of a UNION of secondary views (a view on a view) may fail with the error:
Msg 602, Level 21, State 3:
Could not find row in Sysindexes for dbid '4', object
'1932533918', index '0'. Run DBCC CHECKTABLE on Sysindexes.
The SQL Server is terminating this process.

NOTE: The dbid and object vary from case to case.


WORKAROUND

Break the UNION into individual INSERT statements. For example, you can rewrite the following query: 


   insert into table
   select * from view1
   UNION ALL
   select * from view2

to look like: 

   insert into table
   select * from view1
   insert into table
   select * from view2


STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.21a. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

This problem does not occur in SQL Server version 6.0.

Additional query words: Windows NT 


Keywords          : kbother SSrvProg kbbug4.21a SSrvWinNT 
Version           : 4.21a
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 19, 1999