OBIEE12c Segmentation: Segment Count does not Finish (Doc ID 2299061.1)

Last updated on DECEMBER 03, 2021

Applies to:

Symptoms

After OBIEE 11g to 12c upgrade, created a new segment. The execution of the segment count never ends and does not return a result. Following errors are logged.


ERROR
-----------------------
[OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 1dfc] LCMAPIsUtil.DoesSIMetadataNeedRefresh-> called with token <TOKEN> : False
[OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 1ae0] [43065] The connection with Cluster Controller was lost.
[OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 10a0] Connection Pool entry for DSN <DSN>, DB name is Oracle Data Warehouse, connection pool name is Oracle Data Warehouse Connection Pool [[
Properties: description=RpScopeVar Exchange; producerID=0x3ffd0008; requestID=0xfffe01e4; sessionID=0xfffe0000; userName=nQS;
]]
[OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 10a0] Connection Pool exit for DSN <DSN>, DB name is Oracle Data Warehouse, connection pool name is Oracle Data Warehouse Connection Pool [[
Properties: description=RpScopeVar Exchange; producerID=0x3ffd0008; requestID=0xfffe01e4; sessionID=0xfffe0000; userName=nQS;
]]
[OBIS] [NOTIFICATION:1] [] [] [ecid: ] [sik: ssi] [tid: 10a0] Connection destroyed due to timeout. dsn is VALUEOF(OLAP_DSN), DB name is Oracle Data Warehouse [[
Properties: description=RpScopeVar Exchange; producerID=0x3ffd0008; requestID=0xfffe01e4; sessionID=0xfffe0000; userName=nQS;
]]
[OBIS] [ERROR:1] [] [] [ecid: ] [sik: ssi] [tid: 21b4] [43065] The connection with Cluster Controller was lost.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.