| Mahesh 2005-10-28, 5:03 pm |
| Hi All,
Hey this is my 1st topic on this community. Following is the
description:-
I am getting following error:-
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
The following stored procedure call failed: " { call
[dbo].[bts_InsertProperty]( ?, ?, ?, ?, ?)}". SQL Server returned error
string: "SqlDumpExceptionHandler: Process 58 generated fatal exception
c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this
process.
Scenario:- I have orchestration, in which I am looping through through
each record with the help of Xmlnodelist and xmlNode. I want to save
my file to SQL Server 2000 DB. I have created SP for insert into DB
table. Created Generated Items Schema with this SP with XML
AUTO,XMLDATA for my SQL Adapter.
Orchestration running fine upto the Send(SQL Adapter)shape.and after
that giving above exception. Nothing is happening in DB. Also not able
to catch SP execution in SQL profiler.
Any help on this will be helpful.
Thanks in advance.
|