Question Re: Creating a WebI doc using ASP.NET in Technology Q&A

Creating a WebI doc using ASP.NET

Former Member — Fri, 19 Dec 2008 10:20:26 GMT

Hi,

We have a BO XI 3.1 Server installed.

And we are trying to create a Webi Doc through ASP.NET.

But once I provide a Universe Name and click Ok, I got the following error :

Server: http://localhost:80/businessobjects/enterprise115/cdzisapi.wis?

java.lang.RuntimeException: java.io.FileNotFoundException: http://localhost:80/businessobjects

/enterprise115/cdzisapi.wis

at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)

at com.businessobjects.wp.cpi.CPIConnection.postRequest(CPIConnection.java:437)

at com.businessobjects.wp.xml.XMLViaHttp.loadScript(XMLViaHttp.java:144)

at com.businessobjects.wp.xml.XMLViaHttp.initInstance(XMLViaHttp.java:971)

at com.businessobjects.wp.xml.XMLSession.load(XMLSession.java:158)

at com.businessobjects.wp.xml.XMLSession.load(XMLSession.java:46)

at com.businessobjects.wp.om.OMSessionLoader.load(OMSessionLoader.java:29)

at com.businessobjects.wp.tc.TCMain.initClient(TCMain.java:1447)

at com.businessobjects.wp.tc.thread.InitAppletRunner.run(InitAppletRunner.java:81)

at java.lang.Thread.run(Unknown Source)

at com.businessobjects.wp.cpi.CPIConnection.postRequest(CPIConnection.java:441)

at com.businessobjects.wp.xml.XMLViaHttp.loadScript(XMLViaHttp.java:144)

at com.businessobjects.wp.xml.XMLViaHttp.initInstance(XMLViaHttp.java:971)

at com.businessobjects.wp.xml.XMLSession.load(XMLSession.java:158)

at com.businessobjects.wp.xml.XMLSession.load(XMLSession.java:46)

at com.businessobjects.wp.om.OMSessionLoader.load(OMSessionLoader.java:29)

at com.businessobjects.wp.tc.TCMain.initClient(TCMain.java:1447)

at com.businessobjects.wp.tc.thread.InitAppletRunner.run(InitAppletRunner.java:81)

at java.lang.Thread.run(Unknown Source)

As I can see, the path tries to find DLL for BO XI R2, but we have BO XI 3.1.

Any idea/solution will be of a great help.

Thanks,

Harshad

Re: Creating a WebI doc using ASP.NET

Former Member — Mon, 22 Dec 2008 14:29:33 GMT

Hi Harshad,

Following information might help you to resolve the issue.

1.If previously you have BOXIR2 installed on the machine on which BOXIR3.1 is installed then might be there are some traces of BOXIR2 left in the registry.

2.Could you please test the issue on cleaning up the registry.

Regards,

Sarbhjeet Kaur

Re: Creating a WebI doc using ASP.NET

Former Member — Mon, 22 Dec 2008 14:43:45 GMT

Hi Sarbhjeet,

I'll give a try as per your suggestion, and let you know if problem still persists.

Thanks for the help.

Thanks,

Harshad

Re: Creating a WebI doc using ASP.NET

Former Member — Mon, 22 Dec 2008 14:59:12 GMT

Harshad,

You may also need to look into whether or not the .wis extension is registered by using the following workflow:

1) Log into your web server (with admin rights, etc)

2) At the desktop right-click on My Computer and choose Manage

3) Expand the Services and Applications tab, expand Internet Information Service

4) Right-clidk on Web Sites, choose Properties and go to the Home Directory tab

5) click on Configuration (about 3/4 ways down on the right side)

6) You will see a list of Application Extensions and their associated Executable Path

7) if .wis is not registered in this list then click Add, enter .wis, and browse to the place where the DLL for .wis is located (default installation: most likely "C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\cdzISAPI.dll")

😎 indicate this for "all verbs" and uncheck the option "Verify that file exists", click OK

9) bounce the web server (IIS service) to get .wis initialized, and that should help out with overcoming the noted error.

Thanks,

John

Re: Creating a WebI doc using ASP.NET

Former Member — Mon, 22 Dec 2008 15:56:00 GMT

Hi John,

I have already done this process, but still it is giving the error.

Also, Sarbhjeet, if you can see in the error message the hyperlink :

http://localhost:80/businessobjects/enterprise115/cdzisapi.wis?

it is expecting the cdzISAPI.dll from enterprise115 i.e. BO XI R2, so I am curious if I install BO XI 3.1 on

fresh machine, then it will change from enterprise115 to enterprise12.

Then how can I add a Web Service Extension which is pointing to ..\businessobjects\enterprise115

\cdzisapi.dll ?

Waiting for your reply.

Thanks,

Harshad

Re: Creating a WebI doc using ASP.NET

Former Member — Tue, 23 Dec 2008 08:54:10 GMT

Hi Harshad,

Following information might help you to resolve the issue.

To manually deploy BusinessObjects Enterprise XI .NET services to a web site other than the Default Web Site perform the following steps:

1. Click Start > Programs > Administrative Tools > Internet Services Manager, and right-click the servername.

2. Click New > Web Site > Next, type a description, click 'Next', set the root folder to an empty directory, click 'Next', and click 'Finish'.

3. Right-click the new web site, click New > Virtual Directory > Next, type "businessobjects" to set the 'Alias', click 'Next', set the path to the following:

<installation directory>\Business Objects\BusinessObjects 12\Web Content

4. Click Next > Next> Finish, right-click the businessobjects virtual directory, click Properties > Virtual Directory > Configuration.

5. Click 'Add', click 'Browse', and select the following file:

C:\WINDOWS\Microsoft.NET\Framework\<version_number>\aspnet_isapi.dll

6. Click 'Open', in the extension text box enter .cri, clear the 'Verify that file exists' option, and click 'OK'.

7. Repeat steps 5-6 for the file extensions .csp, .cwr, and .rpt.

====================

NOTES:

" For the file type .wis repeat steps 5-6 but use a different file:

C:\Progra_1\Busine1\Busine~1\win32_x86\cdzISAPI.dll

" To use the full file path in Windows 2003 you will need to use double quotes around the path:

"C:\Program Files\Business Objects\BusinessObjects Enterprise 12\win32_x86\cdzISAPI.dll".

" Stop IIS and edit the c:\WINDOWS\system32\inetsrv\MetaBase.xml in Notepad and remove the """ string from around the C:\Program Files\Business Objects\BusinessObjects Enterprise 12\win32_x86\cdzISAPI.dll string. Restart IIS.

" DO NOT use Wordpad to edit the MetaBase.xml file as it will corrupt the file. Use Notepad instead.

====================

8. Expand the tree: <new website>> businessobjects > enterprise12, on the InfoView directory, right-click and select Properties > Create > OK. Repeat this for the WebAdmin and WebTools directory.

9. For Windows Server 2003, right-click the web site, click Properties > HTTP Headers > File Types > New, type ".properties" for Extension, type "application/octet-stream" for Content type (MIME), click OK > OK > OK, and restart IIS.

Regards,

Sarbhjeet Kaur

Re: Creating a WebI doc using ASP.NET

Former Member — Tue, 23 Dec 2008 08:56:03 GMT

Hi Harshad,

You can also try the following solution to resolve the issue.

To fix this issue, change the path to an 8.3 format, in the default install folder, that would be:

C:\PROGRA_1\BUSINE1\BUSINE_{1.5\WIN32_}1\cdzISAPI.dll

Regards,

Sarbhjeet Kaur

Re: Creating a WebI doc using ASP.NET

Former Member — Wed, 24 Dec 2008 23:23:00 GMT

Hi Sarbhjeet,

I literally don't have a words to say Thanks to you.

This forum has provided only 10 points otherwise I have given you 100/100 points for your help.

Thanks once again for helping me to solve my problem in my critical situation.

Many Thanks.

Thanks,

Harshad

Re: Creating a WebI doc using ASP.NET

Former Member — Mon, 12 Jan 2009 20:04:31 GMT

I had the same problem, but followed the directions and now my WebI query panel works, except I receive a warning popup. I see a security warning:

"The current Web page is trying to open a file on your Computer. Do you want to allow this?

Current site: Mysite.com

File: C:\WINDOWS\system32\shdoclc.dll

Do you or anyone else know how to get rid of this? It will annoy my users if it does that in production or the their testing environments.

I don't see actual quotations in the XML file, but I do see this:

.wis,"D:\Business Objects\BusinessObjects Enterprise 12.0\win32_x86\cdzISAPI.dll",1

Edited by: Aaron Schmitzer on Jan 12, 2009 9:07 PM

Edited by: Aaron Schmitzer on Jan 12, 2009 9:24 PM

Re: Creating a WebI doc using ASP.NET

Former Member — Tue, 12 Jan 2010 10:01:10 GMT

After following Sarbhjeetu2019s instructions, when I run my .asp reports page I am asked if I want to open or save the Crystal Report file instead of viewing the report inside the viewer.

An overview of my setup is as follows:

IIS version 6, ASP version 1.1.4322 and Crystal Reports Server XI R2.

Crystal reports is not installed on the web server.

Created a new website

Have two virtual directories:

businessobjects:

E:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Web Content

crystalreportviewers115

E:\Program Files\Business Objects\common\3.5\crystalreportviewers115

I have added and selected the following files on the website and both virtual directories and removed u201Cverify that file existsu201D:

.wis u2013 "E:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\cdzISAPI.dll"

.cri - C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll

.csp - C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll

.rpt - C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_isapi.dll

There are no """ strings to remove from around the E:\Program Files\Business Objects\BusinessObjects Enterprise 12\win32_x86\cdzISAPI.dll string in the MetaBase.xml file.

I have added the application/octet-stream MIME type for both website and virtual directories.

Any help would be greatly appreciated..

Thanks,

Leigh

Edited by: leighturner on Jan 12, 2010 11:10 AM

Edited by: leighturner on Jan 12, 2010 11:18 AM

Re: Creating a WebI doc using ASP.NET

Former Member — Thu, 18 Feb 2010 17:47:50 GMT

the cdzisapi.dll file is missing. Does any one know from where I can get the missing file?

Thanks