<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>RE: Show files error</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText45239 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Hi all,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>We are in the process of migrating from
MPE/IX and Image to HP-UX and Oracle.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>In this process we have encounterd a smal
problem regarding attach to the database. It seems that quiz,qtp,quick need the
file resolv.conf and that we must have a DNS server to lookup in order to
connect to the database.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Is there a way to avoid this, ? we have
oracle and the application on the same server. When we delete resolv.conf we can
not attach to the database. We have a nameserver but this server is not
inhouse.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>we have set upp nsswitch.conf like
this</FONT></DIV>
<DIV dir=ltr><FONT
face="Courier New">hosts: dns
[NOTFOUND=continue] files<BR>ipnodes: dns
[NOTFOUND=continue] files<BR>networks:
files<BR>protocols:
files<BR>rpc:
files<BR>publickey: files<BR>netgroup:
files<BR>automount: files
nis<BR>aliases: files
nis<BR>services: files<BR></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>Best Regards</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>Jonas</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>Från:</B>
powerh-l-bounces+jonas.rosell=cefalo.se@lists.sowder.com genom Peter
Bateman<BR><B>Skickat:</B> to 2006-02-16 02:23<BR><B>Till:</B>
powerh-l@lists.sowder.com<BR><B>Ämne:</B> RE: Show files
error<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Harold:<BR><BR> My understanding of the NODELAY option is
that PowerHouse<BR> will try to open every relational database referenced
in the dictionary.<BR><BR> If my understanding is correct then could there
be a db that development<BR> powerhouse can't open?? But production
can open them all!<BR><BR>Regards,<BR>Peter<BR><BR>>thnx, but my QUIZ command
is already:<BR>><BR>>QUIZ == "$PH_LOCATION:QUIZA710G1
SUBDICT=(NODELAY,SEARCH)"<BR>><BR>>We have 840d1 installed and when I try
that version, it works fine in<BR>>production. However, in development,
I get a different error at the<BR>>same point:<BR>><BR>>*E* No
dictionary file with the specified name exists.<BR>><BR>>It appears to me
to be a Powerhouse bug of some sort. I've also been<BR>>informed that
other completely different Powerhouse systems in my area<BR>>also have the
same problem.<BR>><BR>><BR>> _____<BR>><BR>>From: Joe
Boyle [<A
href="mailto:atla38@dsl.pipex.com">mailto:atla38@dsl.pipex.com</A>]<BR>>Sent:
Tue, February 14, 2006 12:30 PM<BR>>To: Johnson, Harold A EDUC:EX;
powerh-l@lists.sowder.com<BR>>Subject: RE: Show files
error<BR>><BR>><BR>><BR>>in fact, it could be that you need to use
'qshow subdict=search'<BR>><BR>>Regards, Joe.<BR>><BR>>
_____<BR>><BR>>From:
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com<BR>>[<A
href="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com">mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</A>]
On<BR>>Behalf Of Joe Boyle<BR>>Sent: 14 February 2006 20:18<BR>>To:
Johnson, Harold A EDUC:EX; powerh-l@lists.sowder.com<BR>>Subject: Re: Show
files error<BR>><BR>><BR>><BR>>try 'show file in
mydbname'<BR>><BR>> ----- Original
Message -----<BR>><BR>> From: Johnson,
Harold A EDUC:EX<BR>><<A
href="mailto:Harold.A.Johnson@gov.bc.ca">mailto:Harold.A.Johnson@gov.bc.ca</A>><BR>><BR>>
To:
powerh-l@lists.sowder.com<BR>><BR>>
Sent: Tuesday, February 14, 2006 8:03
PM<BR>><BR>> Subject: Show files
error<BR>><BR>><BR>><BR>> Hi
all. I get the following error when I try to do a "Show<BR>>files"
command in quiz or qshow (for example). Any ideas what is<BR>>causing
this? I get the same error in all of our environments for
a<BR>>particular system (ie: deve, test, prod). It's been occuring for
some<BR>>time (months) but there doesn't seem to be any other problems
with<BR>>either the database or with
Powerhouse.<BR>><BR>> A QSHOW "show
record" of the product_component_version" comes<BR>>back
fine.<BR>> A "show table" in SQL is
fine.<BR>><BR>> OpenVMS
v7.3-2<BR>> Oracle RDB
v7.1-241<BR>> Powerhouse
v710g1<BR>><BR>>
$quiz<BR>><BR>> >show
file<BR>><BR>>
...<BR>><BR>> ... lots of
tables<BR>><BR>>
...<BR>><BR>> ALL_SNAPSHOTS IN
SFAS_DATABASE<BR>><BR>> USER_SNAPSHOTS
IN SFAS_DATABASE<BR>><BR>>
PRODUCT_COMPONENT_VERSION IN
SFAS_DATABASE<BR>><BR>> *E* Relational
Database access failed.<BR>><BR>>
%RDB-E-ARITH_EXCEPT, truncation of a numeric value at
runtime<BR>><BR>> %COSI-F-INTOVF,
integer
overflow<BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>><BR>>
_____<BR>><BR>><BR>>
--<BR>> = = = = = = = = = = = = = = = = =
= = = = = = = = = = =<BR>> Mailing list:
powerh-l@lists.sowder.com<BR>> Subscribe:
"subscribe" in message body
to<BR>>powerh-l-request@lists.sowder.com<BR>>
Unsubscribe: "unsubscribe &lt;password&gt;" in message body
to<BR>>powerh-l-request@lists.sowder.com<BR>>
<A
href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>>
This list is closed, thus to post to the list you must be
a<BR>>subscriber.<BR>><BR><BR><BR>>--<BR>>= = = = = = = = = = = = =
= = = = = = = = = = = = = = =<BR>>Mailing list:
powerh-l@lists.sowder.com<BR>>Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com<BR>>Unsubscribe: "unsubscribe
&lt;password&gt;" in message body
to<BR>>powerh-l-request@lists.sowder.com<BR>><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>>This
list is closed, thus to post to the list you must be a
subscriber.<BR><BR>_________________________________________________________________<BR>Powerful
Parental Controls Let your child discover the best the Internet has<BR>to
offer. <BR><A
href="http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines">http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines</A><BR>
Start enjoying all the benefits of MSN® Premium right now and get the<BR>first
two months FREE*.<BR><BR>--<BR>= = = = = = = = = = = = = = = = = = = = = = = = =
= = =<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe: "subscribe" in
message body to powerh-l-request@lists.sowder.com<BR>Unsubscribe: "unsubscribe
&lt;password&gt;" in message body to
powerh-l-request@lists.sowder.com<BR><A
href="http://lists.sowder.com/mailman/listinfo/powerh-l">http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This
list is closed, thus to post to the list you must be a
subscriber.<BR></FONT></P></DIV>
</BODY>
</HTML>