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>
