Re: Installing SQR and getting it to work in Oracle database and application on two databases

[Ben Le <ble@PCC.EDU>]

Lynne,
We are having the same problem once in a while with "memory fault (core
dump)" error. It is not consistency. We are on Oracle 81.6/Banner 4/HP-UX.
What I found out that Oracle 8.1.6 does not handle 'NULL' value very well
that why we are getting core dump when running SQR report. We had to apply
the 'NULL' fix to all Banner ProC applications in able to work with Oracle
8.1.6. Brio does not have the 'NULL' fix patch for Oracle 8.1.6 as I know
of. The core dump error is hard to diagnose the errors. If you are on Unix,
you can use 'strings' command to select the only text message out from the
'core' file to look for errors.

At 10:27 AM 5/16/01 -0600, you wrote:
>Our oracle application version 10 resideson Oracle 7.3.4 database.  Our
>tables reside on Oracle database 8.1.6.  We are installing SQR version
>6.1.3 and trying to get SQR to work with two Oracle database.  During our
>installation we chose the option Oracle 8.1.6 option.  We tried to run SQR
>reports within our Oracle application, which resides on 7.3.4
>database.  SQR gives us "memory fault (core dump)" error when we do
>this.  However, SQR runs perfectly when we run our reports at command line
>(outside Oracle application).
>
>Does anyone know how to get SQR to work in a two database?
>
>Thanks,
>Lynne

--------------------------------------------------------------------------------------------------------------------------------
Benjamin Le
ITS, System Development
Portland Community College
12000 SW 49th Ave. Portland, Oregon 97219
(503)-977-4970  Fax: (503)-977-4987
Mailto:ble@pcc.edu      http://www.pcc.edu
--------------------------------------------------------------------------------------------------------------------------------