Show files error

Tue Feb 14 14:34:20 CST 2006

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060214/d5d969b0/attachment-0001.html