This sounds like some weirdness we encountered two weeks ago. A user was receiving the following error when trying to export to a csv with an AR report template: Error occurred in generating report. ARERR [553] Operation requested is too large for a single SQL command.
It was repeatable on different machines with 7.0.1 no patch and 7.1 patch 6. We found that selecting all of the records, selecting the report template and exporting will results in this error. If we deselected all of the records, select the report template and then export this error does not happen. Since we found a work around we didn't run a SQL trace log on the DB server to see what the differences were in the way the SQL statement is issued depending on selecting the records or not. Jason On Tue, Apr 14, 2009 at 9:14 AM, William Rentfrow < wrentf...@stratacominc.com> wrote: > ** 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. > wrentf...@stratacominc.com > Corporate Website, www.stratacominc.com > 715-410-8156 C > > > ------------------------------ > *From:* William Rentfrow > *Sent:* Thursday, April 02, 2009 9:51 AM > *To:* arslist@ARSLIST.ORG > *Subject:* RE: Reports won't run in the WUT > > I checked that too - it is correct. > > William Rentfrow > Principal Consultant, StrataCom Inc. > wrentf...@stratacominc.com > Corporate Website, www.stratacominc.com > 715-410-8156 C > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Mansur, Joanne > *Sent:* Thursday, April 02, 2009 7:56 AM > *To:* arslist@ARSLIST.ORG > *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: > arsl...@arslist.org] *On Behalf Of *Lammey, Peter A. > *Sent:* Wednesday, April 01, 2009 3:54 PM > *To:* arslist@ARSLIST.ORG > *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: > arsl...@arslist.org] *On Behalf Of *William Rentfrow > *Sent:* Wednesday, April 01, 2009 3:42 PM > *To:* arslist@ARSLIST.ORG > *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. > > wrentf...@stratacominc.com > > Corporate Website, www.stratacominc.com > > 715-410-8156 C > > > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] *On Behalf Of *Charles Baldi > *Sent:* Wednesday, April 01, 2009 2:10 PM > *To:* arslist@ARSLIST.ORG > *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 < > wrentf...@stratacominc.com> 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. > > wrentf...@stratacominc.com > > Corporate Website, 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: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
