I am running Oracle analytics server 6.4. We have EBS SSO enabled.
We are facing Session Timout message to frequently while login from DV console. This is annyoying for end users as well and they are asking to resolve this issue.
Hi @Muhammad Shoaib
You can refer below MOS for navigation steps -
Data Visualization URL Fails To Load In A Load Balanced | SSL | SSO Environment (Doc ID 2216708.1)
Regards,
Arjun
Hi @Mallikarjuna Kuppauru-Oracle ,
I have enabled option at domain level and restarted the services but unfortunately issue not resolved.
You can download .HAR file from browser while facing the issue , then you can able to see some more information about issue.
Below error is observed in BI server log:
Caused by: java.io.IOException: Broken pipe at sun.nio.ch.FileDispatcherImpl.write0(Native Method) at sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47) at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) at sun.nio.ch.IOUtil.write(IOUtil.java:65) at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:469) at weblogic.socket.NIOOutputStream$SingleBufferWrite.writeTo(NIOOutputStream.java:849) at weblogic.socket.NIOOutputStream$BlockingWriter.flush(NIOOutputStream.java:455) at weblogic.socket.NIOOutputStream$BlockingWriter.write(NIOOutputStream.java:334) at weblogic.socket.NIOOutputStream.write(NIOOutputStream.java:220) at weblogic.socket.JSSEFilterImpl.writeToNetwork(JSSEFilterImpl.java:829) at weblogic.socket.JSSEFilterImpl.wrapAndWrite(JSSEFilterImpl.java:789) at weblogic.socket.JSSEFilterImpl.write(JSSEFilterImpl.java:503) at weblogic.socket.JSSESocket$JSSEOutputStream.write(JSSESocket.java:154) at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:628) at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:590) at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:474) at weblogic.servlet.internal.ChunkOutput$3.checkForFlush(ChunkOutput.java:760) at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:373) at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:165) at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:186) at org.glassfish.jersey.servlet.internal.ResponseWriter$NonCloseableOutputStreamWrapper.write(ResponseWriter.java:325) at org.glassfish.jersey.message.internal.CommittingOutputStream.write(CommittingOutputStream.java:229) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$UnCloseableOutputStream.write(WriterInterceptorExecutor.java:299) at oracle.bi.tech.frameworks.plugin.manager.jee.WebAppPlugInManager.getResource(WebAppPlugInManager.java:160) at oracle.bi.tech.frameworks.plugin.manager.jee.WebAppPlugInManager.getResource(WebAppPlugInManager.java:116) at oracle.bi.tech.frameworks.plugin.manager.multi.MultiPlugInManager.getResource(MultiPlugInManager.java:157) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.lambda$getResource$1(CatalogPlugInManager.java:1170) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.executeIfNotNull(CatalogPlugInManager.java:236) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.loadCatalogPluginsIfNeededAndExecute(CatalogPlugInManager.java:282) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.loadCatalogPluginsIfNeededAndExecute(CatalogPlugInManager.java:226) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.getResource(CatalogPlugInManager.java:1169) at oracle.bi.tech.frameworks.plugin.registry.resource.PlugInRegistryResource$6.write(PlugInRegistryResource.java:757) at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:78) at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:60) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.invokeWriteTo(WriterInterceptorExecutor.java:265) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.aroundWriteTo(WriterInterceptorExecutor.java:250) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) at org.glassfish.jersey.server.internal.JsonWithPaddingInterceptor.aroundWriteTo(JsonWithPaddingInterceptor.java:106) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:86) ... 70 more
When I click on "Click here to login again" button , below error is printed in BI server log:
Error:
at sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:93) at sun.nio.ch.IOUtil.write(IOUtil.java:65) at sun.nio.ch.SocketChannelImpl.write(SocketChannelImpl.java:469) at weblogic.socket.NIOOutputStream$SingleBufferWrite.writeTo(NIOOutputStream.java:849) at weblogic.socket.NIOOutputStream$BlockingWriter.flush(NIOOutputStream.java:455) at weblogic.socket.NIOOutputStream$BlockingWriter.write(NIOOutputStream.java:334) at weblogic.socket.NIOOutputStream.write(NIOOutputStream.java:220) at weblogic.socket.JSSEFilterImpl.writeToNetwork(JSSEFilterImpl.java:829) at weblogic.socket.JSSEFilterImpl.wrapAndWrite(JSSEFilterImpl.java:789) at weblogic.socket.JSSEFilterImpl.write(JSSEFilterImpl.java:503) at weblogic.socket.JSSESocket$JSSEOutputStream.write(JSSESocket.java:154) at weblogic.servlet.internal.ChunkOutput.writeChunkTransfer(ChunkOutput.java:628) at weblogic.servlet.internal.ChunkOutput.writeChunks(ChunkOutput.java:590) at weblogic.servlet.internal.ChunkOutput.flush(ChunkOutput.java:474) at weblogic.servlet.internal.ChunkOutput$3.checkForFlush(ChunkOutput.java:760) at weblogic.servlet.internal.ChunkOutput.write(ChunkOutput.java:373) at weblogic.servlet.internal.ChunkOutputWrapper.write(ChunkOutputWrapper.java:165) at weblogic.servlet.internal.ServletOutputStreamImpl.write(ServletOutputStreamImpl.java:186) at org.glassfish.jersey.servlet.internal.ResponseWriter$NonCloseableOutputStreamWrapper.write(ResponseWriter.java:325) at org.glassfish.jersey.message.internal.CommittingOutputStream.write(CommittingOutputStream.java:229) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$UnCloseableOutputStream.write(WriterInterceptorExecutor.java:299) at oracle.bi.tech.frameworks.plugin.manager.jee.WebAppPlugInManager.getResource(WebAppPlugInManager.java:160) at oracle.bi.tech.frameworks.plugin.manager.jee.WebAppPlugInManager.getResource(WebAppPlugInManager.java:116) at oracle.bi.tech.frameworks.plugin.manager.multi.MultiPlugInManager.getResource(MultiPlugInManager.java:157) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.lambda$getResource$1(CatalogPlugInManager.java:1170) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.executeIfNotNull(CatalogPlugInManager.java:236) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.loadCatalogPluginsIfNeededAndExecute(CatalogPlugInManager.java:282) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.loadCatalogPluginsIfNeededAndExecute(CatalogPlugInManager.java:226) at oracle.bi.tech.services.plugin.managers.CatalogPlugInManager.getResource(CatalogPlugInManager.java:1169) at oracle.bi.tech.frameworks.plugin.registry.resource.PlugInRegistryResource$6.write(PlugInRegistryResource.java:757) at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:78) at org.glassfish.jersey.message.internal.StreamingOutputProvider.writeTo(StreamingOutputProvider.java:60) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.invokeWriteTo(WriterInterceptorExecutor.java:265) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor$TerminalWriterInterceptor.aroundWriteTo(WriterInterceptorExecutor.java:250) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) at org.glassfish.jersey.server.internal.JsonWithPaddingInterceptor.aroundWriteTo(JsonWithPaddingInterceptor.java:106) at org.glassfish.jersey.message.internal.WriterInterceptorExecutor.proceed(WriterInterceptorExecutor.java:162) at org.glassfish.jersey.server.internal.MappableExceptionWrapperInterceptor.aroundWriteTo(MappableExceptionWrapperInterceptor.java:86) ... 70 more
]] [2024-05-27T14:05:03.361+05:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.tech.model.endpoint.PoolStatsLogger] [tid: HTTP ConnectionManager Eviction Scheduler] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-000303b0,0:26:39] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] Connection Manager {httpclient} route (overall) stats [leased: 0; pending: 0; available: 1; max: 1000] [2024-05-27T14:05:03.362+05:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.tech.model.endpoint.PoolStatsLogger] [tid: HTTP ConnectionManager Eviction Scheduler] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-000303b0,0:26:39] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] Connection Manager {httpclient} route {}->http://prodoas.fatima-group.com:9505 stats [leased: 0; pending: 0; available: 1; max: 500] [2024-05-27T14:05:05.665+05:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.web.datasetsvc.rest.maintenance.DsmTransactionsCleanTask] [tid: pool-61-thread-7] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-0000000a,0:1120] [APP: bidatasetsvc] [partition-name: DOMAIN] [tenant-name: GLOBAL] dsm transactions cleanup task started [2024-05-27T14:05:05.671+05:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.web.datasetsvc.rest.maintenance.DsmTransactionsCleanTask] [tid: pool-61-thread-7] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-0000000a,0:1120] [APP: bidatasetsvc] [partition-name: DOMAIN] [tenant-name: GLOBAL] dsm transactions cleanup task ended [2024-05-27T14:05:17.077+05:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.tech.model.servicelcm.ServiceLCM] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-00030488,0] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000OytIVTnF4E05zzg8yW1aK4yU000004] [SI-Key: ssi] Could not find a Reference for "oa.platform.showSecurityBanner" key [2024-05-27T14:05:30.084+05:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.tech.model.servicelcm.ServiceLCM] [tid: [ACTIVE].ExecuteThread: '18' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-00030491,0] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000OytIVTnF4E05zzg8yW1aK4yU000004] [SI-Key: ssi] Could not find a Reference for "oa.platform.showSecurityBanner" key [2024-05-27T14:05:39.547+05:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.tech.model.endpoint.PoolStatsLogger] [tid: HTTP ConnectionManager Eviction Scheduler] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-000303b0,0:26:39] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] Connection Manager {httpasyncclient} route (overall) stats [leased: 0; pending: 0; available: 0; max: 1000] [2024-05-27T14:05:42.256+05:00] [bi_server1] [WARNING] [] [oracle.bi.endpointmanager.jee.JEEComponent] [tid: Timer-16] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-0000000a,0:1495] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] Deprecated endpoint configuration for 'adminservice': scope not explicit, defaulting to EXTERNAL. This default may be removed. [2024-05-27T14:05:42.256+05:00] [bi_server1] [WARNING] [] [oracle.bi.endpointmanager.jee.JEEComponent] [tid: Timer-16] [userId: <anonymous>] [ecid: 4989b497-9220-40aa-abde-b715cf6bc990-0000000a,0:1495] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] Deprecated endpoint configuration for 'asyncadminservice': scope not explicit, d
@Muhammad Shoaib looks you implemented steps in
Security Integration of OBIEE 12c/Oracle Analytics Server with Oracle E-Business Suite (EBS) (Doc ID 2825669.1)
What connectionWaitTimeout & oracleNetConnectTimeout Values had been set in LibOvd Adapter XML ?
Please be aware any changes in the Adapter will require to delete current Adapter and create a new one
Hi @Mostafa Morsy-Oracle,
Both values set as 3600.
Shoaib
@Muhammad Shoaib
what is the value of "cookie-max-age-secs" in Weblogic.xml file ? did you make any changes in analytics.ear file ?please check ID 2401492.1
can you reproduce the issue and attach the .HAR File
Can you check below -
JSESSIONID Set With An Expiry Date That Does Not Get Extended In Spite Of Activity (Doc ID 2582982.1)
Sorry for late rply, I have below setting in my weblogic.xml file:
<session-descriptor> <timeout-secs>3600</timeout-secs> <invalidation-interval-secs>60</invalidation-interval-secs> <cookie-name>ADMINCONSOLESESSION</cookie-name> <cookie-path>/console/</cookie-path> <cookie-max-age-secs>-1</cookie-max-age-secs> <url-rewriting-enabled>false</url-rewriting-enabled> </session-descriptor>
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
There is no option for legend title in many visualization types.
