Job - SynchronizeAllTextIndexes

Personal Library

Name	SynchronizeAllTextIndexes
Domain	root
Job Dependencies	OptimizeAllTextIndexes
AcquiredResources	none
Cartridge	core
Pipeline	TextIndexes-SynchronizeAll
Affected Domain Objects	Product, Auction, Category, Costcenter, Department, Domain, Order, Journalentry, Messagebody, Organization, Pagelet, Derivedproduct
Affected Tables	dr$auction_av_str_val* dr$category_av_str_val* dr$costcenter_av_str_val* dr$department_av_str_val* dr$domain_av_str_val* dr$isorder_av_str_val* dr$journalentry_ck001* dr$messagebody_av_str_val* dr$org_av_str_val* dr$pageentpt_av_str_val* dr$pagelet_av_str_val* dr$product_ctx* dr$product_ctx_<locale>* dr$derivedproduc_ctx_<locale>* dr$derivedproduct_ctx* dr$configuration_ctx_<locale>* dr$configurationparame_ctx*
Stored Procedure	intershop.database.synchronizeAllTextIndexes.Procedure (database.properties) or the default: core.sync_all_ctx_indexes()
Default State	Enabled
Is Site Specific	False
Edit State	n.a.
Live State	n.a.
Server Group	JOB
Description	Synchronize all text indexes. This job calls the stored procedure configured in property 'intershop.database.synchronizeAllTextIndexes.Procedure', which is responsible for synchronizing all text indexes of the entire database schema to maintain text indexes.
Scheduling	Starting time: 00:05 Interval: 60 min
What Happens Switched Off	Oracle Text index selection-performance decrease.
Trouble Shooting	The job calls the stored procedure core.sync_all_ctx_indexes(), which can be executed manually in database using SQL*Plus: SQL> exec core.sync_all_ctx_indexes() [2012-11-21 15:25:59.958 +00:00] Text index synchronization with parameters: [2012-11-21 15:25:59.958 +00:00] Memory: 250M [2012-11-21 15:25:59.959 +00:00] Parallel Degree: 2 [2012-11-21 15:25:59.959 +00:00] Tablename.Indexname PendingCount SyncElaTime s. [2012-11-21 15:25:59.969 +00:00] AUCTION_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.971 +00:00] AUCTION_AV.AUCTION_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.972 +00:00] CATEGORY_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.972 +00:00] CATALOGCATEGORY_AV.CATEGORY_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.972 +00:00] CONFIGURATIONPARAME_CTX: synchronize... [2012-11-21 15:25:59.972 +00:00] CONFIGURATIONPARAMETER.CONFIGURATIONPARAME_CTX: finished. 0 0 [2012-11-21 15:25:59.972 +00:00] CONFIGURATION_CTX_DE_DE: synchronize... [2012-11-21 15:25:59.973 +00:00] CONFIGURATIONPARAMETER.CONFIGURATION_CTX_DE_DE: finished. 0 0 [2012-11-21 15:25:59.973 +00:00] CONFIGURATION_CTX_EN_US: synchronize... [2012-11-21 15:25:59.973 +00:00] CONFIGURATIONPARAMETER.CONFIGURATION_CTX_EN_US: finished. 0 0 [2012-11-21 15:25:59.973 +00:00] COSTCENTER_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.974 +00:00] COSTCENTER_AV.COSTCENTER_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.974 +00:00] DEPARTMENT_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.974 +00:00] DEPARTMENT_AV.DEPARTMENT_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.974 +00:00] DERIVEDPRODUCT_CTX: synchronize... [2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUCT.DERIVEDPRODUCT_CTX: finished. 0 0 [2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUC_CTX_DE_DE: synchronize... [2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUCT.DERIVEDPRODUC_CTX_DE_DE: finished. 0 0 [2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUC_CTX_EN_US: synchronize... [2012-11-21 15:25:59.975 +00:00] DERIVEDPRODUCT.DERIVEDPRODUC_CTX_EN_US: finished. 0 0 [2012-11-21 15:25:59.976 +00:00] DOMAIN_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.976 +00:00] DOMAIN_AV.DOMAIN_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.976 +00:00] ISORDER_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.976 +00:00] ISORDER_AV.ISORDER_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.976 +00:00] JOURNALENTRY_CK001: synchronize... [2012-11-21 15:25:59.977 +00:00] JOURNALENTRY.JOURNALENTRY_CK001: finished. 0 0 [2012-11-21 15:25:59.977 +00:00] MESSAGEBODY_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.977 +00:00] MESSAGEBODY_AV.MESSAGEBODY_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.977 +00:00] ORG_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.978 +00:00] ORGANIZATION_AV.ORG_AV_STR_VAL: finished. 0 .01 [2012-11-21 15:25:59.978 +00:00] PAGEENTPT_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.978 +00:00] PAGELETENTRYPOINT_AV.PAGEENTPT_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.978 +00:00] PAGELET_AV_STR_VAL: synchronize... [2012-11-21 15:25:59.979 +00:00] PAGELET_AV.PAGELET_AV_STR_VAL: finished. 0 0 [2012-11-21 15:25:59.979 +00:00] PRODUCT_CTX: synchronize... [2012-11-21 15:26:02.232 +00:00] PRODUCT.PRODUCT_CTX: finished. 2267 2.25 [2012-11-21 15:26:02.232 +00:00] PRODUCT_CTX_DE_DE: synchronize... [2012-11-21 15:26:07.829 +00:00] PRODUCT.PRODUCT_CTX_DE_DE: finished. 2267 5.6 [2012-11-21 15:26:07.829 +00:00] PRODUCT_CTX_EN_US: synchronize... [2012-11-21 15:26:13.044 +00:00] PRODUCT.PRODUCT_CTX_EN_US: finished. 2267 5.21 PL/SQL procedure successfully completed. Elapsed: 00:00:14.34
Comments	none

Product Version	7.3
Product To Version
Status	New Labels

Disclaimer

The information provided in the Knowledge Base may not be applicable to all systems and situations. Intershop Communications will not be liable to any party for any direct or indirect damages resulting from the use of the Customer Support section of the Intershop Corporate Web site, including, without limitation, any lost profits, business interruption, loss of programs or other data on your information handling system.