IBM Support

JR41594: CMVC 217121 - SOLVE THE DEFECT IN THE MIGRATION CODE IF CUSTOMER IS MIGRATING DATABASE (ORACLE) FROM WC6 TO WC7.

Direct links to fixes

7.0.0-WS-WCServer-FP009
WebSphere Commerce Version 7.0.0.6 Fix Pack
WebSphere Commerce Version 7.0.0.7 Fix Pack
WebSphere Commerce Version 7.0.0.8 Fix Pack
WebSphere Commerce Version 7.0.0.9 Fix Pack
JR41594: database check might fail during migration from V6.0 to V7.0 Fix Pack 5

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • WebSphere Commerce Database migration check failing with Warning
messages

Local fix

  • 



Problem summary


    

  • USERS AFFECTED:
Customers migrating database (ORACLE) from WC 6 to WC 7

PROBLEM ABSTRACT:

Observed Results: WARNING: [wcimDBCheckingTask] The column
atchrlus_id of table atchrlus referred in KEYS is not of integer
type.

 WARNING: [wcimDBCheckingTask] The column
atchastlg_id of table atchastlg referred in KEYS is not of
integer type.

....
...
 ERROR:    BUILD FAILED
 ERROR:
/WebSphere7/CommerceServer70/migration/xml/features/BASE/db/comm
on.xml:
8: null
 ERROR:    Total time: 1 minute 15 seconds
ERROR:    [WCIMANT] <run> WCIM has completed the
job(s) with errors. Check the log files for details.

WC Database migration check on Oracle database fails with
warning messages like the above one.


BUSINESS IMPACT:
Unable to migrate the WebSphere Commerce database successfully

RECOMMENDATION:

    



Problem conclusion


    

  • In the fix, IBM change one class file in <WC>/lib/Utilities.jar
to fix the problem.
-------------------------------------------------------------
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
    JR41594
    • 

  • Reported component name
    WC BUS EDITION
    • 

  • Reported component ID
    5724I3800
    • 

  • Reported release
    600
    • 

  • Status
    CLOSED  PER
    • 

  • PE
    NoPE
    • 

  • HIPER
    NoHIPER
    • 

  • Special Attention
    YesSpecatt / Pervasive
    • 

  • Submitted date
    2012-01-04
    • 

  • Closed date
    2012-03-16
    • 

  • Last modified date
    2012-03-16
    • 





    

  • 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 EDITION
    • 

  • Fixed component ID
    5724I3800
    • 



Applicable component levels


    

  • R700  PSY
       UP
    • 








      
              
                            

              

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

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            16 March 2012
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback