Show files error

[Johnson, Harold A EDUC:EX]

Thnx, but in this particular case, there is only the one database.
Version 840d1 comes up with this error, but v710g1 comes up with the
previous error, using the same database.
 

-----Original Message-----
From: powerh-l-bounces+harold.a.johnson=gov.bc.ca at lists.sowder.com
[mailto:powerh-l-bounces+harold.a.johnson=gov.bc.ca at lists.sowder.com] On
Behalf Of Peter Bateman
Sent: Wed, February 15, 2006 5:23 PM
To: powerh-l at lists.sowder.com
Subject: RE: Show files error

Harold:

  My understanding of the NODELAY option is that PowerHouse
  will try to open every relational database referenced in the
dictionary.

  If my understanding is correct then could there be  a db that
development
  powerhouse can't open?? But production can open them all!

Regards,
Peter

>thnx, but my QUIZ command is already:
>
>QUIZ == "$PH_LOCATION:QUIZA710G1 SUBDICT=(NODELAY,SEARCH)"
>
>We have 840d1 installed and when I try that version, it works fine in 
>production.  However, in development, I get a different error at the 
>same point:
>
>*E* No dictionary file with the specified name exists.
>
>It appears to me to be a Powerhouse bug of some sort.  I've also been 
>informed that other completely different Powerhouse systems in my area 
>also have the same problem.
>
>
>   _____
>
>From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
>Sent: Tue, February 14, 2006 12:30 PM
>To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
>Subject: RE: Show files error
>
>
>
>in fact, it could be that you need to use 'qshow subdict=search'
>
>Regards, Joe.
>
>   _____
>
>From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
>[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On 
>Behalf Of Joe Boyle
>Sent: 14 February 2006 20:18
>To: Johnson, Harold A EDUC:EX; powerh-l at lists.sowder.com
>Subject: Re: Show files error
>
>
>
>try 'show file in mydbname'
>
>	----- Original Message -----
>
>	From: Johnson, Harold A EDUC:EX
><mailto:Harold.A.Johnson at gov.bc.ca>
>
>	To: powerh-l at lists.sowder.com
>
>	Sent: Tuesday, February 14, 2006 8:03 PM
>
>	Subject: Show files error
>
>
>
>	Hi all.  I get the following error when I try to do a "Show
files" 
>command in quiz or qshow (for example).  Any ideas what is causing 
>this?  I get the same error in all of our environments for a particular

>system (ie: deve, test, prod). It's been occuring for some time 
>(months) but there doesn't seem to be any other problems with either 
>the database or with Powerhouse.
>
>	A QSHOW "show record" of the product_component_version" comes
back 
>fine.
>	A "show table" in SQL is fine.
>
>	OpenVMS v7.3-2
>	Oracle RDB v7.1-241
>	Powerhouse v710g1
>
>	$quiz
>
>	>show file
>
>	...
>
>	... lots of tables
>
>	...
>
>	ALL_SNAPSHOTS IN SFAS_DATABASE
>
>	USER_SNAPSHOTS IN SFAS_DATABASE
>
>	PRODUCT_COMPONENT_VERSION IN SFAS_DATABASE
>
>	*E* Relational Database access failed.
>
>	%RDB-E-ARITH_EXCEPT, truncation of a numeric value at runtime
>
>	%COSI-F-INTOVF, integer overflow
>
>
>
>
>
>
>
>
>   _____
>
>
>	--
>	= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>	Mailing list: powerh-l at lists.sowder.com
>	Subscribe: "subscribe" in message body to 
>powerh-l-request at lists.sowder.com
>	Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at lists.sowder.com
>	http://lists.sowder.com/mailman/listinfo/powerh-l
>	This list is closed, thus to post to the list you must be a 
>subscriber.
>


>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: 
>powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" in message body to 
>powerh-l-request at lists.sowder.com
>http://lists.sowder.com/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.

_________________________________________________________________
Powerful Parental Controls Let your child discover the best the Internet
has to offer.  
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU
=http://hotmail.com/enca&HL=Market_MSNIS_Taglines
  Start enjoying all the benefits of MSN(r) Premium right now and get
the first two months FREE*.

--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe &lt;password&gt;" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.