Categories
- All Categories
- 71 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 57 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
12c: Error Performance Tile Conditional Formating
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
-
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:
0 -
Hi Christian,
Indeed it was a typo.
We migrated from 12.2.1.0.0 to 12.2.1.2.0.
0 -
Thought as much. So waht are you doing exactly? I just did it and it works fine.
0 -
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
0 -
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
0 -
Beaten to it by Pedro...
0