Once again, Doug Mueller came thru with the answer. It was a variation on the
previous problem, only this time it was a Diary field instead of a Character.
When I did:
select fieldId, isLong from field_diary where schemaId = 426
I got: FIELDID: 536870919, ISLONG: 1.
Fortunately, we no longer use this field and so we can delete it. I asked Doug
what somebody should do if they still needed the field and he said he didn't
know, but support would.
Thanks, Doug!
Dwayne
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
--- Begin Message ---
Dear List,
I am suffering a recurrence of a problem I sent in back in February. I have a
form with no sql view. If I change the db name of a field I get “Creation of
one of the SQL views for the form failed within the SQL database. Operation
completed successfully, but the SQL view is not in place. (ARWARN 69).”
The last time the problem turned out to be “ISLONG” character fields, but I ran
the same selection statement and found no such fields. In fact, there are no
fields > 255 chars in the form.
If I run an sql log I see:
****
/CREATE VIEW LA_SILab
(Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By,Modified_Date,Status,Lab_Name,Software_title,Computer
_type,What_to_do_,Work_Log,Others_still_In_Progress,Install_number,Valid_Through,Last_modified_by_person_Date,Attachment_Field4,Attachment_Field5,Attachment_F
ield6) AS SELECT
T426.C1,C2,C3,C4,C5,C6,C7,C8,C536870916,C536870917,C536870918,C536870919,C536870921,C540003300,C560000069,C563000663,CO1000000004||';'||CC100
0000004||';'||C1000000004,CO1000000005||';'||CC1000000005||';'||C1000000005,CO1000000006||';'||CC1000000006||';'||C1000000006
FROM T426, B426 WHERE T426.C1 =
B426.C1,T426C536870919 WHERE T426.C1 = T426C536870919.entryId
<SQL > <TID: 0023399328> <RPC ID: 0000001601> <Queue: Admin > <Client-RPC:
390600 > <USER: martinrd >
/* Thu Apr 10 2008 10:41:57.5490 */*** ERROR *** ORA-00933: SQL command not
properly ended
***
If I run this statement in TOAD I get “ORA-00933: SQL command not properly
ended” and it hi-lites the next to last “C1”.
The form name is “LA:SILab”. I checked for fields with names the same as
Oracle keywords.
I have no problem updating other forms.
So if all you good people who came to my aid last time would like to try again
I will be very glad for your help.
(ARS 7.1, RH Linux server, Oracle 10.2 db)
Dwayne Martin
James Madison University
--- End Message ---
