That is interesting that support doesn't know about this. For one I would think it is a pretty common issue. Anybody who has upgraded their pre 7 server would experience it (unless a Unix installer uses a different mapping that updates or overwrites). Maybe not many people have tried exporting to Excel? Second we resolved this ourselves at my last job but I am pretty sure that we told support exactly what we did to fix it when closing out our ticket. I guess the solution didn't make it any further then the incident record (ISS03165279 for anybody on the inside who may want to look it up).
We just fixed it on our server here. Here is what we did: Updated configuration record Request ID: 000000000000001 for AR System report type. Changed Run Command value From: /servlet/NativeReportServlet?O=$RPTOP$&U=$USR$&P=$PWD$&Q=$RPTQUERY$&QR=$RPTQOVR$&S=$RPTSVR$&F=$RPTFORM$&VW=$RPTVIEW$&VWEXT=$RPTVIEWEXT$&APP=$RPTAPP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAGE$&CTRY=$COUNTRY$&enc=$RPTENC$ To: /servlet/NativeReportServlet?O=$RPTOP$&U=$USR$&P=$PWD$&Q=$RPTQUERY$&QR=$RPTQOVR$&S=$RPTSVR$&F=$RPTFORM$&VW=$RPTVIEW$&VWEXT=$RPTVIEWEXT$&APP=$RPTAPP$&R=$RPTNAME$&RF=$RPTFILE$&LOC=$LOC$&TZ=$TIMEZONE$&LNG=$LANGUAGE$&CTRY=$COUNTRY$&enc=$RPTENC$&DT=$RPTDEST$&CS=$RPTCHARSET$ Let me know if this works for you. Jason On Wed, Apr 23, 2008 at 6:36 AM, Sokol, Brian <[EMAIL PROTECTED]> wrote: > ** Thanks Jason, > > Yes it is an upgraded server. I opened a tkt with BMC support but they > were clueless. They kept insisting it was a problem with my report (even > though I get the same error on all reports). It is getting more and more > difficult to prove there is a bug. Please let me know if you come up with a > solution. > > Brian > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Jason Miller > *Sent:* Wednesday, April 23, 2008 4:12 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Can you export to a csv file from Mid Tier? > > ** Hi Brian, sorry I am late to the party. Sounds like a pre 7 server > that was upgraded to 7.x. I have seen this before and actually need to > fixed at my new job. > > What I have seen happen is the Report Type record for "AR System" does not > import (.arx file) during the upgrade because the record already exists and > the mapping is set to reject duplicate records. In version 7 there was a > little bit more "magic" added to the Run Command field (if I remember > correctly) to handle exporting to csv which wasn't available before. > > I have been meaning to find the specifics since we have the same problem > currently. I will post the fix once I find it (hopefully tomorrow, or today > (1am according to my laptop)). > > Jason > > On Tue, Apr 22, 2008 at 6:31 AM, Sokol, Brian <[EMAIL PROTECTED]> > wrote: > > > ** It is a tiny report. There is nothing wrong with it. I can print it > > or preview it. I can also export it using the user tool. Just will not work > > on MidTier. > > > > Brian > > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Steve Brown > > *Sent:* Sunday, April 20, 2008 6:29 PM > > *To:* arslist@ARSLIST.ORG > > *Subject:* Re: Can you export to a csv file from Mid Tier? > > > > ** > > > > Try preview report. How big is the file. > > > > > > > > If successful then problem with lies with the export,( destination, > > permissions) > > > > > > > > if unsuccessful problem lies with report, check parameter settings, > > another report, create small temp report preview that, as a start > > > > > > > > *Steve Brown* > > > > System Management Consulting > > > > p 03 9781009 > > > > m 021 48 22 66 > > > > e [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Sokol, Brian > > *Sent:* Saturday, 19 April 2008 3:34 a.m. > > *To:* arslist@ARSLIST.ORG > > *Subject:* Can you export to a csv file from Mid Tier? > > > > > > > > ** > > > > I thought this was now possible? I am on ver 7.1. I have a report for > > the form I am using. In the Report window I selected Destination File and > > Report Format CSV. When I click Run a get a window to name the file. That > > all works up to that point. When I click Ok after naming the file I get an > > error: > > > > Report Error > > Failed To Perform Action > > > > Am I doing something wrong here? > > > > Brian Sokol > > Manager, Desktop Services > > Scholastic Inc. > > 557 Broadway > > NY, NY 10012 > > (212) 343-6494 > > http://www.Scholastic.com > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
