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

12c: Error Performance Tile Conditional Formating

Received Response
51
Views
7
Comments
Carsten Weber
Carsten Weber Rank 5 - Community Champion
edited August 13 in Oracle Analytics Cloud and Server

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

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru 
    1715906 wrote:We currently have Oracle BIEE 12.2.1.0.0 installed and upgraded from 12.1.0 to this version last December.

    Hmmm the intial release of 12c was 12.2.1.0.0.

    I presume you mean you upgraded from 12.2.1.0.0 to 12.2.1.2.0, right?

    Edit: Hmmm works fine:

    pastedImage_0.png

  • Carsten Weber
    Carsten Weber Rank 5 - Community Champion

    Hi Christian,

    Indeed it was a typo.

    We migrated from 12.2.1.0.0 to 12.2.1.2.0.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    Thought as much. So waht are you doing exactly? I just did it and it works fine.

  • Carsten Weber
    Carsten Weber Rank 5 - Community Champion

    I am using SQL within an analysis to get information from our database via a predefined connection pool. That works so far.

    Afterwards I have created a performance tile and asigned a database attribute to it. That also worked well.

    In the last step I started to create the conditinal format to the tile and it showed the error message.

    Example: Attribute value = 80

    Conditional format: When value > 80 then use green font color

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    Oh so it's a Direct DB Request? Ok I didn't test that. Will try it later and let you know.

    Edit: mcuh later. Connection too bad to get to any of my cloud instances

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    Hi,

    If you're using a direct database request that you can forget the conditional formatting, it's one of its limitations, not possible.

    See documentation here.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    Beaten to it by Pedro...