Error while trying to querry database

[joaotelles]

Hi all,

As I try to make a querry on the database to create a preview report I got the following error:

ORA 121-54 TNS could not resolve the connect identifier specified.

The tnsnames.ora appear to be all right and only one tnsnames.ora exists.

The thing that I figure that might be the problem is that the user that the BO is using to source the database is not the bobje, because if I set it to be the bobje the CMS wont start giving the following error:

Sleeping 90 seconds before enabling the ports...

Creating session manager...

Logging onto CMS...

err: Error: Couldn't logon to CMS

err: Error description: The system lab01 can be contacted, but there is no Central Management Server running at port 6400.


Does anyone have any idea of how to solve it?

Tks

 

[Turkbear]

Hi,
That Oracle error is unrelated to the user account -
On the server running BOE, try connecting using SqlPlus or the SqlWorksheet...If those are not installed, go to a command prompt window and try:
tnsping <yourtnsaliashere>





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

 

[joaotelles]

dpa@LAB01-OTA> tnsping DP7A

TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 03-MAY-2009 14:55:25

Copyright (c) 1997, 2006, Oracle. All rights reserved.

Used parameter files:
/opt/oraclea/product/10.2.0/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dba)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = DP7A)))
OK (50 msec)


The ping was OK.

 

[Turkbear]

Hi,
Odd..That was from the same machine as the report you are trying to run?

Is this a published report and if so, is DP7A set as the Oracle instance to use?





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

 

[joaotelles]

Yes its from the same machine... and DP7A is the instance setted pon the ccm.config to be the oracle instance (SERVICENAME="DP7A")...and its the oracle instace on the cmsdbsetup.sh as you can see..

Business Objects


Current CMS Data Source: DP7A

Current cluster name: DBA

Current Auditing Data Source: DP7A


select (Select a Data Source)
reinitialize (Recreate the current Data Source)
copy (Copy data from another Data Source)
changecluster (Change current cluster name)
selectaudit (Select an Auditing Data Source)


[select(6)/reinitialize(5)/copy(4)/changecluster(3)/selectaudit(2)/back(1)/quit(0)]

 

[Turkbear]

Hi,
Is the instance used by the report you are running or trying to create for its data the same as the CMS database(DP7A)? -




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

 

[joaotelles]

I believe that thats the instance used by the report I am running

 

[Turkbear]

Hi,
It could make a difference...check the database information for that report in the CMC ( also make sure it is using the correct info, not some other instance saved when the report was published)...






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

 

[hilfy]

Are you trying to run a report that reads the CMS database? Or are you running against the audit tables? (BTW, having the CMS database and the Audit database in the same db instance is NOT a best-practice!) You generally cannot query the CMS database directly from a report - if you upgraded from CE or from and earlier version of BO this is a major change.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[joaotelles]

Sorry by the late reply I was on a work trip...

Turkbear, I looked into the CMC and didnt find any information about the database information referred to a report specifically... I dont know if its relevant but these report that Im trying to run were imported using the import wyzard and the universes there are using too...

Hilfy, the best practice is if I had two instances on the tnsnames one for the data source other for the audit? like:

Business Objects


Current CMS Data Source: DP7A

Current cluster name: DBA

Current Auditing Data Source: DP7B


select (Select a Data Source)
reinitialize (Recreate the current Data Source)
copy (Copy data from another Data Source)
changecluster (Change current cluster name)
selectaudit (Select an Auditing Data Source)


[select(6)/reinitialize(5)/copy(4)/changecluster(3)/selectaudit(2)/back(1)/quit(0)]

 

[hilfy]

Best practice is to have two separate databases, which would require two separate TNSNames entries (as opposed to two separate TNSNames entries that point to the same database...)

What database does the universe connect to? You can determine this by importing the universe into the Designer desktop application and looking at the connection. If these are not activity/audit reports running off of the audit database, I suspect that you don't have the correct TNSNames entry for database used by the connection.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[joaotelles]

Im facing some firewall issues in order to connect the Designer.. I believe its because I use Windows Vista, the error is this one:

repo_proxy 13] SessionFacade:penSessionLogon with user info has failed(CMS host '192.168.89.2' address was resolved properly, but cannot be reached to establish a CMS connection. Verify that your router/firewall allows communication on port 6400
(hr=#0x80042a01)

I already tried to make a tunnel using putty but didint works...any suggest of how to take this firewall problem out of game...?

 

[Turkbear]

Hi,
Unless you disable the firewall ( not usually a good idea if connected to the outside world) you need some special configuration changes to allow communication with the CMS..Look at the BOE docs about firewalls and their special needs.



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

 

[joaotelles]

Hi,

I disabled the firewall and the logon on the designer was sucessfull...and after I set a new connection to the database, importing the universes, setting its parameters to use the new connection and then exporting the universes back to the BO server.. the querry was succesful!!!!

Tks for all that helped me with these problem...I hope the great job here on this forum continues for a long time