In my case the issue was with the ldap provider , I check with IT team and they found the issue with one of the server hosting webgate access to ldap servers. I would say check the logs and see what does it say , then see if you can login to weblogic console and check find this user there ...

This is resolved by fixing the permission issue with the problematic user which was found in jazn-data.xml file.

OPSS table is clean ,, as the query didn't return any record select * from jps_attrs where jps_dn_entryid in (select entryid from jps_dn where parentdn = 'cn=opssroot,cn=jpscontext,cn=opsssecuritystore,cn=obi,cn=jaas policy,cn=permissions,') and jps_dn_entryid not in (select jps_dn_entryid from jps_attrs where attrname =…

Issue resolved . the problem lies with LDAP. Thanks again for all your time , valuable inputs .

I figured out ..obadmin actually and for that matter the the user supplied in cli is a weblogic user ..so it has nothing to do with the user supplied through online rpd and anaytics url . In my case i have obadmin user as ldap as well as weblogic user.. So now that part is clear , it's fair to say logically that it looks…

Thanks .. I've one question .. I downloaded the rpd on the server like this .. ./datamodel.sh downloadrpd -O /uat/SampeTest.rpd -U obadmin -SI ssi it asked for obadmin password and the rpd password(as you said , it's for offline use , and that any pwd can be set at this time) The rpd downloaded successfully .So it means…

Yes its up. Infact all services are up.

thanks .. the username/password works fine while downloading the rpd through datamodel command , but when I use the same username / password to login to analytics or open the rpd online it throws the error.

sawserver.log [OBIPS] [ERROR:1] [] [saw.securitysubsystem.checkauthentication.runimpl] [ecid: 1762ywm5b-8hfb-43e4-b31d-887d6c116545f-00000007,0:2495:38:1] [tid: 284677029024] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId: ] Odbc driver returned an error (SQLDriverConnectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE:…

I think obips and not obis

Problem lies with the OHS-Webgate .. In my case the certs were removed during the upgrade .. you can try disable SSL and see if it helps .. else install certs .

so that means , no restart of any services required.

I'm following up this thread have some questions around it .....is it that customer has to take license to use VA feature of 12.2.1.4 after upgrading from 12.2.1.2? thanks

This patch is for 11.1.1.9 to 12.2.1.4 upgrade . Though I applied but no help.

yes browser cache has been cleared. Do you think emptying tmp files can cause this havoc?

one need to have separate ohs installed . 

thank you .. I do all this though.

No I cannot .. it will throw error while config that the Tables are already been used. thanks

So my fmw 12.2.3 infra doesn't have OHS and EM plugins .. installed those separately fixed the issue but is it supposed to be like this ? Isn't the fmw 12.2.3 infra installation should have those. I did the same on Windows 2012 and it worked fine , but on OL6.8 this is happening? So either there could be issue with the…

Okay issue was with database .. I was using database 12.2 .0.x which is not supported.. when I used 12.1.0.xx it worked. How I know ?? Check the sawserver logs and there it will list out driver errors.