I/O error Fatal error: Unknown device error -- transaction rolled back

This is a multi-part message in MIME format.

------=_NextPart_000_0013_01C4166C.3C733A00
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Any help on this issue would be helpful.

I was seeing an error in one of our applications. I narrowed it down to =
a portion of a stored procedure which I have included in the Code =
sample.

Info from server window:
  Adaptive Server Anywhere Network Server Version 9.0.1.1751
  Note: Database file "c:\aal\dr\data\db\tfl\tfl.db" consists of 1017 =
disk fragments
  Transaction log: tfl.log

Code sample:
Create variable vClientList long varchar;
begin
declare vFamilyNo integer;
declare vClientNo integer;
set vClientNo =3D 512412948;
select familyno into vFamilyNo from Contact where clientno =3D =
vClientNo;
select list (distinct clientno) into vClientList
from "DBA".Contact
Where "DBA".Contact.FamilyNo =3D VFamilyNo and=20
"DBA".Contact.Clientno <> 1999999999;
end;

Command that causes error:
message 'ClientList=3D ' + String(vClientList) + ' ' + String(now(*));

Error information from server window:
A read failed with error code: (38), Reached the end of the file. Fatal =
error: Unknown device error
Connection terminated abnormally Disconnected SharedMemory client's =
AppInfo: HOST=3D1665S;
OS=3DWindows 2000 Build 2195 Service Pack 4;PID=3D0x4cc;THREAD=3D0x19c;
EXE=3DC:\Program Files\Sybase\SQL Anywhere =
9\win32\dbisqlc.exe;VERSION=3D9.0.1.1751;
API=3DDBLIB;TIMEZONEADJUSTMENT=3D-360=20

Thanks in Advance
Dave Westphal
------=_NextPart_000_0013_01C4166C.3C733A00
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<ADDRESS><FONT face=3DArial>Any help on this issue would be=20
helpful.</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial></FONT>&nbsp;</ADDRESS>
<ADDRESS><FONT face=3DArial>I was seeing an error in one of our =
applications. I=20
narrowed it down to a portion of a stored procedure which I have =
included in the=20
Code sample.</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial></FONT>&nbsp;</ADDRESS>
<ADDRESS><FONT face=3DArial>Info from server window:</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial size=3D2>&nbsp; Adaptive Server Anywhere =
Network Server=20
Version 9.0.1.1751</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial size=3D2>&nbsp; Note: Database file=20
"c:\aal\dr\data\db\tfl\tfl.db" consists of 1017 disk =
fragments</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial size=3D2>&nbsp; Transaction log:=20
tfl.log</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial size=3D2></FONT>&nbsp;</ADDRESS><FONT =
size=3D2>
<ADDRESS><FONT face=3DArial size=3D3>Code sample:</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>Create variable vClientList long=20
varchar;</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>begin</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>declare vFamilyNo integer;</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>declare vClientNo integer;</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>set vClientNo =3D =
512412948;</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>select familyno into vFamilyNo from Contact =
where=20
clientno =3D vClientNo;</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>select list (distinct clientno) into=20
vClientList</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>from "DBA".Contact</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>Where "DBA".Contact.FamilyNo =3D VFamilyNo =
and=20
</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>"DBA".Contact.Clientno &lt;&gt;=20
1999999999;</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>end;</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial></FONT>&nbsp;</ADDRESS><FONT size=3D2>
<ADDRESS><FONT face=3DArial size=3D3>Command that causes =
error:</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial>message 'ClientList=3D ' + =
String(vClientList) + ' ' +=20
String(now(*));</FONT></ADDRESS>
<ADDRESS><FONT face=3DArial></FONT>&nbsp;</ADDRESS>
<ADDRESS><FONT face=3DArial size=3D3>Error information from server=20
window:</FONT></ADDRESS><FONT face=3DArial><FONT size=3D2>
<ADDRESS>A read failed with error code: (38), Reached the end of the =
file. Fatal=20
error: Unknown device error</ADDRESS>
<ADDRESS>Connection terminated abnormally Disconnected SharedMemory =
client's=20
AppInfo: HOST=3D1665S;</ADDRESS>
<ADDRESS>OS=3DWindows 2000 Build 2195 Service Pack=20
4;PID=3D0x4cc;THREAD=3D0x19c;</ADDRESS>
<ADDRESS>EXE=3DC:\Program Files\Sybase\SQL Anywhere=20
9\win32\dbisqlc.exe;VERSION=3D9.0.1.1751;</ADDRESS>
<ADDRESS>API=3DDBLIB;TIMEZONEADJUSTMENT=3D-360 </ADDRESS>
<ADDRESS>&nbsp;</ADDRESS>
<ADDRESS><FONT size=3D3>Thanks in Advance</FONT></ADDRESS>
<ADDRESS><FONT size=3D3>Dave=20
Westphal</FONT></ADDRESS></FONT></FONT></FONT></FONT></BODY></HTML>

------=_NextPart_000_0013_01C4166C.3C733A00--

0
Dave
3/30/2004 9:32:44 PM
sybase.sqlanywhere.general 32637 articles. 22 followers. Follow

3 Replies
1328 Views

Similar Articles

[PageSpeed] 7
Get it on Google Play
Get it on Apple App Store

Thanks for your post. Your reproducible is exceedingly similar to one 
posted last week, and I am pleased to report that this problem has 
already been fixed, and should be available in the first posted EBF of 
the 9.0.1 release. That EBF should appear on downloads.sybase.com in 
short order.

Glenn

"Dave Westphal" <Dave_Westphal@aal.org> wrote in
news:4069e777$1@forums-2-dub: 

> Any help on this issue would be helpful.
> 
> I was seeing an error in one of our applications. I narrowed it down
> to a portion of a stored procedure which I have included in the Code
> sample. 
> 
> Info from server window:
>   Adaptive Server Anywhere Network Server Version 9.0.1.1751
>   Note: Database file "c:\aal\dr\data\db\tfl\tfl.db" consists of 1017
>   disk fragments Transaction log: tfl.log
> 
> Code sample:
> Create variable vClientList long varchar;
> begin
> declare vFamilyNo integer;
> declare vClientNo integer;
> set vClientNo = 512412948;
> select familyno into vFamilyNo from Contact where clientno =
> vClientNo; select list (distinct clientno) into vClientList
> from "DBA".Contact
> Where "DBA".Contact.FamilyNo = VFamilyNo and 
> "DBA".Contact.Clientno <> 1999999999;
> end;
> 
> Command that causes error:
> message 'ClientList= ' + String(vClientList) + ' ' + String(now(*));
> 
> Error information from server window:
> A read failed with error code: (38), Reached the end of the file.
> Fatal error: Unknown device error Connection terminated abnormally
> Disconnected SharedMemory client's AppInfo: HOST=1665S; OS=Windows
> 2000 Build 2195 Service Pack 4;PID=0x4cc;THREAD=0x19c; EXE=C:\Program
> Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.1.1751; 
> API=DBLIB;TIMEZONEADJUSTMENT=-360 
> 
> Thanks in Advance
> Dave Westphal
> ------=_NextPart_000_0013_01C4166C.3C733A00
> <!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>
> <ADDRESS><FONT face=Arial>Any help on this issue would be 
> helpful.</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> <ADDRESS><FONT face=Arial>I was seeing an error in one of our
> applications. I narrowed it down to a portion of a stored procedure
> which I have included in the Code sample.</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> <ADDRESS><FONT face=Arial>Info from server window:</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>&nbsp; Adaptive Server Anywhere
> Network Server Version 9.0.1.1751</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2>&nbsp; Note: Database file 
> "c:\aal\dr\data\db\tfl\tfl.db" consists of 1017 disk
> fragments</FONT></ADDRESS> <ADDRESS><FONT face=Arial size=2>&nbsp;
> Transaction log: tfl.log</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial size=2></FONT>&nbsp;</ADDRESS><FONT size=2>
> <ADDRESS><FONT face=Arial size=3>Code sample:</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>Create variable vClientList long 
> varchar;</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>begin</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>declare vFamilyNo integer;</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>declare vClientNo integer;</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>set vClientNo = 512412948;</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>select familyno into vFamilyNo from Contact
> where clientno = vClientNo;</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>select list (distinct clientno) into 
> vClientList</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>from "DBA".Contact</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>Where "DBA".Contact.FamilyNo = VFamilyNo and
> </FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>"DBA".Contact.Clientno &lt;&gt; 
> 1999999999;</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial>end;</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS><FONT size=2>
> <ADDRESS><FONT face=Arial size=3>Command that causes
> error:</FONT></ADDRESS> <ADDRESS><FONT face=Arial>message 'ClientList=
> ' + String(vClientList) + ' ' + String(now(*));</FONT></ADDRESS>
> <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> <ADDRESS><FONT face=Arial size=3>Error information from server 
> window:</FONT></ADDRESS><FONT face=Arial><FONT size=2>
> <ADDRESS>A read failed with error code: (38), Reached the end of the
> file. Fatal error: Unknown device error</ADDRESS>
> <ADDRESS>Connection terminated abnormally Disconnected SharedMemory
> client's AppInfo: HOST=1665S;</ADDRESS>
> <ADDRESS>OS=Windows 2000 Build 2195 Service Pack 
> 4;PID=0x4cc;THREAD=0x19c;</ADDRESS>
> <ADDRESS>EXE=C:\Program Files\Sybase\SQL Anywhere 
> 9\win32\dbisqlc.exe;VERSION=9.0.1.1751;</ADDRESS>
> <ADDRESS>API=DBLIB;TIMEZONEADJUSTMENT=-360 </ADDRESS>
> <ADDRESS>&nbsp;</ADDRESS>
> <ADDRESS><FONT size=3>Thanks in Advance</FONT></ADDRESS>
> <ADDRESS><FONT size=3>Dave 
> Westphal</FONT></ADDRESS></FONT></FONT></FONT></FONT></BODY></HTML>
> 
> ------=_NextPart_000_0013_01C4166C.3C733A00--



-- 
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
0
Glenn
3/30/2004 10:41:21 PM
I have a very similar problem (the same error message) in a database running
on the ASA Engine version 8.0.2.4392.  (I can generate the error message
with a select (*)...order by... statement in a specific customer's
database.) Is there any plan to fix this issue in an EBF for Sybase 8?

"Glenn Paulley" <paulley@ianywhere.com> wrote in message
news:Xns94BCB3EF6C78Fpaulleyianywherecom@10.22.241.106...
> Thanks for your post. Your reproducible is exceedingly similar to one
> posted last week, and I am pleased to report that this problem has
> already been fixed, and should be available in the first posted EBF of
> the 9.0.1 release. That EBF should appear on downloads.sybase.com in
> short order.
>
> Glenn
>
> "Dave Westphal" <Dave_Westphal@aal.org> wrote in
> news:4069e777$1@forums-2-dub:
>
> > Any help on this issue would be helpful.
> >
> > I was seeing an error in one of our applications. I narrowed it down
> > to a portion of a stored procedure which I have included in the Code
> > sample.
> >
> > Info from server window:
> >   Adaptive Server Anywhere Network Server Version 9.0.1.1751
> >   Note: Database file "c:\aal\dr\data\db\tfl\tfl.db" consists of 1017
> >   disk fragments Transaction log: tfl.log
> >
> > Code sample:
> > Create variable vClientList long varchar;
> > begin
> > declare vFamilyNo integer;
> > declare vClientNo integer;
> > set vClientNo = 512412948;
> > select familyno into vFamilyNo from Contact where clientno =
> > vClientNo; select list (distinct clientno) into vClientList
> > from "DBA".Contact
> > Where "DBA".Contact.FamilyNo = VFamilyNo and
> > "DBA".Contact.Clientno <> 1999999999;
> > end;
> >
> > Command that causes error:
> > message 'ClientList= ' + String(vClientList) + ' ' + String(now(*));
> >
> > Error information from server window:
> > A read failed with error code: (38), Reached the end of the file.
> > Fatal error: Unknown device error Connection terminated abnormally
> > Disconnected SharedMemory client's AppInfo: HOST=1665S; OS=Windows
> > 2000 Build 2195 Service Pack 4;PID=0x4cc;THREAD=0x19c; EXE=C:\Program
> > Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.1.1751;
> > API=DBLIB;TIMEZONEADJUSTMENT=-360
> >
> > Thanks in Advance
> > Dave Westphal
> > ------=_NextPart_000_0013_01C4166C.3C733A00
> > <!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>
> > <ADDRESS><FONT face=Arial>Any help on this issue would be
> > helpful.</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> > <ADDRESS><FONT face=Arial>I was seeing an error in one of our
> > applications. I narrowed it down to a portion of a stored procedure
> > which I have included in the Code sample.</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> > <ADDRESS><FONT face=Arial>Info from server window:</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>&nbsp; Adaptive Server Anywhere
> > Network Server Version 9.0.1.1751</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2>&nbsp; Note: Database file
> > "c:\aal\dr\data\db\tfl\tfl.db" consists of 1017 disk
> > fragments</FONT></ADDRESS> <ADDRESS><FONT face=Arial size=2>&nbsp;
> > Transaction log: tfl.log</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial size=2></FONT>&nbsp;</ADDRESS><FONT size=2>
> > <ADDRESS><FONT face=Arial size=3>Code sample:</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>Create variable vClientList long
> > varchar;</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>begin</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>declare vFamilyNo integer;</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>declare vClientNo integer;</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>set vClientNo = 512412948;</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>select familyno into vFamilyNo from Contact
> > where clientno = vClientNo;</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>select list (distinct clientno) into
> > vClientList</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>from "DBA".Contact</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>Where "DBA".Contact.FamilyNo = VFamilyNo and
> > </FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>"DBA".Contact.Clientno &lt;&gt;
> > 1999999999;</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial>end;</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS><FONT size=2>
> > <ADDRESS><FONT face=Arial size=3>Command that causes
> > error:</FONT></ADDRESS> <ADDRESS><FONT face=Arial>message 'ClientList=
> > ' + String(vClientList) + ' ' + String(now(*));</FONT></ADDRESS>
> > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> > <ADDRESS><FONT face=Arial size=3>Error information from server
> > window:</FONT></ADDRESS><FONT face=Arial><FONT size=2>
> > <ADDRESS>A read failed with error code: (38), Reached the end of the
> > file. Fatal error: Unknown device error</ADDRESS>
> > <ADDRESS>Connection terminated abnormally Disconnected SharedMemory
> > client's AppInfo: HOST=1665S;</ADDRESS>
> > <ADDRESS>OS=Windows 2000 Build 2195 Service Pack
> > 4;PID=0x4cc;THREAD=0x19c;</ADDRESS>
> > <ADDRESS>EXE=C:\Program Files\Sybase\SQL Anywhere
> > 9\win32\dbisqlc.exe;VERSION=9.0.1.1751;</ADDRESS>
> > <ADDRESS>API=DBLIB;TIMEZONEADJUSTMENT=-360 </ADDRESS>
> > <ADDRESS>&nbsp;</ADDRESS>
> > <ADDRESS><FONT size=3>Thanks in Advance</FONT></ADDRESS>
> > <ADDRESS><FONT size=3>Dave
> > Westphal</FONT></ADDRESS></FONT></FONT></FONT></FONT></BODY></HTML>
> >
> > ------=_NextPart_000_0013_01C4166C.3C733A00--
>
>
>
> --
> 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


0
dbmerritt
3/31/2004 6:41:08 PM
Assuming that you have the same problem, it will be fixed in 8.0.2 build
4383.
-- 

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions  http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"dbmerritt" <dbmerritt@terralink.com> wrote in message
news:406b10c4$1@forums-1-dub...
> I have a very similar problem (the same error message) in a database
running
> on the ASA Engine version 8.0.2.4392.  (I can generate the error message
> with a select (*)...order by... statement in a specific customer's
> database.) Is there any plan to fix this issue in an EBF for Sybase 8?
>
> "Glenn Paulley" <paulley@ianywhere.com> wrote in message
> news:Xns94BCB3EF6C78Fpaulleyianywherecom@10.22.241.106...
> > Thanks for your post. Your reproducible is exceedingly similar to one
> > posted last week, and I am pleased to report that this problem has
> > already been fixed, and should be available in the first posted EBF of
> > the 9.0.1 release. That EBF should appear on downloads.sybase.com in
> > short order.
> >
> > Glenn
> >
> > "Dave Westphal" <Dave_Westphal@aal.org> wrote in
> > news:4069e777$1@forums-2-dub:
> >
> > > Any help on this issue would be helpful.
> > >
> > > I was seeing an error in one of our applications. I narrowed it down
> > > to a portion of a stored procedure which I have included in the Code
> > > sample.
> > >
> > > Info from server window:
> > >   Adaptive Server Anywhere Network Server Version 9.0.1.1751
> > >   Note: Database file "c:\aal\dr\data\db\tfl\tfl.db" consists of 1017
> > >   disk fragments Transaction log: tfl.log
> > >
> > > Code sample:
> > > Create variable vClientList long varchar;
> > > begin
> > > declare vFamilyNo integer;
> > > declare vClientNo integer;
> > > set vClientNo = 512412948;
> > > select familyno into vFamilyNo from Contact where clientno =
> > > vClientNo; select list (distinct clientno) into vClientList
> > > from "DBA".Contact
> > > Where "DBA".Contact.FamilyNo = VFamilyNo and
> > > "DBA".Contact.Clientno <> 1999999999;
> > > end;
> > >
> > > Command that causes error:
> > > message 'ClientList= ' + String(vClientList) + ' ' + String(now(*));
> > >
> > > Error information from server window:
> > > A read failed with error code: (38), Reached the end of the file.
> > > Fatal error: Unknown device error Connection terminated abnormally
> > > Disconnected SharedMemory client's AppInfo: HOST=1665S; OS=Windows
> > > 2000 Build 2195 Service Pack 4;PID=0x4cc;THREAD=0x19c; EXE=C:\Program
> > > Files\Sybase\SQL Anywhere 9\win32\dbisqlc.exe;VERSION=9.0.1.1751;
> > > API=DBLIB;TIMEZONEADJUSTMENT=-360
> > >
> > > Thanks in Advance
> > > Dave Westphal
> > > ------=_NextPart_000_0013_01C4166C.3C733A00
> > > <!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>
> > > <ADDRESS><FONT face=Arial>Any help on this issue would be
> > > helpful.</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> > > <ADDRESS><FONT face=Arial>I was seeing an error in one of our
> > > applications. I narrowed it down to a portion of a stored procedure
> > > which I have included in the Code sample.</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> > > <ADDRESS><FONT face=Arial>Info from server window:</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial size=2>&nbsp; Adaptive Server Anywhere
> > > Network Server Version 9.0.1.1751</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial size=2>&nbsp; Note: Database file
> > > "c:\aal\dr\data\db\tfl\tfl.db" consists of 1017 disk
> > > fragments</FONT></ADDRESS> <ADDRESS><FONT face=Arial size=2>&nbsp;
> > > Transaction log: tfl.log</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial size=2></FONT>&nbsp;</ADDRESS><FONT size=2>
> > > <ADDRESS><FONT face=Arial size=3>Code sample:</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>Create variable vClientList long
> > > varchar;</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>begin</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>declare vFamilyNo integer;</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>declare vClientNo integer;</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>set vClientNo = 512412948;</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>select familyno into vFamilyNo from Contact
> > > where clientno = vClientNo;</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>select list (distinct clientno) into
> > > vClientList</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>from "DBA".Contact</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>Where "DBA".Contact.FamilyNo = VFamilyNo and
> > > </FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>"DBA".Contact.Clientno &lt;&gt;
> > > 1999999999;</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial>end;</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS><FONT size=2>
> > > <ADDRESS><FONT face=Arial size=3>Command that causes
> > > error:</FONT></ADDRESS> <ADDRESS><FONT face=Arial>message 'ClientList=
> > > ' + String(vClientList) + ' ' + String(now(*));</FONT></ADDRESS>
> > > <ADDRESS><FONT face=Arial></FONT>&nbsp;</ADDRESS>
> > > <ADDRESS><FONT face=Arial size=3>Error information from server
> > > window:</FONT></ADDRESS><FONT face=Arial><FONT size=2>
> > > <ADDRESS>A read failed with error code: (38), Reached the end of the
> > > file. Fatal error: Unknown device error</ADDRESS>
> > > <ADDRESS>Connection terminated abnormally Disconnected SharedMemory
> > > client's AppInfo: HOST=1665S;</ADDRESS>
> > > <ADDRESS>OS=Windows 2000 Build 2195 Service Pack
> > > 4;PID=0x4cc;THREAD=0x19c;</ADDRESS>
> > > <ADDRESS>EXE=C:\Program Files\Sybase\SQL Anywhere
> > > 9\win32\dbisqlc.exe;VERSION=9.0.1.1751;</ADDRESS>
> > > <ADDRESS>API=DBLIB;TIMEZONEADJUSTMENT=-360 </ADDRESS>
> > > <ADDRESS>&nbsp;</ADDRESS>
> > > <ADDRESS><FONT size=3>Thanks in Advance</FONT></ADDRESS>
> > > <ADDRESS><FONT size=3>Dave
> > > Westphal</FONT></ADDRESS></FONT></FONT></FONT></FONT></BODY></HTML>
> > >
> > > ------=_NextPart_000_0013_01C4166C.3C733A00--
> >
> >
> >
> > --
> > 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
>
>


0
Chris
3/31/2004 7:33:50 PM
Reply:

Similar Artilces:

errors errors errors..
Name: harun Email: harunbjk1903hrnatgmaildotcom Product: Firefox Summary: errors errors errors.. Comments: first of all when i launch firefox (3) i cant enter websites via writing.. for example when I type "google" and then press ctrl and enter, it crashes.. and i take lots of error reports. firefox 2 was better.. see you again , harun Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; tr; rv:1.9) Gecko/2008052906 Firefox/3.0 From URL: http://hendrix.mozilla.org/ ...

Error, Error and more errors
Okay, all I wanted to do was test this app out and it has been a nightmare. 1.) Didn't install the sql database. I had to manually install it. 2.) I get errors when trying to add a picture to an album. "Procedure or function ngUpdatePicture has too many arguments specified" Any ideas? I've gotten more errors than this, but there is no use in bitchin. Are you using the v1.6.1 installer? Also, did you select to install the SQL Server db and give it a valid admin login? What were some of the error messages? Did you have an existing DB from a previous install? ...

error error error
These are the 2 new errors i am getting now:   1).  Server Error in '/' Application. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.Source Error: Line 53: ...

Fatal error: Unknown device error
I have been running into this error trying to test a Crystal report; it throws this error and appears to make the database server unusable until I manually shut it down and restart it. I have now rebuilt the database at least four times, using both iSQL and an ODBC utility I designed, with no effect. The crystal report executes a single database SELECT query, which references two views. I have not yet tried the SQL directly in iSQL, will try that next. Where does this error come from, and how can I prevent it from occurring? I am using 8.0.2, and have run into this with the l...

mpatdbi: Fatal error: Unknown device error
The ASA 9.0.2 engine on one of my servers intermittently encounters this failure. I usually down the engine and restart it. My questions are: Can call db_stop_database/db_start_database in embedded SQL and be on my merry way? Should I db_stop_engine/db_start_engine to resolve the problem? How do I trouble shoot this? I've exhausted my knowledge base. Is there a way to force the error in order to test resolving it as above? Thanks, -----Jon----- P.S. The database is 61GB so getting Sybase a copy is problematic. From another post, "This error occurs wh...

Fatal error: Unknown device error #4
The following error appeared in the database error log about the same time that my database server stopped responding to requests. Can anyone tell me what could cause this error? I. 03/10 14:45:25. A read failed with error code: (38), Reached the end of the file. E. 03/10 14:45:25. Fatal error: Unknown device error I. 03/10 14:45:25. Fatal error: Unknown device error I. 03/10 14:45:25. David Glenn wrote: > The following error appeared in the database error log about > the same time that my database server stopped responding to > requests. Can anyone tell me what could ca...

Fatal error: Unknown device error #3
SQL 7.0.3 Please, what is this error? during a processs... starting checkpoint of... finished checpoint of... starting checkpoint of... finished checpoint of... ... -> Fatal error: Unknown device error Thanks in advanced "ei" <NOCANSPAM_pmascaro@evolucioninformatica.com> wrote in news:4157bbe0$1@forums-2-dub: > SQL 7.0.3 > > Please, what is this error? > > during a processs... > > starting checkpoint of... > finished checpoint of... > starting checkpoint of... > fini...

Fatal error: Unknown device error #2
sybase version 9.0, EBF 1250, windows 200 server The server starts a single database and proceeds normally, at some point the server reports : E. 03/09 10:48:13. Fatal error: Unknown device error and shuts down. The output message file is attached. Thank you. Bill Urbanovsky I. 03/09 08:58:58. 1: -n I. 03/09 08:58:58. 2: irsaims I. 03/09 08:58:58. 3: -x I. 03/09 08:58:58. 4: TCPIP I. 03/09 08:58:58. 5: -p I. 03/09 08:58:58. 6: 1024 I. 03/09 08:58:58. 7: -i I. 03/09 08:58:58. 8: 720 I. 03/09 08:58:58. 9: -o I. 03/09 08:58:58. 10: serverlog.txt I. 03/09 08:58:58. 11:...

General error: I/O error
From a select statement, I get the following error... Select error: SQLSTATE = S1000 [Sybase][ODBC Driver][Adaptive Server Anywhere]General error:I/O error Fatal error: No error -- transaction rolled back. Since all I'm trying to do is a simple select, It seems like the database file is corrupt. Please advise if you have seen this error or know what is going on. The environment is ASA6.0.03 and WindowsNT4. Thank you. If you look in the window of the database server, do you see any errors? Can you execute other selects? -- Reg Domaratzki Sybase Mobile and...

CIFs Error: Storage Error Unknown error with error code: -602
Server was an Identity Migration target (source single server tree nw6sp5/edir8737/gw8hp1 to oes2sp1x64+latest patches), but I have been having problems with getting cifs to work since the migration. Whenever I go into iManager, file protocols, cifs & try to make any change other than stopping/starting the service I get the error in the subject (even to change something simple like the comment). Other oddities I noticed since the actual IM swap that somehow might have something to do with this: users arent LUM enabled or so it seems the afpProxyUser- & cifsProxyUser- both...

Server crash: Fatal error: Unknown device error
Hello - We are experiencing problems with ASA 8.0 with a specific query in our application. Running the query in ISQL causes the following error message to popup on the client and display in the server window: Fatal error: Unknown device error The DB server is essentially crashed at this point, and needs to be restarted. This does not seem to affect the database (I hope!), as the database starts and validates OK after the error. This happens consistently with a specific query in our app (which works OK in 7.0). I have boiled the problem down to a relatively simple test case...

Error error error, help me
Hello, How do I populate a drop down list in asp.net from a database? I have a block of vbscript code that does the server side coding for it. My code is as follows.. <script language="vb" runat="server"> Dim objConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data\employee.mdb;") Dim Sql, valEmp As String Dim objDREmp as OleDbDataReader Sub FillEmployeeName(sender As Object, e As System.EventArgs) Sql = "select * from [Employee]" Dim objCommand As Ole...

error after error
Hello, All I seem to be getting an error I don't quite understand. Can someone point out why I'm geeting this error? The first error states: unquoted string "subroutines" may clash with future reserved word at NPtest.pl line 6. after I quote "subroutines" I get an error that states: syntax error at NPtest.pl line 6, near "require" Execution of NPtest.pl aborted due to compilation errors. Heres the first script: #!/usr/bin/perl # NEWPACKAGE.pl package NEWPACKAGE sub printing1 {print "duh duh duh.\n&quo...

error error !
Full Message: ERROR{} Additional Information: None Severity: Error Date: November 14, 2007 11:42:35 AM Acknowledged Date: None Source: /Devices/Workstations/b2305dsyldes-58 Message ID: ERROR Probable Cause URL: None Log ID: ac4f2a9dbea6435421f4d9f92db8e971 Related Objects: None What does this means ? Marc-Andre, no idea, maybe a little more background information would help? -- Shaun Pond well, nothing special to say, some DLU policy, 1 remote policy, that's about it.......... Shaun Pond wrote: > Marc-Andre, > > no idea, maybe a little m...

Error or not error?
Hi gurus, hope you can help me with this problem: OS: Solaris 7 ASE: 12.5 I recently got some strange error messages when doing dbcc tablealloc with fix: *************************************************************** TABLE: hence_meaning OBJID = 100192376 INDID=0 FIRST=1817 ROOT=401935 SORT=0 INDID=2 FIRST=2882 ROOT=2881 SORT=1 Table Corrupt: Attempted to get page 330126, object 100192376; got page 0, object 0. Table Corrupt: Attempted to get page 272316, object 100192376; got page 0, object 0. Table Corrupt: Attempted to get page 322961, object 100192376; got p...

Web resources about - I/O error Fatal error: Unknown device error -- transaction rolled back - sybase.sqlanywhere.general

Transaction cost - Wikipedia, the free encyclopedia
Bargaining costs are the costs required to come to an acceptable agreement with the other party to the transaction, drawing up an appropriate ...

Sheryl Sandberg, Peter Thiel, Mail.ru Group Involved In Notable Facebook Stock Transactions
Facebook shares were involved in some large transactions in recent days, with moves by Chief Operating Officer Sheryl Sandberg , board member ...

Twitter’s Site Upgrade Reveals New Social, Transaction Possibilities for Third Parties
Twitter has launched the biggest redesign in its company history, introducing a new interface for Twitter.com that makes it easier to share and ...

Transaction Network Services - LinkedIn
Learn about working at Transaction Network Services. Join LinkedIn today for free. See who you know at Transaction Network Services, leverage ...

DocuSign Transaction Rooms (formerly Cartavi) on the App Store on iTunes
Get DocuSign Transaction Rooms (formerly Cartavi) on the App Store. See screenshots and ratings, and read customer reviews.

Banks playing key role in reporting transactions with suspected terrorism links, Austrac says
Australia's financial intelligence agency Austrac is monitoring the financial DNA of those Australians likely to transfer money to fund Islamic ...

IDG Contributor Network: Avoiding ginormous transaction logs with SharePoint databases
There isn’t a week that goes by that I don’t hear or read about an organization seeing ginormous transaction log (.ldf) files, while the associated ...

FTC Bans Wire Transfers, Reloadable Cash Cards, And Payment Orders In Phone Transactions
We’ve shared warnings about many different types of telemarketing scams, but they all have one thing in common: they extract money from their ...

After asking UAE bank for $3 million ransom, hacker dumps tens of thousands of customers' transactions ...
He calls himself Hacker Buba, and he's shared tens of thousands of customers' complete financial information.

Check your credit card transactions: 54 Starwood hotels hit by malware
Third-party forensic experts have discovered that the point-of-sale systems in 54 Starwood hotels across the US and Canada were infected with ...

Resources last updated: 12/29/2015 7:22:28 PM