Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

dbsrv9.exe - application error ASA 9.0.1.1862 when executing subquery

3 posts in General Discussion Last posting was on 2004-05-27 18:40:44.0Z
Dave Westphal Posted on 2004-05-27 15:50:18.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
Subject: dbsrv9.exe - application error ASA 9.0.1.1862 when executing subquery
Lines: 120
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_002C_01C443D8.3951B6F0"
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: xbonat.thrivent.com
X-Original-NNTP-Posting-Host: xbonat.thrivent.com
Message-ID: <40b60e3a$1@forums-1-dub>
Date: 27 May 2004 08:50:18 -0700
X-Trace: forums-1-dub 1085673018 64.214.85.60 (27 May 2004 08:50:18 -0700)
X-Original-Trace: 27 May 2004 08:50:18 -0700, xbonat.thrivent.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3081
Article PK: 6542

The error:
            dbsrv9.exe - application error             The instruction at "0x0063cf0c" referenced memory at "0x00000014".             The memory could not be "read".
 
occurs when I execute the following query in dbisqlc:
    SELECT Travel_ID, UserName, Group_desc     FROM vw_TravelCluster     where TimeEntered||':'||Travel_ID in (     select Min(TimeEntered||':'||Travel_ID)     from vw_TravelCluster group by Travel_Id);   In dbisqlc if I execute   SELECT Travel_ID, UserName, Group_desc FROM vw_TravelCluster;   followed by:   SELECT Travel_ID, UserName, Group_desc FROM vw_TravelCluster where TimeEntered||':'||Travel_ID in ( select Min(TimeEntered||':'||Travel_ID) from vw_TravelCluster group by Travel_Id);   I do not get the server crash.   Any ideas on what to look for?   Thanks in advance, Dave


Glenn Paulley Posted on 2004-05-27 17:28:34.0Z
Newsgroups: ianywhere.public.general
Subject: Re: dbsrv9.exe - application error ASA 9.0.1.1862 when executing subquery
From: Glenn Paulley <paulley@ianywhere.com>
References: <40b60e3a$1@forums-1-dub>
Organization: iAnywhere Solutions
Message-ID: <Xns94F688DFEB1E4paulleyianywherecom@10.22.241.106>
User-Agent: Xnews/5.04.25
NNTP-Posting-Host: paulley-t41.sybase.com
X-Original-NNTP-Posting-Host: paulley-t41.sybase.com
Date: 27 May 2004 10:28:34 -0700
X-Trace: forums-1-dub 1085678914 10.25.99.149 (27 May 2004 10:28:34 -0700)
X-Original-Trace: 27 May 2004 10:28:34 -0700, paulley-t41.sybase.com
Lines: 120
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3082
Article PK: 6544

The problem is likely access plan dependent; if you run the simpler query
first, it populates the cache with the contents of vw_TravelCluster
(which I assume is a view). The subsequent query doesn't cause the crash
because it's access plan is likely different from when the cache is cold.

If it is convenient, please open a case with Technical Support using
CaseXpress, and include a copy of your database and your command line for
starting the engine. One of my team will be happy to look at this in
short order.

Glenn

"Dave Westphal" <Dave_Westphal@aal.org> wrote in
news:40b60e3a$1@forums-1-dub:

> The error:
> dbsrv9.exe - application error
> The instruction at "0x0063cf0c" referenced memory at
> "0x00000014". The memory could not be "read".
>
> occurs when I execute the following query in dbisqlc:
> SELECT Travel_ID, UserName, Group_desc
> FROM vw_TravelCluster
> where TimeEntered||':'||Travel_ID in (
> select Min(TimeEntered||':'||Travel_ID)
> from vw_TravelCluster group by Travel_Id);
>
> In dbisqlc if I execute
>
> SELECT Travel_ID, UserName, Group_desc
> FROM vw_TravelCluster;
>
> followed by:
>
> SELECT Travel_ID, UserName, Group_desc
> FROM vw_TravelCluster
> where TimeEntered||':'||Travel_ID in (
> select Min(TimeEntered||':'||Travel_ID)
> from vw_TravelCluster group by Travel_Id);
>
> I do not get the server crash.
>
> Any ideas on what to look for?
>
> Thanks in advance,
> Dave
> ------=_NextPart_000_002C_01C443D8.3951B6F0
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
> <META content="MSHTML 6.00.2800.1400" name=GENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=#ffffff>
> <DIV><FONT face=Arial size=2>The error:</FONT></DIV><FONT face=Arial
> size=2><FONT size=2>
> <ADDRESS>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
> bsp; dbsrv9.exe - application error</ADDRESS>
> <ADDRESS>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
> bsp; The instruction at "0x0063cf0c" referenced memory at
> "0x00000014".</ADDRESS>
> <ADDRESS>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
> bsp; The memory could not be "read".</ADDRESS></FONT></FONT>
> <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> <DIV><FONT face=Arial size=2>occurs when I execute the
> following&nbsp;query in dbisqlc:</FONT></DIV>
> <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp; SELECT Travel_ID,
> UserName, Group_desc </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;FROM
> vw_TravelCluster </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;where
> TimeEntered||':'||Travel_ID in ( </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;select
> Min(TimeEntered||':'||Travel_ID) </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp; from
> vw_TravelCluster group by Travel_Id); </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2></FONT>&nbsp;</ADDRESS>
> <ADDRESS><FONT face=Arial size=2>In dbisqlc if I
> execute</FONT></ADDRESS> <ADDRESS><FONT face=Arial><FONT face="Times
> New Roman" size=2>&nbsp;</FONT> <ADDRESS><FONT face=Arial
> size=2>SELECT Travel_ID, UserName, Group_desc </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>FROM vw_TravelCluster;
> </FONT></ADDRESS> <ADDRESS><FONT size=2></FONT>&nbsp;</ADDRESS>
> <ADDRESS><FONT size=2>followed by:</FONT></ADDRESS>
> <ADDRESS><FONT size=2>&nbsp;</FONT>
> <ADDRESS><FONT face=Arial size=2>SELECT Travel_ID, UserName,
> Group_desc </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>FROM vw_TravelCluster
> </FONT></ADDRESS> <ADDRESS><FONT face=Arial size=2>where
> TimeEntered||':'||Travel_ID in ( </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>select
> Min(TimeEntered||':'||Travel_ID) </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>from vw_TravelCluster group by
> Travel_Id); </FONT></ADDRESS>
> <ADDRESS><FONT size=2></FONT>&nbsp;</ADDRESS>
> <ADDRESS><FONT size=2>I do not get the server crash.</FONT></ADDRESS>
> <ADDRESS><FONT
> size=2></FONT>&nbsp;</ADDRESS></ADDRESS></FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>Any ideas on what to look
> for?</FONT></ADDRESS> <ADDRESS><FONT face=Arial
> size=2></FONT>&nbsp;</ADDRESS> <ADDRESS><FONT face=Arial size=2>Thanks
> in advance,</FONT></ADDRESS> <ADDRESS><FONT face=Arial
> size=2>Dave</FONT></ADDRESS></BODY></HTML>
>
> ------=_NextPart_000_002C_01C443D8.3951B6F0--

--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288


Dave Westphal Posted on 2004-05-27 18:40:44.0Z
From: "Dave Westphal" <Dave_Westphal@aal.org>
Newsgroups: ianywhere.public.general
References: <40b60e3a$1@forums-1-dub> <Xns94F688DFEB1E4paulleyianywherecom@10.22.241.106>
Subject: Re: dbsrv9.exe - application error ASA 9.0.1.1862 when executing subquery
Lines: 129
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: xbonat.thrivent.com
X-Original-NNTP-Posting-Host: xbonat.thrivent.com
Message-ID: <40b6362c$1@forums-1-dub>
Date: 27 May 2004 11:40:44 -0700
X-Trace: forums-1-dub 1085683244 64.214.85.60 (27 May 2004 11:40:44 -0700)
X-Original-Trace: 27 May 2004 11:40:44 -0700, xbonat.thrivent.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3083
Article PK: 6543

I created a case ( 11038338), but had a problem uploading the zipped
database, it exceeds 2mb it is over 15mb in size. will try to delete some of
the data in the database.

"Glenn Paulley" <paulley@ianywhere.com> wrote in message
news:Xns94F688DFEB1E4paulleyianywherecom@10.22.241.106...
> The problem is likely access plan dependent; if you run the simpler query
> first, it populates the cache with the contents of vw_TravelCluster
> (which I assume is a view). The subsequent query doesn't cause the crash
> because it's access plan is likely different from when the cache is cold.
>
> If it is convenient, please open a case with Technical Support using
> CaseXpress, and include a copy of your database and your command line for
> starting the engine. One of my team will be happy to look at this in
> short order.
>
> Glenn
>
> "Dave Westphal" <Dave_Westphal@aal.org> wrote in
> news:40b60e3a$1@forums-1-dub:
>
> > The error:
> > dbsrv9.exe - application error
> > The instruction at "0x0063cf0c" referenced memory at
> > "0x00000014". The memory could not be "read".
> >
> > occurs when I execute the following query in dbisqlc:
> > SELECT Travel_ID, UserName, Group_desc
> > FROM vw_TravelCluster
> > where TimeEntered||':'||Travel_ID in (
> > select Min(TimeEntered||':'||Travel_ID)
> > from vw_TravelCluster group by Travel_Id);
> >
> > In dbisqlc if I execute
> >
> > SELECT Travel_ID, UserName, Group_desc
> > FROM vw_TravelCluster;
> >
> > followed by:
> >
> > SELECT Travel_ID, UserName, Group_desc
> > FROM vw_TravelCluster
> > where TimeEntered||':'||Travel_ID in (
> > select Min(TimeEntered||':'||Travel_ID)
> > from vw_TravelCluster group by Travel_Id);
> >
> > I do not get the server crash.
> >
> > Any ideas on what to look for?
> >
> > Thanks in advance,
> > Dave
> > ------=_NextPart_000_002C_01C443D8.3951B6F0
> > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> > <HTML><HEAD>
> > <META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
> > <META content="MSHTML 6.00.2800.1400" name=GENERATOR>
> > <STYLE></STYLE>
> > </HEAD>
> > <BODY bgColor=#ffffff>
> > <DIV><FONT face=Arial size=2>The error:</FONT></DIV><FONT face=Arial
> > size=2><FONT size=2>
> > <ADDRESS>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
> > bsp; dbsrv9.exe - application error</ADDRESS>
> > <ADDRESS>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
> > bsp; The instruction at "0x0063cf0c" referenced memory at
> > "0x00000014".</ADDRESS>
> > <ADDRESS>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n
> > bsp; The memory could not be "read".</ADDRESS></FONT></FONT>
> > <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
> > <DIV><FONT face=Arial size=2>occurs when I execute the
> > following&nbsp;query in dbisqlc:</FONT></DIV>
> > <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp; SELECT Travel_ID,
> > UserName, Group_desc </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;FROM
> > vw_TravelCluster </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;where
> > TimeEntered||':'||Travel_ID in ( </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp;&nbsp;select
> > Min(TimeEntered||':'||Travel_ID) </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>&nbsp;&nbsp;&nbsp; from
> > vw_TravelCluster group by Travel_Id); </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2></FONT>&nbsp;</ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>In dbisqlc if I
> > execute</FONT></ADDRESS> <ADDRESS><FONT face=Arial><FONT face="Times
> > New Roman" size=2>&nbsp;</FONT> <ADDRESS><FONT face=Arial
> > size=2>SELECT Travel_ID, UserName, Group_desc </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>FROM vw_TravelCluster;
> > </FONT></ADDRESS> <ADDRESS><FONT size=2></FONT>&nbsp;</ADDRESS>
> > <ADDRESS><FONT size=2>followed by:</FONT></ADDRESS>
> > <ADDRESS><FONT size=2>&nbsp;</FONT>
> > <ADDRESS><FONT face=Arial size=2>SELECT Travel_ID, UserName,
> > Group_desc </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>FROM vw_TravelCluster
> > </FONT></ADDRESS> <ADDRESS><FONT face=Arial size=2>where
> > TimeEntered||':'||Travel_ID in ( </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>select
> > Min(TimeEntered||':'||Travel_ID) </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>from vw_TravelCluster group by
> > Travel_Id); </FONT></ADDRESS>
> > <ADDRESS><FONT size=2></FONT>&nbsp;</ADDRESS>
> > <ADDRESS><FONT size=2>I do not get the server crash.</FONT></ADDRESS>
> > <ADDRESS><FONT
> > size=2></FONT>&nbsp;</ADDRESS></ADDRESS></FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>Any ideas on what to look
> > for?</FONT></ADDRESS> <ADDRESS><FONT face=Arial
> > size=2></FONT>&nbsp;</ADDRESS> <ADDRESS><FONT face=Arial size=2>Thanks
> > in advance,</FONT></ADDRESS> <ADDRESS><FONT face=Arial
> > size=2>Dave</FONT></ADDRESS></BODY></HTML>
> >
> > ------=_NextPart_000_002C_01C443D8.3951B6F0--
>
>
>
> --
> Glenn Paulley
> Research and Development Manager, Query Processing
> iAnywhere Solutions Engineering
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288