Technote

(troubleshooting)
Ad Copy is missing after migrating to WebSphere Commerce version 6.0
Problem(Abstract)
You notice Ad Copy does not display for e-Marketing Spots defined for the store front after migration to WebSphere Commerce version 6.0. When you view the content in WebSphere Commerce Accelerator, there appears to be no image set up for the content.
Cause In previous versions of WebSphere Commerce, Ad Copy was defined for the e-Marketing Spots. In V6, Ad Copy is called Content, so the Ad Copy now appears to be placed under the Content item on the Marketing menu. When you view the content in the WebSphere Commerce Accelerator there appears to be no image set up for the content. The migration scripts do not adjust the values correctly during the database migration process. Resolving the problem This problem (APAR JR25946) is resolved in Fix Pack 6.0.0.3 or newer. You can obtain Fix Pack 6.0.0.3 or newer from the WebSphere Commerce Fixes by version page.

After applying the required fixes, migrate your data to ensure that the database is set up correctly for the migrated Ad Copy data. If you have already migrated your data, apply the required fixes, and manually update the database tables to ensure that the data is set up correctly using the following SQL:

INSERT INTO colltype (colltype_id, name) VALUES (4, 'Flash');
UPDATE colltype SET name = 'Image' WHERE colltype_id = 3;
UPDATE collateral SET colltype_id = 4 WHERE colltype_id = 2;
UPDATE collateral SET colltype_id = 2 WHERE colltype_id = 3;
UPDATE collateral SET colltype_id = 3 WHERE colltype_id = 1;
The old Ad Copy data remains blank in WebSphere Commerce Accelerator. The migrated content is 'read-only', You must use Attachments for all your new Ad Copy. With the new attachments feature, the data becomes what is called a 'Managed File'.

In order to use the new Attachments functionality in V6, you might need to make modifications to your store JSP files to use both the migrated and new entries. Use the eMarketingSpotDisplay.jsp sample included as part of the fix. (WC_Installdir/samples/Snippets/web/Marketing/Campaigns/eMarketingSpotDisplay.jsp).
Cross Reference information
Segment Product Component Platform Version Edition
Commerce WebSphere Commerce - Express Migration i5/OS, Linux, Windows 6.0, 6.0.0.1, 6.0.0.2 Express
Commerce WebSphere Commerce Professional Edition Migration AIX, i5/OS, Linux, Solaris, Windows 6.0, 6.0.0.1, 6.0.0.2 Professional Edition
Commerce WebSphere Commerce Developer Enterprise Migration Windows 6.0, 6.0.0.1, 6.0.0.2 Enterprise
Commerce WebSphere Commerce Developer Professional Edition Migration Windows 6.0, 6.0.0.1, 6.0.0.2 Developer Professional Edition
Commerce WebSphere Commerce Developer Express Migration Windows 6.0, 6.0.0.1, 6.0.0.2 Developer Express
   

Document Information

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