OBIEE Hierarchies Not Working When upgrading OBIEE 11.1.1.7 TO 11.1.1.9.5

User_NPL69

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]

[Deleted User]

Just out of curiosity: What's the point of going to 11.1.1.9? Even its replacement, the 12c family with 12.2.1.4 is on its way out and replaced by OAS.

Why migrate from something that's 3 generations outdated to something that's 2 generations outdated rather than going to something up-to-date and supported?

User_NPL69

Hi Christian Berg,

Thanks for your response. Main objective of this migration to support  OUD. Hence we have planned immediate upgrade.

[Deleted User]

My points is: Why not upgrade to a current and supported version? Why do you "upgrade" to an old version?

User_NPL69

We are not having supporting OS for that. Hence upgrading in the existing OS

[Deleted User]

Ok. Tough luck for you then since this but was fixed in the 12c family but there is no back-port for the patch to 11.1.1.9 since it's too old.

Which pretty much makes my point. You're facing an issue in an outdated version which doesn't receive patches anymore because it's so old. By staying on outdated technology you're creating problems for yourself which you can't solve.