Sorry for bumping this, but I still couldn't figure it out. Does anyone have an idea - where would you look if your MidTier raised an ORA error on a form that works without problems in the fat client?
Regards, Michael From: Nau, Michael Sent: Friday, February 08, 2013 4:32 PM To: arslist@ARSLIST.ORG Subject: MidTier raises ORA-00904, User tool doesn't Hi List, here's some error I encountered this morning: We have a custom form - display-only, just a customized view of the data on TMS:Task. The form hasn't been touched in years. It's so old, I don't even know if anyone has ever opened it in the webclient. On it, there is a menu to select a support group and a drop-down list to select a task status. When the users changes on of these two fields, a table showing the tasks is refreshed, using the selected values as EXTERNAL qualifications. Works without any problems on the User Tool. Now...on the webclient the form takes unusually long to load. The table is not showing, not at all, not even the header / footer. Now it gets really interesting: When the user selects a status from the drop-down list, ORA-00904 is raised, pointing to "T740"."C536870919", and ARWARN 311. This is the drop-down list itself. What I've done: - flushed cache - restarted midtier - checked the form and all field names for characters the midtier could trip over - renamed the drop-down list and the table AR 7.0.0.1 / Solaris / Oracle 11gR2 MidTier 7.5.00 7 RHEL / tomcat 5.5.32 Have a nice weekend, Michael Nau IT Infrastructure & Customer Services ING-DiBa AG Theodor-Heuss-Allee 100 60486 Frankfurt am Main Telefon 069 / 27 222 66596 m....@ing-diba.de<mailto:m....@ing-diba.de> www.ing-diba.de<http://www.ing-diba.de/> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
ING-DiBa AG, Frankfurt am Main. Registernummer HRB 7727, Handelsregister Amtsgericht Frankfurt am Main. Vorstand: Roland Boekhout (Vorsitzender), Herbert Willius (stellv. Vorsitzender), Bas Brouwers, Bernd Geilen, Katharina Herrmann, Martin Krebs. Aufsichtsrat: Ben Tellings (Vorsitzender) Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
