I was thinking of doing that Axton but if it doesn't work then the repercussions are that I have start from square one since all the workflow would be corrupt right? Has anyone actually tried this? If so that would raise my confidence and I guess I could try to purge the view form and reimport it via an altered def file... Im waiting for Remedy BMC to get back to me on this to see if they can provide any advice on this.
Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Monday, October 02, 2006 10:54 AM To: [email protected] Subject: Re: Receiving error when attempting to remove field on View Form It looks like the column was dropped frmo the table/view the view form points to. Add the column back to the view/table, then delete the field from the view form. Alternatively, you can export your workflow against this form, delete the form, recreate it with your modified def, then reimport the workflow. Axton Grams On 10/2/06, Lammey, Peter A. <[EMAIL PROTECTED]> wrote: > ** > > > I have been working with a DBA who setup a table on the AR System database. > I noted that one field on the table needed to be removed but since the > DBA had removed the column from the oracle table, I keep getting the > errors from the view when I try to remove the field from the view itself: > > Failure during SQL operation to the database : ORA-00904: "EMP_NUM": > invalid identifier (ARERR 552). > > I basically cannot save the form by removing this field and every time > I try to add another field I get the same error. > It seems that the view form is now corrupt. > > I have also tried to export the form into a .def file and edited the > def file and moved the num-fields down one and removed the part of the > file that references the field but I still get the same error that is above. > > I rather not delete the form and all workflow because of this. > > Does anyone know of a way out of this? > I also removed any references to the field and even tried to change > the field name used in the view for the field to another field but I > still get the same result. > > Thanks > Peter Lammey > ESPN MIT Technical Services & Applications Management > 860-766-4761 __20060125_______________________This posting was > submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
