web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Inventory closing / cancellation Performance

(0) ShareShare
ReportReport
Posted on by 30


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)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans