One more question If I configure OBI to use a database as the authentication provider by using a SQLAuthenticator (as described in official guide) how can i assign multiple roles to one user from databse similar to initialization block? Of course all roles are phisically presented in weblogic

Row-wise initialization IS A THING semicolon works Thanks!

@Gianni Ceresa thanks Ok features and content are separate. but , regarding content, if steps 1-14+ arent required how can i assign several roles to one user in the security block? this script asigns only one role(r1) to user (and of cource all roles in wchich it was included in weblogic) select '1111' user_id, 'DEN'…

Almost all users are in database. No users created in RPD layer. Couple created in Weblogic. I mean the first ones OBIEE 12.2.1.4.

I have found no helpful info There are some descriptions -Total temp space used by a query during execution of report. Total temp size used on DB side? Total temp size used in BI side? What for used? -Specifies the total KB received for a query. Data type is Number(10). received by whom? what was sent? Because I see real…

Thanks About 2 options We did it but faced interesting issue. When you recreate certificate you should specify Common name. If you have 2 machines with diffrent names(not like domainX.machine but f.e. machine1 and supermachine2) you cant specify Common name for both or they wont start . To make it work you should add…

I've noticed one warning in admin server log <BEA-090154> <Identity certificate has expired... But we didnt set any certificates. But after some searching i found that there is default certificate that expires after 5 year of using the System)). Great article…

Restarted the whole machine. Opened cmd with admin rights and started nodemanager c:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi_domain\bin\startNodeManager.cmd (Secure scoket listener started on port 9506) Opened cmd with admin rights and started weblogic (during starting entered credentials)…

"Are you able to access the WebLogic Administration Console as weblogic (or any other administrator)?" Yes I can start weblogic manually "If so, in the Domain Structure panel expand Environment > Servers > AdminServer, and check whether the SSL checkbox is ticked. Then do the same for bi_server1 to understand if SSL has…