There were some very old fields created before the year 2000 which in the
database were classed as “CLOB”, but which Remedy seemed to think were “LONG.”
Per Doug Mueller I ran:
select fieldId, isLong from field_char where schemaId = 424 (the schemaid).
That showed three fields with a value of 1. They were obsolete anyway so I
deleted them. When I saved the form I did NOT get the usual error about the
sql view not being in place. When checked the database the sql view was there!
Thank you Doug, for the solution.
Dwayne Martin
--- Begin Message ---
Hello Everyone,
We have a form named “LA:SoftwareInstall.” For years we have queried the
database using the view name “la_softwareinstall.” Now that view is no longer
present. If I look at a list of all our views on the database (Oracle 10.2 db)
I see views for the other forms, but nothing resembling “la_softwareinstall.”
It is missing in both our test and live databases.
Last year we copied our existing database to a new server, then installed the
7.1 ARS system on top of it. Is it possible that the “la_softwareinstall” view
somehow got left behind in the database copy?
Is there an easy way to get it back again? I know we could use a complicated
"create view" statement directly in Oracle, but would that even be wise?
Dwayne Martin
James Madison University
--- End Message ---