While I don't know about BOXI R3, I know that it is possible to use MidTier and BOXI R2 on the save server, although I had to figure out how to get it to work mostly on my own. In our case, we were using Tomcat for the MidTier and for some reason (I don't recall what) we also had to use the Java servlet engine rather than the .NET one for BO in order to get things to work. I had to upgrade Tomcat to 5.5.25 (which wasn't officially supported with BOXI R2, but I think it is supposed to be for R3) and then had to manually install all the WAR files in the right order using the built in Tomcat manager application. Once I did that (there were probably some other small details also, but it was last year, and I no longer have access to my notes) we were able to use it successfully. One thing to consider, though, is that you would probably want to configure a second, separate instance of Tomcat rather than running Midtier and BO in the same instance, due to memory constraints.
That said, one thing we were never able to get working was viewing the built in Crystal reports in the MidTier. After working with BMC, we came to the conclusion that it was not possible with the version of BO that came with Analytics due to licensing constraints. That is, the feature that is required in order to view the reports was not licensed with the license given for Analytics. However, I don't know if that is really correct - I'm not sure if we ever came to a common understanding with BMC on the issue. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of strauss Sent: Thursday, February 26, 2009 12:37 PM To: [email protected] Subject: Re: Business Objects ** After a fair amount of unsuccessful testing, I was told this week by BMC Support that it is impossible to use the BOXI server under Analytics (we are evaluating Analytics 2.5 on BOXI R3) on the same server as mid-tier: "Regarding the Analytics/Mid-Tier question, Analytics and Mid-Tier can't live together on the same webserver due Analytics restrictions. ...and therefore I would not be able to use the instance of BOXI that is installed with Analytics to accomplish Crystal web reporting for the mid-tier. I still need the separate support server setup that I have now, where Crystal Reports Server XI is on a server using .NET and IIS, and mid-tier is on the same server using the bundled Tomcat server, and this server is specified for serving reports by any or all of the normal mid-tiers that serve ITSM users. 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 Pierson, Shawn Sent: Thursday, February 26, 2009 11:15 AM To: [email protected] Subject: Re: Business Objects ** I see. In our environment we have a separate business objects instance maintained by our reporting team that is used for multiple applications. For the ITSM apps, we bought BMC Analytics, and for our custom apps we just pull the data directly from the database in the custom universes we created. Instead of doing reporting directly from the Mid Tier, we just have links to the appropriate portions of WEBI (the web-based Business Objects environment) to pull up those reports. To the end user, it doesn't make a difference if you have BOXI installed right on the Remedy Mid Tier server or if it's on another server, if you run the full BOXI version since it's just a matter of pointing hyperlinks to the right place. Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sokol, Brian Sent: Thursday, February 26, 2009 10:55 AM To: [email protected] Subject: Re: Business Objects ** This has nothing to do with ITSM? It is pure ars. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pierson, Shawn Sent: Thursday, February 26, 2009 11:38 AM To: [email protected] Subject: Re: Business Objects ** If your company has another business objects environment, it is possible to install the ITSM universe in that environment and avoid these problems altogether. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Sokol, Brian Sent: Thursday, February 26, 2009 10:14 AM To: [email protected] Subject: Business Objects ** I have been trying in vain for many, many months to get BO to work with our MidTier. Business Objects says it is a BMC problem and vice versa. On top of that I don't really trust our Crystal admin. Up to now I could get the reports to display but always got an error when I tried to print them. I am able to export the report to a pdf but can not print it. Now I have another problem. I just updated the report in the remedy Report form and get this error: An unexpected error has occurred com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred cause:java.io.IOException: CreateProcess: "C:\Program Files\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe" -report "C:\Program Files\AR System\ARWebReportViewer\reports\m11c23c11b16\6shgOZtHHZgKVndQxd8aK8q3Ak\POReport.rpt" -newrpt -discard -version 1100 -thumbnail -outfile -token z...@ag@_E\TAgWDIea[I<P0QZ9V<;YJ;JmL8fP82mY7]Q`91jlhYgd3==8SkcM=C1f=f5P:L3S0]Gd;NGai31_De<<P0QZ9V<;Yj;J -token -outfile -thumbnail 1100 -version -discard -newrpt System\ARWebReportViewer\reports\m11c23c11b16\6shgOZtHHZgKVndQxd8aK8q3Ak\POReport.rpt? Files\AR ?C:\Program -report 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe? Enterprise Objects\BusinessObjects Files\Business CreateProcess: java.io.IOException: was thrown originally exception The occurred has error="3" unexpected detail:AnmL8fP82mY7]Q`91jlhYgd3==8SkcM=C1f=f5P:L3S0]Gd;NGai31_De<</h3" The problem has to do with reportadd.exe. I assume this is copying over my new version of the report file. Our install of BOXI is on our D drive. The reportadd.exe file is located at d:\boerir2\common\3.5\bin In the error above it is looking for this file on the C drive. I also found this KB on the BMC support site: Can Business Objects XI be installed on a non-C drive to run Crystal reports in Mid-Tier? Product Environment Solution You should always install BOXI on "C:\" drive. If you don't install BOXI on "C:\" drive, you will get crystal exception such as below while running crystal reports. com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred cause:java.io.IOException: CreateProcess: "C:\Program Files\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe" -report So is this a Business Objects bug or a BMC bug? BMC is not referencing any kind of KB or bug note from business objects. Also has anyone experienced the problem I am having where you can display the report but not print it? Running this on ARS/Mid Tier 7.1/Win Server 2003/IIS Thanks, Brian __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here<http://www.sug.com/disclaimers/default.htm#Mail>. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here<http://www.sug.com/disclaimers/default.htm#Mail>. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
