Oracle Business Intelligence

Products Banner

12c: Error Performance Tile Conditional Formating

Received Response
54
Views
7
Comments

Hi guys,

When trying to apply a conditional format to a performance tile within an analysis I receive the following error code:

Assertion-Fehler: !sSqlExpr.empty() in Zeile 1005 von project/webquerymanager/xmlexpressionwrapper.cpp

Fehlercodes: ACIOA5LN

#0 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin

/libsawbedrock643r.so(_ZN3saw11debug_tools20AssertionHandlerBase31handleAssertionFailureByDefaultENS0_9Assertion4TypeEPKwRKNS_6StringIwNS_12SMAAllocatorIwEEEEiPKNS_7GDValueEPSA_+0x69) [0x7fa31e861b09]

#1 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawbedrock643r.so(_ZN3saw11debug_tools9Assertion13handleFailureENS1_4TypeEPKwS4_i+0x36) [0x7fa31e8605f6]

#2 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawquerymanager643r.so(_ZN3saw2qm20XmlExpressionWrapper13sqlExpressionERKNS_6StringIwNS_12SMAAllocatorIwEEEE+0x155) [0x7fa317fb7695]

#3 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviewbase643r.so(_ZN3saw20PropertyAdditionImpl17setReferencedExprERKNS_6StringIwNS_12SMAAllocatorIwEEEE+0x27) [0x7fa3183361c7]

#4 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw20ReportFormattingRule19addPropertyAdditionERKNS_6StringIwNS_12SMAAllocatorIwEEEES6_S6_NS_2qm15AggregationRuleE+0x84) [0x7fa3188725b4]

#5 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw21RuleExpressionBuilder11getMetadataERKNS_10XmlElementERNS_6StringIwNS_12SMAAllocatorIwEEEERNS_11SQLDataTypeE+0x5ba) [0x7fa31888a8ca]

#6 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw30FormatManagerExpressionBuilder18createDLExpressionERKNS_10XmlElementE+0x44) [0x7fa318869104]

#7 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw30FormatManagerExpressionBuilder24visitParsedColumnRefExprERKNS_6StringIwNS_12SMAAllocatorIwEEEERKNS_10XmlElementE+0x17) [0x7fa3188698c7]

#8 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawreport643r.so(_ZN3saw14XmlExprVisitor11processExprERKNS_10XmlElementE+0x1bf) [0x7fa3175a2dcf]

#9 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawreport643r.so(_ZN3saw17ExpressionBuilder19visitComparisonExprERKNS_10XmlElementE+0xda) [0x7fa31760795a]

#10 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawreport643r.so(_ZN3saw14XmlExprVisitor11processExprERKNS_10XmlElementE+0x384) [0x7fa3175a2f94]

#11 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw30FormatManagerExpressionBuilder9buildExprERKNS_10XmlElementE+0x50) [0x7fa318869ac0]

#12 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw20RuleBuilderXMLHelper12setConditionEPNS_21QDRBaseFormattingRuleEPKNS_10XmlElementERNS_11RuleBuilder14commonLoadDataE+0x1e2) [0x7fa318882452]

#13 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw20RuleBuilderXMLHelper8loadRuleEPNS_21QDRBaseFormattingRuleEPKNS_10XmlElementERNS_11RuleBuilder14commonLoadDataE+0x80) [0x7fa318887c30]

#14 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw20RuleBuilderXMLHelper22loadQDRBaseRuleFromXMLEPNS_21QDRBaseFormattingRuleEPKNS_10XmlElementERNS_11RuleBuilder14commonLoadDataE+0xc1) [0x7fa318887da1]

#15 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw17ReportRuleBuilder4loadERN7_SAWSTL6vectorINS_6HandleINS_14FormattingRuleES4_EENS1_9allocatorIS5_EEEEPKNS_10XmlElementERNS1_6bitsetILm47EEERNS0_14structLoadDataE+0x97d) [0x7fa31887b83d]

#16 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw17ReportRuleBuilder4loadERN7_SAWSTL6vectorINS_6HandleINS_14FormattingRuleES4_EENS1_9allocatorIS5_EEEEPKNS_10XmlElementERNS1_6bitsetILm47EEERNS0_14structLoadDataE+0xed) [0x7fa31887afad]

#17 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw17ReportRuleBuilder4loadERN7_SAWSTL6vectorINS_6HandleINS_14FormattingRuleES4_EENS1_9allocatorIS5_EEEEPKNS_10XmlElementERNS1_6bitsetILm47EEERNS0_14structLoadDataE+0xed) [0x7fa31887afad]

#18 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw17ReportRuleBuilder4loadERN7_SAWSTL6vectorINS_6HandleINS_14FormattingRuleES4_EENS1_9allocatorIS5_EEEEPKNS_10XmlElementERNS1_6bitsetILm47EEERNS0_14structLoadDataE+0xed) [0x7fa31887afad]

#19 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw17ReportRuleBuilder4loadERN7_SAWSTL6vectorINS_6HandleINS_14FormattingRuleES4_EENS1_9allocatorIS5_EEEEPKNS_10XmlElementERNS1_6bitsetILm47EEERNS0_14structLoadDataE+0xed) [0x7fa31887afad]

#20 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw17ReportRuleBuilder11createRulesEPKNS_10XmlElementEPNS_11RuleBuilder14commonLoadDataE+0x274) [0x7fa31887db54]

#21 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw12FormatEngine4loadEPNS_11RuleBuilder14commonLoadDataERNS_21AbstractObjectFactoryIS1_NS_6StringIwNS_12SMAAllocatorIwEEEEPFPS1_vENS_18DefaultErrorHendleEEE+0x17e) [0x7fa318858dbe]

#22 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw12FormatEngineC1Ev+0x736) [0x7fa318859ae6]

#23 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawformatengine643r.so(_ZN3saw19FormatEngineFactory18createFormatEngineEv+0x33) [0x7fa3188670d3]

#24 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw24ViewComponentContextImpl4initEv+0x47) [0x7fa31ae20cf7]

#25 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw27ViewComponentContextFactory26createViewComponentContextEv+0x5f) [0x7fa31ae20c2f]

#26 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZNK3saw8activate22EVCReportActionHandler26createViewComponentContextERNS_6HandleINS_20ViewComponentContextES3_EE+0x14) [0x7fa31ae7dfe4]

#27 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviewbase643r.so(_ZN3saw16AnalysisViewBase15submitViewQueryEPNS_8activate25ViewControllerReportStuffERKNS_6StringIwNS_12SMAAllocatorIwEEEEb+0xb6) [0x7fa318325356]

#28 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZNK3saw8activate20EVCActionHandlerImpl34EVCActionHandlerSubmitQueryFuncObj4evalERKNS0_20EVCActivationContextERNS0_23ViewControllerViewStuffEPNS0_25ViewControllerReportStuffE+0x3c) [0x7fa31ae99cec]

#29 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw8activate20EVCActionHandlerImpl27EVCActionHandlerFuncObjBase11tryMakeCallERS2_RKNS0_20EVCActivationContextERNS0_23ViewControllerViewStuffEPNS0_25ViewControllerReportStuffE+0x35) [0x7fa31ae9a485]

#30 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw8activate20EVCActionHandlerImpl15callSubmitQueryERKNS0_20EVCActivationContextERNS0_23ViewControllerViewStuffEPNS0_25ViewControllerReportStuffE+0x27) [0x7fa31ae9aa77]

#31 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw8activate22EVCReportActionHandler26handleSubmitQueryPhaseImplERNS0_13EVCActionBaseERNS0_18EVCActionEventBaseE+0x1a) [0x7fa31ae7daaa]

#32 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl30submitReportQueryOrPromptQueryERNS_8activate20EVCActivationContextERN7_SAWSTL4pairIKNS_6StringIwNS_12SMAAllocatorIwEEEENS1_23ViewControllerViewStuffEEE+0x130) [0x7fa31ace5ec0]

#33 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl13submitQueriesERNS_8activate20EVCActivationContextE+0xf3) [0x7fa31ace61e3]

#34 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl9_ActivateERNS_12NQHttpStreamENS_8activate12ActivateModeERKN7_SAWSTL6vectorINS_6StringIwNS_12SMAAllocatorIwEEEENS5_9allocatorISA_EEEE+0x700) [0x7fa31ace87e0]

#35 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawviews643r.so(_ZN3saw26EmbeddedViewControllerImpl8ActivateERNS_12NQHttpStreamE+0x36) [0x7fa31acd2676]

#36 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl19setupEVCForViewAjaxERNS_12AjaxResponseERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES6_EERN7_SAWSTL8auto_ptrINS_23DummyDashboardEmbedViewEEERKNS_6StringIwNS_12SMAAllocatorIwEEEE+0x99c) [0x7fa32171e46c]

#37 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl14getViewPreviewENS_12AjaxResponseERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES5_EE+0xbd) [0x7fa32171f38d]

#38 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw17ViewSubsystemImpl14AnswersGetViewERNS_12NQHttpStreamERKNS_6HandleINS_13ClientSessionES4_EE+0xcc) [0x7fa32171886c]

#39 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw16WebExtensionBase12CallFunctionERNS_12NQHttpStreamERKNS_6HandleINS_22WebMasterClientSessionES4_EERKNS3_IKNS_12CharacterSetES9_EERKNS_6StringIwNS_12SMAAllocatorIwEEEERKNS_8HttpArgsERNS_20ClientSessionUpdatesE+0x136f) [0x7fa3218c9c8f]

#40 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw19HttpServerExtension14processRequestERNS_12NQHttpStreamENS_6HandleIKNS_12CharacterSetES5_EERKNS_17RefStringTemplateIcEEPcm+0x1308) [0x7fa32148d488]

#41 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawsubsystems643r.so(_ZN3saw19HttpServerExtension11processPOSTERNS_12NQHttpStreamEPcS3_m+0x8f) [0x7fa321487def]

#42 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawhttpserver643r.so(_ZN3saw13SAWHttpServer14processRequestERNS_19HttpRequestProviderERNS_20HttpResponseProviderE+0x37b) [0x7fa3220346db]

#43 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/sawserver(_ZN3saw14SAWHttpService17handleHttpRequestERNS_10RPCRequestERNS_11RPCResponseE+0x88) [0x40d4b8]

#44 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw8RPCInetd15dispatchRequestERNS_10RPCRequestERNS_11RPCResponseE+0x108) [0x7fa31fbe2788]

#45 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw25RPCServerMessageResponder7respondERNS_17RPCServerEndPointE+0x8fc) [0x7fa31fbc164c]

#46 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw13RPCServerImpl7respondERNS_17RPCServerEndPointE+0x120) [0x7fa31fbc25c0]

#47 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw15SocketRPCServer16handleConnectionERNS0_15SocketServerJobE+0x269) [0x7fa31fbd9889]

#48 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawcomm643r.so(_ZN3saw15SocketRPCServer11dispatchJobERNS0_15SocketServerJobERKNS_28ThreadPoolJobProcessingHintsE+0xaa) [0x7fa31fbdab4a]

#49 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw10ThreadPool12workerThreadEm+0x634) [0x7fa31f90e414]

#50 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw10ThreadPool17workerThreadThunkEPv+0x25) [0x7fa31f910835]

#51 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawthreads643r.so(_ZN3saw19portableThreadThunkEPvj+0x16f) [0x7fa31f904aaf]

#52 /opt/oracle/base/product/fmw_12.2.1.1.0/bi/bifoundation/web/bin/libsawthreads643r.so(SAWPOSIXThreadThunk+0x13) [0x7fa31f92c933]

#53 /lib64/libpthread.so.0() [0x3f47007aa1]

#54 /lib64/libc.so.6(clone+0x6d) [0x3f468e8aad]

We currently have Oracle BIEE 12.2.1.0.0 installed and upgraded from 12.1.0 to this version last December.

I am not sure if it has worked with the previews version as I have never tried it in the past.

Does it maybe have to do with the path for Oracle home since it shows "fmw_12.2.1.1" (which has been created by patching to our current version) as our current Oracle home is actually just called "fmw"?

Does anyone know this error or has any suggestions on this matter?

Thanks for any help.

Answers