I am getting the following error when trying to INSERT into a Postgresql view across a linked server connection. Here is the error being reported in SQL Server.
Msg 0, Sev 0, State 1: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000]
Msg 3624, Sev 20, State 1, Line 63 : A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support. [SQLSTATE HY000]
Msg 0, Sev 20, State 1, Line 52 : process_error_log 0 [SQLSTATE 01000]
Msg 3624, Sev 20, State 1, Line 63 : Location: "e:\\sql9_sp2_t\\sql\\ntdbms\\msql\\utils\\oledblob.cpp":819 Expression: hr == S_OK SPID: 59 Process ID: 3780 [SQLSTATE 01000]
Msg 3624, Sev 20, State 1, Line 63 : Location: qxcntxt.cpp:1069 Expression: cref == 0 SPID: 59 Process ID: 3780 [SQLSTATE 01000]
I found the following message in the Server Event Application log from the time this error occured:
Exception occurred in destructor of RowsetNewSS 0x0000000081EBC250. This error may indicate a problem related to releasing pre-allocated disk blocks used during bulk-insert operations. Restart the server to resolve this problem.
Any idea what could be causing this? I have had inserts work in the past but they have started giving me these errors. The DBCC CHECKDB does not show any problems with the database. I have had to restart the server to clear the problem, which I can not keep doing. Can you give me an idea of what is going on in this section of the driver so that I can adjust my design?