Did the field ever exist? I'm guessing it failed under the covers on creation when Remedy went to actually create the table. The word "USER" is a reserved word in the database. That's why the name in the view has the "_X" tagged onto it. ( Same reason the view for the user form is named "User_x" )
It's best to stay away from reserved names, as all sorts of weird things can happen as a result. If you can, I would suggest recreating the form and name the field something different. Juan Ingles On Wed, May 20, 2009 at 8:20 AM, Dwayne Martin <marti...@jmu.edu> wrote: > Dear List, > > I have a form (“PCS:Asset”) that had a field called “User” that has > mysteriously disappeared. In sql, if I select all the field IDs and names > from the “field” table, it isn’t there. > > But when I try to save an entry I get an error saying “ARERR [552] Failure > during SQL operation to the database : ORA-00904: "USER_X": invalid > identifier.” > > The SQL log shows: > select …, USER_X, … from PCS_ASSET where ASSETT_ID = 'PCA0000005' > . . . */*** ERROR *** ORA-00904: "USER_X": invalid identifier > > So my field is gone, but its ghost remains in the SQL view to haunt me. > > If I look for “Fields in View” the field isn’t in the “In” or “Not In” > table. > > I tried “DROP VIEW PCS_ASSET” and adding a new field to see if Remedy would > rebuild the SQL view, but if I do “DESC PCS_ASSET” I see the new field, > along with “USER_X > > If I try to create a new field with the same name and ID, it first > complains that the “User” name is already in use, then when I change the > name it says “Field does not exist on current form : 565000229 (ARERR 314).” > > This problem may have something to do with the “_X” after the fieldname. > Maybe I put two spaces after the name. > > I’m thinking of starting over from scratch. Any other suggestions? > > Dwayne Martin > James Madison University > (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"