Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
User_NPL69
Rank 3 - Community Apprentice
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 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]
0
Answers
-
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?
0 -
Hi Christian Berg,
Thanks for your response. Main objective of this migration to support OUD. Hence we have planned immediate upgrade.
0 -
My points is: Why not upgrade to a current and supported version? Why do you "upgrade" to an old version?
0 -
We are not having supporting OS for that. Hence upgrading in the existing OS
0 -
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.
0