Re: Business Objects XI - Solaris MidTier integration issues - RESOLVED
Hi All, My problem is solved. I am able to see reports on the web. The problem was in ARWebReportViewer configuration - AR System ODBC Date Source Connection. During installation of this application on BO server I had given a custom datasource name. But now I changed it to match the standard name given in Windows ODBC drivers list - AR System ODBC Data Source Regards, Prashant On Sun, May 25, 2008 at 2:33 PM, Prashant Patil [EMAIL PROTECTED] wrote: Dear All, I am in the process of configuring ARS web reporting – using ARS7.1 with Business Objects XI. At the current stage I am facing the following 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\ARWebReportViewerITSM\reports\m11c23c11b16\4461F84D76B2DA56A269A03CB0FA2257\HPD5fOpenIncidents5fbyDaysActive.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED]NLViXgJYC;H?L[EMAIL PROTECTED] \MO40NLViXgJYC;H?L[EMAIL PROTECTED] I am sure I am missing something related to defining paths. I appreciate all the help as I am struggling to get web reports to work. I have gone through a post by William Rentfrow ( http://www.nabble.com/Re%3A-boxi-crystal-report-location---Longish-response-tt15828219.html) but am confused about the path settings Our configuration and steps done are: 1 - Solaris AR Server 7.1 MidTier 7.0.01 1 – Business Objects XI Windows box running IIS 6 I need to get mid-tier solaris box(es) to display Crystal Reports on the web. (A) Configure Business Objects XI Server 1) Installed Java SDK 1.5.0_12 2) Installed Tomcat 5.5.23 3) Installed Apache Tomcat IIS Redirector 1.2.14.0 4) Restart IIS Admin Service 5) Checked Apache homepage (http://BO-server-name:8080) – OK 6) Installed the ARWebReportViewer. 7) Checked ARReports link ( http://BO-server-name:8080/arreports/shared/config/configreport.jsp) - OK (B) Configure Report Settings on Solaris MidTier 1) Crystal/BO Report Engine Deployment - BOXI/Crystal Reports Server XI on a different machine without a mid tier 2) Reporting Working Directory - /apps/remedyitsm/mid-tier/reports (local folder on MidTier server) 3) BOXI/Crystal Report Server 11 Location - http://BO-server-name:8080 (C) Update Crystal entry in Report Type form using User Tool Old Entry value – Crystal10URL=$CRTLOC$/arreports/….. Updated to – Crystal10URL= http://BO-server-name:8080/arreports/…..; (D) Configure Report Settings in ARWebReportViewer application on BO server 1) Reporting Working Directory* - C:\Program Files\AR System\ARWebReportViewerITSM\reports 2) CMS Machine Name* - BO-server-name 3) CMS Machine Connection Details – Chose Business Objects Enterprise XI AR System ODBC Data Source Name - ARSITSM CMS Folder Name - ARReports CMS User Name Pwd – Used same access details after testing with BO URL - http://BO-server-name/businessobjects/enterprise115/InfoView/logon.aspx Thanks. Regards, Prashant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Business Objects XI - Solaris MidTier integration issues
Dear All, I am in the process of configuring ARS web reporting – using ARS7.1 with Business Objects XI. At the current stage I am facing the following 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\ARWebReportViewerITSM\reports\m11c23c11b16\4461F84D76B2DA56A269A03CB0FA2257\HPD5fOpenIncidents5fbyDaysActive.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED]NLViXgJYC;H?L[EMAIL PROTECTED] \MO40NLViXgJYC;H?L[EMAIL PROTECTED] I am sure I am missing something related to defining paths. I appreciate all the help as I am struggling to get web reports to work. I have gone through a post by William Rentfrow ( http://www.nabble.com/Re%3A-boxi-crystal-report-location---Longish-response-tt15828219.html) but am confused about the path settings Our configuration and steps done are: 1 - Solaris AR Server 7.1 MidTier 7.0.01 1 – Business Objects XI Windows box running IIS 6 I need to get mid-tier solaris box(es) to display Crystal Reports on the web. (A) Configure Business Objects XI Server 1) Installed Java SDK 1.5.0_12 2) Installed Tomcat 5.5.23 3) Installed Apache Tomcat IIS Redirector 1.2.14.0 4) Restart IIS Admin Service 5) Checked Apache homepage (http://BO-server-name:8080) – OK 6) Installed the ARWebReportViewer. 7) Checked ARReports link ( http://BO-server-name:8080/arreports/shared/config/configreport.jsp) - OK (B) Configure Report Settings on Solaris MidTier 1) Crystal/BO Report Engine Deployment - BOXI/Crystal Reports Server XI on a different machine without a mid tier 2) Reporting Working Directory - /apps/remedyitsm/mid-tier/reports (local folder on MidTier server) 3) BOXI/Crystal Report Server 11 Location - http://BO-server-name:8080 (C) Update Crystal entry in Report Type form using User Tool Old Entry value – Crystal10URL=$CRTLOC$/arreports/….. Updated to – Crystal10URL= http://BO-server-name:8080/arreports/…..; (D) Configure Report Settings in ARWebReportViewer application on BO server 1) Reporting Working Directory* - C:\Program Files\AR System\ARWebReportViewerITSM\reports 2) CMS Machine Name* - BO-server-name 3) CMS Machine Connection Details – Chose Business Objects Enterprise XI AR System ODBC Data Source Name - ARSITSM CMS Folder Name - ARReports CMS User Name Pwd – Used same access details after testing with BO URL - http://BO-server-name/businessobjects/enterprise115/InfoView/logon.aspx Thanks. Regards, Prashant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Business Objects XI - Solaris MidTier integration issues
Dear All, Just an update on the problem: I am getting a different error now. Regarding step (C) I have changed the values back to the original and the error Failed to process request is gone now. However once Run Report is clicked I get the screen to enter report title and sub-title. Here when I click OK it is giving the following error :( * Error Failed to open the connection. Failed to open the connection. C:\WINDOWS\TEMP\{FF156FD4-60BD-4BC2-B8AA-ABFFDAFEBC96}.rpt * Anybody have any ideas what could be the problem? Thanks. Regards, Prashant On Sun, May 25, 2008 at 2:33 PM, Prashant Patil [EMAIL PROTECTED] wrote: Dear All, I am in the process of configuring ARS web reporting – using ARS7.1 with Business Objects XI. At the current stage I am facing the following 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\ARWebReportViewerITSM\reports\m11c23c11b16\4461F84D76B2DA56A269A03CB0FA2257\HPD5fOpenIncidents5fbyDaysActive.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED]NLViXgJYC;H?L[EMAIL PROTECTED] \MO40NLViXgJYC;H?L[EMAIL PROTECTED] I am sure I am missing something related to defining paths. I appreciate all the help as I am struggling to get web reports to work. I have gone through a post by William Rentfrow ( http://www.nabble.com/Re%3A-boxi-crystal-report-location---Longish-response-tt15828219.html) but am confused about the path settings Our configuration and steps done are: 1 - Solaris AR Server 7.1 MidTier 7.0.01 1 – Business Objects XI Windows box running IIS 6 I need to get mid-tier solaris box(es) to display Crystal Reports on the web. (A) Configure Business Objects XI Server 1) Installed Java SDK 1.5.0_12 2) Installed Tomcat 5.5.23 3) Installed Apache Tomcat IIS Redirector 1.2.14.0 4) Restart IIS Admin Service 5) Checked Apache homepage (http://BO-server-name:8080) – OK 6) Installed the ARWebReportViewer. 7) Checked ARReports link ( http://BO-server-name:8080/arreports/shared/config/configreport.jsp) - OK (B) Configure Report Settings on Solaris MidTier 1) Crystal/BO Report Engine Deployment - BOXI/Crystal Reports Server XI on a different machine without a mid tier 2) Reporting Working Directory - /apps/remedyitsm/mid-tier/reports (local folder on MidTier server) 3) BOXI/Crystal Report Server 11 Location - http://BO-server-name:8080 (C) Update Crystal entry in Report Type form using User Tool Old Entry value – Crystal10URL=$CRTLOC$/arreports/….. Updated to – Crystal10URL= http://BO-server-name:8080/arreports/…..; (D) Configure Report Settings in ARWebReportViewer application on BO server 1) Reporting Working Directory* - C:\Program Files\AR System\ARWebReportViewerITSM\reports 2) CMS Machine Name* - BO-server-name 3) CMS Machine Connection Details – Chose Business Objects Enterprise XI AR System ODBC Data Source Name - ARSITSM CMS Folder Name - ARReports CMS User Name Pwd – Used same access details after testing with BO URL - http://BO-server-name/businessobjects/enterprise115/InfoView/logon.aspx Thanks. Regards, Prashant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Business Objects XI - Solaris MidTier integration issues
Prashant, check the permission for both your local C:\windows\temp directory and the windows\temp directory on the BO-Server Try to grant write permission to 'Everyone'. HTH Mario Prashant Patil [EMAIL PROTECTED] OMTo Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: Business Objects XI - Solaris ORG MidTier integration issues 25.05.2008 17:26 Please respond to [EMAIL PROTECTED] RG ** Dear All, Just an update on the problem: I am getting a different error now. Regarding step (C) I have changed the values back to the original and the error Failed to process request is gone now. However once Run Report is clicked I get the screen to enter report title and sub-title. Here when I click OK it is giving the following error :( Error Failed to open the connection. Failed to open the connection. C:\WINDOWS\TEMP\{FF156FD4-60BD-4BC2-B8AA-ABFFDAFEBC96}.rpt Anybody have any ideas what could be the problem? Thanks. Regards, Prashant On Sun, May 25, 2008 at 2:33 PM, Prashant Patil [EMAIL PROTECTED] wrote: Dear All, I am in the process of configuring ARS web reporting – using ARS7.1 with Business Objects XI. At the current stage I am facing the following 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\ARWebReportViewerITSM\reports\m11c23c11b16\4461F84D76B2DA56A269A03CB0FA2257\HPD5fOpenIncidents5fbyDaysActive.rpt -newrpt -discard -version 1100 -thumbnail -outfile -token [EMAIL PROTECTED]NLViXgJYC;H?L[EMAIL PROTECTED]JYC;H?L[EMAIL PROTECTED] I am sure I am missing something related to defining paths. I appreciate all the help as I am struggling to get web reports to work. I have gone through a post by William Rentfrow ( http://www.nabble.com/Re%3A-boxi-crystal-report-location---Longish-response-tt15828219.html ) but am confused about the path settings Our configuration and steps done are: 1 - Solaris AR Server 7.1 MidTier 7.0.01 1 – Business Objects XI Windows box running IIS 6 I need to get mid-tier solaris box(es) to display Crystal Reports on the web. (A) Configure Business Objects XI Server 1) Installed Java SDK 1.5.0_12 2) Installed Tomcat 5.5.23 3) Installed Apache Tomcat IIS Redirector 1.2.14.0 4) Restart IIS Admin Service 5) Checked Apache homepage (http://BO-server-name:8080) – OK 6) Installed the ARWebReportViewer. 7) Checked ARReports link ( http://BO-server-name:8080/arreports/shared/config/configreport.jsp) - OK (B) Configure Report Settings on Solaris MidTier 1) Crystal/BO Report Engine Deployment - BOXI/Crystal Reports Server XI on a different machine without a mid tier 2) Reporting Working Directory - /apps/remedyitsm/mid-tier/reports (local folder on MidTier server) 3) BOXI/Crystal Report Server 11 Location - http://BO-server-name:8080 (C) Update Crystal entry in Report Type form using User Tool Old Entry value – Crystal10URL=$CRTLOC$/arreports/….. Updated to – Crystal10URL= http://BO-server-name:8080/arreports/…..; (D) Configure Report Settings in ARWebReportViewer application on BO server 1) Reporting Working Directory* - C:\Program