dbTalk Databases Forums  

[Info-Ingres] E_op0395_psf_joinid

Go Back dbTalk Databases Forums Databases comp.databases.ingres [Info-Ingres] E_op0395_psf_joinid

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] E_op0395_psf_joinid in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Paul White
 
Posts: n/a

Default [Info-Ingres] E_op0395_psf_joinid - 09-14-2011 , 04:12 AM





Hi Martin,
Did you ever get to the bottom of this problem?
We've just started getting the error in our Sri Lankan office.


Quote:
Hi All,
Since upgrading to II 9.1.1 (a64.lnx/103)NPTL + p13159 we've picked up a
few E_OP0395_PSF_JOINID errors.

What are they?
SELECT * FROM "kadoorie"."xy_dup_nm_nid"

E_OP0395_PSF_JOINID consistency check - unexpected outer join ID
found
The table is a simple table and not some complicated view. The problem
does not repeat when I execute the query.

Martin Bowes
Here is the first instance.
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Tue Sep 13
16:42:05 2011 E_OP0395_PSF_JOINID consistency check
- unexpected outer join ID found
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: An error
occurred in the following session:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Quote:
Session 164D4380:1468
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: DB
Name: estreet_test (Owned by: ingres
)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User:
kushan (kushan )
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User
Name at Session Startup: kushan
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Terminal: console
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Group
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Role
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Application Code: 00000000 Current Facility: OPF (00000004)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
user: ingres
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
host: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
tty: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
pid: 1200
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
connection target: estreet_test
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
information: user='ingres',host='GRANDPEERLESS',tty='GRANDPEERL ESS',
pid=1200,conn='estreet_test'
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Description:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Query:SELECT C.CUSTCODE AS CUSTCODE, M.MTDThisYear AS MTDThisYear,
M.YTDThisYear AS YTDThisYear, M.YTDlastYear AS YTDlastYear,
O.OUTSTANDINGVALUE AS OUTSTANDINGVALUE, C.ARGROUP AS ARGROUP, C.REPCODE AS
REPCODE, C.CREDITSTATUS AS CREDITSTATUS, C.DOCDATE AS DOCDATE,
C.AMOUNTDUE
AS AMOUNTDUE, C.UNALLOCDISCOUNT AS UNALLOCDISCOUNT, C.TRANSTYPE AS
TRANSTYPE,
C.STATUS AS STATUS, C.NAME AS NAME FROM (SELECT oi.cust_code AS
CUSTCODE,
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, oi.doc_date AS DOCDATE, oi.amount_due AS AMOUNTDUE,
oi.discount
AS UNALLOCDISCOUNT, oi.trans_type AS TRANSTYPE, oi.status AS STATUS, cu.name
AS
NAME FROM customer cu, open_items oi WHERE oi.cust_code = cu.cust_code
AND
oi.status != 'F' AND cu.run_code = 'MON' ) AS C FULL JOIN (SELECT
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, ph.cust_code AS CUSTCODE, SUM(sd.net_amount)
AS
OUTSTANDINGVALUE FROM plist_header ph, plist_detail pd, customer cu,
catalog
ca, sorder_detail sd, sorder_header sh WHERE ph.plist_no = pd.plist_no and
pd.catlog_code = ca.catlog_code and sh.sorder_no = sd.sorder_no and
ph.cust_code = cu.cust_code and pd.plist_no = sd.plist_no and
pd.catlog_code =
sd.catlog_code and ph.status IN ('P','N','O') and sd.status IN ('B','P')
and
pd.status = 'N' and sh.order_type = 'S' group by ph.cust_code,
cu.ar_group,
cu.rep_code, cu.c
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
redit_status, cu.name ) AS O ON O.CUSTCODE = C.CUSTCODE INNER JOIN (SELECT

cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, iss.cust_code AS CUSTCODE,
SUM(iss.mtd_value_p9)
AS MTDThisYear, SUM(iss.ytd_value_p9) AS YTDThisYear,
SUM(iss.ytd_value_pp9)
AS YTDlastYear FROM infoset_summary iss, customer cu WHERE cu.cust_code =

iss.cust_code AND (mtd_value_p9 != 0 OR ytd_value_p9 != 0 OR ytd_value_pp9
!=
0 ) GROUP BY iss.cust_code, cu.ar_group, cu.rep_code, cu.credit_status,
cu.name ) AS M ON M.CUSTCODE = C.CUSTCODE


version.rel
II 9.2.0 (int.w32/143)
13664


Paul White

Reply With Quote
  #2  
Old   
Martin Bowes
 
Posts: n/a

Default Re: [Info-Ingres] E_op0395_psf_joinid - 09-14-2011 , 04:41 AM





Hi Paul,

I can't bring that problem to mind, nor can I find a mention of it in my logs...do you have a date I raised it?

I've also checked the tech support site and it has a few listings against this problem. It seems that you may be able to at least get a workaround solution by simplifying the query using session temporary tables. For example the subquery1 full join subquery2 stuff could be simplified by instantiating each of the subqueries as a session temp table, keying them and joining them in the main query.

Marty

-----Original Message-----
From: Paul White [mailto:shift7solutions (AT) gmail (DOT) com]
Sent: 14 September 2011 10:12
To: 'Ingres and related product discussion forum'
Cc: csenaratne (AT) peercore (DOT) com.au
Subject: [Info-Ingres] E_op0395_psf_joinid

Hi Martin,
Did you ever get to the bottom of this problem?
We've just started getting the error in our Sri Lankan office.


Quote:
Hi All,
Since upgrading to II 9.1.1 (a64.lnx/103)NPTL + p13159 we've picked up a
few E_OP0395_PSF_JOINID errors.

What are they?
SELECT * FROM "kadoorie"."xy_dup_nm_nid"

E_OP0395_PSF_JOINID consistency check - unexpected outer join ID
found
The table is a simple table and not some complicated view. The problem
does not repeat when I execute the query.

Martin Bowes
Here is the first instance.
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Tue Sep 13
16:42:05 2011 E_OP0395_PSF_JOINID consistency check
- unexpected outer join ID found
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: An error
occurred in the following session:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Quote:
Session 164D4380:1468
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: DB
Name: estreet_test (Owned by: ingres
)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User:
kushan (kushan )
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User
Name at Session Startup: kushan
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Terminal: console
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Group
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Role
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Application Code: 00000000 Current Facility: OPF (00000004)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
user: ingres
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
host: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
tty: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
pid: 1200
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
connection target: estreet_test
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
information: user='ingres',host='GRANDPEERLESS',tty='GRANDPEERL ESS',
pid=1200,conn='estreet_test'
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Description:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Query:SELECT C.CUSTCODE AS CUSTCODE, M.MTDThisYear AS MTDThisYear,
M.YTDThisYear AS YTDThisYear, M.YTDlastYear AS YTDlastYear,
O.OUTSTANDINGVALUE AS OUTSTANDINGVALUE, C.ARGROUP AS ARGROUP, C.REPCODE AS
REPCODE, C.CREDITSTATUS AS CREDITSTATUS, C.DOCDATE AS DOCDATE,
C.AMOUNTDUE
AS AMOUNTDUE, C.UNALLOCDISCOUNT AS UNALLOCDISCOUNT, C.TRANSTYPE AS
TRANSTYPE,
C.STATUS AS STATUS, C.NAME AS NAME FROM (SELECT oi.cust_code AS
CUSTCODE,
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, oi.doc_date AS DOCDATE, oi.amount_due AS AMOUNTDUE,
oi.discount
AS UNALLOCDISCOUNT, oi.trans_type AS TRANSTYPE, oi.status AS STATUS, cu.name
AS
NAME FROM customer cu, open_items oi WHERE oi.cust_code = cu.cust_code
AND
oi.status != 'F' AND cu.run_code = 'MON' ) AS C FULL JOIN (SELECT
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, ph.cust_code AS CUSTCODE, SUM(sd.net_amount)
AS
OUTSTANDINGVALUE FROM plist_header ph, plist_detail pd, customer cu,
catalog
ca, sorder_detail sd, sorder_header sh WHERE ph.plist_no = pd.plist_no and
pd.catlog_code = ca.catlog_code and sh.sorder_no = sd.sorder_no and
ph.cust_code = cu.cust_code and pd.plist_no = sd.plist_no and
pd.catlog_code =
sd.catlog_code and ph.status IN ('P','N','O') and sd.status IN ('B','P')
and
pd.status = 'N' and sh.order_type = 'S' group by ph.cust_code,
cu.ar_group,
cu.rep_code, cu.c
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
redit_status, cu.name ) AS O ON O.CUSTCODE = C.CUSTCODE INNER JOIN (SELECT

cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, iss.cust_code AS CUSTCODE,
SUM(iss.mtd_value_p9)
AS MTDThisYear, SUM(iss.ytd_value_p9) AS YTDThisYear,
SUM(iss.ytd_value_pp9)
AS YTDlastYear FROM infoset_summary iss, customer cu WHERE cu.cust_code =

iss.cust_code AND (mtd_value_p9 != 0 OR ytd_value_p9 != 0 OR ytd_value_pp9
!=
0 ) GROUP BY iss.cust_code, cu.ar_group, cu.rep_code, cu.credit_status,
cu.name ) AS M ON M.CUSTCODE = C.CUSTCODE


version.rel
II 9.2.0 (int.w32/143)
13664


Paul White






_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Reply With Quote
  #3  
Old   
Paul White
 
Posts: n/a

Default Re: [Info-Ingres] E_op0395_psf_joinid - 09-14-2011 , 04:59 AM


Thanks Martin. It was new dotnet code and they have changed it now. The
programmer has already been gently reconditioned.


I didn't try searching hard enough then. Servicedesk knowledgebase came up
with no hits with or without the E_ prefix, and I saw only your links via
google so I assumed it was a new bug. Your post from Dec 2008 seems
unrelated:

http://community.ingres.com/forum/co...info-ingres-e_
op0395_psf_joinid.html

I'll do a bit more investigation in between commercials breaks. Do you have
a servicedesk bug id?

Paul



-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Martin
Bowes
Sent: Wednesday, 14 September 2011 7:41 PM
To: Ingres and related product discussion forum
Cc: csenaratne (AT) peercore (DOT) com.au
Subject: Re: [Info-Ingres] E_op0395_psf_joinid

Hi Paul,

I can't bring that problem to mind, nor can I find a mention of it in my
logs...do you have a date I raised it?

I've also checked the tech support site and it has a few listings against
this problem. It seems that you may be able to at least get a workaround
solution by simplifying the query using session temporary tables. For
example the subquery1 full join subquery2 stuff could be simplified by
instantiating each of the subqueries as a session temp table, keying them
and joining them in the main query.

Marty

-----Original Message-----
From: Paul White [mailto:shift7solutions (AT) gmail (DOT) com]
Sent: 14 September 2011 10:12
To: 'Ingres and related product discussion forum'
Cc: csenaratne (AT) peercore (DOT) com.au
Subject: [Info-Ingres] E_op0395_psf_joinid

Hi Martin,
Did you ever get to the bottom of this problem?
We've just started getting the error in our Sri Lankan office.


Quote:
Hi All,
Since upgrading to II 9.1.1 (a64.lnx/103)NPTL + p13159 we've picked up a
few E_OP0395_PSF_JOINID errors.

What are they?
SELECT * FROM "kadoorie"."xy_dup_nm_nid"

E_OP0395_PSF_JOINID consistency check - unexpected outer join ID
found
The table is a simple table and not some complicated view. The problem
does not repeat when I execute the query.

Martin Bowes
Here is the first instance.
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Tue Sep 13
16:42:05 2011 E_OP0395_PSF_JOINID consistency check
- unexpected outer join ID found
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: An error
occurred in the following session:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Quote:
Session 164D4380:1468
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: DB
Name: estreet_test (Owned by: ingres
)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User:
kushan (kushan )
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User
Name at Session Startup: kushan
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Terminal: console
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Group
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Role
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Application Code: 00000000 Current Facility: OPF (00000004)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
user: ingres
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
host: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
tty: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
pid: 1200
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
connection target: estreet_test
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
information: user='ingres',host='GRANDPEERLESS',tty='GRANDPEERL ESS',
pid=1200,conn='estreet_test'
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Description:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Query:SELECT C.CUSTCODE AS CUSTCODE, M.MTDThisYear AS MTDThisYear,
M.YTDThisYear AS YTDThisYear, M.YTDlastYear AS YTDlastYear,
O.OUTSTANDINGVALUE AS OUTSTANDINGVALUE, C.ARGROUP AS ARGROUP, C.REPCODE AS
REPCODE, C.CREDITSTATUS AS CREDITSTATUS, C.DOCDATE AS DOCDATE,
C.AMOUNTDUE
AS AMOUNTDUE, C.UNALLOCDISCOUNT AS UNALLOCDISCOUNT, C.TRANSTYPE AS
TRANSTYPE,
C.STATUS AS STATUS, C.NAME AS NAME FROM (SELECT oi.cust_code AS
CUSTCODE,
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, oi.doc_date AS DOCDATE, oi.amount_due AS AMOUNTDUE,
oi.discount
AS UNALLOCDISCOUNT, oi.trans_type AS TRANSTYPE, oi.status AS STATUS, cu.name
AS
NAME FROM customer cu, open_items oi WHERE oi.cust_code = cu.cust_code
AND
oi.status != 'F' AND cu.run_code = 'MON' ) AS C FULL JOIN (SELECT
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, ph.cust_code AS CUSTCODE, SUM(sd.net_amount)
AS
OUTSTANDINGVALUE FROM plist_header ph, plist_detail pd, customer cu,
catalog
ca, sorder_detail sd, sorder_header sh WHERE ph.plist_no = pd.plist_no and
pd.catlog_code = ca.catlog_code and sh.sorder_no = sd.sorder_no and
ph.cust_code = cu.cust_code and pd.plist_no = sd.plist_no and
pd.catlog_code =
sd.catlog_code and ph.status IN ('P','N','O') and sd.status IN ('B','P')
and
pd.status = 'N' and sh.order_type = 'S' group by ph.cust_code,
cu.ar_group,
cu.rep_code, cu.c
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
redit_status, cu.name ) AS O ON O.CUSTCODE = C.CUSTCODE INNER JOIN (SELECT

cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, iss.cust_code AS CUSTCODE,
SUM(iss.mtd_value_p9)
AS MTDThisYear, SUM(iss.ytd_value_p9) AS YTDThisYear,
SUM(iss.ytd_value_pp9)
AS YTDlastYear FROM infoset_summary iss, customer cu WHERE cu.cust_code =

iss.cust_code AND (mtd_value_p9 != 0 OR ytd_value_p9 != 0 OR ytd_value_pp9
!=
0 ) GROUP BY iss.cust_code, cu.ar_group, cu.rep_code, cu.credit_status,
cu.name ) AS M ON M.CUSTCODE = C.CUSTCODE


version.rel
II 9.2.0 (int.w32/143)
13664


Paul White






_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Reply With Quote
  #4  
Old   
Martin Bowes
 
Posts: n/a

Default Re: [Info-Ingres] E_op0395_psf_joinid - 09-14-2011 , 06:55 AM


Hi Paul,

I've just checked my notes from December 2008 and I can't find a mention of the problem. Nor can I find a relevant issue with tech support raised at around that time.

I'm going to assume we found a simple workaround as well and didn't bother to do anything else with it.

Marty

-----Original Message-----
From: Paul White [mailto:shift7solutions (AT) gmail (DOT) com]
Sent: 14 September 2011 11:00
To: 'Ingres and related product discussion forum'
Cc: csenaratne (AT) peercore (DOT) com.au
Subject: Re: [Info-Ingres] E_op0395_psf_joinid

Thanks Martin. It was new dotnet code and they have changed it now. The
programmer has already been gently reconditioned.


I didn't try searching hard enough then. Servicedesk knowledgebase came up
with no hits with or without the E_ prefix, and I saw only your links via
google so I assumed it was a new bug. Your post from Dec 2008 seems
unrelated:

http://community.ingres.com/forum/co...info-ingres-e_
op0395_psf_joinid.html

I'll do a bit more investigation in between commercials breaks. Do you have
a servicedesk bug id?

Paul



-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Martin
Bowes
Sent: Wednesday, 14 September 2011 7:41 PM
To: Ingres and related product discussion forum
Cc: csenaratne (AT) peercore (DOT) com.au
Subject: Re: [Info-Ingres] E_op0395_psf_joinid

Hi Paul,

I can't bring that problem to mind, nor can I find a mention of it in my
logs...do you have a date I raised it?

I've also checked the tech support site and it has a few listings against
this problem. It seems that you may be able to at least get a workaround
solution by simplifying the query using session temporary tables. For
example the subquery1 full join subquery2 stuff could be simplified by
instantiating each of the subqueries as a session temp table, keying them
and joining them in the main query.

Marty

-----Original Message-----
From: Paul White [mailto:shift7solutions (AT) gmail (DOT) com]
Sent: 14 September 2011 10:12
To: 'Ingres and related product discussion forum'
Cc: csenaratne (AT) peercore (DOT) com.au
Subject: [Info-Ingres] E_op0395_psf_joinid

Hi Martin,
Did you ever get to the bottom of this problem?
We've just started getting the error in our Sri Lankan office.


Quote:
Hi All,
Since upgrading to II 9.1.1 (a64.lnx/103)NPTL + p13159 we've picked up a
few E_OP0395_PSF_JOINID errors.

What are they?
SELECT * FROM "kadoorie"."xy_dup_nm_nid"

E_OP0395_PSF_JOINID consistency check - unexpected outer join ID
found
The table is a simple table and not some complicated view. The problem
does not repeat when I execute the query.

Martin Bowes
Here is the first instance.
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Tue Sep 13
16:42:05 2011 E_OP0395_PSF_JOINID consistency check
- unexpected outer join ID found
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: An error
occurred in the following session:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Quote:
Session 164D4380:1468
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: DB
Name: estreet_test (Owned by: ingres
)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User:
kushan (kushan )
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: User
Name at Session Startup: kushan
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Terminal: console
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Group
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Role
Id:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Application Code: 00000000 Current Facility: OPF (00000004)
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
user: ingres
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
host: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
tty: GRANDPEERLESS
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
pid: 1200
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
connection target: estreet_test
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]: Client
information: user='ingres',host='GRANDPEERLESS',tty='GRANDPEERL ESS',
pid=1200,conn='estreet_test'
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Description:
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
Query:SELECT C.CUSTCODE AS CUSTCODE, M.MTDThisYear AS MTDThisYear,
M.YTDThisYear AS YTDThisYear, M.YTDlastYear AS YTDlastYear,
O.OUTSTANDINGVALUE AS OUTSTANDINGVALUE, C.ARGROUP AS ARGROUP, C.REPCODE AS
REPCODE, C.CREDITSTATUS AS CREDITSTATUS, C.DOCDATE AS DOCDATE,
C.AMOUNTDUE
AS AMOUNTDUE, C.UNALLOCDISCOUNT AS UNALLOCDISCOUNT, C.TRANSTYPE AS
TRANSTYPE,
C.STATUS AS STATUS, C.NAME AS NAME FROM (SELECT oi.cust_code AS
CUSTCODE,
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, oi.doc_date AS DOCDATE, oi.amount_due AS AMOUNTDUE,
oi.discount
AS UNALLOCDISCOUNT, oi.trans_type AS TRANSTYPE, oi.status AS STATUS, cu.name
AS
NAME FROM customer cu, open_items oi WHERE oi.cust_code = cu.cust_code
AND
oi.status != 'F' AND cu.run_code = 'MON' ) AS C FULL JOIN (SELECT
cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, ph.cust_code AS CUSTCODE, SUM(sd.net_amount)
AS
OUTSTANDINGVALUE FROM plist_header ph, plist_detail pd, customer cu,
catalog
ca, sorder_detail sd, sorder_header sh WHERE ph.plist_no = pd.plist_no and
pd.catlog_code = ca.catlog_code and sh.sorder_no = sd.sorder_no and
ph.cust_code = cu.cust_code and pd.plist_no = sd.plist_no and
pd.catlog_code =
sd.catlog_code and ph.status IN ('P','N','O') and sd.status IN ('B','P')
and
pd.status = 'N' and sh.order_type = 'S' group by ph.cust_code,
cu.ar_group,
cu.rep_code, cu.c
GRANDPEERLESS ::[II\INGRES\ca8 , 3240 , 164d4380]:
redit_status, cu.name ) AS O ON O.CUSTCODE = C.CUSTCODE INNER JOIN (SELECT

cu.ar_group AS ARGROUP, cu.rep_code AS REPCODE, cu.credit_status AS
CREDITSTATUS, cu.name AS NAME, iss.cust_code AS CUSTCODE,
SUM(iss.mtd_value_p9)
AS MTDThisYear, SUM(iss.ytd_value_p9) AS YTDThisYear,
SUM(iss.ytd_value_pp9)
AS YTDlastYear FROM infoset_summary iss, customer cu WHERE cu.cust_code =

iss.cust_code AND (mtd_value_p9 != 0 OR ytd_value_p9 != 0 OR ytd_value_pp9
!=
0 ) GROUP BY iss.cust_code, cu.ar_group, cu.rep_code, cu.credit_status,
cu.name ) AS M ON M.CUSTCODE = C.CUSTCODE


version.rel
II 9.2.0 (int.w32/143)
13664


Paul White






_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top