Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

After ssl configration ,usage tracking configration ,analytic cant login ,always log in loading

3462470Nov 10 2017

OBIEE12c version:12.2.1.2.0

ssl configed referance for

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=531849997213523&parent=DOCUMENT&sourceId=2244478.1&id=21…

usage tracking referance for Welcome to OBIEE12c - Set-up Usage Tracking – Part 1 - Red Stack Tech

I patched 24967379 and  25853222

before config usage tracking ,analytic can log in normal in ssl configration.

em message like this

sawlog0.log:

Exception in handler thread. An error occurred during processing of the SSL protocol.

Error Codes: I2GIBJSN:

Location: saw.rpc.ssl.read, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads

620099328:error:140760FC:SSL routines:SSL23_GET_CLIENT_HELLO:unknown protocol:s23_srvr.c:635:

obis1-diagnostic.log:

[2017-11-10T16:12:07.979+08:00] [OBIS] [ERROR:1] [] [] [ecid: 005NPlu4qUg0bq^_xTG7yW000EqG0000qZ,0] [sik: ssi] [tid: 89b77700]  [nQSError: 12002] Socket communication error at call=SSL_connect: (Number=1) error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed [[

file: server/Utility/Comm/Src/SUCMSSL.cpp; line: 807

[nQSError: 46119] Failed to open HTTP connection to server OBIServer at port 9503.

Comments

Gianni Ceresa

Because it is in a dashboard prompt, what behavior do you expect?
Your prompt could have various visual appearances but in the end only 2 possible values: why to write a query that will perform an operation to only return a long list of only 2 possible values?
Not even going into the logic of the query, what you are trying to do is a huge waste of resources for something that will probably not work as you expect because you have a different need than what you are trying to do.
With only 2 possible values, your prompt should not be "SQL Result" sourced but defined using "Custom Values" where you enter 'Sold' and 'Not sold' .

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details