Sales Order Entry - Performance Issue - Urgent!!!

Zaki Ahmed

Well Known Member
We are having performance issue with sales order entry application. We have two enterprise servers (Server1 for Production and Server2 for Dev).

Issue is, when we enter/change a sales order in production, it takes upto 4 minutes to update the tables (F4201 and F4211). During that time, if user does a find on that same order or take a row exit of same order, it hangs up his machine for 4-5 minutes (the time it takes to update the tables). It seems like Server1 enterprise server for production takes a whole lot time to do table updates. But in dev, it works just fine.

We have recently applied the full pkg to production, so it can't be specs issue. We have recently updated Dev with production data, so it can't be data issue as well.

I am attaching the log files and jde.ini file for Server1 and Server2 servers. Please take a look at it and let me know if you find something that needs to be fixed.

EnterpriseOne E810
Sql Server
Windows
 
Did you try to reindex some of these tables. It looks like the select statements are taking a while. Reindex F0101,F0111,F4211,F4201,F0116,F03012 and see whether this gets resolved.
 
We had serious performance problems because of a missing index on F42199 (Sales Ledger), also try reindexing F42119
 
Back
Top