My problems
    1) : I can't reindex database and found errors like "[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "DBO.TMPLEDGERCONSTRANS" because it does not exist or you do not have permissions. "Cannot drop index 'I_505RECID' because it enforces the full-text key for table or indexed view 'VENDTABLE'." 
    2) Inventory closing process take a long time, I want to increases performance.  (I think ..if reindexing successful maybe it's reduces time used)
I founds  KB2835615 that resolve my reindex problem and Try closing inventory ...performance it's increase about 600% (used time decrease from 12 Hrs. to 2 Hrs.)
but when I cancel last inventory closing it take a long time more than before I installed "KB2835615" and reindex success  (both batch processing and UI form)
    - In case Batch It's founds a lot lock processes
    - UI form used a long time more than 2 Hrs (Normally used 10~20 mins)
and i try KB2980874 but not work
Thank you.
Panuwat Jungjitdamrong
*This post is locked for comments
I have the same question (0) 
		

 Report
Report All responses (
 All responses ( Answers (
 Answers (