Hi Christopher,
You've run into a limitation by Remedy. I've had a ticket open on this but
got it back with 'as designed'.....
If you would create a join A which uses an outer join B as one of its base
forms, and one of the base forms for outer join B has no record in it, and
you retrieve this record in Join A, you will get the error message 302. In
my opinion this is a system defect.
For instance, if you would have the Remedy Asset Management application, an
asset can have a user assigned, and an asset can have an owner assigned. You
can create nice join forms on this
UserOuterJoin: Form A: AST_Asset, Form B: AST_AssetPeople; where
asset_entry_id = entry_id and role = "User"
OwnerOuterJoin: Form A: AST_Asset, Form B: AST_AssetPeople; where
asset_entry_id = entry_id and role = "Owner"
Both these outer joins would work great and return all assets, with optional
linked users (or owners) if there are any.
Now if you'd want to run one report on all your assets with their Users AND
their Owners, in theory you could build an inner join C on the UserOuterJoin
and the OwnerOuterJoin. If you would do that, you'd get error message 302 on
all assets that do not have related users OR owners.
Now this example is a bit clunky but I guess you can see the problem here.
The good news is that I did find a workaround for this: I ended up creating
joins with the correct data as much as possible. For joining the data from
the different joins, I've added display only fields on the join form and
populated these using filters on GetEntry. Not an ideal solution but at
least it worked.
Good luck,
Michiel
On 2/12/07, Pruitt, Christopher J <[EMAIL PROTECTED]> wrote:
**
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] <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.
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
