Comments below... Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Pam Hollis Sent: Wednesday, October 10, 2007 1:10 PM To: [email protected] Subject: Re: Running mid-tier reports on Business Objects Enterprise server ** I am unclear on some of this - We have everything installed now and I am able to Login To my ARWEBREPORTVIEWER on my Business Objects Server and I can login to my Mid-Tier Server. But, not sure what I should put where. ARWEBREPORTVIEWER Configuration Page. Reporting Working Directory - Is this the location of the reports folder on the BO server for the ARwebreportviewer? Yes if you are using a mid-tier on your reporting server, but that does not appear to be what you have done. If you do not, then this is the directory that is shared to the mid-tier server (requires file level permission on the Crystal server for the mid-tier server so that it can place the .rpt file there for Crystal to serve up. I managed to do this ONCE last year while testing what the documentation and white papers tell you to do - I had to put the mid-tier server and the Crystal reporting server in the same domain, then run mid-tier on IIS with IIS running on a domain account that had write access to the directory on the Crystal server. I consciously avoid this configuration. Machine Name - Name of the Business Object server that we installed the arwebreportviewer Machine Connection Details - Business Objects Enterprise XI AR System ODBC Data Source Name -- ???? AR System ODBC Data Source CMS Folder Name - ???? ARReports (the web path you defined in IIS or Tomcat to the reporting working directory above) CMS user Name - Administrator Then on the Mid-Tier Report Settings We Choose BOXI/CRYSTAL Report Server 11 on a different machine w/o a Midtier Reporting Working Directory - What directory goes here C:\AR System\Mid-Tier\reports is the default location used by mid-tier BOXI/Cyrstal Report Server 11 Location - address of the Business Object Server If I am pointing to the mid-tier on my Crystal server: http://midtierserver on crystalserverFQDN:8080 <http://midtierserver on :8080> If I am pointing directly to the Crystal report server: http://crystalserverFQDN:80 _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Tuesday, September 11, 2007 1:48 PM To: [email protected] Subject: Re: Running mid-tier reports on Business Objects Enterprise server Here is my procedure for a stand-alone BOXI server to produce reports for a production mid-tier on any platform. The BOXI server is on Windows Server 2003 Enterprise R2. Install IIS 6.0 Install Java SDK 1.5.0_12 Install SQL Server 2005 Std x86 and Sp1 in mixed mode for Crystal Report Server. SQL Server authentication and TCP/IP limited to subnet - no port open in Firewall Create local SQL Server account <crystal user> as a db creator Install Crystal Reports Server XI on IIS Use .NET 2.0 and un-check Java Specify local SQL Server (server name instance) and crystal user account information CRXI installer creates BOE11 database and five CMS_xxxxxxx tables (The Central Management Server in the Central Configuration Manager may have to have the crystal user account pwd set manually) Install Mid-Tier 7.0.01 (IIS service off) and force load of Tomcat 5.5.17 with web enabled (port 8080) Make sure you select to also install the AR Crystal Web Application Edit tomcat config to add windows service account with strong password with Roles: manager Start - Tomcat 5.5 - Monitor Tomcat Right-click Open from the system tray to Configure On the Java tab Change "Initial memory pool" to 1024 Change "Maximum memory pool" to 1536 Change "Thread stack size" to 3000 Restart Tomcat service Add service account to local Power Users group Change Apache Tomcat service to run under service account Restart Tomcat service DO NOT Edit prefetchConfig.xml to pre-load and cache forms or applications - this server is for Crystal Web _only_ Configure mid-tier server at http://<webserver <http://%3cwebserver> fqdn>:8080/config/ General Settings Set values for Preference, Data Visualization Module, Homepage, and Authentication Server to <ar server fqdn> AR Server Settings Installation should add one server, <ar server fqdn>- Port ##### If used to serve CRXI for other remedy servers, they will need to be listed (test for conflicts) Cache Settings Default values - do not implement Pre-Fetch Report Settings [POINT TO IIS, NOT TOMCAT] Crystal/BO Report Engine Deployment: BOXI/Crystal Report Server 11 on this machine (If not listed as a choice to select, may have to uninstall/reinstall mid-tier and force it to load the AR Crystal Web Application) Reporting Working Directory: C:\AR System\Mid-Tier\reports Crystal Enterprise 10 Location: http://<webserver>:80 <http://%3cwebserver%3e:80> BOXI/Crystal Report Server 11 Location: http://<webserver>:80 <http://%3cwebserver%3e:80> CMS Machine Name: <webserver short name> Business Objects Enterprise XI selected (Crystal Report Server XI selection does NOT authenticate properly) AR System ODBC Data Source Name: AR System ODBC Data Source CMS Folder Name: ARReports CMS User Name: Administrator CMS Password: <blank> Configure production mid-tier server(s) to use the BOXI server for web reporting Report Settings [POINT TO MID-TIER ON TOMCAT] BOXI/Crystal Report Server 11 on a different machine with Midtier (If not listed as a choice to select, may have to uninstall/reinstall mid-tier) C:\Program Files (x86)\AR System\Mid-Tier\reports http://<webserver <http://%3cwebserver> midtier with boxi>:8080 http://<webserver <http://%3cwebserver> midtier with boxi>:8080 Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _____ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
