Analytics page not coming up

1055274

Hi Friends,

Eventhough all the services are up analytics page is not coming up. In EM i have checked all the services are up and running.

Any help is appreciated.

i can see below error in the saw log file.

OBIPS] [ERROR:31] [] [saw.security.userpopulationmanagerimpl.initializeroles] [ecid: ] [tid: ] Error retrieving user/group data from Oracle BI Server's User Population API.

Could not create a system user connection to Oracle BI Server during start-up. Please check the error message and try again.

Authentication Failure.

Odbc driver returned an error (SQLDriverConnectW).

State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

[nQSError: 43113] Message returned from OBIS.

[nQSError: 43126] Authentication failed: invalid user/password.

Thanks,

kumar

Joel

Hi @1055274

Have you taken a look at this?

1055274

Hi Joel,

thanks for your reply. but the error seems to be different in my case.

Thanks,

kumar

1055274

While stopping services using stop bi services command i am getting the below error

Optic: startPhoneCall(/status) Error, will retry...

requestRetry(/status) at 16/10/06-07:55:33

startPhoneCall(/status) at 16/10/06-07:55:33

InetSocketAddress: localhost:9501

dialOpmn: SSL localhost:9501 wallet=E:\OBIEE\user_projects\domai

ns\bifoundation_domain\opmn\instance1\wallet timeout=60000ms

dialOpmn: SSL connect failed (Failed to create secure socket for OPMN at localhost:9501): localhost:9501

localhost:9501 -- last success at 16/10/06-07:52:28

Joel

Can you search for OPMN.log file and post any errors from it here?

1055274

[ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 3 (Unknown error)

[2016-09-27T03:19:56-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 5 (Unknown error)

[2016-09-27T03:20:01-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 1 (Unknown error)

[2016-09-27T05:00:59-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 1 (Unknown error)

[2016-09-27T05:00:59-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 4 (Unknown error)

[2016-09-27T05:01:05-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 5 (Unknown error)

[2016-09-27T05:54:16-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 1 (Unknown error)

[2016-09-27T05:54:16-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 4 (Unknown error)

[2016-09-27T05:54:22-04:00] [opmn] [ERROR:1] [727] [pm-requests] Launch target process pipe read error: logquery 1 (Unknown error)

this is the only error i can find in opmn log

Joel

Could you try refreshing user GUIDs to see if this resolves the connection issues you seem to be facing?

1055274

i have refreshed GUIDs as well no luck

2845107

Can you check "biplatform" and "mds" password are connecting and they have not expired as they do at times.

Thanks

1055274

tested in console and the connection was successful for MDS and BIPLATFORM

Rampradeep Pakalapati

Hi,

From the error looks like an internal connection between the services is not happening. Most cases this happens when BISystemUser is not working as expected.

1. CHange the BISystemUser password in COnsole

2. Update the same in EM and restart the services.

Better upload a previously working RPD and Catalog. Also if you changed any configuration settings to fix the above error revert them back to their original state.

Thanks,

Rampradeep