No access path defined for relation.
Deskin, Bob
Bob.Deskin@Cognos.COM
Wed, 24 Nov 2004 09:09:16 -0500
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4D22F.2F1D4467
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
You don't say where you get the message. Is it QDESIGN? And did you ever
get it before you moved to 8.43D (and from where)? What's the file type?
=20
In QDESIGN, the message means that QDESIGN can't figure out an access
path for the named table. Most files types require that an access path
be established by the time you enter BUILD.
=20
When you say intermittent, do you mean within the same screen or across
many screens. If the latter, check those screens and make sure an access
path has been established. It is possible that things were tightened up
in D.
Bob Deskin =20
Senior Product Manager, Application Development Tools, Cognos Inc.=20
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178=20
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA=20
-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Maeve Hooper
Sent: November 24, 2004 8:47 AM
To: powerh-l@lists.sowder.com
Cc: Paul Howard (E-mail); Mellina Coutouvidis
Subject: No access path defined for relation.
=09
=09
Hello=20
Does anybody know anything about this Powerhouse message. We are
getting it intermittently (We have recently upgraded to Powerhouse
843d). We are running against Sybase 12.5.0.3 and HP-UX 11.11
No access path defined for relation. (STAFF*01)=20
(Staff is the name of one of our tables).=20
Thanks!=20
Maeve Hooper=20
=20
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.=20
=20
------_=_NextPart_001_01C4D22F.2F1D4467
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16"><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2523" name=3DGENERATOR></HEAD><BODY =
><DIV>
<DIV><SPAN class=3D684400514-24112004><FONT face=3DArial color=3D#0000ff =
size=3D2>You=20
don't say where you get the message. Is it QDESIGN? And did you ever get =
it=20
before you moved to 8.43D (and from where)? What's the file=20
type?</FONT></SPAN></DIV>
<DIV><SPAN class=3D684400514-24112004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D684400514-24112004><FONT face=3DArial color=3D#0000ff =
size=3D2>In=20
QDESIGN, the message means that QDESIGN can't figure out an access path =
for the=20
named table. Most files types require that an access path be established =
by the=20
time you enter BUILD.</FONT></SPAN></DIV>
<DIV><SPAN class=3D684400514-24112004><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D684400514-24112004><FONT face=3DArial color=3D#0000ff =
size=3D2>When=20
you say intermittent, do you mean within the same screen or across many =
screens.=20
If the latter, check those screens and make sure an access path has been =
established. It is possible that things were tightened up in=20
D.</FONT></SPAN></DIV>
<DIV><SPAN class=3D684400514-24112004><!-- Converted from text/rtf =
format -->
<P><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Bob=20
Deskin &=
nbsp; =20
</FONT></SPAN><BR><SPAN lang=3Den-us><FONT face=3DArial size=3D2>Senior =
Product=20
Manager, Application Development Tools, Cognos Inc.</FONT></SPAN> =
<BR><SPAN=20
lang=3Den-us><FONT face=3DArial size=3D2>bob.deskin@cognos.com (613) =
738-1338 ext 7268=20
FAX: (613) 727-1178</FONT></SPAN> <BR><SPAN lang=3Den-us><FONT =
face=3DArial=20
size=3D2>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9=20
CANADA</FONT></SPAN> </P></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20
powerh-l-admin@lists.sowder.com =
[mailto:powerh-l-admin@lists.sowder.com] <B>On=20
Behalf Of </B>Maeve Hooper<BR><B>Sent:</B> November 24, 2004 8:47=20
AM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Cc:</B> Paul Howard =
(E-mail);=20
Mellina Coutouvidis<BR><B>Subject:</B> No access path defined for=20
relation.<BR><BR></FONT></DIV><!-- Converted from text/rtf format =
--><BR>
<P><FONT face=3DArial size=3D2>Hello</FONT> </P>
<P><FONT face=3DArial size=3D2>Does anybody know anything about this =
Powerhouse=20
message. We are getting it intermittently (We have recently upgraded =
to=20
Powerhouse 843d). We are running against Sybase 12.5.0.3 and HP-UX=20
11.11</FONT></P>
<UL>
<P><FONT face=3DArial color=3D#000000 size=3D2><I> No access =
path defined for=20
relation. (STAFF*01)</I></FONT> </P>
<P><I><FONT face=3DArial color=3D#000000 size=3D2>(Staff is the name =
of one of our=20
tables).</FONT></I> </P>
<P><I><FONT face=3DArial color=3D#000000 size=3D2>Thanks!</FONT></I> =
</P></UL>
<P><FONT face=3DArial size=3D2>Maeve Hooper</FONT> =
</P></BLOCKQUOTE></DIV>
<DIV> </DIV>
<DIV>
<P> <FONT FACE=3D"Arial" =
SIZE=3D"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>
</DIV></BODY></HTML>
------_=_NextPart_001_01C4D22F.2F1D4467--