Technote

(troubleshooting)
Invalid Metadata or does not have a feature named OPTCOUNTER in JDBCMediator
Problem(Abstract)
You extend an existing WebSphere Commerce service module (for example, by adding new tables) and the following exception occurs:

CWXFD3134E: Execution of get request failed. Invalid Metadata in JDBCMediator.
Or
saveGraph Original exception: Class 'ClassName' does not have a feature named 'OPTCOUNTER'
Symptom From the trace.log, you see the following exception (by accessing the catalog in the Management Center)
com.ibm.websphere.command.CommandException
at com.ibm.commerce.foundation.server.command.bod.
BusinessObjectCommandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.java:129)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:335)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:159)
...
Caused by: Current exception:
Message:
CWXFD3134E: Execution of get request failed. Invalid Metadata in JDBCMediator.
Stack trace:
com.ibm.websphere.command.CommandException: CWXFD3134E: Execution of get request failed. Invalid Metadata in JDBCMediator.
at com.ibm.websphere.command.LocalTarget.executeCommand(LocalTarget.java:69)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:335)
at com.ibm.websphere.command.CacheableCommandImpl.execute(CacheableCommandImpl.java:159)
at com.ibm.commerce.catalog.facade.server.commands.
AbstractFetchCatalogSOICmdImpl.execute(AbstractFetchCatalogSOICmdImpl.java:134)
at com.ibm.commerce.foundation.server.command.bod.
AbstractGetBusinessObjectDocumentCmdImpl.performExpression(AbstractGetBusinessObjectDocumentCmdImpl.java:267)
at com.ibm.commerce.foundation.server.command.bod.
AbstractGetBusinessObjectDocumentCmdImpl.performExecute(AbstractGetBusinessObjectDocumentCmdImpl.java:142)
at com.ibm.commerce.foundation.server.command.bod.
BusinessObjectCommandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.java:109)
at com.ibm.ws.cache.command.CommandCache.executeCommand(CommandCache.java:335)

Or
graphbuilders I com.ibm.commerce.foundation.internal.server.services.dataaccess.
graphbuilderservice.JDBCGraphBuilderService saveGraph Original exception: Class 'CatalogGroupDescription' does not have a feature named 'OPTCOUNTER'
[1/29/08 9:05:51:801 EST] 0000009e bod I CWXFD3112E: Database operation failed
com.ibm.commerce.foundation.server.services.dataaccess.bom.exception.
BusinessObjectMediatorException: CWXFD3112E: Database operation failed
at com.ibm.commerce.foundation.server.services.dataaccess.bom.mediator.
AbstractChangeBusinessObjectPartMediatorImpl.applyChanges(AbstractChangeBusinessObjectPartMediatorImpl.java:254)
at com.ibm.commerce.foundation.server.command.bod.bom.
AbstractChangeNounPartUsingBusinessObjectMediatorCmdImpl.save(AbstractChangeNounPartUsingBusinessObjectMediatorCmdImpl.java:306)
at com.ibm.commerce.foundation.server.command.bod.
AbstractChangeNounPartActionCmdImpl.performExecute(AbstractChangeNounPartActionCmdImpl.java:161) Cause The JDBC Mediator fixes are not installed correctly which is caused by required WAS fixes not being installed in the proper order. Resolving the problem Ensure that the APARs listed in the following URL are installed according to the specified order.
http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21290621


Use historyInfo.bat or historyInfo.sh to check the APARs being installed.

The order of APAR installation is important..
Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce - Express Customization / Application Development i5/OS, Linux, Windows 6.0.0.4
Commerce WebSphere Commerce Professional Edition Customization / Application Development AIX, i5/OS, Linux, Solaris, Windows 6.0.0.4
   

Document Information

Current web document: http://www.ibm.com/support/docview.wss?uid=swg21297249