Cannot access the repository. (USR0013)

[Former Member]

receive the following message when try log into Universe Designer

Cannot access the repository. (USR0013)

[repo_proxy 13] SessionFacade::openSessionLogon with user info has failed(Security plugin error: An error has occurred in the plugin, but the plugin is unable to return a detailed error message.(hr=#0x80042a01).

Have searched various forums and tried restarting the repository database didnt work any ideas ???

[Former Member · Accepted solution]

Hi Dennis,

Cause could be :-

The error messages occur because there is a firewall on the server blocking access to the repository.

Resolution

To resolve the error messages, open ports on the firewall for the Central Management Server (CMS) and the Input File Repository Server (FRS).

Here are the steps:

Log on to the Central Configuration Manager (CCM). Stop the CMS.

Click Properties for the CMS. At the end of the command line add following two switches:

"-port <FDQN>:6400 "

"-requestport 6401"

Stop the Input FRS in the CCM. Click Properties.

Add the following two switches at the end of the command line:

"-port <FDQN>:6400"

" -requestport 6402"

NOTE

Steps 1 through 4 open ports 6401 and 6402 for the respective applications on the firewall.

Open the Hosts file in a text editor such as Notepad on each client machine that experiences this issue.

The file is located at <installation directory>\Windows\System32\drivers\etc.

Add the server FQDN and IP address to the file.

Save and close the file.

Stop and restart services.

Regards,

Chaitanya Deshpande

[Former Member · Accepted solution]

Thanks Chaitanya

General Details:

server name: test-bo

Domain Name: ssfs.com.au

FQDN = test-bo.ssfs.com.au

Server Test-bo using static IP not DHCP u2013 199.100.101.135

in HOSTS added: 199.100.101.135 test-bo.ssfs.com.au

This is what I did (in bold are the changes made):

in the CCM > CMS > prop > command

"
test-bo\C$\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\CMS.exe" -service -name test-bo.cms -restart -port test-bo.ssfs.com.au:6400 -requestport 6401

in the CCM > Input File Repository Server > prop > command

"
test-bo\C$\Program Files\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\inputfileserver.exe" -service -name Input.test-bo -ns test-bo -restart -port test-bo.ssfs.com.au:6400 -requestport 6402

after doing above - adding to the hosts file - restarting the services still get the same error when in Universe Designer. Anything else to try ???

[former_member212749 · Accepted solution]

Hi,

Can you restart the DB server which consist the Repository. Try restarting the Services also

Hope this could help you.

Regards

Prashant

[Former Member · Accepted solution]

Tried restarting the Repository DB and also restarting the services in the CCM restarted

- CMS

- Input File Repository Server

by Repository DB you mean the Database on the server hosting the Business Objects software right? This is the database that contains the audit DB etc correct?

[former_member212749 · Accepted solution]

Hi ,

Yes, I ment to restart the repository DB server.Are you having the privilage to logon to Designer.Are you using the administrator rights.

The Only option is the Restart the Servers DB servers and the Machine that you are using ..

Regards

Prashant

[Former Member]

Hi Dennis,

Check whether you are able to ping the BusinessObjects server, from the client machine, and vice versa with the ip address, and the machine name.

In the above thread an explanation was given which was quite similar to this:

Due to multiple NIC cards , the communication between WebI and the database is sometimes hindered and the report comes with the "MySQL has gone away" error.

Resolution

Open the Hosts file in a Notepad from "C:\WINNT\system32\drivers\etc"

And add the IP address followed by the host name.

i.e. 127.0.0.1 localhost

172.16.9.72 d-3278boxir2.botest.com

Then save the file.

Stop the CMS from the Central Configuration Manager and then in the Command Line in the Properties Tab add "-port fully qualified domain name":6400 before -restart.

i.e. -port mytest.botest.com:6400

Restart the CMS.

However if you are working with webi report you would need to do the same with your WebI report server but this time do a : -port mytest.botest.com. No need to specify the port here.

Also, from your client machine in the Network Connections, in the Advanced tab, click on Advanced settings, and check for the LAN which you are using, and give it the higher preference.

-

---

If the above is not working we can try with the ip address in the command line instead of the FQDN(fully qualified domain name).

[Former Member]

 restarting the repository database didnt work any ideas ???

Did you try restarting the CMS?

I believe the error occurs when the Designer session times out. Usually logging in to a new session resolves the problem.