Enabling fix JR57116
JR57116 provides the ability to invalidate specific cache objects that are in the WCPriceDistributedMapCache.
Procedure
- From a command prompt, connect to the production database with a proper user ID and password.
-
Drop the existing database triggers by invoking the following SQL script.
- WCDE_installdir/schema/dbtype/wcs.cacheivl.drop.trigger.sql
- WC_installdir/schema/dbtype/wcs.cacheivl.drop.trigger.sql
-
Add the existing and new database triggers by invoking the following SQL script.
- WCDE_installdir/schema/dbtype/wcs.cacheivl.trigger.sql
- WC_installdir/schema/dbtype/wcs.cacheivl.trigger.sql