nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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

Find more posts tagged with

Accepted answers

All comments

1055274

Hi Ram,

I have changed the passwords for bisystem user both in console and em but still getting the same issue.

even i have tested with sampleapplite rpd and catalog.

Thanks,

Kumar

Rampradeep Pakalapati

Check you deployments ...this surely seems to be some connection issue mostly the schema's or SystemUser.Check the opmn status from command and see if all are alive.

1055274

ya all the deployments are in active state but when i check all the servers in EM are up.

when i check the opmnctl status all the services are alive but presentation services are going to init status and then to alive status

Rampradeep Pakalapati

Just to make sure Catalog is not creating this havoc, create an empty folder and make this folder path as catalog path and restart the OPMN.

1055274

yes rama i have created test catalog and restarted. nothing is working out for me.

Rampradeep Pakalapati

Now lets get into details, What led to this issue. Apart from saw log errors are you seeing anything in Managed and AdminServer logs. Also make sure the port you are using is correct (validate with port in Console).

1055274

error from the bi server log:

[2016-10-07T05:35:36.951-04:00] [bi_server1] [ERROR] [OBI-SEC-00048] [oracle.bi.security.service] [tid: [ACTIVE].ExecuteThread: '22' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: cf76073aa3b704f2:-ec6e70d:1579e097e7c:-8000-0000000000002181,0] [APP: bisecurity#11.1.1] Identity store provider error[[

oracle.bi.security.service.IdentityStoreProviderException: oracle.security.idm.OperationFailureException: oracle.ods.virtualization.service.VirtualizationException: oracle.ods.virtualization.engine.util.DirectoryException: LDAP Error 1 : LDAP response read timed out, timeout used:120000ms.

at oracle.bi.security.service.URIdentityStoreProvider.getUserProfileHolder(URIdentityStoreProvider.java:382)

at oracle.bi.security.service.SystemUserValidator.validateSystemUserProfile(SystemUserValidator.java:224)

at oracle.bi.security.service.SystemUserValidator.access$100(SystemUserValidator.java:32)

at oracle.bi.security.service.SystemUserValidator$1.run(SystemUserValidator.java:116)

at oracle.bi.security.service.SystemUserValidator$1.run(SystemUserValidator.java:110)

1055274

error from adminserver.log

<AdminServer> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <weblogic> <> <44082bc59b86a981:-6c6f9c90:1579d951b36:-8000-0000000000000021> <1475817964289> <BEA-240003> <Console encountered the following error weblogic.security.providers.authentication.LDAPAtnDelegateException: [Security:090294]could not get connection

at weblogic.security.providers.authentication.LDAPAtnDelegate.getConnection(LDAPAtnDelegate.java:3492)

at weblogic.security.providers.authentication.LDAPAtnDelegate.getConnection(LDAPAtnDelegate.java:3479)

at weblogic.security.providers.authentication.LDAPAtnDelegate.listUsers(LDAPAtnDelegate.java:2267)

at weblogic.security.providers.authentication.LDAPAuthenticatorImpl.listUsers(LDAPAuthenticatorImpl.java:178)

at weblogic.security.providers.authentication.ActiveDirectoryAuthenticatorMBeanImpl.listUsers(ActiveDirectoryAuthenticatorMBeanImpl.java:227)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

Rampradeep Pakalapati

Go through the doc 1501767.1

Andrew Fomin.

Let me re-energize this topic.

Was this system ever working before?