| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> IMPROMPTU
Subject: IMPROMPTU
I have been testing using Impromptu as a query tool against Oracle and love it
but have hit a snag which I think is an Oracle constraint which I can't
identify. I need to pull data from 2 tables GL_HEAD(general ledger records) and
GL_MAST (general ledger master). I pull just the description from GL_MAST and
4 fields from GL_HEAD - FISC_YEAR, COMPANY, GL_ACCNO and a calculated field
which is the opening balance + month1 debits - month1 credits + month2 debits
- month2 credits etc.up to 16 months of values............
I list the Impromptu SQL below - it is interesting that Impromptu puts brackets around each part of the calculation - there are 31 of them !!!
We have:
Hardware: Compaq Proliant 100mHz CPU, 512 MB RAM, 23 GB disk
Op system: Netware 3.11
Oracle: V 7.0.16.0
Oracle Netware SPX Server V 1.1.1.8
We use IPX/SPX protocol
My problem is that this SQL crashes my server immediately whether I run from
Impromptu or from SQL*PLUS. I get no Oracle error codes - within 1 second the
server is down.
I edited out all the brackets in Impromptu and the job runs fine. I also
identified that if I have up to 12 fields in my calculated field then the job
works fine (get results back in a few seconds using only 300 rows of data) but
as I add the next field to the calculation it brings my server down.
Unfortunately I can't tell my users to edit their Impromptu SQL code to remove the brackets every time so need to identify why my server is falling over - can anyone advise me on what to look for in Oracle logs or operating system level. Netware has not given us any reasonable error codes to work with so far ????
select T1.FISC_YEAR "c1",T1.COMPANY "c2",T1.GL_ACCNO "c3",T2.GL_DESC "c4",
(((((((((((((((((((((((((((((((T1.BAL_LOCAL+T1.L_CURDR01)-T1.L_CURCR01)+T1.L_CURDR02)-T1.L_CURCR02)+T1.L_CURDR03)-T1.L_CURCR03)+T1.L_CURDR04)-T1.L_CURCR04)+ T1.L_CURDR05)-T1.L_CURCR05)+T1.L_CURDR06)-T1.L_CURCR06)+T1.L_CURDR07)-T1.L_ CURCR07)+T1.L_CURDR08)-T1.L_CURCR08)+T1.L_CURDR09)-T1.L_CURCR09)+T1.L_CURDR10)- T1.L_CURCR10)+T1.L_CURDR11)-T1.L_CURCR11)+T1.L_CURDR12)-T1.L_CURCR12)+T1.L_ CURDR13)-T1.L_CURCR13)+T1.L_CURDR14)-T1.L_CURCR14)+T1.L_CURDR15)-T1.L_CURCR15)+ T1.L_CURDR16)-T1.L_CURCR16 "c5"
+--------------------------------------------------------------------+
| | / Chris Don, Data Administration Specialist | | \ South Africa / Engen Marketing Ltd, Engen Court,Cape Town | | | _/ Tel: South Africa 010-27-21-403-5143 | | \ _/ Fax: South Africa 010-27-21-403-4067 | | | _/ Internet Identity: ZAWLHCD1_at_IBMMAIL.COM | |Cape \ _/ | |Town \*_____/ |Received on Fri Feb 02 1996 - 01:32:19 CST
+--------------------------------------------------------------------+
 |
 |