PH can see Oracle, but displays no records on the Oracle database

[Brett Greiner]

Hi Peter

Great, its now finding the records in Oracle.

So to setup Powerhouse correctly for Oracle, we setup the 
PH dictionary with OWNER=AFL then we don't have to explicity set 
the owner each time. Correct?

Cheers
Brett



-----Original Message-----
From: powerh-l-bounces+brett.greiner=synoptix.co.nz at lists.sowder.com
[mailto:powerh-l-bounces+brett.greiner=synoptix.co.nz at lists.sowder.com]
On Behalf Of Peter Bateman
Sent: Saturday, 13 May 2006 00:23
To: powerh-l at sowder.com
Subject: RE: PH can see Oracle, but displays no records on the Oracle
database




Hi Brett:

   Here is some ideas.

   AFL does not have permission to read the metadata.

   I would try dbaudit=full to see what PH is doing then
   try the same thing with SQLPLUS.

   Try running QSHOW with the OWNER=AFL this should
   cause show database AFL  to display only the records
   owner by AFL.

Regards,
Peter
>
>
>The previous issue was the LIBPATH not pointing to the Oracle lib 
>directory. Thanks for all the input.
>
>
>Now the records for the Oracle database are not showing up when doing a

>'show database afl'.
>
>But you can setup a cursor to access the Oracle data.
>
>Any ideas?
>
>Brett
>
>
>Q S H O W   (PowerHouse  8.43.D1)
>Copyright 2005 COGNOS INCORPORATED
>
> > show database afl
>12 May 2006                   Allied Farmers                      Page
>1
>                        D A T A B A S E  R E P O R T
>                   For DICTIONARY:  /test/dict/afldict.pdc
>     Database:           AFL
>     Organization:       RELATIONAL
>     Null Values Allowed:Yes
>     Type:               ORACLE
>     Hold Cursor:        Unspecified
>     Open:               AFL
>     Userid:             AFL
>     Records & Sizes:    ** none **
>
>
>Q U I Z (PowerHouse 8.43.D1)
>Copyright 2005 COGNOS INCORPORATED
>
> > SQL DECLARE TEST_CURSOR CURSOR FOR SELECT * FROM ASSET_CATEGORY
>
> > access TEST_CURSOR
>
> > go
>
>Records selected: 1
>
> >
>
>
>
>
>
>
>
>
>
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list: 
>powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to 
>powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe <password>" 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.
>Add 'site:lists.sowder.com powerh-l' to your search terms to search the

>list archive at Google.

_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft(r)
SmartScreen Technology. 
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 <password>" 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.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.