EPM 11.1.2 - R&A DATABASE CONNECTIONS DISAPPEAR FROM THE "DATABASE CONNECTION MANAGER

When accessing the database connection panel through Reporting and Analysis all previously entered database connection do not appear. This is due to a bug in the Windows SMB2 protocol. To work around this bug you have to disable the protocol. On Windows 2008 the protocol is automatically enabled. This needs to be done on both the servers and the clients.

Note that “server” is the server which hosts RAF repository service and RM1 folder, “client” – server which hosts replicated Repository service that accesses repository files via network i.e. \\<server_host>\RM1 

In order to disable SMB 2.0 on the server side, follow these steps: 

1. Run "regedit" on Windows Server 2008 based computer. 

2. Expand and locate the sub tree as follows. 

HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters 

3. Add a new REG_DWORD key with the name of "Smb2" (without quotation mark) 

Value name: Smb2 

Value type: REG_DWORD 

0 = disabled 

1 = enabled

4. Set the value to 0 to disable SMB 2.0, or set it to 1 to re-enable SMB 2.0. 

5. Reboot the server. 

To disable SMB 2.0 for Windows Vista or Windows Server 2008 systems that are the “client” systems run the following commands: 

sc config lanmanworkstation depend= bowser/mrxsmb10/nsi 

sc config mrxsmb20 start= disabled 

Note there's an extra " " (space) after the "=" sign. 

To enable back SMB 2.0 for Windows Vista or Windows Server 2008 systems that 

are the “client” systems run the following commands:

sc config lanmanworkstation depend= bowser/mrxsmb10/mrxsmb20/nsi 

sc config mrxsmb20 start= auto 

Again, note there's an extra " " (space) after the "=" sign. 


Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today