We are running a report on DEV environment and the below error is displayed -
A database error occured. The database error text is: ORA-12541: TNS:no listener
. (WIS 10901)
Now the same reports were working yesterday, but seems to be none in working condition, now in this case I have the access to desinger, I checked the universe and saw it is working fine. The integrity check was also done correctly and completely. What could be the issue reason?
I have not tried running a report on db, I will do that also…
EDIT: I ran the query on database and it is working fine, now it’s wiered…I never faced this kind of issue as far as I remember…
Hey Joe, thanks for your response. Where exactly I can check this, I do not have access to BO Server machine but yes I have access to CMC and I tried searching for above setting, but couldn’t find. Can you please help me.
SaiKrishan, thanks for your response too. I think the link you provided is what I was looking for, but my issue didn’t get resolve as there is no approach is mentioned related to the issue I am facing.
Hey Joe, once again thanks. Actually we have a different team who takes care of BO Server but if you can provide me what actually needs to be check, I can coordinate with them…
One more thing, we have found that the port which I am using is different from one which is mentioned on BO server and I am not sure if it has changed recently, but I was able to run the reports till last friday, the problem started this Monday , so need to make sure if in this period something has changed. What is your opinion or if there is anything which I need to check more, I can try from my side…
Why don’t you just speak to your server team and ask them to check the TNS names file in the Oracle directory on the server?
Find the one on your machine and they can check theirs against that.
Do you have access to Designer? I think you have (from your earlier posts) - Please import the universe, edit the connection - try to test it there itself. If the same error pops up, please take the connection string and ask the DBAs to look into it.
Thanks for your response. I checked the designer and there it is working fine and also I ran the report query on TOAD and it is working fine. Only the issue is with reports when you check from infoview , some port or listener configuration is gone wrong and what it is , I am not able to figure it till now…
Are you sure it is the same universe (one you tested from the designer) to which the reports are pointing to?
I would like you to create a new report based on the same universe from the inforview and confirm it again throws the same error.
What I want to make sure is if the connection is working fine from the designer then is there a possibility that the reports that erroring out are pointing to some other universe/universes(multiple data providers).
I am doubtful that there could be a port issue in this case.
Hey Mak thanks for your response. Yes I checked and Designer is working fine , only infoview is throwing error. Also I checked the report in webi rich client and it is working fine there also…
One more thing , the Port no. should be same on Server and Client machine? I guess if suppose Client is not installed on my system, then also I am able to run webi reports but I don’t know why it is happening and this problem started occuring this week only , prior to this it was working fine…
The workstation has no role to play when you are accessing the reports from Infoview. It is the TNS configuration on the BO server which is hitting the data source.
Please ask the dba people to cross check the connectivity of your oracle client installed on the BO server with the target database.
Also check if you have multiple universes used in your reports. In that case you will need to check the connections for each universe.
But we are able to use Designer on BO server, we are able to generate reports on webi rich client , the problem is only with infoview reports… Still I am standing on the same point, no success… no move…Please advice.
We do not have multiple universes, we have a single universe.
Hey Mak, Andy … First of all many thanks for helping me in this issue, it was badly required.
Yes it is clustered environment, we have a common link for infoview for 3 different environments and we just change the Server name in that window and get to different environments.
I am not sure where exactly I should be checking like in CMC also I need to check for ports?
Or it would be great if you can help me in knowing below things-
Where I can check for ports, like first in TNS file, CMC and anywhere else?
The port which is there in TNS should be opened from offshore? - I know this has to be, but not sure how it got changed automatically as we didn’t change anything…
Do I need to configure my machine where BO Client is installed to run reports in infoview?
Note - I am able to run the reports in webi rich client, I am able to login to client tools. I am not able to create any new report in infoview and not able to open any report.
I would suggest you to copy the TNS entry for the target database (from TNSfile) available on the Designer machine where the connection is working fine and find out on which clustered machine the WebI job server is configured.
Go to the TNS file on that server and put the copied entry in the TNS file. This should make all your existing and new reports work.
(BOB member since 2007-10-05)
(BOB member since 2002-08-29)
(BOB member since 2011-02-10)
(BOB member since 2007-10-05)
(BOB member since 2011-08-11)