You will have to go deep into ar to fix this one: My guess is that the AP:Detail-Signature had been modified somehow. It used to contain a field that has since been removed.
To explore this run the following queries: SELECT NUMFIELDS FROM ARSCHEMA WHERE NAME LIKE 'AP:Detail-Signature' SELECT count(*) FROM FIELD WHERE SCHEMAID IN (SELECT SCHEMAID FROM ARSCHEMA WHERE NAME LIKE 'AP:Detail-Signature') If the 2 numbers are different then you will get the "Field Count" error. If the field count from the "FIELD" table is greater than the NUMFIELDS value then you can find the missing field by: SELECT * FROM FIELD WHERE SCHEMAID IN (SELECT SCHEMAID FROM ARSCHEMA WHERE NAME LIKE 'AP:Detail-Signature') THEN DO THIS: SELECT 'T' || SCHEMAID FROM ARSCHEMA WHERE NAME LIKE 'AP:Detail-Signature' Then do a DESC on the result of the above query. You will then have to do a comparison between the description of the table and the results of the FIELD list. You should be able to tell from there what field should exist on the form. Pay close attention to the "Data Type" and "Field Type" values. I wish I could remember where the reference is for those things ... but I can't remember off the top of my head. Those 2 fields tell you what type of field it is and what type of data is stored in it. i.e. is it a "Integer", "Date", "Character" or "Date" field. If it is a "Character" is it a "Display-Only" field? etc. If the field count in the "NUMFIELDS" is greater than the field count in the "FIELD" table then you need to probably call Remedy support and see if they can help you find it. (I am assuming you didn't customize this form and left it out of the box?) You may be able to get a hint by looking at the "QUERY SHORT" parameter on the "FILTER" table: SELECT * FROM FILTER WHERE NAME = ' AP:Dtl-Sig-NextActionEscTime' but it may confuse you more than help. OR By running this query: SELECT * FROM FILTER_PUSH WHERE FILTERID IN (SELECT FILTERID FROM FILTER WHERE NAME = ' AP:Dtl-Sig-NextActionEscTime') SELECT * FROM FILTER_SET WHERE FILTERID IN (SELECT FILTERID FROM FILTER WHERE NAME = ' AP:Dtl-Sig-NextActionEscTime') and look at the "FIELDID" value. Compare that with the "AssignShort" field to make sure it is pushing to or setting from the "AP:Detail-Signature" table. Good Luck, Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Christopher Allen Sent: Friday, October 24, 2008 11:15 AM To: arslist@ARSLIST.ORG Subject: Form dropped but still in schema table ** Hey everyone, Yesterday we noticed out error log on dev had not had any changes in about 24 hours, which is a bit unusual, and the last few lines stated: Wed Oct 22 12:01:47 2008 Approve : Invalid join member form name <0> (ARERR 266) Wed Oct 22 12:01:47 2008 Approve : Operation cancelled due to error (ARAPPNOTE 4502) Wed Oct 22 12:01:47 2008 New-Details - CHG:Infrastructure Change - CRQ000000011371 Wed Oct 22 22:06:37 2008 390695 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Wed Oct 22 22:06:37 2008 0xc0000005 Wed Oct 22 22:06:37 2008 390695 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Oct 22 22:06:40 2008 390695 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Wed Oct 22 22:06:40 2008 0xc0000005 Wed Oct 22 22:06:40 2008 390695 : AR System server terminated -- fatal error encountered (ARNOTE 21) Wed Oct 22 22:11:01 2008 390695 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Wed Oct 22 22:11:01 2008 0xc0000005 Wed Oct 22 22:11:01 2008 390695 : AR System server terminated -- fatal error encountered (ARNOTE 21) We restarted the services to try and get it going again, and in just over a minute the log stopped again, full of the following sort of errors: Thu Oct 23 09:09:09 2008 390600 : The form definition file field count does not match number of fields in the file (ARERR 403) Thu Oct 23 09:09:09 2008 AP:Detail-Signature Thu Oct 23 09:10:21 2008 390600 : Form does not exist on server (ARERR 303) Thu Oct 23 09:10:21 2008 390600 : Error in definition for a filter (ARERR 343) Thu Oct 23 09:10:21 2008 AP:Dtl-Sig-NextActionEscTime Thu Oct 23 09:10:21 2008 390600 : Error in definition for a filter (ARERR 343) Thu Oct 23 09:10:21 2008 AP:Dtl-Sig-NextActionEscTime Thu Oct 23 09:10:21 2008 390600 : Form does not exist on server (ARERR 303) (thousands of rows of this) So I went and found, sure enough, the join AP:Detail-Signature was missing on our dev server, but it was there on production. No problem, I'll just import from production to dev: The value(s) for this entry violate a unique index that has been defined for this form: (ARERR 382) The following form was not imported: AP:Detail-Signature (ARERR 55) We checked the arschema table, and sure enough, it's there, id 99. Even overwriting the object on the destination server gave the same error (which strikes me as really odd). We imported this morning with Migrator. This time it seemed to work fine- the form was in the object list and we opened it and saved it with no errors. However the error log was filled in 13 seconds of restarting the services. Same sort of errors as above- the form does not exist. I opened the schema table and saw the form was now ID 1778 and ID 99 was gone. So the workflow is looking for a form id which no longer exists. It seems like going into the schema table and changing the form id from 1778 to 99 will magically fix this, but I wanted to get some more opinions before I go poking around in the DB. Also, how could the form have been dropped without updating the schema table? Through sql? SQL 2005 sp2 ARS 7.0.1 p6 Windows Server 2003 Thanks! Chris __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
