Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Hierarchies Not Working When upgrading OBIEE 11.1.1.7 TO 11.1.1.9.5

Received Response
31
Views
5
Comments
User_NPL69
User_NPL69 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:18PM in Oracle Analytics Forum

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]

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    User_NPL69 Rank 3 - Community Apprentice

    Hi Christian Berg,

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

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

  • User_NPL69
    User_NPL69 Rank 3 - Community Apprentice

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

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.