Another good idea. I changed the Active Link qualification from "'Issue ID' = $Issue ID$" to "'Create Date' = $Create Date$." That works in the WUT, but now Mid-Tier is complaining that it can't find "Create_Date." It looks like for some reason the Mid-Tier ODBC can't read the table.
Thanks again, Dwayne From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Monday, March 01, 2010 3:29 PM To: [email protected] Subject: Re: Crystal report can't find field in Mid-Tier ** How about changing the query a little bit.. Try getting the same entry, using some other query, hardcode it if required.. For e.g. where create date = <some specific date that exists as a create date on that form>. Verify if that works.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Martin, Robert Sent: Friday, February 26, 2010 12:34 PM To: [email protected] Subject: Re: Crystal report can't find field in Mid-Tier ** Joe, I upgraded from Crystal 9 to Crystal 11, and updated the report via Crystal 11, but still get the error. But thanks for goading me into finally doing the upgrade I had been putting off for years. Dwayne From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Thursday, February 25, 2010 11:15 PM To: [email protected] Subject: Re: Crystal report can't find field in Mid-Tier ** What version of Crystal Reports are you using? Is it the recommended version for the version of ARS that you use? Just to eliminate a possibility that it may not be a bug with the ARS application but possibly with Crystal, can you check known problems with Crystal on the version of Crystal that you are on? And update it to a later patch if possible? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Martin, Robert Sent: Thursday, February 25, 2010 4:06 PM To: [email protected] Subject: Re: Crystal report can't find field in Mid-Tier ** Re: Are the erroring fields in the View that the report is running against? The Mid-Tier seems to be sensitive to that whereas the WUT is more forgiving. Also, are those fields similar in name to other fields on the form? For example, do you have both "Entry ID" and "Entry_ID"? I could see crystal server getting confused about something like that. By the way, you definitely want to have "use underscores" checked in your ODBC config. Regards, Chuck Baldi Chuck, Thanks, but Yes, the erroring fields are in the view that the report is running against. And thanks for reminding me to recheck "Use Underscores." I had forgotten. Re: Another thing I might have tried doing just for kicks, is editing the report using Crystal designer, remove the query, recreate it, remove the field from the results, add it back, save, and then add the report file to the Remedy reporting application again. Then flush the MT cache if required again, and try the report from the web.. That would hopefully 'repair' any potential problem that might be with the rpt file itself.. Joe Joe, I removed the field from the report. Saved the report, then re-inserted the field, saved the report again, and re-attached it to the "Report" entry, then flushed the Mid-Tier cache. But I still get the error. But thanks for the suggestion. I'll try anything. Dwayne -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Martin, Robert Sent: Thursday, February 25, 2010 12:16 PM To: [email protected] Subject: Re: Crystal report can't find field in Mid-Tier ** Thanks for the suggestion, Joe. That one didn't work either, but it was worth a try. Keep 'em comin'. Dwayne From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Thursday, February 25, 2010 9:11 AM To: [email protected] Subject: Re: Crystal report can't find field in Mid-Tier ** 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 _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
