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
Last Reviewed: February 19, 2000 |