Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Assertion failure: 1 <= nMonth && nMonth <=12 at line 629 of project/webbedrock/datetime.cpp

Received Response
11
Views
2
Comments
13131313
13131313 Rank 2 - Community Beginner
edited Aug 13, 2024 5:45PM in Oracle Analytics Cloud and Server

Due to customers being on different versions of OBIEE, we develop our RPD in 11g and then convert to 12c where required.

Have come across a strange issue where a date object recently added works fine in 11g but is generating the below error when selected in a 12c environment, can anyone see anything obvious as to why?

Assertion failure: 1 <= nMonth && nMonth <=12 at line 629 of project/webbedrock/datetime.cpp

  Error Details

Error Codes: ACIOA5LN

#0 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw11debug_tools20AssertionHandlerBase31handleAssertionFailureByDefaultENS0_9Assertion4TypeEPKwRKNS_6StringIwNS_12SMAAllocatorIwEEEEiPKNS_7GDValueEPSA_+0x69) [0x7f345f2fcb09]

#1 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw11debug_tools9Assertion13handleFailureENS1_4TypeEPKwS4_i+0x36) [0x7f345f2fb5f6]

#2 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw4Date9monthDaysEss+0x85) [0x7f345f2fde25]

#3 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw4Date15gregorianFormatEj+0x45) [0x7f345f2fe015]

#4 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw4Date10initializeEj+0x4d) [0x7f345f2fe19d]

#5 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw4DateplEj+0x27) [0x7f345f2fe277]

#6 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawutil643r.so(+0x17e0b2) [0x7f345fd9d0b2]

#7 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawutil643r.so(_ZNK3saw12TimeZoneImpl14dstEndDateTimeEs+0x3b) [0x7f345fd9d59b]

#8 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawutil643r.so(_ZNK3saw12TimeZoneImpl5isDstERKNS_8DateTimeE+0x6c) [0x7f345fd9d62c]

#9 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawutil643r.so(_ZNK3saw12TimeZoneImpl12getUtcOffsetERKNS_8DateTimeE+0x9) [0x7f345fd9d969]

#10 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawutil643r.so(_ZN3saw9DateUtils19convertTimeZoneTimeERKNS_8DateTimeEiRKNS_8TimeZoneE+0x15) [0x7f345fcda625]

#11 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawformat643r.so(_ZNK3saw18TimeStampFormatter11FormatValueERNS_24StringBufferBaseTemplateIwEERKNS_8DateTimeE+0xd4) [0x7f3455c190c4]

#12 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawformat643r.so(_ZNK3saw18TimeStampFormatter19impl_formatToBufferERNS_24StringBufferBaseTemplateIwEEPKv+0x36) [0x7f3455c192e6]

#13 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawformat643r.so(_ZNK3saw17WebValueFormatter14FormatToStreamERNS_15WebOutputStreamEPKv+0x39) [0x7f3455c12b19]

#14 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers19VDLBaseCellRendererINS0_20HTMLCellRendererTypeEE19renderValueAndImageERNS_12NQHttpStreamEPKNS_21CompiledDisplayFormatERKNS_6HandleIKNS_17WebValueFormatterESB_EEPKvRNS0_19EmptyStreamRendererIS2_EERNS_24StringBufferBaseTemplateIwEE+0xa33) [0x7f345b37e633]

#15 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawrendererbase643r.so(_ZN3saw9renderers19VDLEdgeCellRendererINS0_20HTMLCellRendererTypeEE14renderContentsEv+0x2c9) [0x7f345a457af9]

#16 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawrendererbase643r.so(_ZN3saw9renderers19VDLBaseCellRendererINS0_20HTMLCellRendererTypeEE10renderCellEv+0x228) [0x7f345a4324d8]

#17 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers20HtmlGridViewRenderer17renderCellContentENS0_12WRBConstants16CellRendererTypeE+0x16a) [0x7f345b33d11a]

#18 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers16GridViewRendererINS0_20HTMLCellRendererTypeEE10renderCellENS0_12WRBConstants16CellRendererTypeE+0x146) [0x7f345b2ca946]

#19 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers16GridViewRendererINS0_20HTMLCellRendererTypeEE14renderRowLayerEm+0x1e1) [0x7f345b2bd1b1]

#20 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers16GridViewRendererINS0_20HTMLCellRendererTypeEE25renderRowEdgeLayersForRowEm+0x6c) [0x7f345b2c21cc]

#21 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers29ScrollingHtmlGridViewRenderer20renderRowHeaderBlockEv+0x6ba) [0x7f345b35331a]

#22 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers29ScrollingHtmlGridViewRenderer23renderScrollingGridViewEv+0x28f1) [0x7f345b34ee61]

#23 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers29ScrollingHtmlGridViewRenderer14renderGridDataEv+0x183) [0x7f345b3519b3]

#24 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers16GridViewRendererINS0_20HTMLCellRendererTypeEE19renderLegendAndGridEv+0x2ec) [0x7f345b2c628c]

#25 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers16GridViewRendererINS0_20HTMLCellRendererTypeEE27renderGridWithOptionalChartEv+0x2da) [0x7f345b2c6f8a]

#26 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers16GridViewRendererINS0_20HTMLCellRendererTypeEE14renderGridViewERNS_10WebHTMLDiv3DefERNS0_17GridViewHTMLTable3DefE+0x3bc) [0x7f345b2b7e1c]

#27 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers16GridViewRendererINS0_20HTMLCellRendererTypeEE6encodeERNS_12NQHttpStreamERNS_6HandleINS0_16RenderingContextES7_EEPNS_4ViewERNS6_INS0_14ChartCacheBaseESC_EERNS6_ISA_SA_EERN7_SAWSTL3mapINS_6StringIwNS_12SMAAllocatorIwEEEENSI_ISM_SF_NSH_4lessISM_EENSH_9allocatorINSH_4pairIKSM_SF_EEEEEESO_NSP_INSQ_ISR_SU_EEEEEE+0x107) [0x7f345b2c5dd7]

#28 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawgridviewbase643r.so(_ZN3saw9renderers8GridView16generateHtmlViewERNS_12NQHttpStreamERNS_6HandleINS0_16RenderingContextES5_EE+0x768) [0x7f345b2f03a8]

#29 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawrendererbase643r.so(_ZN3saw9renderers8DataView12GenerateViewERNS_12NQHttpStreamERKNS_6StringIwNS_12SMAAllocatorIwEEEE+0x4da) [0x7f345a50c7ca]

#30 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw14NQCompoundView10GenerateUIERNS_12NQHttpStreamE+0x24db) [0x7f345b7521db]

#31 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw14NQCompoundView12GenerateViewERNS_12NQHttpStreamERKNS_6StringIwNS_12SMAAllocatorIwEEEE+0x569) [0x7f345b754599]

#32 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26HTMLEmbeddedViewController16HandleViewStatusERNS_12NQHttpStreamERKNS_6StringIwNS_12SMAAllocatorIwEEEERNS_8activate23ViewControllerViewStuffERNS9_25ViewControllerReportStuffENS_22EmbeddedViewController18EmbeddedViewStatusENSE_10SyndicatedES8_+0x120d) [0x7f345b7b843d]

#33 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl12GenerateViewERNS_12NQHttpStreamERKNS_6StringIwNS_12SMAAllocatorIwEEEES8_+0xa17) [0x7f345b77eb97]

#34 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl14getViewPreviewENS_12AjaxResponseERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES5_EE+0x65e) [0x7f34621b9bce]

#35 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl14AnswersGetViewERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES4_EE+0xcc) [0x7f34621b2b0c]

#36 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw16WebExtensionBase12CallFunctionERNS_12NQHttpStreamERKNS_6HandleINS_22WebMasterClientSessionES4_EERKNS3_IKNS_12CharacterSetES9_EERKNS_6StringIwNS_12SMAAllocatorIwEEEERKNS_8HttpArgsERNS_20ClientSessionUpdatesE+0x136f) [0x7f346236417f]

#37 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw19HttpServerExtension14processRequestERNS_12NQHttpStreamENS_6HandleIKNS_12CharacterSetES5_EERKNS_17RefStringTemplateIcEEPcm+0x1476) [0x7f3461f274a6]

#38 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw19HttpServerExtension11processPOSTERNS_12NQHttpStreamEPcS3_m+0x8f) [0x7f3461f21c9f]

#39 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawhttpserver643r.so(_ZN3saw13SAWHttpServer14processRequestERNS_19HttpRequestProviderERNS_20HttpResponseProviderE+0x37b) [0x7f3462ad06db]

#40 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/sawserver(_ZN3saw14SAWHttpService17handleHttpRequestERNS_10RPCRequestERNS_11RPCResponseE+0x88) [0x40d4b8]

#41 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw8RPCInetd15dispatchRequestERNS_10RPCRequestERNS_11RPCResponseE+0x108) [0x7f346067d788]

#42 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw25RPCServerMessageResponder7respondERNS_17RPCServerEndPointE+0x8fc) [0x7f346065c64c]

#43 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw13RPCServerImpl7respondERNS_17RPCServerEndPointE+0x120) [0x7f346065d5c0]

#44 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw15SocketRPCServer16handleConnectionERNS0_15SocketServerJobE+0x269) [0x7f3460674889]

#45 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw15SocketRPCServer11dispatchJobERNS0_15SocketServerJobERKNS_28ThreadPoolJobProcessingHintsE+0xaa) [0x7f3460675b4a]

#46 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw10ThreadPool12workerThreadEm+0x634) [0x7f34603a83f4]

#47 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw10ThreadPool17workerThreadThunkEPv+0x25) [0x7f34603aa815]

#48 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw19portableThreadThunkEPvj+0x16f) [0x7f346039ea8f]

#49 /u01/oracle02/Oracle/Middleware/Oracle_Home/bi/bifoundation/web/bin/libsawthreads643r.so(SAWPOSIXThreadThunk+0x13) [0x7f34603c6913]

#50 /lib64/libpthread.so.0() [0x3c14a07aa1]

#51 /lib64/libc.so.6(clone+0x6d) [0x3c146e8bcd]

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    13131313 wrote:Due to customers being on different versions of OBIEE, we develop our RPD in 11g and then convert to 12c where required.

    a) Very bad idea

    b) *HOW* do you "convert where required"??

  • 13131313
    13131313 Rank 2 - Community Beginner

    Open in the 12c Admin tool, save as with a check global consistency.  This is the first issue we've encountered using this process.

    It's a pretty large generic repository for a product we sell and not an option to maintain separately.