No access path defined for relation.

Wed, 24 Nov 2004 14:53:56 -0000

This is a multi-part message in MIME format.

------_=_NextPart_001_01C4D235.6C486540
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

This is a second mail. Think I messed up first time.

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

=20

Sagar is correct I believe.

=20

We got this when migrating to 843d and Oracle 9i on HP-UX 11i.

=20

Build 1965.5 fixes it.

=20

=20

David

=20

=20

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Deskin, Bob
Sent: 24 November 2004 14:29
To: Maeve Hooper
Cc: Paul Howard (E-mail); Mellina Coutouvidis; powerh-l@lists.sowder.com
Subject: RE: No access path defined for relation.

=20

I suggest logging a call with support. This sounds familiar but I don't
recall the exact circumstances.

=20

Bob

	-----Original Message-----
	From: Maeve Hooper [mailto:mhooper@mhg.co.za]=20
	Sent: November 24, 2004 9:26 AM
	To: Deskin, Bob; powerh-l@lists.sowder.com
	Cc: Paul Howard (E-mail); Mellina Coutouvidis
	Subject: RE: No access path defined for relation.

	Sorry - I should have said we get it in Quick. The code compiles
fine - there is an access statement. So far, it is the same screen but
not all the time ie. we can't reproduce it. The message appears as the
user enters the screen in entry mode - no data has been entered. The
screen is called from a menu, so the user has probably done lots of
other things on other screens before getting this error.  This table is
widely used across the system.

	=20

	We moved to 8.43d from 8.43c.We weren't getting the error before
then, but we did change boxes at the same time so it is possible there
is also a setup issue.?

		-----Original Message-----
		From: Deskin, Bob [mailto:Bob.Deskin@Cognos.COM]
		Sent: Wednesday, November 24, 2004 4:09 PM
		To: Maeve Hooper; powerh-l@lists.sowder.com
		Cc: Paul Howard (E-mail); Mellina Coutouvidis
		Subject: RE: No access path defined for relation.

		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.

			=20

			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)

			(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

**********************************************************************
The above information is confidential to the Addresse and may be privileged=
. Unauthorised access and use is prohibited.

Internet communications are not secure and therefore this Company does not =
accept legal responsibility for the contents of this message.

If you are not the intended recipient, any disclosure, copying, distributio=
n or any action taken or omitted to be taken in reliance on it, is prohibit=
ed and may be unlawful.
**********************************************************************

------_=_NextPart_001_01C4D235.6C486540
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns:eXclaimer=3D"http://www.exclaimer.co.uk">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii">

<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<title>Message</title>

<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Wingdings;
	panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p
	{margin-right:0cm;
	margin-left:0cm;
	font-size:12.0pt;
	font-family:"Times New Roman";}
span.EmailStyle18
	{font-family:Arial;
	color:navy;}
@page Section1
	{size:595.3pt 841.9pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
 /* List Definitions */
 ol
	{margin-bottom:0cm;}
ul
	{margin-bottom:0cm;}
-->
</style>

</head>

<body lang=3DEN-GB link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

This is a second mail. Think I messed =
up
first time.

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;********************************=
**************************</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Sagar is correct I believe.</span></fo=
nt></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>We got this when migrating to 843d and
Oracle 9i on HP-UX 11i.</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Build 1965.5 fixes it.</span></font></=
p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>David</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span style=
=3D'font-size:
10.0pt;font-family:Arial;color:navy'>&nbsp;</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 face=3DTah=
oma><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> powerh-l-admin@lists.s=
owder.com
[mailto:powerh-l-admin@lists.sowder.com] <b><span style=3D'font-weight:bold=
'>On
Behalf Of </span></b>Deskin, Bob<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 24 November 2004 14:29=
<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Maeve Hooper<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> Paul Howard (E-mail); Me=
llina
Coutouvidis; powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: No access path
defined for relation.</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>&nbsp;</span></fo=
nt></p>

<div>

I
suggest logging a call with support. This sounds familiar but I don't recall
the exact circumstances.

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>&nbsp;</span></fo=
nt></p>

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 color=3Dbl=
ue
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:blue'>=
Bob</span></font></p>

</div>

<blockquote style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-right:0cm;margin-bottom:12.0pt;margin-=
left:
36.0pt'><font size=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:=
10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Maeve Hooper
[mailto:mhooper@mhg.co.za] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> November 24, 2004 9:26=
 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Deskin, Bob;
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> Paul Howard (E-mail); Me=
llina
Coutouvidis<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: No access path
defined for relation.</span></font></p>

<div>

=
Sorry -
I should have said we get it in Quick. The code compiles fine - there is an
access statement. So far, it is the same screen but not all the time ie. we
can't reproduce it. The message appears as the user enters the screen in en=
try
mode - no data has been entered. The screen is called from a menu, so the u=
ser
has probably done lots of other things on other screens before getting this
error.&nbsp; This table is widely used across the system.

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>&nbsp;</span></fo=
nt></p>

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 color=3Dbl=
ue
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:blue'>=
We moved
to 8.43d from 8.43c.We weren't getting the error before then, but we did ch=
ange
boxes at the same time so it is possible there is also a setup issue.?</spa=
n></font></p>

</div>

<blockquote style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-right:0cm;margin-bottom:12.0pt;margin-=
left:
36.0pt'><font size=3D2 face=3DTahoma><span style=3D'font-size:10.0pt;font-f=
amily:
Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Deskin, Bob
[mailto:Bob.Deskin@Cognos.COM]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, November 24=
, 2004
4:09 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Maeve Hooper;
powerh-l@lists.sowder.com<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> Paul Howard (E-mail); Me=
llina
Coutouvidis<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: No access path
defined for relation.</span></font></p>

<div>

<div>

=
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?</f=
ont>

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>&nbsp;</span></fo=
nt></p>

</div>

<div>

=
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.

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>&nbsp;</span></fo=
nt></p>

</div>

<div>

=
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.</fon=
t>

</div>

<div>

<p style=3D'margin-left:36.0pt'><font size=3D2 face=3DArial><span lang=3DEN=
-US
style=3D'font-size:10.0pt;font-family:Arial'><!-- Converted from text/rtf f=
ormat -->Bob
Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;
</span></font><br>
<font size=3D2 face=3DArial><span lang=3DEN-US style=3D'font-size:10.0pt;fo=
nt-family:
Arial'>Senior Product Manager, Application Development Tools, Cognos Inc.</=
span></font>
<br>
<font size=3D2 face=3DArial><span lang=3DEN-US style=3D'font-size:10.0pt;fo=
nt-family:
Arial'>bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178</s=
pan></font>
<br>
<font size=3D2 face=3DArial><span lang=3DEN-US style=3D'font-size:10.0pt;fo=
nt-family:
Arial'>3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA<=
/span></font><span
lang=3DEN-US> </span></p>

</div>

<blockquote style=3D'margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'>

<p class=3DMsoNormal style=3D'margin-right:0cm;margin-bottom:12.0pt;margin-=
left:
36.0pt'><font size=3D2 face=3DTahoma><span lang=3DEN-US style=3D'font-size:=
10.0pt;
font-family:Tahoma'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] <b=
><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Maeve Hooper<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> November 24, 2004 8:47=
 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> powerh-l@lists.sowder.co=
m<br>
<b><span style=3D'font-weight:bold'>Cc:</span></b> Paul Howard (E-mail); Me=
llina
Coutouvidis<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> No access path defi=
ned
for relation.</span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>&nbsp;</span></fo=
nt></p>

<!-- Converted from text/rtf format -->

<p style=3D'margin-left:36.0pt'><font size=3D2 face=3DArial><span style=3D'=
font-size:
10.0pt;font-family:Arial'>Hello</span></font> </p>

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</s=
pan>

=
&nbsp;No
access path defined for relation. (STAFF*01)

<p style=3D'margin-left:72.0pt'><i><font size=3D2 color=3Dblack face=3DAria=
l><span
style=3D'font-size:10.0pt;font-family:Arial;color:black;font-style:italic'>=
(Staff
is the name of one of our tables).</span></font></i> </p>

<p style=3D'margin-left:72.0pt'><i><font size=3D2 color=3Dblack face=3DAria=
l><span
style=3D'font-size:10.0pt;font-family:Arial;color:black;font-style:italic'>=
Thanks!</span></font></i>
</p>

<p style=3D'margin-left:36.0pt'><font size=3D2 face=3DArial><span style=3D'=
font-size:
10.0pt;font-family:Arial'>Maeve Hooper</span></font> </p>

</blockquote>

</div>

<div>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>&nbsp;</span></fo=
nt></p>

</div>

<div>

<p style=3D'margin-left:36.0pt'><font size=3D3 face=3D"Times New Roman"><sp=
an
style=3D'font-size:12.0pt'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span=
></font><font
size=3D2 face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial'>Th=
is message
may contain privileged and/or confidential information.&nbsp; 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, delet=
e it
immediately from your system and notify the sender promptly by e-mail that =
you
have done so.&nbsp; Thank you.</span></font> </p>

</div>

</blockquote>

</blockquote>

</div>

********************************************************************** 
The above information is confidential to the Addresse and may be privileged=
. Unauthorised access and use is prohibited. 
 
Internet communications are not secure and therefore this Company does not =
accept legal responsibility for the contents of this message. 
 
If you are not the intended recipient, any disclosure, copying, distributio=
n or any action taken or omitted to be taken in reliance on it, is prohibit=
ed and may be unlawful. 
********************************************************************** 

</body>

</html>
=00
------_=_NextPart_001_01C4D235.6C486540--