I doubt it has anything to do with the Mid-tier cache, but could you try flushing it and then retry the operation?
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Martin, Robert Sent: Thursday, February 25, 2010 8:44 AM To: [email protected] Subject: FW: Crystal report can't find field in Mid-Tier ** Thanks for the suggestion, Latzko. I went to the host machine ODBC and the only thing checked was "Use Underscores." I unchecked it, but it didn't make any difference either to the reports that work or those that don't. Dwayne From: Latzko Joachim [mailto:[email protected]] Sent: Thursday, February 25, 2010 8:30 AM To: Martin, Robert - martinrd Subject: AW: Crystal report can't find field in Mid-Tier Have you checked the ODBC data source on the machine where the Crystal Reports server is installed? There are some options like 'use underscores' and so on. Compare that to the setting of the ODBC Data Source on your workstation. ---------------------------------------------------------------------------- -- Von: Action Request System discussion list(ARSList) im Auftrag von Martin, Robert Gesendet: Do 25.02.2010 14:27 An: [email protected] Betreff: Crystal report can't find field in Mid-Tier ** Dear List, We have several forms with buttons that call active links, that open Crystal Reports for the entry on which the button resides. They all work in the WUT. But in Mid-Tier, there are two forms that give the error: This field name is not known. Details: errorKind Error in File C:\WINDOWS\TEMP\{71402FB4-0BAE-468A-AA5F-9E7AAEDC95CA}.rpt: Error in formula . '{CS_CallEntry.Entry_ID}="CS000148"' This field name is not known. Details: errorKind. I checked in SQL developer, and "Entry_ID" is the correct field name in CS_CallEntry. If it wasn't the report would fail in the WUT as well. (The other form gives a similar error, but with a different form and field name.) So why can Mid-Tier find the Entry_ID for all other forms, but not these two? And why can the WUT find it, but not Mid-Tier? (ARS and Mid-Tier 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
