EXCEPTION_ACCESS_VIOLATION

I am using SQL Server 7 and the following query giving
exception access violation error.
Error is : ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 14 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
Could you please suggest what could be wrong with the
Query.
It is working fine if I sub divide the Derived expression
to intermediate temporary tables.
SELECT D1.CHG_OFF_1,D1.REGION AS REGION,@.BUDGET_DATE AS
BUDGET_DATE,
(((D1.WB_AVG * ISNULL
(ANN_INTEREST,0))/TOTAL_DEPOSITS)/@.YEAR_DAYS) *
@.MONTH_DAYS AS WB_EXPENSE
INTO #WB_MTD
FROM ( SELECT COALESCE(D.CHG_OFF_1,L.CHG_OFF_1) AS
CHG_OFF_1,
COALESCE(D.REGION,L.REGION) AS REGION,
@.BUDGET_DATE AS BUDGET_DATE,
(((ISNULL(L.PRE_LOANS,0) - ISNULL
(D.PRE_DEPOSITS,0)) + (ISNULL(D.CUR_DEPOSITS,0) - ISNULL
(L.CUR_LOANS,0)))/2) AS WB_AVG
FROM (SELECT BUSINESS_DATE AS
BUDGET_DATE,CHG_OFF_1,REGION,SUM(ISNULL(CURR_BAL,0)) AS
CUR_DEPOSITS,SUM(ISNULL(PRE_BAL,0)) AS PRE_DEPOSITS
FROM DEPOSITS_CUBE_V
WHERE BUSINESS_DATE = @.BUDGET_DATE AND
CURR_BAL > 0
GROUP BY BUSINESS_DATE,CHG_OFF_1,REGION) AS D
FULL OUTER JOIN (SELECT BUSINESS_DATE AS
BUDGET_DATE,CHG_OFF_1,REGION,SUM(ISNULL(CURR_BAL,0)) AS
CUR_LOANS,SUM(ISNULL(PRE_BAL,0)) AS PRE_LOANS
FROM LOANS_CUBE_V WHERE BUSINESS_DATE = @.BUDGET_DATE AND CURR_BAL > 0
GROUP BY BUSINESS_DATE,CHG_OFF_1,REGION) AS L
ON D.BUDGET_DATE = L.BUDGET_DATE AND
D.CHG_OFF_1 = L.CHG_OFF_1 AND D.REGION = L.REGION ) AS D1
JOIN (SELECT REGION,SUM(ISNULL(CURR_BAL,0)) AS
TOTAL_DEPOSITS,SUM((ISNULL(CURR_BAL,0) * ISNULL
(RATE_LAST_USED,0))/100) AS ANN_INTEREST
FROM DEPOSITS_CUBE_V WHERE BUSINESS_DATE = @.BUDGET_DATE AND CURR_BAL > 0
GROUP BY REGION) AS R
ON D1.REGION = R.REGION
Thanks in advalceThere types of errors are typically bugs in SQL Server. Assuming you are current on service pack and
have searched KB already, I suggest you open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Girija Ponnaganti" <anonymous@.discussions.microsoft.com> wrote in message
news:006701c3ad6a$a59dd9b0$a401280a@.phx.gbl...
> I am using SQL Server 7 and the following query giving
> exception access violation error.
> Error is : ODBC: Msg 0, Level 19, State 1
> SqlDumpExceptionHandler: Process 14 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> Could you please suggest what could be wrong with the
> Query.
> It is working fine if I sub divide the Derived expression
> to intermediate temporary tables.
> SELECT D1.CHG_OFF_1,D1.REGION AS REGION,@.BUDGET_DATE AS
> BUDGET_DATE,
> (((D1.WB_AVG * ISNULL
> (ANN_INTEREST,0))/TOTAL_DEPOSITS)/@.YEAR_DAYS) *
> @.MONTH_DAYS AS WB_EXPENSE
> INTO #WB_MTD
> FROM ( SELECT COALESCE(D.CHG_OFF_1,L.CHG_OFF_1) AS
> CHG_OFF_1,
> COALESCE(D.REGION,L.REGION) AS REGION,
> @.BUDGET_DATE AS BUDGET_DATE,
> (((ISNULL(L.PRE_LOANS,0) - ISNULL
> (D.PRE_DEPOSITS,0)) + (ISNULL(D.CUR_DEPOSITS,0) - ISNULL
> (L.CUR_LOANS,0)))/2) AS WB_AVG
> FROM (SELECT BUSINESS_DATE AS
> BUDGET_DATE,CHG_OFF_1,REGION,SUM(ISNULL(CURR_BAL,0)) AS
> CUR_DEPOSITS,SUM(ISNULL(PRE_BAL,0)) AS PRE_DEPOSITS
> FROM DEPOSITS_CUBE_V
> WHERE BUSINESS_DATE = @.BUDGET_DATE AND
> CURR_BAL > 0
> GROUP BY BUSINESS_DATE,CHG_OFF_1,REGION) AS D
> FULL OUTER JOIN (SELECT BUSINESS_DATE AS
> BUDGET_DATE,CHG_OFF_1,REGION,SUM(ISNULL(CURR_BAL,0)) AS
> CUR_LOANS,SUM(ISNULL(PRE_BAL,0)) AS PRE_LOANS
> FROM LOANS_CUBE_V WHERE BUSINESS_DATE => @.BUDGET_DATE AND CURR_BAL > 0
> GROUP BY BUSINESS_DATE,CHG_OFF_1,REGION) AS L
> ON D.BUDGET_DATE = L.BUDGET_DATE AND
> D.CHG_OFF_1 = L.CHG_OFF_1 AND D.REGION = L.REGION ) AS D1
> JOIN (SELECT REGION,SUM(ISNULL(CURR_BAL,0)) AS
> TOTAL_DEPOSITS,SUM((ISNULL(CURR_BAL,0) * ISNULL
> (RATE_LAST_USED,0))/100) AS ANN_INTEREST
> FROM DEPOSITS_CUBE_V WHERE BUSINESS_DATE => @.BUDGET_DATE AND CURR_BAL > 0
> GROUP BY REGION) AS R
> ON D1.REGION = R.REGION
>
> Thanks in advalce

EXCEPTION_ACCESS_VIOLATION

I have installed SQL 2000 sp3a and I am getting and access
violation on even the simplest queries performed from the
Query Analyser.
Example
Select * from tblcode
Returns
SqlDumpExceptionHandler: Process 54 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process.
Any ideas will be greatly appreciated.| From: "Doug" <dougs@.inquiry-tracking.com>
| Sender: "Doug" <dougs@.inquiry-tracking.com>
| Subject: EXCEPTION_ACCESS_VIOLATION
| Date: Tue, 9 Dec 2003 10:36:06 -0800
|
| I have installed SQL 2000 sp3a and I am getting and access
| violation on even the simplest queries performed from the
| Query Analyser.
|
| Example
| Select * from tblcode
|
| Returns
|
| SqlDumpExceptionHandler: Process 54 generated fatal
| exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
| is terminating this process.
|
| Any ideas will be greatly appreciated.
--
Hi Doug,
You should raise a product support call on this.
Thanks,
--
Eric Cárdenas
SQL Server support
||||Same sh*t that happens to me, seems to be connected to sqlServer now
generatign faulty indexes, beats me as to how I'm to handle it.
Everytime the maintenanceplan has been run it fails and leaves a certain
table inoperable/inaccesible (due to sqlServer generation badly namded
_and_ duplicate named indexes that cannot be deleted) :(
Anyone else experiencing this problem?
Peace,
Johan
In article <1058e01c3be83$4ed4fbc0$a601280a@.phx.gbl>, dougs@.inquiry-
tracking.com says...
> I have installed SQL 2000 sp3a and I am getting and access
> violation on even the simplest queries performed from the
> Query Analyser.
> Example
> Select * from tblcode
> Returns
> SqlDumpExceptionHandler: Process 54 generated fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> is terminating this process.
> Any ideas will be greatly appreciated.
>|||Just found the answer - in article
http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q293/1/77.ASP&N
oWebContent=1
But since this only recognizes the problem with 'hind%'-indexes you'll
have to adjust statement to include (for example) '== '. This problems
seems to have been a well known fact for sql7 and "known" for sql2000.
After scanning this newsgroup it seems that I'm not the only one
experiencing this problem, and it seems to have risen to "fame" with
sp3a...
2 words - "fuck" & "microsoft"...
Peace,
Johan
In article <MPG.1a47a16784ac9671989681@.news.internet5.net>, johan@.fap.se
says...
> Same sh*t that happens to me, seems to be connected to sqlServer now
> generatign faulty indexes, beats me as to how I'm to handle it.
> Everytime the maintenanceplan has been run it fails and leaves a certain
> table inoperable/inaccesible (due to sqlServer generation badly namded
> _and_ duplicate named indexes that cannot be deleted) :(
> Anyone else experiencing this problem?
> Peace,
> Johan
> In article <1058e01c3be83$4ed4fbc0$a601280a@.phx.gbl>, dougs@.inquiry-
> tracking.com says...
> > I have installed SQL 2000 sp3a and I am getting and access
> > violation on even the simplest queries performed from the
> > Query Analyser.
> >
> > Example
> > Select * from tblcode
> >
> > Returns
> >
> > SqlDumpExceptionHandler: Process 54 generated fatal
> > exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
> > is terminating this process.
> >
> > Any ideas will be greatly appreciated.
> >
>|||| 2 words - "fuck" & "microsoft"...
|
| Peace,
| Johan
--
Johan,
Have you actually RAISED A CALL with MICROSOFT?
--
Eric Cárdenas
SQL Server support

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no changes
have been made to the jobs.
Any help is appreciated. Thanks
In this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks
|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no change
s
have been made to the jobs.
Any help is appreciated. ThanksIn this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks

Exception Access Violation

We are running SQL Server 2000, SP 3, and today have begun receiving the
following error: "Process 88 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
The error is occurring about every hour and appears to occur when an hourly
job is run to backup the transaction log for a db. The transaction log is
backed up and then the error appears to occur when SQL Server tries to write
a text report following the transaction log backup, the steps are part of a
database maintenance plan. This is the first time we've ever had a problem
with these jobs and they've been running for about 4 years now and no changes
have been made to the jobs.
Any help is appreciated. ThanksIn this case, you may have to call SQL Server support. SQL Server
has choked on something.
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
write
> a text report following the transaction log backup, the steps are part of
a
> database maintenance plan. This is the first time we've ever had a
problem
> with these jobs and they've been running for about 4 years now and no
changes
> have been made to the jobs.
> Any help is appreciated. Thanks|||While you should probably call PSS, the first thing they will ask is if you
are up to date on SPs...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:F7A1A30D-A8DD-41F7-A5B9-A3F162F6D7E8@.microsoft.com...
> We are running SQL Server 2000, SP 3, and today have begun receiving the
> following error: "Process 88 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
> The error is occurring about every hour and appears to occur when an
> hourly
> job is run to backup the transaction log for a db. The transaction log is
> backed up and then the error appears to occur when SQL Server tries to
> write
> a text report following the transaction log backup, the steps are part of
> a
> database maintenance plan. This is the first time we've ever had a
> problem
> with these jobs and they've been running for about 4 years now and no
> changes
> have been made to the jobs.
> Any help is appreciated. Thanks