FoundationSystemException: CWXFD3302E error when default content is fetched causing transaction to rollback

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:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Commerce Enterprise
Marketing / Campaigns

Software version:

7.0

Operating system(s):

AIX, IBM i, Linux, Solaris, Windows, i5/OS

Software edition:

Advanced, All Editions

Reference #:

1616697

Modified date:

2012-11-15

Translate my page

Machine Translation

Content navigation