Skip to main content

CSC Indexing - ORA-00001: unique constraint (CORE.SRCH_ORDER_TOKENS_P) violated


When you get that constraint violation error it means indexing jobs on CSC are stepping on each other or even themselves, if you happen to have a schedule without catch up and even running too often then you'll be seeing a lot errors lik this:

ERROR [nucleusNamespace.atg.textsearch.indexing.job.IndexingJob] (pool-103-thread-1) ORA-00001: unique constraint (DRESS_CORE.SRCH_ORDER_TOKENS_P) violated

And eventually you'll get an error like this:

ERROR [nucleusNamespace.atg.dynamo.messaging.SqlJmsProvider] (ServerService Thread Pool -- 102) null: java.sql.SQLExc
eption: javax.resource.ResourceException: IJ000451: The connection manager is shutdown: java:/ATGAgentDS

So just update the schedule for the indexing components:

/atg/commerce/textsearch/schedule/OrderIncrementalScheduleConfig
schedule=calendar * * * * * 0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46,48,50,52,54,56,58

/atg/userprofiling/textsearch/schedule/ProfileIncrementalScheduleConfig/
schedule=calendar * * * * * 1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43,45,47,49,51,53,55,57,59

Explanation from Oracle can be found in here, it affects ATG 11.1:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=284080926304738&id=1930422.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=hfbbbr18i_34#SYMPTOM
Labels:

Comments

Post a Comment

Popular posts from this blog

Fix broken sequence on parent-child relationship tables for PUB schema

Whenever you find an error like this (for category-product relationship for example) ERROR [nucleusNamespace.atg.commerce.catalog.ProductCatalog-ver]  Error reading list or array index from the database. Expected: "0", got "1". The following property was not read: " {fixedChildProducts,pType=List,IDesc=[ItemDesc: category],table=dcs_cat_chldprd,cols=child_prd_id   ,pBI=atg.beans.MergedDynamicBeanInfo@5409e0ad,pIDesc=null   ,cType=interface atg.repository.RepositoryItem,cBI=[ItemDesc: product],cIDesc=[ItemDesc: product],colHandle=null}", for item id: "2350:36". This means the data base table holding this property does not have sequential integers starting with 0 in its multi-column. This should only happen if the database table was modifie d directly (outside of Dynamo).: java.lang.Exception It means sequence_num column doesn't contain a consecutive sequence number for the category on all of its products, this is, if category has
2 comments
Read more

BCC Project Details With SQL Queries

Troubleshooting BCC projects can sometimes be a little tedious if you have to deal with the UI (someone mentioned flash?) while sifting through project assets, sometimes you just want to check if an asset exists on a given project, in what project was an asset updated, the history of a project, etc. etc. While BCC does a good job at presenting such data, sometimes it can get stuck depending on the number of assets it has or even the system resources. Feel free to use the following queries to soothe your pain a little bit:.
1 comment
Read more

Configure LDAP SSO for BCC and Endeca Workbench

If you want to setup your BCC with a SSO server along with LDAP validation you can follow the next steps, this is all for OOTB configs: LDAP In Memory Server Feel free to clone and build:  https://github.com/kwart/ldap-server Then you can start it with:  java -jar ldap-server.jar -b 127.0.0.1 -p 10389 ldap_test.ldif Lastly, you can validate connectivity with this command:  ldapsearch -h localhost -p 10389 -x -D "uid=admin,ou=system" -w secret Just make sure that you defined user and organization appropriately. CIM Setup SSO Run <ATG_ROOT>/home/bin/cim.sh Select options as follows: Platform-Guided Search Integration [8] Content Administration Choose Commerce AddOns: [4] Single Sign On (SSO) [D] Done [1] Commerce Only SSO Authentication [1] LDAP Server Authentication [1] Non-Switching Datasource Don't include demo application [2] Index by Product [A] Select Application Server [2] Weblogic Enter Weblogic home path: /your/weblogic/wlserver/path Enter domain path: /your/
Post a Comment
Read more