OK, I had a problem with IIS where I couldn't browse the arreports virtual directory. That has been fixed now, so instead of getting a 500 error, I get:
HTTP Error 404 - File or directory not found. Internet Information Services (IIS) ? 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Wednesday, May 26, 2010 10:06 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI Ok, this is the URL it's trying to pull up: http://<mysever>/arsys/m11c23c11b16/56FB4E5FAFEA4D336FC6EE4CE9E26851/null or http://<mysever>/crystalreportviewers11/arsys/m11c23c11b16/56FB4E5FAFEA4D336FC6EE4CE9E26851/null Does that look right? arsys is not the name of the reports directory or any part of the reports configuration. 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Wednesday, May 26, 2010 9:45 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI I've removed the redirect and tried both the home (where the now blank default page is) and the /crystalreportviewers11 location, but get: The page cannot be found When trying to run a report, but I do get the blank index page and the authorization error when I access the sites directly. I've also tried the /businessobjects and /enterprise11 directories (why not, at this point). I've double checked that all of my servers are running in the BO, including RAS. 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Tuesday, May 25, 2010 3:47 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI That redirect is probably the problem. My servers have the iisstart.htm in them, which will display if you point a web browser at <webserver>:80 or localhost:80, but no redirect page. My guess is that the redirect is interfering with the DefaultAppPool where /crystalreportviewers11 is defined as one of the default applications (I have three - root, /businessobjects, and /crystalreportviewers11. Try specifying the URL to the /crystalreportviewers11 location in mid-tier. 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:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Tuesday, May 25, 2010 1:46 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI I guess that is the problem. The IIS server that does BOXI is multi-purpose and doesn't just do BO. Is there a way in BO I can tell where the Crystal/BO Report Engine is? What URL to use? Http://<myserver>:80 is just a text index page that redirects to a login page. 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Tuesday, May 25, 2010 1:52 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI Well, you only use http://<myserver>/businessobjects/enterprise11/admin/en/admin.cwr with the Administrator login to go and check/set your license keys (if the BOXI installer did not do it for you). The mid-tier Report Settings simply point at http://<myserver>:80 on my machines, with the Crystal/BO Report Engine Deployment field set to "BOXI/Crystal Report Server 11 on this machine" I am using Crystal Report Server XI, but it only works properly when you select the CMS Machine Connection Details for Business Objects Enterprise XI, where the settings are: AR System ODBC Data Source ARReports Administrator <the CMS password for the BOXI Administrator account> The CMS Machine Name is the short name for the web server, which in my case corresponds to the local SQL Server 2005 instance name that is hosting the BOE11 database. 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:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Tuesday, May 25, 2010 12:08 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI What Crystal URL am I to use? Admin Console http://<myserver>/businessobjects/enterprise11/admin/en/admin.cwr Info View http://<myserver>/businessobjects/enterprise11/InfoView/logon.aspx None of these work: http://<myserver>/businessobjects/ http://<myserver>/businessobjects/enterprise11/ ?? 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Tuesday, May 25, 2010 12:58 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI I am using tomcat's webserver on 8080 and BOXI is using IIS on port 80. If "Everyone", Administrator, and System have full control already, I don't know how it could be a permissions issue. Is there anywhere I might find useful logs? In the mid-tier logs, it look like everything is getting the right values set: May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mQualFieldTypes=4 May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mQualFieldValues= May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mQualFieldIds=2000037 May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mQualification=5\2000037\ May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mRemoteSchema=PBM:Problem Investigation May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mRemoteServer=ncc056.<domain> May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mCurrentVui=Default Administrator View May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mCurrentSchema=ReportSelection May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : mCurrentServer=ncc056.<domain> May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : --> CompileExternalQualification May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : GoatServlet: SessionID=0728B4793FC6B4A253B8D0DED6B87852 May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : cookie=IP-Restriction-GUID=024530e74c91f47b:-33361d29:128bb21d816:-7fe7; JSESSIONID=0728B4793FC6B4A253B8D0DED6B87852; PopBlock=0; GKW=%7B14%3A%7Bn%3A%22LASTID%22%2Ct%3A6%2Cv%3A%22000000000000193%22%7D%2C15%3A%7Bn%3A%22LASTCOUNT%22%2Ct%3A7%2Cv%3A1%7D%7D; GF=com.remedy.SomethingUnlikely May 25, 2010 12:48:27 PM - FINE (com.remedy.log.SERVLET) : GoatServlet: url=http://localhost:8080/arsys/BackChannel/?param=195%2FCompileExternalQualification%2F22%2Fncc056.its.state.nc.us15%2FReportSelection26%2FDefault%20Administrator%20View22%2Fncc056.its.state.nc.us25%2FPBM%3AProblem%20Investigation10%2F5%5C2000037%5C11%2F1%2F7%2F20000375%2F1%2F1%2F%205%2F1%2F1%2F4 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Monday, May 24, 2010 10:51 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI Then my guess is still that the account that your mid-tier is running under - whatever the Apache Tomcat server is running under - doesn't have enough permissions to write .rpt files in the mid-tier reports directory. If IIS is involved at all, it gets even more complicated - another reason besides lost performance to use tomcat's own web server on port 8080 and leave IIS on port 80 to BOXI. You might try changing the reports to a new C:\reports folder with full control by whatever account is running Apache Tomcat. 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:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Monday, May 24, 2010 8:50 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI There is nothing being created in my /reports folder, but "Everyone" has full control of that folder. I'm just trying locally (mid-tier and BOXI on the same server) at the moment. 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. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Monday, May 24, 2010 4:51 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-tier & BOXI on separate servers 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:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Monday, May 24, 2010 3:16 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Monday, May 24, 2010 2:42 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of strauss Sent: Thursday, May 20, 2010 4:49 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Ramey, Anne Sent: Thursday, May 20, 2010 2:59 PM To: arslist@ARSLIST.ORG 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" _______________________________________________________________________________ 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" _______________________________________________________________________________ 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" _______________________________________________________________________________ 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" _______________________________________________________________________________ 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" _______________________________________________________________________________ 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"
