I spoke too soon.
Whenever I try to save an entry I still get "ARERR [552] Failure during SQL
operation to the database : ORA-00904: "USER_X": invalid identifier," even when
I delete the field entirely.
So I guess my only choice is to start over with a new form.
Dwayne
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
--- Begin Message ---
This is weird. The field re-appeared as mysteriously as it disappeared. So I
renamed it to "UserID" to avoid the naming problem. But when I tried to save
the form I got "Field is not related to this form C56500229" (can't remember
the exact wording). So I deleted the field, saved the form, then pasted the
field back in, and saved again, and now everything seems to be working.
So thanks, Frederick and Juan for your replies. I now know not to name a field
"User."
Dwayne
---- Original message ----
>Date: Wed, 20 May 2009 13:15:14 -0500
>From: "Grooms, Frederick W" <[email protected]>
>Subject: Re: Missing field’s ghost haunti ng form
>To: [email protected]
>
>Since you can see the database view you can see what table column that field
>on the view is pointing to. You can then update that field in the Admin tool
>(finding by the ID number).
>
>Fred
>
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:[email protected]] On Behalf Of Dwayne Martin
>Sent: Wednesday, May 20, 2009 12:17 PM
>To: [email protected]
>Subject: Re: Missing field’s ghost haunting form
>
>Thanks, Juan!
>
>According to my records and memory, the field has been named "User" for at
>least the past nine days. But I guess it is possible that I made some
>innocent change that I don't remember that triggered the problem.
>
>The big question is, now that I have made the mistake, is there any way of
>reversing it other than by creating a whole new form, and repointing the
>workflow from the present to the new form?
>
>Dwayne
>
>---- Original message ----
>>Date: Wed, 20 May 2009 08:56:43 -0700
>>From: Juan Ingles <[email protected]>
>>Subject: Re: Missing field’s ghost haunting form
>>To: [email protected]
>>
>> ** 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
>> <[email protected]> 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)
>>
>
--- End Message ---
