IBM Support

JR48042: CMVC 231211 -When FACETCATGRP.SEQUENCE is set to null, any further changes to that facet causes CMC exception

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When trying to save the sequence of a facet, the following
exception occurs:

[9/30/13 11:06:23:327 EDT] 0000153e bod           E   The
category was not changed because one or more validations have
failed.

com.ibm.commerce.catalog.facade.server.exception.CatalogApplicat
ionException: The category was not changed because one or more
validations have failed.
    at
com.ibm.commerce.catalog.facade.server.services.dataaccess.bom.m
ediator.ChangeCatalogGroupFacetMediator.update(ChangeCatalogGrou
pFacetMediator.java:450)
    at
com.ibm.commerce.foundation.server.command.bod.bom.AbstractChang
eNounPartUsingBusinessObjectMediatorCmdImpl.change(AbstractChang
eNounPartUsingBusinessObjectMediatorCmdImpl.java:381)
    at
com.ibm.commerce.foundation.server.command.bod.AbstractChangeNou
nPartActionCmdImpl.performExecute(AbstractChangeNounPartActionCm
dImpl.java:179)
    at
com.ibm.commerce.foundation.internal.server.command.impl.Command
Target.executeCommand(CommandTarget.java:66)
    at
com.ibm.websphere.command.TargetableCommandImpl.execute(Targetab
leCommandImpl.java:139)
    at
com.ibm.websphere.command.CacheableCommandImpl.execute(Cacheable
CommandImpl.java:138)
    at
com.ibm.commerce.foundation.server.command.bod.AbstractChangeBus
inessObjectDocumentCmdImpl.performAction(AbstractChangeBusinessO
bjectDocumentCmdImpl.java:880)
    at
com.ibm.commerce.foundation.server.command.bod.AbstractActionBus
inessObjectDocumentCmdImpl.performExecute(AbstractActionBusiness
ObjectDocumentCmdImpl.java:145)
    at
com.ibm.commerce.foundation.server.command.bod.BusinessObjectCom
mandTargetImpl.executeCommand(BusinessObjectCommandTargetImpl.ja
va:112)
    at
com.ibm.websphere.command.TargetableCommandImpl.execute(Targetab
leCommandImpl.java:139)
    at
com.ibm.websphere.command.CacheableCommandImpl.execute(Cacheable
CommandImpl.java:138)
    at
com.ibm.commerce.foundation.server.command.bod.BusinessObjectDoc
umentProcessor.processBusinessObjectDocument(BusinessObjectDocum
entProcessor.java:229)
    at
com.ibm.commerce.catalog.facade.server.CatalogFacadeImpl.changeC
atalogGroup(CatalogFacadeImpl.java:100)
    at
com.ibm.commerce.catalog.facade.server.EJSLocalStatelessCatalog_
867afe99.changeCatalogGroup(EJSLocalStatelessCatalog_867afe99.ja
va:471)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor
Impl.java:60)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod
AccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at
com.ibm.commerce.foundation.internal.client.services.invocation.
impl.LocalEJBInvocationBindingImpl.invoke(LocalEJBInvocationBind
ingImpl.java:199)

...and you find that FACETCATGRP.SEQUENCE is null

Local fix

  • Set FACETCATGRP.SEQUENCE equal to some value e.g. 0.0

Problem summary

  • USERS AFFECTED:
WebSphere Commerce v7 users using facets. Scenarios that set the
column to null are unknown

PROBLEM ABSTRACT:
When FACETCATGRP.SEQUENCE is set to null, any further changes to
that facet causes CMC exception

BUSINESS IMPACT:
Low. Facet doesn't display

RECOMMENDATION:

Problem conclusion

  • An extra check was added to the code before trying to cast the
sequence value to detect whether it is null or not before
casting to double,
-------------------------------------------------------------
The latest available maintenance information can be obtained
from the Recommended Fixes for WebSphere Commerce technote:
http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296

Temporary fix

  • 



Comments


    

  • 



APAR Information




    

  • APAR number
    JR48042
    • 

  • Reported component name
    WC BUS DEV ED W
    • 

  • Reported component ID
    5724I3900
    • 

  • Reported release
    700
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    NoSpecatt
    • 

  • Submitted date
    2013-10-10
    • 

  • Closed date
    2013-12-02
    • 

  • Last modified date
    2013-12-02
    • 





    

  • APAR is sysrouted FROM one or more of the following:
    

    • 

  • APAR is sysrouted TO one or more of the following:
    

    • 



Fix information


    

  • Fixed component name
    WC BUS DEV ED W
    • 

  • Fixed component ID
    5724I3900
    • 



Applicable component levels


    

  • R700  PSY
       UP
    • 








      
              
                            

              

              [{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSYT2H","label":"WebSphere Commerce Developer Enterprise"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":null,"label":null}}]
              

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            02 December 2013
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback