For those that are interested, I never did track down the root cause of this issue, but it resolved itself after our weekly reboot of the AR Server.
The date/times on the DB server and ARS Server were within seconds. The logs between dev and prod were different, but nothing about the differences shed any light on the situation. I guess when all else fails, reboot!
Thanks for everyone's input.
Thad
"Argue for your limitations, and sure enough, they're yours."-- Richard Bach
| "Carey Matthew Black"
<[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/13/2006 04:35 AM
|
|
Thad,
>From what I understand about how ARS creates a new form the process is
roughly something like this....
get the next schemaId value.
Insert a "form" named "FormN" (01 is the norm, but you must have
01..06 so it went with 07).
Then all the "non-default" properties are set for "Form07" then at the
end a "Rename" is done to move the name from "Form07" to what ever you
called it in the Admin Tool.
I would also try to rename a form and see what happens then too.
And on your dev server (that is working normally) repeat actions there
and compare the SQL logs. That will most likely produce a Red Flag for
what is NOT happening on prod.
The root of this is likely very easy and centered around the "form" meta data.
You might have issues like:
The server things Form01..06 exist but they do not and it chokes
because it tries to update it's cache and fails(something goes bang)
to do so.
Their is a VUI/field definition for an arschemaId that does not
exist and ...bang...
The hard part is you are well beyond what most of us can trouble shot
from this end of emails. :( And your Prod server is where the problem
is, but your Dev server is "Happy".
You also mentioned that your problems started with an import to the
production server. what likely happened is that you tripped over a
failure in ARS to be fully backwards compatible (or some other subtle
thing) that you may not be able to fully duplicate. It might even have
been something like the ARS server lost it's connection to the RDBMS
during the object import and only part of the objects got there. Which
might explain why the server thinks there are Form01..06 out there
somewhere.
I doubt BMC Level 1 Tech support will be of much help, but you should
already be hammering them for help too.
Good luck.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On 10/12/06, Thad Esser <[EMAIL PROTECTED]> wrote:
> **
> Below is the SQL log for when I created the form. The thing I find odd is that I'm saving the form with a name like "xxxJunk", but the sql shows "Form07". Indeed, a Form07 is created, although when I open it, the admin tool has to adjust the fields to "improve the view".
>
> schemaid in the control table was 606 before the save, and it was 607 after, so it looks like that part is working as it should. Do you guys/gals see anything else in these logs?
>
> Thanks,
> Thad
> "Argue for your limitations, and sure enough, they're yours."-- Richard Bach
>
<snip>
>
> Thad,
>
> My first though would be to turn on SQL logs as you try to create a
> new form. Then pick through the log and see what the ARS server is
> doing before it gives the error. It may be subtle to find, but I would
> hope that the SQL log would show you what is going on.
>
> --
> Carey Matthew Black
> Remedy Skilled Professional (RSP)
> ARS = Action Request System(Remedy)
>
> Love, then teach
> Solution = People + Process + Tools
> Fast, Accurate, Cheap.... Pick two.
>
>
> On 10/12/06, Thad Esser <[EMAIL PROTECTED]> wrote:
> > **
> > Hello,
> >
> > Recently, when trying to import a def file, we started getting an ARERR 400.
> > After searching the archives, I found where someone else had the same
> > issue, but I didn't see that a solution was posted. Based on that
> > conversation, I tried just creating a new regular form, with no
> > modifications and saving it. On save we get the following error:
> >
> > The following item was not imported : xxxjunk (ARERR 55)
> > The file specified for a form does not hold a form definition (ARERR 400)
> >
> > This is on our production server and doesn't happen on our dev server. Does
> > anyone have any suggestions on where to start?
> >
> > Server: ARS 6.3, no patch
> > Oracle: 9.2.0.6
> > OS: Win2k, sp4
> >
> > Thanks,
> > Thad
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.***
