It sounds like one of your remedy views has gotten dropped.
Since your remedy joins are on the views, and your oracle sql you are
running is against the t-tables, this would agree.
Additionally, in the past, whenever I have had join forms that would
return results list, but then no actual ticket data in the details
section of the user tool window, it was always because a view form was
dropped.
Try opening up each of the view forms in the user tool to make sure they
all exist. Additionally, you might check on the database level to make
sure the view forms are there.
I know that it can get tricky whenever you have nested joins. If you do
something that causes one of the lowest level joins to be rebuilt, then
you run the risk of remedy not properly rebuilding all joins.
Example:
A
B C
D E
Where A is a join of B and C, and C is a join of D and E, I've seen in
the past where you modify form E that causes the view to be
dropped/recreated, and occastionally A will get dropped. This gets
tricky if you have other forms that are joins of A and, say, F, then you
don't have the visibility to see that A is broken.
Check this out to see if it is the problem. This is the easiest to fix:
just find the broken join form, open it up in admin tool, move a field
and hit save.
If all of your forms are SQL views, then you will need to re-run your
sql query to rebuild the view. Start at the bottom so you don't re-break
everything once you're finished.
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Pruitt, Christopher J
Sent: Monday, February 12, 2007 3:48 PM
To: [email protected]
Subject: ARERR (302) Entry does not exist in database dilemma
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.
__20060125_______________________This posting was submitted with HTML in
it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
