Last ditch effort to post to the list, this time via email instead of the web form...sorry if this is a repeat.
I have a couple of oddball issues. On my development system, I upgraded from 5.12 to 6.3 to 7.01. The development box is a win2003svr with ars, midtier, crystal all on one box. The database is on linux RHEL4 with oracle 10gR2. Everything upgraded fine except for one form. None of the other forms have issues. The problem form behaves completely normal in the user client - all three views. However, when I try to access it via midtier and a browser, I get nothing but a white page...no menu, no header or footer. Nada, zip, zilch. No matter which view I try, I get nothing. Has anyone else come across this? BTW, this form has been around since version 3.2 and has about 500,000 records. I doubled checked aliases, permissions, preferences - all seems correct. I tried saving the form as another name. With the new name, I can see the views via web browser. So I thought I could work around it by exporting the newly named form, editing the def file to change the form name back to the original, then reimport it back on top of the misbehaving form and.....that didn't work either. Supposedly upgrading to patch 001 would fix this issue but it didn't. And now instead I have another bug which is........ A different form (one that was working correctly unpatched) now returns an error code when ever a view is modified. Thankfully it's only this one form. The message is: Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully but the SQLView is not in place ARWARN 69. >From the error log: Mon Mar 12 08:26:02 2007 390600 : Failure during SQL operation to the database (ARERR 552) Mon Mar 12 08:26:02 2007 ORA-02250: missing or invalid constraint name Edited from the sql log: */DROP VIEW ERP_Software_Test_Request Mon Mar 12 2007 08:26:03.6400 */*** ERROR *** ORA-00942: table or view does not exist Mon Mar 12 2007 08:26:03.6400 */CREATE VIEW ERP_Software_Test_Request [edited to remove the very long create table statement] Mon Mar 12 2007 08:26:03.6400 */*** ERROR *** ORA-02250: missing or invalid constraint name I checked my database and sure enough, there is no view for the form. The solution isn't as easy as recreating the view because any time I make a change, the missing constraint will probably prevent the view from recreating. What's the missing constraint....Dunno, support is trying to figure it out....(Let me run and set my calendar <.< ) I'm actually considering uninstalling the patch (would that be as simple as restoring the original files -those listed for the manual patch upgrade in the readme.text??) Thanks guys! Carina _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
