Report on Server not connecting to Oracle 9.2 databse

[Crystal11User]

Enterprise 11 is setup on a Windows 2000 professional computer using IIS 5.0, and a data source has been created in the "odbc data source administrator", and the database is listed in Oracle's tnsanmes.ora as:

DBXYZ.COMPANYXYZ.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DBXYZ.COMPANYXYZ.NET)
)
)

I am able to connect to the database from SQL+ on the server. However the reports are not displaying and a message is displayed "The database logon information for the report is either incomplete or incorrect".

What needs to be done to fix this problem?

 

[Turkbear]

Hi,
Can you switch from ODBC to using Oracle's native driver..
The use of ODBC can get complicated ( is it System,File, User..)

You should be able to do this in the CMC....

See if that helps..

Also, be sure the 'prompt user...' box is unchecked on that same CMC page..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Crystal11User]

Thanks for the info. Tried to access CMC, but ran into a .csp redirect page under admin called redirect.csp. The problem is that the server is running asp.net, so it looks like the folder should contain an .aspx page instead of a .csp page. Looks like a setup bug.

 

[kutoose]

You have to enter the database information for the report through CMC. Log on to CMC, select the report, click on database and fill the user name and password.

 

[Turkbear]

Hi,
By default BOE XI does not support .csp pages..Is this a fresh installation of CE or an upgrade?

Try launching the CMC using this type URL ( assuming default file locations)

http://yourserver/businessobjects/enterprise11/admin/en/admin.cwr

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Crystal11User]

Thanks for the info.

Tried to access /enterprise11/admin/en/admin.cwr, but the file doesn't exist.

 

[Crystal11User]

This was a fresh install.

 

[Crystal11User]

When trying to access the link:

http://chykeys/businessobjects/enterprise11/admin/redirect.csp

get:


<!--
File Version Start - Do not remove this if you are modifying the file
Build: 10.0.0
File Version End

(c) Business Objects 2003. All rights reserved.
-->
<%@ language=Javascript %>
<%
var DEFAULT_LANG = "en";
var OTHER_ACCEPTED_LANG = new Array("en", "de", "fr", "ja", "es", "it", "nl", "ko");

function GetLangPath(inFullLang)
{
var langLength = Math.min( 6, inFullLang.length );
var langFull = inFullLang.substr(0,langLength).toLowerCase();
var lang = langFull.substr(0, 2);

if (lang == "zh")
{
var idxSepComma = 0;
var idxSepSemiC = 0;

________________________________________________________

What is the deal with this? This file is not readable. I assume it is the wrong file type for IIS 5.0? If so what is the solution to this problem? Replace the files with others?

 

[Turkbear]

HI,
Ok,,See if this URL works in your system:

http://<yourservernamehere>/businessobjects/enterprise11/WebTools/adminlaunch/default.aspx

If that also fails, I would try a reinstall..



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Crystal11User]

That works. I'm able to see default.aspx.

But not CMC.

 

[Turkbear]

Hi,
so what happens when you click on the link to the CMC:

It should call this url(exactly as shown, including the %2F stuff):

http://<yourserver>/businessobjects...iveredirect.aspx?goto=../../admin/default.htm

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Crystal11User]

Went into IIS and under the business objects directory and went to the main page configuration and created an association between .csp and .cwr and aspnet_isapi.dll.

This fixed the problem.

 

[Turkbear]

Hi,
That is a workaround the Business Objects has sent me as well, for my older files..What I do not understand is why you are getting redirects to .csp pages...My XI installation does not use them at all..Did you install ePortfolio emulation by any chance?








To Paraphrase:"The Help you get is proportional to the Help you give.."