Is the mid-tier reporting function on the BOXI server creating the appropriate report folder and file??
On my BOXI server, the mid-tier is installed in C:\AR System\Mid-Tier and the report folders appear as: C:\AR System\Mid-Tier\reports\m11c23c11b16\32-character GUID foldernames\one or more .rpt files They are defined in C:\AR System\Mid-Tier\reports in the Mid-Tier Configuration Tool - on the BOXI server. There were 43 GUID named folders, one for each report or set of reports (same report file but sorted on category, date range, priority, or other options) that someone used on the web over the last two years. The .rpt file gets copied to the BOX server's mid-tier on first use, then is updated only if revised or if different options are selected (several rpt files in same folder). Just now I opened a report through the production mid-tier that had never been run before, which created a new 44th GUID named folder under C:\AR System\Mid-Tier\reports\m11c23c11b16\ on the BOXI server. It did NOT create a folder in the equivalent \reports folder on the production mid-tier, even though that has also been specified in the Mid-Tier Configuration Tool, because the report configuration tells it to use the mid-tier on the BOXI server instead. That folder on the mid-tier server is in fact empty. If you are not seeing the .rpt files generated in the reports folder on the BOXI server's mid-tier by the handoff from the main mid-tier server, there may be a permissions issue with that \reports folder. My tomcat instance for the mid-tiers on both servers runs under a domain account that has full rights to the \reports folder on the local BOXI server, so that could be it. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ramey, Anne Sent: Monday, May 24, 2010 3:16 PM To: [email protected] Subject: Re: Mid-teir & BOXI on separate servers When I try to run a report from the "ReportSelection" screen I get: Server Error in '/businessobjects' Application. ________________________________________ Key cannot be null. Parameter name: key Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ramey, Anne Sent: Monday, May 24, 2010 2:42 PM To: [email protected] Subject: Re: Mid-teir & BOXI on separate servers ** I did this and get the same error: Error during processing : ARERR [9246] Cannot find report null of type null for form {2} on server {3}. Please see your administrator. I am obviously missing a step or something. This time the error is from the midtier that is on the same box as the BOXI. Am I supposed to load all of the reports that are loaded into remedy up into BOXI? Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of strauss Sent: Thursday, May 20, 2010 4:49 PM To: [email protected] Subject: Re: Mid-teir & BOXI on separate servers ** The CLEANEST way to do this is put another mid-tier on the BOXI server, and point your production mid-tier at it as a "BOXI/Crystal Report Server 11 on a different machine with Midtier." Then you don't have to fight to get file level permissions working between the two boxes. Typically when I do this I install BOXI on IIS using .NET so that the mid-tier using Tomcat and java has no chance of interfering with BOXI (and the mid-tier uses Tomcat exclusively as a web server - no connection to IIS with an ISAPI shim). The BOXI server mid-tier uses "BOXI/Crystal Report Server 11 on this machine" on port 80 for reporting. Then the production mid-tier uses the BOXI mid-tier for reporting on port 8080 as shown in the first paragraph. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ramey, Anne Sent: Thursday, May 20, 2010 2:59 PM To: [email protected] Subject: Mid-teir & BOXI on separate servers ** I have BOXI and mid-teir both working fine, now I'm trying to get them to talk to each other. I'm following the instructions in the mid-teir guide, but am getting a strange error and am unsure what to do next. Mid-teir 7.1 p6 on linux BOXI on Windows 2003 R2 (7.1 ARWebReportViewer) ITSM 7.03 The error is: Error during processing : ARERR [9246] Cannot find report null of type null for form {2} on server {3}. Please see your administrator. on the screen, this in catalina.out: Throw Error - 9246 And this in the mid-teir log: May 20, 2010 3:54:40 PM - SEVERE (com.remedy.log.DVMODULE) : Exception while processing requestjava.io.IOException: Error during processin g : ARERR [9246] Cannot find report null of type null for form {2} on server {3}. Please see your administrator. Can anyone point me to what I've missed? Thanks, Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"

