Obiee hierarchies not working when upgrading from obiee 11.7 to 11.9. Even I have tried applying patch 25479567. But only few hierarchies got worked rest is not working. Even I have tried to rebuild the same in 11.9 Environment. It is not working still . Kindly help
Assertion failure: position < RECURRING_DEPTH_LIMIT at line 1626 of project/weblayoutbuilder/criteriacolumnimpl.cpp
Error Details
Error Codes:
ACIOA5LN#0 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw11debug_tools20AssertionHandlerBase31handleAssertionFailureByDefaultENS0_9Assertion4TypeEPKwRKNS_6StringIwN7_SAWSTL9allocatorIwEEEEiPKNS_7GDValueEPSB_+0x61) [0x2ae7ecc202d1] #1 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw11debug_tools9Assertion13handleFailureENS1_4TypeEPKwS4_i+0x44) [0x2ae7ecc1fff4] #2 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw18CriteriaColumnImpl24getBusinessLevelPositionERKNS_6HandleIKNS_14business_model12LogicalLevelES4_EES7_RKNS1_INS_5samns18SubjectAreaMDCacheES9_EERKNS_6StringIwN7_SAWSTL9allocatorIwEEEERi+0x2dd) [0x2ae7f0ef9e4d] #3 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw18CriteriaColumnImpl24getBusinessLevelPositionERKNS_6HandleIKNS_14business_model12LogicalLevelES4_EES7_RKNS1_INS_5samns18SubjectAreaMDCacheES9_EERKNS_6StringIwN7_SAWSTL9allocatorIwEEEERi+0x219) [0x2ae7f0ef9d89] #4 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw18CriteriaColumnImpl24getBusinessLevelPositionERKNS_6HandleIKNS_14business_model12LogicalLevelES4_EES7_RKNS1_INS_5samns18SubjectAreaMDCacheES9_EERKNS_6StringIwN7_SAWSTL9allocatorIwEEEERi+0x219) [0x2ae7f0ef9d89] #5 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw18CriteriaColumnImpl24getBusinessLevelPositionERKNS_6HandleIKNS_14business_model12LogicalLevelES4_EES7_RKNS1_INS_5samns18SubjectAreaMDCacheES9_EERKNS_6StringIwN7_SAWSTL9allocatorIwEEEERi+0x219) [0x2ae7f0ef9d89] #6 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw18CriteriaColumnImpl24getBusinessLevelPositionERKNS_6HandleIKNS_14business_model12LogicalLevelES4_EES7_RKNS1_INS_5samns18SubjectAreaMDCacheES9_EERKNS_6StringIwN7_SAWSTL9allocatorIwEEEERi+0x219) [0x2ae7f0ef9d89] #7 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw18CriteriaColumnImpl26setBusinessModelPropertiesERKNS_13SQLColumnInfoE+0x1e8) [0x2ae7f0efa668] #8 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw18CriteriaColumnImpl8loadCoreERKNS_10XmlElementE+0x8f7) [0x2ae7f0efd697] #9 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawlayoutbuilder643r.so(_ZN3saw20LayoutBuilderFactory23createReportLayoutModelERKNS_6HandleINS_20ViewComponentContextES2_EE+0x334) [0x2ae7f0f6c5f4] #10 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviews643r.so(_ZNK3saw8activate22EVCReportActionHandler29createAndSetReportLayoutModelERNS0_25ViewControllerReportStuffE+0x78) [0x2ae7ef754eb8] #11 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviewbase643r.so(_ZN3saw16AnalysisViewBase15submitViewQueryEPNS_8activate25ViewControllerReportStuffERKNS_6StringIwN7_SAWSTL9allocatorIwEEEEb+0x1b5) [0x2ae7f1588595] #12 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviews643r.so(_ZN3saw8activate20EVCActionHandlerImpl15callSubmitQueryERKNS0_20EVCActivationContextERNS0_23ViewControllerViewStuffEPNS0_25ViewControllerReportStuffE+0x63) [0x2ae7ef76f333] #13 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviews643r.so(_ZN3saw8activate22EVCReportActionHandler26handleSubmitQueryPhaseImplERNS0_13EVCActionBaseERNS0_18EVCActionEventBaseE+0x1a) [0x2ae7ef75337a] #14 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawreport643r.so(_ZN3saw4View15notifyEVCActionERNS_8activate13EVCActionBaseERNS1_18EVCActionEventBaseE+0xf9) [0x2ae7f2230169] #15 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl30submitReportQueryOrPromptQueryERNS_8activate20EVCActivationContextERN7_SAWSTL4pairIKNS_6StringIwNS4_9allocatorIwEEEENS1_23ViewControllerViewStuffEEE+0x177) [0x2ae7ef55f4f7] #16 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl13submitQueriesERNS_8activate20EVCActivationContextE+0x2b9) [0x2ae7ef56b889] #17 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl9_ActivateERNS_12NQHttpStreamENS_8activate12ActivateModeERKN7_SAWSTL6vectorINS_6StringIwNS5_9allocatorIwEEEENS8_ISA_EEEE+0x11f5) [0x2ae7ef56caf5] #18 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl8ActivateERNS_12NQHttpStreamE+0x46) [0x2ae7ef553b46] #19 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl19setupEVCForViewAjaxERNS_12AjaxResponseERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES6_EERN7_SAWSTL8auto_ptrINS_23DummyDashboardEmbedViewEEERKNS_6StringIwNSA_9allocatorIwEEEE+0xb58) [0x2ae7eac00558] #20 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl14getViewPreviewENS_12AjaxResponseERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES5_EE+0xcf) [0x2ae7eac070cf] #21 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl14AnswersGetViewERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES4_EE+0xda) [0x2ae7eabfc09a] #22 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw10subsystems17HttpCommandServerINS_13ViewSubsystemEE25commandServerInvokeMethodEmRNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES7_EE+0x77) [0x2ae7eac1c037] #23 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw16WebExtensionBase12CallFunctionERNS_12NQHttpStreamERKNS_6HandleINS_22WebMasterClientSessionES4_EERKNS3_IKNS_12CharacterSetES9_EERKNS_6StringIwN7_SAWSTL9allocatorIwEEEERKNS_8HttpArgsERNS_20ClientSessionUpdatesE+0x25f7) [0x2ae7eadcd747] #24 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw19HttpServerExtension14processRequestERNS_12NQHttpStreamENS_6HandleIKNS_12CharacterSetES5_EERKNS_17RefStringTemplateIcEEPcm+0xa2a) [0x2ae7ea96a57a] #25 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw19HttpServerExtension11processPOSTERNS_12NQHttpStreamEPcS3_m+0x82) [0x2ae7ea963b42] #26 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawhttpserver643r.so(_ZN3saw13SAWHttpServer14processRequestERNS_19HttpRequestProviderERNS_20HttpResponseProviderE+0x187c) [0x2ae7ea37163c] #27 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/sawserver(_ZN3saw14SAWHttpService17handleHttpRequestERNS_10RPCRequestERNS_11RPCResponseE+0x90) [0x40c0d0] #28 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/sawserver(_ZN3saw14SAWHttpService14callYourMemberERNS_10RPCRequestERNS_11RPCResponseEMNS_10RPCServiceEFvS2_S4_E+0x2d) [0x4111fd] #29 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw8RPCInetd15dispatchRequestERNS_10RPCRequestERNS_11RPCResponseE+0xa7) [0x2ae7ebd9b5d7] #30 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/sawserver(_ZN3saw8RPCInetd14callYourMemberERNS_10RPCRequestERNS_11RPCResponseEMNS_9RPCServerEFvS2_S4_E+0x2d) [0x4111bd] #31 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw25RPCServerMessageResponder7respondERNS_17RPCServerEndPointE+0xb46) [0x2ae7ebd76f86] #32 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw13RPCServerImpl7respondERNS_17RPCServerEndPointE+0x137) [0x2ae7ebd77dd7] #33 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw15SocketRPCServer16handleConnectionERNS0_15SocketServerJobE+0x606) [0x2ae7ebd95e76] #34 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw15SocketRPCServer11dispatchJobERNS0_15SocketServerJobERKNS_28ThreadPoolJobProcessingHintsE+0x19d) [0x2ae7ebd96f3d] #35 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw10ThreadPool12workerThreadEm+0x6d3) [0x2ae7ebf8a743] #36 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw10ThreadPool17workerThreadThunkEPv+0x30) [0x2ae7ebf8ce50] #37 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw19portableThreadThunkEPvj+0x1c0) [0x2ae7ebf7fa10] #38 /obiee/obiee_instance14/Middleware/Oracle_BI1/bifoundation/web/bin/libsawthreads643r.so(SAWPOSIXThreadThunk+0x13) [0x2ae7ebfaf173] #39 /lib64/libpthread.so.0 [0x30bee0683d] #40 /lib64/libc.so.6(clone+0x6d) [0x30be2d509d]
