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

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

Q133089

The information in this article applies to:

Microsoft SQL Server version 4.2x

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. This problem does not occur in SQL Server version 6.0.

Additional query words: Windows NT

Keywords : kbother
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2