Fatal System Error

Whats happening:

Error#: 40002
Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement has
been terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,
Column4, Column5, Column6) VALUES
("","Value1","Value2","Value3","Value4","Value5")'

Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement has
been terminated.

Active Form: frmForm
Form Name:

--
GETID Stored Procedure:
--

CREATE PROCEDURE GETID @.strsql text AS

PRINT cast(@.strsql as varchar(4000))

EXEC(" "
+@.strsql + " select @.@.identity as id")

GO
--

Anyone know what could be causing it? The database has changed - the
frontend code hasn't, so it has to be a database problem. What
happened was a few tables became incorrect so we restored them from a
backup. Everything else seems to work, apart from adding a new record
to this table.
You can edit current records etc..just not add.

Thanks in advance,[posted and mailed, please reply in news]

(lbillson@.netexperts.co.uk) writes:
> Whats happening:
> Error#: 40002
> Error Item: 01000: [Microsoft...][ODBC...][SQL...]The Statement has
> been terminated. > GETID 'INSERT INTO Table(Column1, Column2, Column 3,
> Column4, Column5, Column6) VALUES
> ("","Value1","Value2","Value3","Value4","Value5")'
> Error Message: 01000: Microsoft...][ODBC...][SQL...]The statement has
> been terminated.
>...
> Anyone know what could be causing it? The database has changed - the
> frontend code hasn't, so it has to be a database problem. What
> happened was a few tables became incorrect so we restored them from a
> backup. Everything else seems to work, apart from adding a new record
> to this table.

It appears that one error message has been lost somewhere. "The statement
has been terminated" is an accompanying message to the real error message.

I don't know what sort of client code you are using, but it seems that
the error handling needs a review. When working with SQL Server it's
essential to get all error message. And particularly the first error
message.

As for what have happened, it seems that the definition of the table has
changed, so that the statement is no longer correct. May be there is one
more column which is not nullable. You could also be running into a
key violation. Or, since you had restored some tables from backup, maybe
you are inserting a non-valid foreign key.

Your best bet is probably to run the query from Query Analyzer.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Fatal Error: Process 64 Generated fatal exception Urgent

List of errors we encountered
1) [Microsoft][ODBC Sql Server Driver][Named Pipes]
2) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 59 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
3) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 64 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
Any Ideas, Please Help.
Darbha
It is the case of an Access Violation (AV), which means a bug in SQL Server.
Can you pin point the query/statement that is causing this error? If so,
check KB and see if there is a fix available. If not, you are better off
contacting Microsoft support.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Darbha" <Darbha@.discussions.microsoft.com> wrote in message
news:AA2515E8-26CF-410D-AFFD-4D3A13C00EBB@.microsoft.com...
List of errors we encountered
1) [Microsoft][ODBC Sql Server Driver][Named Pipes]
2) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 59 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
3) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 64 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
Any Ideas, Please Help.
Darbha
|||It's not necessarily a bug. AVs could be caused by corruption and H/W as
well. Could you post the entire exception from SQL errorlogs.
Adrian
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e6UN0fmRFHA.2748@.TK2MSFTNGP09.phx.gbl...
> It is the case of an Access Violation (AV), which means a bug in SQL
> Server.
> Can you pin point the query/statement that is causing this error? If so,
> check KB and see if there is a fix available. If not, you are better off
> contacting Microsoft support.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Darbha" <Darbha@.discussions.microsoft.com> wrote in message
> news:AA2515E8-26CF-410D-AFFD-4D3A13C00EBB@.microsoft.com...
> List of errors we encountered
> 1) [Microsoft][ODBC Sql Server Driver][Named Pipes]
> 2) Error Test i am getting:
> [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> Process 59 Generated fatal exception c00000005
> EXCEPTION_ACESS_VIOLATION.SQL.
> Server is terminating this process
> 3) Error Test i am getting:
> [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> Process 64 Generated fatal exception c00000005
> EXCEPTION_ACESS_VIOLATION.SQL.
> Server is terminating this process
>
> Any Ideas, Please Help.
> Darbha
>

Fatal Error: Process 64 Generated fatal exception Urgent

List of errors we encountered
1) [Microsoft][ODBC Sql Server Driver][Named Pipes]
2) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 59 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
3) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 64 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
Any Ideas, Please Help.
DarbhaIt is the case of an Access Violation (AV), which means a bug in SQL Server.
Can you pin point the query/statement that is causing this error? If so,
check KB and see if there is a fix available. If not, you are better off
contacting Microsoft support.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Darbha" <Darbha@.discussions.microsoft.com> wrote in message
news:AA2515E8-26CF-410D-AFFD-4D3A13C00EBB@.microsoft.com...
List of errors we encountered
1) [Microsoft][ODBC Sql Server Driver][Named Pipes]
2) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 59 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
3) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 64 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
Any Ideas, Please Help.
Darbha|||It's not necessarily a bug. AVs could be caused by corruption and H/W as
well. Could you post the entire exception from SQL errorlogs.
Adrian
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:e6UN0fmRFHA.2748@.TK2MSFTNGP09.phx.gbl...
> It is the case of an Access Violation (AV), which means a bug in SQL
> Server.
> Can you pin point the query/statement that is causing this error? If so,
> check KB and see if there is a fix available. If not, you are better off
> contacting Microsoft support.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Darbha" <Darbha@.discussions.microsoft.com> wrote in message
> news:AA2515E8-26CF-410D-AFFD-4D3A13C00EBB@.microsoft.com...
> List of errors we encountered
> 1) [Microsoft][ODBC Sql Server Driver][Named Pipes]
> 2) Error Test i am getting:
> [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> Process 59 Generated fatal exception c00000005
> EXCEPTION_ACESS_VIOLATION.SQL.
> Server is terminating this process
> 3) Error Test i am getting:
> [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> Process 64 Generated fatal exception c00000005
> EXCEPTION_ACESS_VIOLATION.SQL.
> Server is terminating this process
>
> Any Ideas, Please Help.
> Darbha
>

Fatal Error: Process 64 Generated fatal exception c00000005.UREGEN

Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 64 Generated fatal exception c00000005 EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
My Work is not progressing because of this error
Any Ideas, Please Help..Darbha,
What did you do to get the error? This looks like a bug, and I would call
Microsoft Support. If it turns out to be a bug (which is likely) you will be
refunded for the call.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602­.html
"Darbha" wrote:
> Error Test i am getting:
> [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> Process 64 Generated fatal exception c00000005 EXCEPTION_ACESS_VIOLATION.SQL.
> Server is terminating this process
> My Work is not progressing because of this error
> Any Ideas, Please Help..
>|||On 16-April-2005, we had a power cut for a long time. Even though we have a
power backup. system got shut showing this error message. we are helpless here
even after consulting people who are familiar in this SQL databases.
Please help.
"Mark Allison" wrote:
> Darbha,
> What did you do to get the error? This looks like a bug, and I would call
> Microsoft Support. If it turns out to be a bug (which is likely) you will be
> refunded for the call.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602­.html
>
> "Darbha" wrote:
> > Error Test i am getting:
> > [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> > Process 64 Generated fatal exception c00000005 EXCEPTION_ACESS_VIOLATION.SQL.
> > Server is terminating this process
> >
> > My Work is not progressing because of this error
> > Any Ideas, Please Help..
> >|||We had three error messages before shutting down. i will send you each one of
this immediately. Please help
"Mark Allison" wrote:
> Darbha,
> What did you do to get the error? This looks like a bug, and I would call
> Microsoft Support. If it turns out to be a bug (which is likely) you will be
> refunded for the call.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602­.html
>
> "Darbha" wrote:
> > Error Test i am getting:
> > [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> > Process 64 Generated fatal exception c00000005 EXCEPTION_ACESS_VIOLATION.SQL.
> > Server is terminating this process
> >
> > My Work is not progressing because of this error
> > Any Ideas, Please Help..
> >|||List of errors we encountered
1) [Microsoft][ODBC Sql Server Driver][Named Pipes]
2) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 59 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
3) Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 64 Generated fatal exception c00000005
EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
Any Ideas, Please Help.
Darbha
"Mark Allison" wrote:
> Darbha,
> What did you do to get the error? This looks like a bug, and I would call
> Microsoft Support. If it turns out to be a bug (which is likely) you will be
> refunded for the call.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602­.html
>
> "Darbha" wrote:
> > Error Test i am getting:
> > [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> > Process 64 Generated fatal exception c00000005 EXCEPTION_ACESS_VIOLATION.SQL.
> > Server is terminating this process
> >
> > My Work is not progressing because of this error
> > Any Ideas, Please Help..
> >

Fatal Error: Process 64 Generated fatal exception c00000005.UREGEN

Error Test i am getting:
[Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
Process 64 Generated fatal exception c00000005 EXCEPTION_ACESS_VIOLATION.SQL.
Server is terminating this process
My Work is not progressing because of this error
Any Ideas, Please Help..
Darbha,
What did you do to get the error? This looks like a bug, and I would call
Microsoft Support. If it turns out to be a bug (which is likely) you will be
refunded for the call.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602X.html
"Darbha" wrote:

> Error Test i am getting:
> [Microsoft] [ODBC SQL Server Driver][SQL Server]SqlDumpExceptionHandler:
> Process 64 Generated fatal exception c00000005 EXCEPTION_ACESS_VIOLATION.SQL.
> Server is terminating this process
> My Work is not progressing because of this error
> Any Ideas, Please Help..
>

Fastest way to transfer data from DB2 on host to SQL Server

Hello all,
I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
via db2 connect and ODBC to transfer the data. The data size is 30GB. It
would take more than 2 day. It abended two times.
What is the fastest way to transfer data other than this way?
How can I make faster in this case?
any comments?
Thanks in advance,
Do.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1Are these two boxes in the same location?
"Do Park via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:533A6B9900AD9@.SQLMonster.com...
> Hello all,
> I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
> via db2 connect and ODBC to transfer the data. The data size is 30GB. It
> would take more than 2 day. It abended two times.
> What is the fastest way to transfer data other than this way?
> How can I make faster in this case?
> any comments?
> Thanks in advance,
> Do.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1|||StarQuest has a very fast replication solution, they should be able to
help you reduce considerably the transfer window:
http://www.starquest.com/Productfolder/infoSQDR.html
Good luck,
Bob
Do Park via SQLMonster.com wrote:
> Hello all,
> I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
> via db2 connect and ODBC to transfer the data. The data size is 30GB. It
> would take more than 2 day. It abended two times.
> What is the fastest way to transfer data other than this way?
> How can I make faster in this case?
> any comments?
> Thanks in advance,
> Do.
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200508/1

Fastest way to transfer data from DB2 on host to SQL Server

Hello all,
I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
via db2 connect and ODBC to transfer the data. The data size is 30GB. It
would take more than 2 day. It abended two times.
What is the fastest way to transfer data other than this way?
How can I make faster in this case?
any comments?
Thanks in advance,
Do.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200508/1
Are these two boxes in the same location?
"Do Park via droptable.com" <forum@.droptable.com> wrote in message
news:533A6B9900AD9@.droptable.com...
> Hello all,
> I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
> via db2 connect and ODBC to transfer the data. The data size is 30GB. It
> would take more than 2 day. It abended two times.
> What is the fastest way to transfer data other than this way?
> How can I make faster in this case?
> any comments?
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200508/1
|||StarQuest has a very fast replication solution, they should be able to
help you reduce considerably the transfer window:
http://www.starquest.com/Productfolder/infoSQDR.html
Good luck,
Bob
Do Park via droptable.com wrote:
> Hello all,
> I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
> via db2 connect and ODBC to transfer the data. The data size is 30GB. It
> would take more than 2 day. It abended two times.
> What is the fastest way to transfer data other than this way?
> How can I make faster in this case?
> any comments?
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...erver/200508/1

Fastest way to transfer data from DB2 on host to SQL Server

Hello all,
I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
via DB2 connect and ODBC to transfer the data. The data size is 30GB. It
would take more than 2 day. It abended two times.
What is the fastest way to transfer data other than this way?
How can I make faster in this case?
any comments?
Thanks in advance,
Do.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200508/1Are these two boxes in the same location?
"Do Park via droptable.com" <forum@.droptable.com> wrote in message
news:533A6B9900AD9@.droptable.com...
> Hello all,
> I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
> via DB2 connect and ODBC to transfer the data. The data size is 30GB. It
> would take more than 2 day. It abended two times.
> What is the fastest way to transfer data other than this way?
> How can I make faster in this case?
> any comments?
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200508/1|||StarQuest has a very fast replication solution, they should be able to
help you reduce considerably the transfer window:
http://www.starquest.com/Productfolder/infoSQDR.html
Good luck,
Bob
Do Park via droptable.com wrote:
> Hello all,
> I am transfering data from DB2 on z/OS (MVS) to SQL Server 2000. I use DTS
> via DB2 connect and ODBC to transfer the data. The data size is 30GB. It
> would take more than 2 day. It abended two times.
> What is the fastest way to transfer data other than this way?
> How can I make faster in this case?
> any comments?
> Thanks in advance,
> Do.
>
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forum...server/200508/1

Faster ODBC connections wanted on W2K

Hi
I've been developing an app that use ODBC connections to connect to a database server (SqlServer, MySql or Oracle for the moment).
I noticed that SqlServer connection from a client was between 5 and 6 time faster with a server installed on W2K professional than on W2K Server.
These 2 servers have similar hardware and the same version of SqlServer installed.
The only ODBC parameters that changes on the client is the IP adress of the server.
Do you know what is the problem ?
Do you have some software solutions to get a faster SqlServer ?Need more information.
-Is the client running an a third box or one one or both of the sql-servers?
-Are the databases on either identical? same idnexes, etc?
-Is either sql-server set to use a different amt of ram? Check in the server properteis in em.
-Is either sql-server database set up on a different physical disk than the other? is it the same disk as the os or swapfile?
-Has either server been up and running for a while? If either server has already cached the requested data, it will be much faster. Try them both again after a fresh restart.
-Have you tried OLE-DB instead of ODBC? It tends to perform better.
-Are the two sql-servers on the same network or is one on another subnet or in some other location?

...|||Thank you for your answer.

You wrote :
-Is the client running an a third box or one one or both of the sql-servers?
The client is running on a third box.

-Are the databases on either identical? same idnexes, etc?
The databases are identicals (tables and indexes generated by the client itself)

-Is either sql-server set to use a different amt of ram? Check in the server properteis in em.
I think SqlServers installations are standards so they should use the same amount of memory but how can I check it ?

-Is either sql-server database set up on a different physical disk than the other? is it the same disk as the os or swapfile?
I don't understand your first question but It's the same HD than the OS (installed on C:\MSSQL7)

-Has either server been up and running for a while? If either server has already cached the requested data, it will be much faster. Try them both again after a fresh restart.
Even if the servers have just been started, the result is that it's slower on W2K Server.

-Have you tried OLE-DB instead of ODBC? It tends to perform better.
I have to use ODBC

-Are the two sql-servers on the same network or is one on another subnet or in some other location?
They are on the same network.

As you can see, there is no reason to have my app being slower with W2K server than with W2K pro but i'm not crazy, it's 5 or 6 time slower !
I'm sure that the problem is concerning W2K Server itself : a security option to disable, a service to stop ... I don't know ... I'm just a developer ... not a W2K expert. The problem occured on 2 different PC using W2K Server and I never encountered the problem on W2K pro.

On W2K Server, I check that background services was prefered to applications, I try to set the network card to use 'Full Duplex' but the problem is the same.

Thank you for your help.|||Hmmmm This is curious...

- Regarding the disk setup, my thought was that perhaps the data files were on a seperate physical disk from the OS/swapfile on one machine or the other, but that appears to not be the case.

- Regarding the memory settings, in Enterprise Manager, right click on the server and select properties, select the memory tab and check that the settings are identical for both systems.

- Have you checked to make sure that both ODBC connections are configured to use the same network library? You can do this by clicking on the 'client configuration' button during the DSN setup.

- I would run a profiler trace to watch the processes run and see if they are taking the same amount of time to process in SQL Server and if the problem might be with the network transmission. You can then capture the queries being used, paste them into Query Analyzer and get an execution plan on each sql-server to see if they're parsing the query the same way on each.