nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

12c: Error Performance Tile Conditional Formating

Carsten Weber

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.

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

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:

Carsten Weber

Hi Christian,

Indeed it was a typo.

We migrated from 12.2.1.0.0 to 12.2.1.2.0.

[Deleted User]

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

Carsten Weber

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

[Deleted User]

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

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.

[Deleted User]

Beaten to it by Pedro...