# Part Search "Where Part Description Contains" field not working?

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2017-01-24 18:17 UTC
**Views:** 1451
**Replies:** 5
**URL:** https://www.epiusers.help/t/part-search-where-part-description-contains-field-not-working/37000

---

## Post #1 by @Aaron_Moreng

Hi all,
In our TEST environment, which we just upgraded to 10.1.500.11, the Part Search "Where Part Description Contains" field works as intended. In our LIVE environment, version 10.1.400.11, I get the following error message when attempting to use that field. 

<img src="/uploads/default/original/2X/2/262814b13cac2875f73d194a8b44c8cec8f15f34.png" width="384" height="180">

I looked on the SQL server for both to find indexes on Erp.Part and in both instances, it looks like they are identical. 

Not being a SQL guy, is there any harm in rebuilding the index? If not, do I do this by right clicking on the index and clicking Rebuild All? We are on SQL Server 2008 R2. 

<img src="/uploads/default/original/2X/c/c8431161923b4cc410d62573e8b451ae868bf175.png" width="556" height="486">

---

## Post #2 by @markdamen

You’re looking at the Table index.  Check here for Full Text Catalog:

[cid:image001.png@01D27677.CE980220]

Regards
Mark


Mark Damen
ERP System Manager

[cid:BVDairy-OfficialLogo_bbec4553-4e4a-43e7-baef-7ba65e64810211111111.png]

MarkDamen@bvdairy.co.uk
Mobile: +44 (0) 7790 806926

BV Dairy ι Wincombe Lane ι SHAFTESBURY ι Dorset ι SP7 8QD ι UK
Switchboard: +44 (0) 1747 851855
Fax: +44 (0) 1747 851002



<http://www.bvdairy.co.uk/>



















[cid:AllAccresiationsSmaller_b479dd40-feb0-4971-b164-424e34ca64c4.jpg]


This message is intended for the use of only the person(s) ("Intended Recipient") to whom it is addressed. It may contain information that is privileged and confidential. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. If you are not the Intended Recipient, please contact the sender as soon as possible.

<img src='/uploads/default/original/2X/4/44b62370ab0d151943a681e62f413e3b3c11ebdc.png' width='207' height='434'>



<img src='/uploads/default/original/2X/0/0ec64b12313f7363d181e0a3178e9c431490a7b8.png' width='194' height='68'>



<img src='/uploads/default/original/1X/3eee66342cd163f15f1c372f9136b09e1f04d36e.jpg' width='177' height='94'>

---

## Post #3 by @Aaron_Moreng

Thank you, Mark.
This is interesting because it works in our Epicor10Test environment but not our Epicor10Live one. Here are the two compared to eachother. Neither seems to have the Full Text Catalogs like yours does.

<img src="/uploads/default/original/2X/d/d315d6205ba8c9b227a4fc39a2d2c2eaa2967777.png" width="258" height="487">

---

## Post #4 by @ewidjaja

Hi Aaron, did you figure out the issue/solution for this? 
I am also currently having issues with "Where Part Description Contains" field. It gives us a server side error but not the same message. 

Thanks!
Elvin

---

## Post #5 by @Aaron_Moreng

Well not sure. we’ve long since upgraded and I haven’t encountered it. What version are you on? 10.1 kinda sucks compared to 10.2

---

## Post #6 by @ewidjaja

We are on 10.2.. It is now actually fixed. We moved databases and turns out the new database did not have "Full Text Search" included during the install. So we just ran the install module, added feature and picked the full text indexing, rebuilt all the indexes and now it works!

---


**Canonical:** https://www.epiusers.help/t/part-search-where-part-description-contains-field-not-working/37000
**Original content:** https://www.epiusers.help/t/part-search-where-part-description-contains-field-not-working/37000