Data access error on an indexed subfile.
Robert Mills
robert.mills@windsong-services.co.uk
Tue, 14 May 2002 14:01:30 +0100
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C1FB47.77039DA0
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C1FB47.77039DA0"
------_=_NextPart_001_01C1FB47.77039DA0
Content-Type: text/plain;
charset="iso-8859-1"
Opps.... forgot about that one. Thanks to all those who replied.
-----Original Message-----
From: Boyle, Joe [mailto:Joe.Boyle@cognos.com]
Sent: 14 May 2002 13:09
To: 'Robert Mills'; PowerHouse List (E-mail)
Subject: RE: Data access error on an indexed subfile.
Hi Robert,
I can't see a bug logged, could it be the old odd length problem ?
-----Original Message-----
From: Robert Mills [mailto:robert.mills@windsong-services.co.uk]
Sent: 14 May 2002 12:52
To: PowerHouse List (E-mail)
Subject: Data access error on an indexed subfile.
Greetings,
Environment: PH839C running under MPE/iX 6.5 on an HP e3000.
Just created a default quick screen to edit some data in an indexed subfile:
:qdesign
>screen foo
>file *sa055k1
>gen
>go
On entering find mode it displayed the following:
Data access error. (SA055K1*01)
THE FILE MUST BE LOCKED BEFORE ISSUING THIS INTRINSIC (FSERR 179)
I then tried again with a couple of other indexed subfiles. One worked and
the other did not... puzzled I am. A qshow of the files revealed that my
first file, SA055K1, had a repeating primary index and the others had a
unique primary index.
Any idea's what's going on as I don't remember having this problem with
PH729.
regards,
uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
Robert W.Mills, Systems Development Manager, Windsong Services
Electron House, Cray Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND
Tel: +44 (0)1689.870622 x 3005 Fax: +44 (0)1689 899026
robert.mills@windsong-services.co.uk
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
The thoughts, comments, and opinions expressed herein are mine.
They do not reflect those of my employer, nor anyone else.
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
***Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipients and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C1FB47.77039DA0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<STYLE>
BODY
{
FONT-SIZE: 10pt; MARGIN-LEFT: 50px; COLOR: #000000; BACKGROUND-REPEAT: repeat-y; FONT-FAMILY: Comic Sans MS; BACKGROUND-COLOR: #ffffff
}
</STYLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY
style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: Comic Sans MS; BACKGROUND-COLOR: #ffffff"
bgColor=#ffffff background=cid:370045912@14052002-2b60>
<DIV><SPAN class=370045912-14052002>Opps.... forgot about that one. Thanks to
all those who replied.</SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B> Boyle, Joe
[mailto:Joe.Boyle@cognos.com]<BR><B>Sent:</B> 14 May 2002 13:09<BR><B>To:</B>
'Robert Mills'; PowerHouse List (E-mail)<BR><B>Subject:</B> RE: Data access
error on an indexed subfile.<BR><BR></FONT></DIV>
<DIV><SPAN class=145240812-14052002><SPAN
class=463570812-14052002></SPAN>H<SPAN class=463570812-14052002>i
Robert,</SPAN></SPAN></DIV>
<DIV><SPAN class=145240812-14052002><SPAN
class=463570812-14052002></SPAN></SPAN> </DIV>
<DIV><SPAN class=145240812-14052002><SPAN class=463570812-14052002></SPAN>I
can't see a bu<SPAN class=463570812-14052002>g</SPAN> logged, could it be the
old odd length problem ?</SPAN></DIV>
<DIV><SPAN class=145240812-14052002></SPAN> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT
face=Tahoma>-----Original Message-----<BR><B>From:</B> Robert Mills
[mailto:robert.mills@windsong-services.co.uk]<BR><B>Sent:</B> 14 May 2002
12:52<BR><B>To:</B> PowerHouse List (E-mail)<BR><B>Subject:</B> Data access
error on an indexed subfile.<BR><BR></DIV></FONT>
<DIV><SPAN class=840522811-14052002>Greetings,</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>Environment: PH839C running under MPE/iX
6.5 on an HP e3000.</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>Just created a default quick
screen to edit some data in an indexed subfile:</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>
<DIV><SPAN class=840522811-14052002>:qdesign</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>screen foo</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>file *sa055k1</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>gen</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>>go</SPAN></DIV></SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN
class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002> On entering find mode it displayed
the following:</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002>Data access error.
(SA055K1*01)</SPAN></DIV>
<DIV><SPAN class=840522811-14052002>THE FILE MUST BE LOCKED BEFORE ISSUING
THIS INTRINSIC (FSERR 179)</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN class=840522811-14052002>I
then tried again with a couple of other indexed subfiles. One
worked and the other did not... puzzled I am. A qshow of the files
revealed that my first file, SA055K1, had a repeating primary index and the
others had a unique primary index.</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN
class=840522811-14052002></SPAN> </DIV>
<DIV><SPAN class=840522811-14052002></SPAN><SPAN
class=840522811-14052002>Any idea's what's going on as I don't remember
having this problem with PH729.</SPAN></DIV>
<DIV><SPAN class=840522811-14052002></SPAN> </DIV><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">regards,<BR><BR></SPAN>
<CENTER><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Wingdings">uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
</SPAN><BR><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Comic Sans MS'">Robert W.Mills,
Systems Development Manager, Windsong Services<BR>Electron House, Cray
Avenue, St. Mary Cray, Kent BR5 3PN, ENGLAND<BR>Tel: +44 (0)1689.870622 x
3005 Fax: +44 (0)1689 899026<BR>robert.mills@windsong-services.co.uk
</SPAN><BR><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Wingdings">vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
</SPAN><BR><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: 'Comic Sans MS'">The
thoughts, comments, and opinions expressed herein are mine.<BR>They do not
reflect those of my employer, nor anyone else. </SPAN><BR><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: Wingdings">vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
</SPAN><BR><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: 'Comic Sans MS'">***Confidentiality
Notice: This e-mail message, including any attachments, is for the sole use
of the intended recipients and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message. </SPAN>
<P></P></CENTER><FONT face="Comic Sans MS" size=3>
<DIV></DIV></BLOCKQUOTE></FONT><BR>
<P><FONT face=Arial size=2>This message may contain privileged and/or
confidential information. If you have received this e-mail in error or are not
the intended recipient, you may not use, copy, disseminate or distribute it;
do not open any attachments, delete it immediately from your system and notify
the sender promptly by e-mail that you have done so. Thank you.</FONT></P>
<P><FONT face=Arial size=2></FONT></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C1FB47.77039DA0--
------_=_NextPart_000_01C1FB47.77039DA0
Content-Type: image/jpeg;
name="Spiral Bound.jpg"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="Spiral Bound.jpg"
Content-ID: <370045912@14052002-2b60>
/9j/4AAQSkZJRgABAgEASABIAAD/7QSyUGhvdG9zaG9wIDMuMAA4QklNA+kAAAAAAHgAAwAAAEgA
SAAAAAADBgJS//f/9wMPAlsDRwUoA/wAAgAAAEgASAAAAAAC2AIoAAEAAABkAAAAAQADAwMAAAAB
Jw8AAQABAAAAAAAAAAAAAAAAYAgAGQGQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA4
QklNA+0AAAAAABAASAAAAAEAAQBIAAAAAQABOEJJTQPzAAAAAAAIAAAAAAAAAAA4QklNBAoAAAAA
AAEAADhCSU0nEAAAAAAACgABAAAAAAAAAAI4QklNA/UAAAAAAEgAL2ZmAAEAbGZmAAYAAAAAAAEA
L2ZmAAEAoZmaAAYAAAAAAAEAMgAAAAEAWgAAAAYAAAAAAAEANQAAAAEALQAAAAYAAAAAAAE4QklN
A/gAAAAAAHAAAP////////////////////////////8D6AAAAAD/////////////////////////
////A+gAAAAA/////////////////////////////wPoAAAAAP//////////////////////////
//8D6AAAOEJJTQQAAAAAAAACAAA4QklNBAIAAAAAAAIAADhCSU0ECAAAAAAAEAAAAAEAAAJAAAAC
QAAAAAA4QklNBAkAAAAAAqIAAAABAAAAgAAAAAIAAAGAAAADAAAAAoYAGAAB/9j/4AAQSkZJRgAB
AgEASABIAAD//gAnRmlsZSB3cml0dGVuIGJ5IEFkb2JlIFBob3Rvc2hvcKggNC4wAP/uAA5BZG9i
ZQBkgAAAAAH/2wCEAAwICAgJCAwJCQwRCwoLERUPDAwPFRgTExUTExgRDAwMDAwMEQwMDAwMDAwM
DAwMDAwMDAwMDAwMDAwMDAwMDAwBDQsLDQ4NEA4OEBQODg4UFA4ODg4UEQwMDAwMEREMDAwMDAwR
DAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDP/AABEIAAIAgAMBIgACEQEDEQH/3QAEAAj/xAE/
AAABBQEBAQEBAQAAAAAAAAADAAECBAUGBwgJCgsBAAEFAQEBAQEBAAAAAAAAAAEAAgMEBQYHCAkK
CxAAAQQBAwIEAgUHBggFAwwzAQACEQMEIRIxBUFRYRMicYEyBhSRobFCIyQVUsFiMzRygtFDByWS
U/Dh8WNzNRaisoMmRJNUZEXCo3Q2F9JV4mXys4TD03Xj80YnlKSFtJXE1OT0pbXF1eX1VmZ2hpam
tsbW5vY3R1dnd4eXp7fH1+f3EQACAgECBAQDBAUGBwcGBTUBAAIRAyExEgRBUWFxIhMFMoGRFKGx
QiPBUtHwMyRi4XKCkkNTFWNzNPElBhaisoMHJjXC0kSTVKMXZEVVNnRl4vKzhMPTdePzRpSkhbSV
xNTk9KW1xdXl9VZmdoaWprbG1ub2JzdHV2d3h5ent8f/2gAMAwEAAhEDEQA/APROif0Kv6X81T9L
j+ar/m/5K0F8rJJIfqlJfKySKn6pSXyskkp+qUl8rJJKfqlJfKySSn6pSXyskkp+qUl8rJJKfqlJ
fKySSn//2ThCSU0EBgAAAAAABwABAAAAAQEA//4AJ0ZpbGUgd3JpdHRlbiBieSBBZG9iZSBQaG90
b3Nob3CoIDQuMAD/7gAOQWRvYmUAZIAAAAAB/9sAhAAMCAgNCQ0VDAwVGhQQFBogGxoaGyAiFxcX
FxciEQwMDAwMDBEMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMAQ0NDREOERsRERsUDg4OFBQO
Dg4OFBEMDAwMDBERDAwMDAwMEQwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAz/wAARCAAYBaAD
ASIAAhEBAxEB/90ABABa/8QBPwAAAQUBAQEBAQEAAAAAAAAAAwABAgQFBgcICQoLAQABBQEBAQEB
AQAAAAAAAAABAAIDBAUGBwgJCgsQAAEEAQMCBAIFBwYIBQMMMwEAAhEDBCESMQVBUWETInGBMgYU
kaGxQiMkFVLBYjM0coLRQwclklPw4fFjczUWorKDJkSTVGRFwqN0NhfSVeJl8rOEw9N14/NGJ5Sk
hbSVxNTk9KW1xdXl9VZmdoaWprbG1ub2N0dXZ3eHl6e3x9fn9xEAAgIBAgQEAwQFBgcHBgU1AQAC
EQMhMRIEQVFhcSITBTKBkRShsUIjwVLR8DMkYuFygpJDUxVjczTxJQYWorKDByY1wtJEk1SjF2RF
VTZ0ZeLys4TD03Xj80aUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9ic3R1dnd4eXp7fH/9oADAMB
AAIRAxEAPwCv0T+n4/8AxrP+qavW15J0U/r+P/xrP+qavWg8eKElsWSHZfXWYe4A+ZUMjIFTJBE/
Fc1kXbg63mJP+amk0uesGqdc19Sup2ZrLmWGQxwLR4B35v8A0V0qKlJJJIqUkkkkpSSSSSlJJJJK
UkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSS
SSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJ
KUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpS
SSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJ
JKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkp
SSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJJJKUkkkkpSSSSSlJJ
JJKUkkkkpSSSSSn/0J9G6oKn04zKKXOdYA6x7d1kOP8Ag/3Hs/MXY/sOl/0hYfCT/wCQavnZJArQ
/S1HTXVN21+weYa7/vqzcroeQ+Q3XcYOn/mbF89pIaJfpboXRK+k1uDQPUsILyONPotZ/JatRfKq
SSX6qSXyqkip+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ
KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp
+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6
qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqp
JfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl
8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXy
qkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKq
SSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJ
KfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp
+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn6
qSXyqkkp+qkl8qpJKfqpJfKqSSn6qSXyqkkp+qkl8qpJKfqpJfKqSSn/2Q==
------_=_NextPart_000_01C1FB47.77039DA0--