PowerHouse and Oracle on Solaris -- howto?

[John MacLerran]

Thank You! To everyone who responded.

It was a problem with the LD_LIBRARY_PATH not pointing to the 32-bit 
libraries it was /u01/oracle/product/10.0.2.0/lib   -- instead of the 
correct  /u01/oracle/product/10.0.2.0/lib32

I can now access the database, but all of the fields are 4 times longer 
than they should be.  I do a describe on a table in SQLPlus, and it 
shows a certain row as being a VARCHAR2(6 CHAR), but a show items in 
Quiz shows the same row as  VARCHAR  X(24).  When I report the field,  
the data displays correctly, but it is in the first 6 positions followed 
by blanks.

This database is part of a new ERP that we are implementing, and the 
database is configured for internationalization using a utf-8 type 
character set.  I think that's where the discrepancy is coming from -- 
the database implements each 'character' in multiple bytes - 4 to be exact.

Has anyone else encountered this?  Is there a suggested work-around to 
make PowerHouse recognize multi-byte character sets?  I couldn't find 
anything in the PDL manual.  The release and install notes guide 
mentions that PowerHouse can work with multi-byte character sets, but it 
doesn't say much more than that.

I'll open a case with support this afternoon, but I wanted to get the 
wisdom of the group first.
Thanks!


John MacLerran wrote:
> Dear PowerHouse list
>
> I'm new to using PowerHouse with Oracle, and I'm trying to get the two 
> to talk nicely together.  (Sorry if this is a duplicate. I sent it 
> yesterday, but it didn't show up in the list archives, and I never 
> received notification that it posted, so I figure it got held somewhere.)
>
> OS is Solaris 10
> Oracle version is 10.2
> PowerHouse version is 8.43.F -- brand new...
>
> Oracle is installed, and I can TNSPING the database I'm trying to 
> connect to, and I can access it with SQLPlus.  However, when I create a 
> PDL dictionary and try to access it in quiz, I get the following:
>
> $setdict aiqdb.pdc
> $quiz
> Q U I Z   (PowerHouse  8.43.F)
> Copyright (C) 2008 Cognos Incorporated. All rights reserved.
>
>  > access spriden in BTEST
>
> *W* SQL START DBE error (BTEST).
> DMS-E-YV_LOADSGIFAILED, Unable to load the 'ordba' gateway. Please 
> ensure that
> the database software is configured correctly and is supported on this 
> version
> of the operating system.
>
> SPRIDEN is a valid table in BTEST, and that's the database name I can 
> TNSPING and access via SQLPlus.
>
> Here's what I have in my PDL source:
>
>
> database BTEST type Oracle    &
>   open 'BTEST'              &
> ;;;   (note:  I've also tried  BTEST.isos.isu.edu -- the name that 
> TNSPing returns and the service_name in the tnsnames.ora file)
>   null values ALLOWED        &
>   userid 'macljohn' password 'blahblah'     
> The macljohn userid does have read access to SPRIDEN in BTEST.
>
> I queried the list archives, and one message said that the resolution to 
> the problems was that PowerHouse wasn't installed with Oracle support. I 
> wasn't present when PowerHouse was installed on the server, but neither 
> the Getting Started guide nor the Release and Install notes mentioned 
> anything special that was needed to install with Oracle Support.  There 
> is a section in the Getting Started guide that mentions that the 
> LD_LIBRARY_PATH for the database must be set before executing the . 
> setpow  script, and I've done that, but the error still occurs.  Did the 
> LD_LIBRARY_PATH need to be set correctly before the install was 
> started?  I don't believe that was done.
>
> Where is the 'ordba' gateway that is mentioned in the error message?  Is 
> that a PowerHouse component or an Oracle one?  I did a find . -name on 
> it, and didn't find it, but that could be due to my rights not being 
> correct.
>
> I'd appreciate any insight.
> Thanks!
>
>   

-- 
----------------------------------------------------------------------
  John MacLerran              http://picasaweb.google.com/jmaclerran
  IT Analyst, Senior                       email:   macljohn at isu.edu
  Idaho State University                             V(208) 282-2954
  http://www.isu.edu/~macljohn                       F(208) 282-3673
----------------------------------------------------------------------