Just thought of something else you may want to check. Open the ReportType form.
Do you have entries in this form with the following data (2 records, one with Report Type "AR System" and one "Crystal")? The one in particular you should check is the Report Type Crystal and its Run Command settings. Report Type : AR System Query Converter Class : Query Override Capability : Yes Run Command : /servlet/NativeReportServlet?O=$RPTOP$&U=$USR$&P=$PWD$&Q=$RPTQUERY$&QR=$RPTQOVR$&S=$RPTS VR$&F=$RPTFORM$&VW=$RPTVIEW$&VWEXT=$RPTVIEWEXT$&APP=$RPTAPP$&R=$RPTNAME$&RF=$RPTFILE$&LO C=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAGE$&CTRY=$COUNTRY$&enc=$RPTENC$&DT=$RPTDEST$&CS=$RPTCHA RSET$ Edit Command : /servlet/ViewFormServlet?formfield=17127&server=$UPRPTSVR$&mode=query&qual=%278%27%3D%22 $RPTNAME$%22&viewExt=$RPTVIEWEXT$ Create Command : /servlet/ViewFormServlet?formfield=17127&server=$UPRPTSVR$&mode=submit&qual=%3Com%3E%3Cf id%3E17121%3C%2Ffid%3E%3Cvt%3E4%3C%2Fvt%3E%3Cval%3E$RPTSVR$%3C%2Fval%3E%3Cfid%3E17127%3C %2Ffid%3E%3Cvt%3E4%3C%2Fvt%3E%3Cval%3E$RPTFORM$%3C%2Fval%3E%3C%2Fom%3E&viewExt=$RPTVIEWE XT$ Report Type : Crystal Query Converter Class : com.remedy.arsys.reporting.CrystalQueryConverter Query Override Capability : Yes Run Command : Crystal10URL=$CRTLOC$/arreports/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERVER$;A RServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$;ARVU IType=1&Password0=$PWD$&SF=$RPTQUERY$ BORemoteAPPURL=$CRTXILOC$/arreports/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERVE R$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$; ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ BOCurrentMidtierURL=$CRTXILOC$/arsys/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERV ER$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$ ;ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ BORemoteMidtierURL=$CRTXILOC$/arsys/$RPTLOC$?init=$CRTVWR$&User0=$USR$;ARServer=$ARSERVE R$;ARServerPort=$ARSERVERPORT$;ARAuthentication=$ARAUTHENTICATION$;ARReportLocale=$LOC$; ARVUIType=1&Password0=$PWD$&SF=$RPTQUERY$ Edit Command : Create Command : Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of William Rentfrow Sent: Tuesday, April 14, 2009 12:14 PM To: [email protected] Subject: Revisiting - RE: Reports won't run in the WUT ** So this problem continues. I don't think BMC support believed me until I showed them. Here are the things I know to be true... 1.) Upgrading to WUT 7.1 patch 006 had no effect. 2.) Reports saved from the REPORT form to the /Home/Arcmds folder and run do run (doing a search and then selecting tools/reports and the Crystal Report stored in the folder) 3.) The same report will run in Crystal 4.) The report will NOT run if you go to the IM Console > Reports > Select a report 5.) The server information under the Tools/Options is all correct. 6.) Reports will not run on our Dev, QA, Training, or Prod server this way when accessed in the method described in #4 above. 7.) Reports do not work in the method for #4 for any user All in all it seems like it's client and/or workstation based. When you press the "Run Report" button the cursor goes to an hourglass for 5 seconds or so and then goes back to normal. Nothing else happens. No errors noted anywhere. William Rentfrow Principal Consultant, StrataCom Inc. [email protected]<mailto:[email protected]> Corporate Website, www.stratacominc.com<http://www.stratacominc.com/> 715-410-8156 C ________________________________ From: William Rentfrow Sent: Thursday, April 02, 2009 9:51 AM To: [email protected] Subject: RE: Reports won't run in the WUT I checked that too - it is correct. William Rentfrow Principal Consultant, StrataCom Inc. [email protected]<mailto:[email protected]> Corporate Website, www.stratacominc.com<http://www.stratacominc.com/> 715-410-8156 C ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mansur, Joanne Sent: Thursday, April 02, 2009 7:56 AM To: [email protected] Subject: Re: Reports won't run in the WUT ** Make sure the odbc driver server is configured - it's been giving us trouble lately, especially on Vista machines. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lammey, Peter A. Sent: Wednesday, April 01, 2009 3:54 PM To: [email protected] Subject: Re: [ARSLIST] Reports won't run in the WUT ** Is the Report Server and TCP set correctly in Tools -> Options -> Advanced -> Report Server? We have our remedy connection set to go to a specific port. If the TCP port is not set in their options then that would cause this issue. The other thing to check is in the Report form for that particular report is the Server set the correct server and is the Form Name correctly set? (based on what table the Crystal Report is pointing to) Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of William Rentfrow Sent: Wednesday, April 01, 2009 3:42 PM To: [email protected] Subject: Re: Reports won't run in the WUT ** This was a great guess. Unfortunately that is not the issue. I've tried it several ways (including the way it was when it worked) and it's still broken. William Rentfrow Principal Consultant, StrataCom Inc. [email protected]<mailto:[email protected]> Corporate Website, www.stratacominc.com<http://www.stratacominc.com/> 715-410-8156 C ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Charles Baldi Sent: Wednesday, April 01, 2009 2:10 PM To: [email protected] Subject: Re: Reports won't run in the WUT ** I have seen this happen when the user does *not* have a Report Server defined in their profile. I'm not sure what triggers this, but putting a server name there as gotten rid of this error. Tools --> Options --> Advanced --> Report Server I'd like to know what your solution is, if this is not your issue. Regards, Chuck Baldi On Wed, Apr 1, 2009 at 1:07 PM, William Rentfrow <[email protected]<mailto:[email protected]>> wrote: ** Windows UT 7.1 patch 001, Solaris server 7.1 patch 001.... We - until recently - were able to run reports from the WUT. For example, the IM base product reports include a report called "Incident Details by date range". I just want to run it for the last week which is a minor amount of data. When I select the report + criteria (with a destination of "to screen") the cursor goes to an hourglass and just flickers back to a regular cursor a few seconds later. Nothing else happens. Workflow logging does not give an indication of a problem. I've deleted all local cache and re-installed the WUT. I've check the server for obvious things including; -Messages in the arerror.log -Unix system checks (e.g., disk space - reports can fail if /var is full) -Every other log/setting I can think of. When I pull the report file out of the REPORT form and try it in Crystal Reports against the same server it runs just fine. Something is very amiss - this all worked last week.... William Rentfrow Principal Consultant, StrataCom Inc. [email protected]<mailto:[email protected]> Corporate Website, www.stratacominc.com<http://www.stratacominc.com/> 715-410-8156 C __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ ________________________________ Please consider the environment before printing this e-mail. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ _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"
