WebSphere Commerce Hint: Content Managed Files

The CMFILE table in WebSphere Commerce 6.0 is used to store managed files along with associated meta data. Recently I ran into a situation where I deleted an Attachment from the file system by redeploying the Stores.war module instead of just doing a partial update. When the ScheduledContentManagedFileEARUpdate scheduled job ran I expected to see the file appear in the Attachments folder in the deployed Stores.war file but instead nothing happened.

After doing some research, I found that there are two columns in the CMFILE table that need to be updated to ensure a content managed file is updated when the scheduled job runs. The PROMOTE_FS column indicates if a file has been created on the file system, a 0 value indicates that the file has not been promoted while a 1 value indicates that it has been promoted. The PROMOTE_TIMESTAMP column records the date that the file was created on the file system initially. I used the following SQL update in order to tell the scheduled job to recreate the file.

sql>update CMFILE set PROMOTE_FS = 0, PROMOTE_TIMESTAMP = NULL where CMFILEPATH = ‘path/to/file’;

Sure enough the next time the job ran the file appeared in the Stores.war/StoreName folder in the Attachment directory.

Click here to learn more about managed files.

Advertisements

2 Responses to “WebSphere Commerce Hint: Content Managed Files”


  1. 1 u.h. May 19, 2010 at 9:26 am

    thanks for the tip ! our ScheduledContentManagedFileEARUpdate partial fails i’ll try it as a workaround. we get errors “depth limit reached” in the ffdc log.

  2. 2 Venkatachalam Venugopalan October 27, 2011 at 2:50 pm

    Hi,

    I am facing similar issue while trying to add new JPEG file to a content spot. The PROMOTE_FS & PROMOTE_TIMESTAMP fields in CMFILE table are getting updated, but the new file is not promoted to the file system at all!!!

    Tried to recreate the file by running update query against CMFILE table, but still the file is not promoted to the server… but PROMOTE_FS & PROMOTE_TIMESTAMP fields in CMFILE table are getting updated

    Please share some idea on whats going on and how to handle the situation.

    Thanks,
    Venkatachalam Venugopalan.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





%d bloggers like this: