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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"