DELETING FROM P48013

bwilkinson

bwilkinson

Well Known Member
We are having a problem deleting Work Orders from the P48013, From Terminal
Servers.

1) We Select the Order to Delete.
2) Next we delete the Parts List.
3) Next we delete the Routing. (Were flying up to this point)
4) Finally we delete the Work Order, at this point it takes anywhere from
10 to 30 minutes to delete.
5) Every Delete After the First One takes a little less time then the
previous one

From a Fat Client it takes less then a minute.
The TSE boxes have around 15 users on them and they sitting around 15-20 %
Usage while the delete is going on.
The Enterprise Server is also around 20% when the delete is going on.

Has anybody else had or heard of a problem like this.

-Brian

William "Brian" Wilkinson
Senior Technical Specialist
Quickie Manufacturing
[email protected]
856-829-7900 x143

JDEdwards OneWorld B7332 SP14.1
Microsoft Windows NT 4.0 Server Platform SP6a
Microsoft Windows NT 4.0 Terminal Server
Microsoft SQL Server 7.0 SP2 with hot fix 851
Microsoft Mdac 2.5
Citrix Metaframe 1.8
=========================================




William “Brian” Wilkinson
Quickie Manufacturing
[email protected]
856-829-7900 x143
 
Brain

We had a similar experience in B732.2 using the equipment maintenance
module. When we closed a work order it would take about 10 minutes to change
the WO status. We finally tracked it down to the fact that it was reading
through the F4311 table looking for open purchase orders with this wo on
them. We solved it by putting an extra index on the F4311 on subleder /
subledger type.

Don't know if this is related to your problem but it may be one area to look
at.

Regards

Regards

Marty Fleming
Business Analyst
Richmond Limited

Phone: +64 +6 8786464 Ext 8168
Fax : +64 +6 8780959
Email: mailto:[email protected]
Web Page: http://www.Richmond.co.nz/

Site Specifications
OneWorld: Xe
Database: Oracle 8i
Enterprise Server: Intel NT
Clients O/S: NT
 
Back
Top