Powerhouse 8.40.D on VMS vs 8.43.C on Solaris

[Joe Boyle]

if there are two database instances, one on each of the VMS and UNIX
servers, it may be worth mapping a small pdl file to look at the UNIX
database and compile a problem screen against it form the VMS platform. This
would at least indicate if the issue is due to the Oracle setup or the PH
setup.

If the new screen works it might be the case that there is a difference in
the setup of the two instances, you could then compare Oracle INIT files
etc. Otherwise you will have to wait for a fix from Cognos - assuming it's
due to a bug.

It's unusual to use a get to a passed record buffer - presumably this is to
make the most of a buffer when you have used all 31 opens used. Normally,
ghost screens would be used to get details and pass them back, but I note
your comment that there is two much to recode.

Regards, Joe.

This e-mail and all information contained in it is confidential and may be
legally privileged. If you are not the intended recipient, your access to
this e-mail is unauthorized. Any use, dissemination, distribution,
publication or copying by you of this e-mail or any of the information
contained within it is prohibited and may be unlawful. Do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. The content of this e-mail and any
attachments sent with it may have been altered without the consent or
knowledge of the author.
________________________________________
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Goparaju, Vidyasagar
Sent: 06 August 2004 21:53
To: 'Peter Bateman'; 'powerh-l@lists.sowder.com'
Subject: RE: Powerhouse 8.40.D on VMS vs 8.43.C on Solaris

We are able to read/write to this table in all other programs. We have
problems only on GET on RECEIVED FILE. 
Sagar 
-----Original Message----- 
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Peter Bateman 
Sent: Friday, August 06, 2004 3:38 PM 
To: powerh-l@lists.sowder.com 
Subject: RE: Powerhouse 8.40.D on VMS vs 8.43.C on Solaris 
It looks like QDESIGN is having a problem reading the metadata. 
In Qshow try to display the record layout of the table. 
I think the syntax is 
show record <tablename> in <dbname> detail 
Make sure the correct OWNER is specified or NOOWNER is chosen. 
Regards, 
Peter Bateman 


>From: "Goparaju, Vidyasagar" <VGoparaju@tradepointsystems.com> 
>To: "'powerh-l@lists.sowder.com'" <powerh-l@lists.sowder.com> 
>Subject: Powerhouse 8.40.D on VMS vs 8.43.C on Solaris 
>Date: Fri, 6 Aug 2004 15:33:07 -0400 
> 
> 
> 
>Hi All, 
> 
>We have successfully migrated our Powerhouse application from VMS/RMS to 
>Oracle-9i environment on Sun/Solaris under Powerhouse version 8.43.C. 
> 
>Now we are in the process of migrating the same application to Powerhouse 
>application on VMS/Alpha and Oracle database running on Sun/Solaris. 
>Powerhouse version is 8.40.D. 
> 
>We are having problems on VMS/Powerhouse 8.40.D with the same source that 
>is 
>running OK on Solaris accessing the same Oracle-9i database. 
> 
>We have GET on RECEIVED DESIGNER record structures all over our code. This 
>works fine on VMS/RMS and Oracle-9i on Solaris under Ph-8.43.C. 
> 
>Under Ph 8.40.D environment, QDESIGN issues a WARNING "ACCESS ignored on 
>received file" and I am getting the following runtime error on QUICK 
>"No relation has been specified on file....". 
> 
>Code change is not a good solution as we have exceeded 31 file limits on 
>most of these programs and also we have too many programs to change. 
> 
>I am working with Cognos Support. 
> 
>Please let me know if you have any suggestions. 
> 
>Thanks very much, 
>Sagar 
> 
> 
_________________________________________________________________ 
MSN(r) Calendar keeps you organized and takes the effort out of scheduling 
get-togethers. 
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=htt
p://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@lists.sowder.com 
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com 
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.