Hi all!
I have the following problem :
view definition :
CREATE view v_fc_totals as
select
a.total,
a.transdate as date_s ,
b. name as customer,
b.cust_id,b.compid,
disc =
case
when a.transdate >=b.ddate then a.gallons*b.amount
else 0.0
end +
case
when a.transdate >=c.fdt then a.fuel*c.fd/100.0
else 0.0
end+
case
when a.transdate >=c.adt then a. auto *c.ad/100.0
else 0.0
end+
case
when a.transdate >=c.mdt then a.merch*c.md/100.0
else 0.0
end+
case
when a.transdate >=c.edt then a.food*c.ed/100.0
else 0.0
end
from
trans3 a, customer b, gcards c
where
a.company=b.cust_id and a.client_id=b.compid and
ltrim(rtrim(a.company))||ltrim(rtrim(a.ssn))=ltrim(rtrim(c. newid ))
and a.client_id=c.compid
UNION ALL
select
-a.amount as total,
a. date_s as date_s ,
b. name as customer,
b.cust_id,b.compid,
0.0 as disc
from payement a, customer b
where
a.custid=b.cust_id and a.compid=b.compid
All underlying tables defined.
Running on 7.4.3.25 on Redhat 8.0, works perfectly. On same version ,
installed on W2K, SP2, it crashes server , with following info in knldiag :
2003-07-21 15:54:58 0x810 ERR 18006 EXCEPT EXCEPTION:0xc0000005
Addr:0x58c377 ( 0x1:0x7f87ffff:0:0 )
followed by a lot of 'btrace' lines, ending with:
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE
kernel!sql88k_kernel_fiber + 191 bytes
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE SFrame: IP:006f2e2f
RA:77e887dd FP:04c4ffb4 SP:04c4ffbc
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE Params: 01:7ff2f810
02:77e87671 03:77e87684 04:7ff2f810
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE Source: vos88k.c
( Line: 435 )
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE
KERNEL32!GetModuleFileNameA + 465 bytes
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE SFrame: IP:77e887dd
RA:77e816e6 FP:04c4ffec SP:04c4ffbc
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE Params: 01:006f2d70
02:7ff2f810 03:00000000 04:00009000
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE KERNEL32!77e816e6
<nosymbols>
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE SFrame: IP:77e816e6
RA:00000000 FP:04c4fef0 SP:04c4ffbc
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE Params: 01:00000000
02:04c4ff78 03:00435498 04:04c4ff03
2003-07-21 15:54:59 0x810 ERR 19999 BTRACE No crash dump file
'knlcrash.dmp' written
2003-07-21 15:55:01 0x810 19820 EXCEPT calling ak dump for T16
2003-07-21 15:55:01 0x810 19624 EXCEPT Kernel aborts
2003-07-21 15:55:01 0x8B4 19617 VOLUMEIO Single I/O attach,
'knltrace', UKT:1
2003-07-21 15:55:01 0x810 19684 TASKING Tracewriter termination
timeout: 1200 sec
2003-07-21 15:55:01 0x8B4 19619 TASKING Releasing tracewriter
2003-07-21 15:55:01 0x810 19890 DIAGHIST Backup of diagnostic files
will be forced at next restart
2003-07-21 15:55:01 0x810 19600 VERSION 'Kernel 7.4.3 Build
025-123-046-179'
2003-07-21 15:55:01 0x810 19654 DBSTATE SERVERDB 'TEST' has
stopped
Any ideas why this happens ?
All best,
Dan
If you try to fail, and succeed, which have you done?
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
