Technote (troubleshooting)
Problem(Abstract)
When default content is fetched from the database to display in e-Marketing Spots, the parsing error occurs which causes the transaction to rollback.
Symptom
"FoundationSystemException: CWXFD3302E: Failed to parse the expression" occurs when default content is fetched from the database to display in e-Marketing Spots.
When default content is fetched from the database to display in e-Marketing Spots, the following parsing error occurs which causes the transaction to rollback:
[11/1/12 11:31:56:297 EDT] 00000059 bod E CWXFD3302E: Failed to parse the expression {_wcf.ap=IBM_Store_Details;_wcf.dataLanguageIds='-1'}/MarketingContent[MarketingContentIdentifier[(UniqueID=)]].
com.ibm.commerce.foundation.internal.common.exception.FoundationSystemException: CWXFD3302E: Failed to parse the expression {_wcf.ap=IBM_Store_Details;_wcf.dataLanguageIds='-1'}/MarketingContent[MarketingContentIdentifier[(UniqueID=)]].
at com.ibm.commerce.foundation.server.services.dataaccess.SelectionCriteria.init(SelectionCriteria.java:161)
at com.ibm.commerce.foundation.server.services.dataaccess.SelectionCriteria.<init>(SelectionCriteria.java:100)
at com.ibm.commerce.foundation.server.command.bod.SearchExpression.<init>(SearchExpression.java:92)
at com.ibm.commerce.foundation.server.command.bod.AbstractGetBusinessObjectDocumentCmdImpl.buildSearchExpression(AbstractGetBusinessObjectDocumentCmdImpl.java:577)
at com.ibm.commerce.foundation.server.command.bod.AbstractGetBusinessObjectDocumentCmdImpl.getSearchExpression(AbstractGetBusinessObjectDocumentCmdImpl.java:639)
at com.ibm.commerce.foundation.server.command.bod.AbstractGetBusinessObjectDocumentCmdImpl.validateExpression(AbstractGetBusinessObjectDocumentCmdImpl.java:510)
at com.ibm.commerce.foundation.server.command.bod.AbstractGetBusinessObjectDocumentCmdImpl.performExecute(AbstractGetBusinessObjectDocumentCmdImpl.java:152)
at com.ibm.commerce.foundation.server.command.bod.BusinessObjectCommandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.java:112)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:332)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:166)
at com.ibm.commerce.foundation.server.command.bod.BusinessObjectDocumentProcessor.processBusinessObjectDocument(BusinessObjectDocumentProcessor.java:216)
at com.ibm.commerce.marketing.facade.server.MarketingFacadeImpl.getMarketingContent(MarketingFacadeImpl.java:161)
at com.ibm.commerce.marketing.facade.server.EJSLocalStatelessMarketing_0e493592.getMarketingContent(EJSLocalStatelessMarketing_0e493592.java:607)
at sun.reflect.GeneratedMethodAccessor171.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.commerce.foundation.internal.client.services.invocation.impl.LocalEJBInvocationBindingImpl.invoke(LocalEJBInvocationBindingImpl.java:199)
at com.ibm.commerce.foundation.internal.client.services.invocation.InvocationService.invoke(InvocationService.java:113)
at com.ibm.commerce.foundation.client.facade.bod.AbstractBusinessObjectDocumentFacadeClient.sendBusinessObjectDocument(AbstractBusinessObjectDocumentFacadeClient.java:451)
at com.ibm.commerce.marketing.facade.client.AbstractMarketingFacadeClient.getMarketingContent(AbstractMarketingFacadeClient.java:930)
at com.ibm.commerce.marketing.facade.client.AbstractMarketingFacadeClient.getMarketingContent(AbstractMarketingFacadeClient.java:1115)
at com.ibm.commerce.marketing.facade.client.AbstractMarketingFacadeClient.getMarketingContent(AbstractMarketingFacadeClient.java:1141)
at com.ibm.commerce.marketing.commands.marketingspot.RetrieveContentTaskCmdImpl.getMarketingContent(RetrieveContentTaskCmdImpl.java:411)
at com.ibm.commerce.marketing.commands.marketingspot.RetrieveContentTaskCmdImpl.getMarketingContent(RetrieveContentTaskCmdImpl.java:437)
at com.ibm.commerce.marketing.commands.marketingspot.RetrieveContentTaskCmdImpl.performExecute(RetrieveContentTaskCmdImpl.java:255)
at com.ibm.commerce.foundation.internal.server.command.impl.CommandTarget.executeCommand(CommandTarget.java:66)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:332)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:166)
at com.ibm.commerce.marketing.commands.marketingspot.FilterContentTaskCmdImpl.performExecute(FilterContentTaskCmdImpl.java:624)
at com.ibm.commerce.foundation.internal.server.command.impl.CommandTarget.executeCommand(CommandTarget.java:66)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:332)
at com.ibm.ws.cache.command.CommandCache.executeAndCacheCommand(CommandCache.java:150)
at com.ibm.ws.cache.command.CommandCache.getCommand(CommandCache.java:241)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:168)
at com.ibm.commerce.marketing.facade.server.commands.GetMarketingSpotDataCmdImpl.loadContent(GetMarketingSpotDataCmdImpl.java:1999)
at com.ibm.commerce.marketing.facade.server.commands.GetMarketingSpotDataCmdImpl.loadFilterAndOrderContent(GetMarketingSpotDataCmdImpl.java:1478)
at com.ibm.commerce.marketing.facade.server.commands.GetMarketingSpotDataCmdImpl.getMarketingSpotDataSDOs(GetMarketingSpotDataCmdImpl.java:2048)
at com.ibm.commerce.marketing.facade.server.commands.GetMarketingSpotDataCmdImpl.getMarketingSpotDataObject(GetMarketingSpotDataCmdImpl.java:965)
at com.ibm.commerce.marketing.facade.server.commands.GetMarketingSpotDataCmdImpl.getMarketingSpotDatas(GetMarketingSpotDataCmdImpl.java:863)
at com.ibm.commerce.marketing.facade.server.commands.GetMarketingSpotDataCmdImpl.performExpression(GetMarketingSpotDataCmdImpl.java:659)
at com.ibm.commerce.foundation.server.command.bod.AbstractGetBusinessObjectDocumentCmdImpl.performExecute(AbstractGetBusinessObjectDocumentCmdImpl.java:153)
at com.ibm.commerce.foundation.server.command.bod.BusinessObjectCommandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.java:112)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:332)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:166)
at com.ibm.commerce.foundation.server.command.bod.BusinessObjectDocumentProcessor.processBusinessObjectDocument(BusinessObjectDocumentProcessor.java:216)
at com.ibm.commerce.marketing.facade.server.MarketingFacadeImpl.getMarketingSpotData(MarketingFacadeImpl.java:97)
at com.ibm.commerce.marketing.facade.server.EJSLocalStatelessMarketing_0e493592.getMarketingSpotData(EJSLocalStatelessMarketing_0e493592.java:675)
at sun.reflect.GeneratedMethodAccessor109.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.commerce.foundation.internal.client.services.invocation.impl.LocalEJBInvocationBindingImpl.invoke(LocalEJBInvocationBindingImpl.java:199)
at com.ibm.commerce.foundation.internal.client.services.invocation.InvocationService.invoke(InvocationService.java:113)
at com.ibm.commerce.foundation.client.facade.bod.AbstractBusinessObjectDocumentFacadeClient.sendBusinessObjectDocument(AbstractBusinessObjectDocumentFacadeClient.java:451)
at com.ibm.commerce.marketing.facade.client.AbstractMarketingFacadeClient.getMarketingSpotData(AbstractMarketingFacadeClient.java:360)
at com.ibm.commerce.marketing.facade.client.AbstractMarketingFacadeClient.getMarketingSpotData(AbstractMarketingFacadeClient.java:429)
at sun.reflect.GeneratedMethodAccessor160.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.commerce.foundation.internal.client.taglib.config.GetDataConfig$DataTypeConfig.invokeClientFacadeMethod(GetDataConfig.java:898)
at com.ibm.commerce.foundation.internal.client.taglib.GetDataHandler.execute(GetDataHandler.java:733)
at com.ibm.commerce.foundation.internal.client.taglib.GetDataTag.doTag(GetDataTag.java:388)
at com.ibm._jsp._ContentAreaESpot._jspService(_ContentAreaESpot.java:1585)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)
..
..
..
Caused by: com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.ParseException: Encountered ")" at line 1, column 56.
Was expecting one of:
<LITERAL> ...
<NUMBER> ...
at com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.XPathTranslator.generateParseException(XPathTranslator.java:1574)
at com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.XPathTranslator.jj_consume_token(XPathTranslator.java:1454)
at com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.XPathTranslator.relationalExpr(XPathTranslator.java:881)
at com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.XPathTranslator.andExpr(XPathTranslator.java:819)
at com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.XPathTranslator.orExpr(XPathTranslator.java:795)
at com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.XPathTranslator.parenthesizedExpr(XPathTranslator.java:846)
at com.ibm.commerce.foundation.internal.server.services.dataaccess.xpath.XPathTranslator.relationalExpr(XPathTranslator.java:939)
Cause
When default content for the E-Marketing Spot is empty in DMEMSPOTDEF table, a parsing exception occurs because a non-empty value is expected for DMEMSPOTDEF.CONTENT column
Resolving the problem
Ensure there are no records in the DMEMSPOTDEF table with an empty CONTENT column.
To resolve the problem, assign default content for e-Marketing Spots that contain an empty CONTENT column in the DMEMSPOTDEF table.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.