7.6.04 Web Reporting issues
On BMC Remedy ITSM 7.6.04, running a report. When I connect to the mid-tier directly through the apache tomcat I am able to run all of the OOTB WEB or ARSystem reports. When I connect to the midtier through Siteminder - IIS the reports do not run. I am not getting any error messages. The hourglass is displayed that it is working, but nothing ever comes back. I do not even get the parameter pop-ups. Has anyone seen this issue? Thanks, Laura ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: 7.6.04 Web Reporting issues
Look at the IIS and SiteMinder logs. See if it is blocking the request. SiteMinder had some crude XSS checkers built into it's agent that don't work well with Remedy in the past. Maybe their agent has come a long way since the last time I had to deal with the issue, but the agent used to block requests that contained either or in the GET or POST. This precluded most things Remedy from working. Axton Grams On Mon, Feb 6, 2012 at 10:16 AM, Laura lkas...@hotmail.com wrote: On BMC Remedy ITSM 7.6.04, running a report. When I connect to the mid-tier directly through the apache tomcat I am able to run all of the OOTB WEB or ARSystem reports. When I connect to the midtier through Siteminder - IIS the reports do not run. I am not getting any error messages. The hourglass is displayed that it is working, but nothing ever comes back. I do not even get the parameter pop-ups. Has anyone seen this issue? Thanks, Laura ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Problem with web reporting and Date fields
We patched using 7.5 p6, and resolved our issue. rp ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Problem with web reporting and Date fields
ARS 7.5 p 5/~11542 SQL 2005 Tomcat 5.5.28 Java 1.5.022 IE browsers 6 and 8 Has anyone seen problems with directing web reports to the screen in either .rpt or .csv format, and the date fields not rendering? Our reports show the date field headings, but no values for DATE fields and any field type that follows (we've moved the DATE fields to the end of the report). If we direct the reports to a file, there is no failure. If we report from the UT, there is no failure. The .csv reports directed to the screen display an error in the browser, Illegal Date Style 4 I've deleted the date field, and replaced it with a new one with the same db id. I've deleted the date field, and replaced it with a new one with a different db id. There is no change. I've created new reports; no change. Two out of three servers have this issue (all in dev env.) Obviously we're working around it by not directing the reports to the screen, but... Thoughts anyone? Thanks, Rick ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Web Reporting
I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Web Reporting
Use BIRT. Open Source, works OK. You'll need to understand a whack of stuff about Web Reporting and (perhaps) write a one or two line Java class. We use it on this project in ITSM 7. Even easier for your own stuff. Cheers Ben Chernys _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Myers Sent: October 28, 2008 2:56 PM To: arslist@ARSLIST.ORG Subject: Web Reporting ** I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 __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
Re: Web Reporting
We upgraded our Crystal Reports Professional copies to XI when 7.x came out, and are using the Crystal Reports Server XI that came bundled with it to serve up our reports for mid-tier. Before 7.x, we were using Crystal Reports Professional 9 with the bundled Crystal Enterprise 9 web server in exactly the same manner for the 5.1.2 and 6.3 mid-tiers. Version XI is where BO switched from providing 5 concurrent licenses with their bundled web server (all you needed to make mid-tier reporting work) to 5 named licenses, which does not work unless you tell mid-tier that it is talking to a BOXI server instead of a Crystal Reports Server. I am not sure what BO is shipping now, but in theory the web server bundled with Crystal Reports Professional should be all that you need to serve reports for the mid-tier, since we don't serve anything else (no one is accessing any crystal report natively, only those built into the ITSM application and available through the mid-tier). I'm not sure you will find anyone still working at BMC Remedy who understands this and can give you coherent advice. For many years we were told by support that Crystal Reports Professional was the correct low-cost answer since all you needed was the bundled web server with 5 concurrent licenses to serve up reports on the web; this was true using Crystal 8.5 and 9 with earlier versions of the mid-tier. You needed Crystal Reports Professional itself to edit any of the OOTB reports, or create custom ones for import into the application, so it was the perfect choice of products. When 7.x came out and required a 10 or XI level version of Crystal, whoever knew how that worked was already gone. It took me almost a year to convince support that the licensing had changed in XI and was causing problems for the mid-tier when using the settings they had specified in their documentation. They were working under the false assumption that everyone would have a full-blown, fully licensed version of Crystal Reports Server XI or BOXI available to them, and had not kept up with the web reporting server bundled with CR Professional. I would contend that CR Professional and its bundled web server should be the ONLY thing that you need to do reporting for mid-tier. It would be a gross imposition by BMC Remedy to expect that everyone must buy a more powerful (and expensive) version of the CR/BOXI web server than that just to serve up reports on the web. That function alone cannot justify the cost of a fully licensed BO web server, which is intended (and priced) for serving up complex, native crystal reports over its own interface, to users registered within its own security model. That's like using a .600 Nitro Express to hunt mice. You should investigate whatever BO is currently selling as Crystal Reports Professional and whatever web server is currently shipping with it. You may have to buy the current version but ask for an earlier version in order to get compatibility with ARS 7.x; I have not looked past the original distribution of XI. 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 Bill Myers Sent: Tuesday, October 28, 2008 8:56 AM To: arslist@ARSLIST.ORG Subject: Web Reporting ** I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Web Reporting
Email me off list with your questions. William Rentfrow Principal Consultant, StrataCom Inc. [EMAIL PROTECTED] 701-306-6157 C From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bill Myers Sent: Tuesday, October 28, 2008 8:56 AM To: arslist@ARSLIST.ORG Subject: Web Reporting ** I attempted this post yesterday and did not see it on the list. I apologize if it is a repeat. We are looking at solutions for providing the ability to view, save to file and print Crystal Reports from the ARS 7.1 mid-tier (we do not currently use the mid-tier). I have received so much conflicting information and I was hoping someone would share their experiences. We have been told we need to spend anywhere from $600 to $100,000. We have a list of 6 - 8 products and versions that may or may not be workable. Obviously, we would like to spend as little money as possible. So, would anyone who has travelled this path be willing to share the details of their implementation including approximate costs and licensing requirements? I've contacted BMC support and of course was told to look at the product compatibility matrix. I have and I've looked at the mid-tier documentation. What it doesn't tell you is which supported application would be best suited to our implementation (small company with limited but growing reporting needs) and if there may be other un-supported apps that could do the trick. Of course, the vendors want to sell you the Cadillac when a Yugo would suffice. Thanks! ARS 7.1 (unpatched at present) on Windows Oracle 10.2 on Linux ARS 7.1 mid-tier on Linux Completely custom applications Bill Myers Remedy Developer Datacraft Solutions, Inc. [EMAIL PROTECTED] (p) 919-667-9804 (f) 919-682-5986 __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
Crystal Reports Server XI for Web Reporting
We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonException: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Reports Server XI for Web Reporting
My experience with Crystal Report Server XI was that you would be unable to access the CMC web interface if you tried to install Crystal to use the tomcat instance installed by mid-tier. If it is installed with its own tomcat, or on IIS using .NET, the CMC web interface is accessible for applying the license. Make sure that the mid-tier is configured with the CMS Machine Connection Details for BOXI authentication, NOT Crystal Report Server XI. That should allow you to connect the way mid-tier wants to - using un-named user accounts - versus the default for CRS XI which is named accounts. BO changed the default license behavior in XI to the opposite of what previous versions used, and what mid-tier expects. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Monday, June 02, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Crystal Reports Server XI for Web Reporting ** We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonExcepti on: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley __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
Re: Crystal Reports Server XI for Web Reporting
So I am going to check of the Business Objects Enterprise XI radio button even though I have installed Crystal Reports Server XI? When I do that I get this error. Failed to process the request!! 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\Mid-Tier\reports\m11c23c11b16\676C737A168EFEA47E5CF37BFB82CD76\HPD5fDetail.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED] FYI, we did install our own version of Tomcat beforehand. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Monday, June 02, 2008 12:49 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Server XI for Web Reporting ** My experience with Crystal Report Server XI was that you would be unable to access the CMC web interface if you tried to install Crystal to use the tomcat instance installed by mid-tier. If it is installed with its own tomcat, or on IIS using .NET, the CMC web interface is accessible for applying the license. Make sure that the mid-tier is configured with the CMS Machine Connection Details for BOXI authentication, NOT Crystal Report Server XI. That should allow you to connect the way mid-tier wants to - using un-named user accounts - versus the default for CRS XI which is named accounts. BO changed the default license behavior in XI to the opposite of what previous versions used, and what mid-tier expects. 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 Bardsley, Michael Sent: Monday, June 02, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Crystal Reports Server XI for Web Reporting ** We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonException: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Please consider the environment before printing this e-mail. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Crystal Reports Server XI for Web Reporting
I believe that you have actually progressed from a licensing problem to a java or permissions issue (one that I have never seen) with the creation of the actual report file that mid-tier has to build. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Monday, June 02, 2008 12:32 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Server XI for Web Reporting ** So I am going to check of the Business Objects Enterprise XI radio button even though I have installed Crystal Reports Server XI? When I do that I get this error. Failed to process the request!! 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\Mid-Tier\reports\m11c23c11b16\676C737A168EFEA47E5CF37BFB82CD76\HP D5fDetail.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED] jfkM2HRNT FYI, we did install our own version of Tomcat beforehand. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Monday, June 02, 2008 12:49 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Reports Server XI for Web Reporting ** My experience with Crystal Report Server XI was that you would be unable to access the CMC web interface if you tried to install Crystal to use the tomcat instance installed by mid-tier. If it is installed with its own tomcat, or on IIS using .NET, the CMC web interface is accessible for applying the license. Make sure that the mid-tier is configured with the CMS Machine Connection Details for BOXI authentication, NOT Crystal Report Server XI. That should allow you to connect the way mid-tier wants to - using un-named user accounts - versus the default for CRS XI which is named accounts. BO changed the default license behavior in XI to the opposite of what previous versions used, and what mid-tier expects. 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 Bardsley, Michael Sent: Monday, June 02, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Crystal Reports Server XI for Web Reporting ** We have installed a Crystal Reports Server XI with a 60 trial license and have followed all the installation/configuration procedures per the Remedy Mid Tier 7.0.01 install guide for Web Reporting but when we try to view a report from the MT we receive error below. I found one article on the BO support site that has you check to see if the key code used is configured for Concurrent users or for Named User. But it instructs you to go into the CMC which does not look like it was installed with CRS. Failed to process the request!! All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. com.crystaldecisions.sdk.occa.report.lib.ReportSDKEnterpriseLogonExcepti on: All of your system's 0 Concurrent Access Licenses are in use at this time or your system's license key has expired. Try again later or contact your administrator to obtain additional licenses. Error code:-2147217397 Error code name:enterpriseLogonFailed Michael Bardsley __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ _ Please consider the environment before printing this e-mail. __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
Configuration of Crystal Web Reporting in ARS 7.0
Hi All, I am trying to configure Web Reporting in ARS 7.0. I have Crystal Enterprise 10 installed and am using IIS 6.0 on the same box. When I try to run a report through the Mid-Tier I am prompted for Crystal's CMS userid/password: The Web Component Server could not log you on to the CMS. Please re-enter your user name and password. [On Cache/Page Server: servername.WCS] In ARS 6.3 I was able to pass Crystal's CMS credentials by updating the Run Command field in Remedy's Report Type form with the following: $CRTLOC$/arreports/$RPTLOC$? init=$CRTVWR$User0=$USR$ARServer=$ARSERVER$ARServerPort=$ARSERVERPORT$A RAuthentication=$ARAUTHENTICATION$ARReportLocale=$LOC$ARVUIType=1Passwor d0=$PWD$SF=$RPTQUERY$apsuser=Remedyapspassword=remedyapsauthtype=secEnt erprise This does not seem to be working in 7.0. The report runs fine once I enter the credentials. Has anyone come across this problem before? Does anything need to be adjusted in the above Run Command to make it work? Thanks, Rob ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org