I have a question that has now stumped several DBAs and Remedy
Developers now and was hoping someone on this list may have a answer.
We have a Join that is nested with other joins, however, when we perform
a query via the Remedy User tool it returns an "ARERR (302) Entry does
not exist in database".
To make matters worse, on the User Tool it returns 792 records of which
60% display this error and the remaining 40% do not and before anyone
says there are missing records. We have 3 primary data forms included in
these joins and all of them have the corrected and needed data in them.
Now here is the issue. When we perform the same query at the Oracle
level it returns all the records correctly.
This is the query that is run from the Remedy User Tool (when I turn on
SQL and API logging).
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-00000001025' and E1 = 'LOC000000005915' and E2 IS NULL and E3 =
'EBL-00000000590' ) ORDER BY 1 ASC
It returns no record
However, when I modify the query based on the structure of our Join it
returns the record.
SELECT aradmin.T5092.C1,C8 FROM aradmin.T5092 WHERE (E0 =
'ACI-00000001025' and E1 = 'LOC000000005915' and E2 IS NULL and E3 IS
NULL and E4 = 'EBL-00000000590' ) ORDER BY 1 ASC
E0 and E1 are from the Tele_Location_Join and E2 and E3 should be from
the Location RecType_Join and E4 should be from the Load Data Form,
however, what is happening via the User Tool is E0 and E1 are from the
Tele_Location_Join and E2 and E3 should be from the Location
RecType_Join and it never includes the E4 and the E3 value should be the
E4 value and E3 should be null
This is our Join Structure:
Reporting_Form_Join
An outer join of:
* Charge_Join (Primary)
* Load Data Form (Secondary)
Charge_Join
An outer join of:
* Tele_Location_Join form (Primary)
An inner join of:
* Tele Data form (Primary)
* Location Data form (Secondary)
* Location RecType_Join (Secondary)
An inner join of:
* Location Data form (Primary)
* Location Data form (Secondary)
Our environment is:
AR System: 6.03 patch 15
Remedy User Tool: 6.03 patch 15
Oracle 9i - ver 9.2.0.6.0
Christopher Pruitt
Consultant Specialist
EDS - Bank of America
I3-Inventory IW Infrastructure Team
Phone: +1-972-605-7702 (8-835)
mailto:HYPERLINK
"mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED]
<mailto:HYPERLINK>
Confidentiality Notice: This message and any files transmitted with it
are intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged,
and exempt from disclosure under applicable law. If you are not the
intended addressee for this e-mail, you are hereby notified that any
copying, distribution, or dissemination of this e-mail is strictly
prohibited. If you have received this e-mail in error, please
immediately destroy, erase, or discard this message. Please notify the
sender immediately by return e-mail if you have received this e-mail by
mistake.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
