Dear All,
I'm new in Progress. I'm MFG/PRO user in Japan.
When I refer view, Bus Error.(48) occured.
Database log is as follows;
11:22:22 SQLSRV2 2: SYSTEM ERROR: Bus error. (48)
11:22:54 BROKER 0: Disconnecting client 24 of dead server 2. (2526)
11:22:54 BROKER 0: Begin transaction backout. (2252)
11:22:54 BROKER 0: Transaction backout completed. (2253)
11:22:54 BROKER 0: Disconnecting dead server 2. (2525)
But I use select statement that is same as the view, I can get result
without error.
Environment:
OS : HP-UX11
RDBMS: Progress9.1DSP7
I attach the SQL source.
Tables in the SQL are standard table of MFG/PRO.
CREATE VIEW sql.view_test(
ih_bill,
bill_zip,
bill_city,
bill_line1,
bill_line2,
bill_name,
bill_phone,
ih_ship,
ship_zip,
ship_city,
ship_line1,
ship_line2,
ship_name,
ship_phone,
ih_inv_nbr,
ct_desc,
ih_po,
ih_nbr,
slspsn_name,
ih_rmks,
idh_line,
idh_part,
ih_ship_date,
idh_qty_inv,
idh_um,
idh_taxable,
idh_price,
ih_tax_date,
ih_curr,
ih_disc_pct,
ih_trl1_amt,
ih_trl1_cd,
ih_trl2_amt,
ih_trl2_cd,
ih_trl3_amt,
ih_trl3_cd,
ih_cr_terms,
ih_slspsn,
ar_amt
)
as
SELECT
ih.ih_bill,
ad1.ad_zip,
ad1.ad_city,
ad1.ad_line1,
ad1.ad_line2,
ad1.ad_name,
ad1.ad_phone,
ih.ih_ship,
ad2.ad_zip,
ad2.ad_city,
ad2.ad_line1,
ad2.ad_line2,
ad2.ad_name,
ad2.ad_phone,
ih.ih_inv_nbr,
ct.ct_desc,
ih.ih_po,
ih.ih_nbr,
ad3.ad_name,
ih.ih_rmks,
idh.idh_line,
idh.idh_part,
ih.ih_ship_date,
idh.idh_qty_inv,
idh.idh_um,
decode(idh.idh_taxable,-1,'Y','N'),
idh.idh_price,
ih.ih_tax_date,
ih.ih_curr,
ih.ih_disc_pct,
ih.ih_trl1_amt,
ih.ih_trl1_cd,
ih.ih_trl2_amt,
ih.ih_trl2_cd,
ih.ih_trl3_amt,
ih.ih_trl3_cd,
ih.ih_cr_terms,
ih.ih_slspsn,
ar.ar_amt
FROM
((((((PUB.ih_hist ih LEFT JOIN PUB.idh_hist idh ON ih.ih_inv_nbr = idh.idh_inv_nbr)
LEFT JOIN PUB.ad_mstr ad1 ON ih.ih_ship = ad1.ad_addr)
LEFT JOIN PUB.ad_mstr ad2 ON ih.ih_bill = ad2.ad_addr)
LEFT JOIN PUB.ad_mstr ad3 ON PRO_ELEMENT(ih.ih_slspsn,1,1) = ad3.ad_addr)
LEFT JOIN PUB.ct_mstr ct ON ih.ih_cr_terms = ct.ct_code)
LEFT JOIN PUB.ar_mstr ar ON ih.ih_inv_nbr = ar.ar_nbr);
Regards, Miura
I'm new in Progress. I'm MFG/PRO user in Japan.
When I refer view, Bus Error.(48) occured.
Database log is as follows;
11:22:22 SQLSRV2 2: SYSTEM ERROR: Bus error. (48)
11:22:54 BROKER 0: Disconnecting client 24 of dead server 2. (2526)
11:22:54 BROKER 0: Begin transaction backout. (2252)
11:22:54 BROKER 0: Transaction backout completed. (2253)
11:22:54 BROKER 0: Disconnecting dead server 2. (2525)
But I use select statement that is same as the view, I can get result
without error.
Environment:
OS : HP-UX11
RDBMS: Progress9.1DSP7
I attach the SQL source.
Tables in the SQL are standard table of MFG/PRO.
CREATE VIEW sql.view_test(
ih_bill,
bill_zip,
bill_city,
bill_line1,
bill_line2,
bill_name,
bill_phone,
ih_ship,
ship_zip,
ship_city,
ship_line1,
ship_line2,
ship_name,
ship_phone,
ih_inv_nbr,
ct_desc,
ih_po,
ih_nbr,
slspsn_name,
ih_rmks,
idh_line,
idh_part,
ih_ship_date,
idh_qty_inv,
idh_um,
idh_taxable,
idh_price,
ih_tax_date,
ih_curr,
ih_disc_pct,
ih_trl1_amt,
ih_trl1_cd,
ih_trl2_amt,
ih_trl2_cd,
ih_trl3_amt,
ih_trl3_cd,
ih_cr_terms,
ih_slspsn,
ar_amt
)
as
SELECT
ih.ih_bill,
ad1.ad_zip,
ad1.ad_city,
ad1.ad_line1,
ad1.ad_line2,
ad1.ad_name,
ad1.ad_phone,
ih.ih_ship,
ad2.ad_zip,
ad2.ad_city,
ad2.ad_line1,
ad2.ad_line2,
ad2.ad_name,
ad2.ad_phone,
ih.ih_inv_nbr,
ct.ct_desc,
ih.ih_po,
ih.ih_nbr,
ad3.ad_name,
ih.ih_rmks,
idh.idh_line,
idh.idh_part,
ih.ih_ship_date,
idh.idh_qty_inv,
idh.idh_um,
decode(idh.idh_taxable,-1,'Y','N'),
idh.idh_price,
ih.ih_tax_date,
ih.ih_curr,
ih.ih_disc_pct,
ih.ih_trl1_amt,
ih.ih_trl1_cd,
ih.ih_trl2_amt,
ih.ih_trl2_cd,
ih.ih_trl3_amt,
ih.ih_trl3_cd,
ih.ih_cr_terms,
ih.ih_slspsn,
ar.ar_amt
FROM
((((((PUB.ih_hist ih LEFT JOIN PUB.idh_hist idh ON ih.ih_inv_nbr = idh.idh_inv_nbr)
LEFT JOIN PUB.ad_mstr ad1 ON ih.ih_ship = ad1.ad_addr)
LEFT JOIN PUB.ad_mstr ad2 ON ih.ih_bill = ad2.ad_addr)
LEFT JOIN PUB.ad_mstr ad3 ON PRO_ELEMENT(ih.ih_slspsn,1,1) = ad3.ad_addr)
LEFT JOIN PUB.ct_mstr ct ON ih.ih_cr_terms = ct.ct_code)
LEFT JOIN PUB.ar_mstr ar ON ih.ih_inv_nbr = ar.ar_nbr);
Regards, Miura