JayDee1
Member
Slow Running UBE\'s on ERP 8.0
Hello All,
We are experiencing a non-critical UBE slow-down that has puzzled me for the last several months. After upgrading to ERP 8.0 from XE, UBE's that were submitted to any of APP servers started running slightly slower than usual. One custom report in particular, however, started running a LOT slower than before. This is a product reorder report that was written in house. This report would take up to 30 minutes as opposed to only 5 minutes previously. I found out that once the report was submitted to the application server, it would just sit there for several minutes before it would start executing. I later found out that the application server was waiting to communicate with the database server. Once the app server had started to talk to the DB server, this report would actually start executing on the App server and would finish very quickly. The only solution that I have found that will fix this is to include a static IP route for the database server in each of the application servers. This fixes the latency issue. My question is why is this happening and is there a better resolution than using static IP's. The steps I have taken to fix this issue along with our configuration and setup are listed below. Thank you for your help.
Actions Performed:
Disjoined and rejoined all servers from our Domain
Checked all DNS and WINS settings
Tested various settings in JDE.INI for queues and JDENET
Reinstalled networking components on the App servers
Created new versions of the reorder report with different queue assignment
Reinstalled all JDE services on one of the two App servers
Rebuilt one of the two App servers
Hardware:
DB server: HP DL 560 Quad 3.0 GHZ Pentium Xeon, 6GB RAM
Enterprise Server: HP DL 380, Dual 3.2 GHZ Pentium Xeon
2 Application servers: HP DL 380’s, Dual 3.0 GHZ Pentium Xeon’s, 4GB of Ram for each server
Software:
DB: SQL 2000 Enterprise Edition SP3a running on Windows 2000 Advance Server
Enterprise/App servers: Windows 2000 Server SP 4.0 and Windows 2003 Server SP1(on one of the two app servers)
JDE:
ERP 8.0 SP 22
Hello All,
We are experiencing a non-critical UBE slow-down that has puzzled me for the last several months. After upgrading to ERP 8.0 from XE, UBE's that were submitted to any of APP servers started running slightly slower than usual. One custom report in particular, however, started running a LOT slower than before. This is a product reorder report that was written in house. This report would take up to 30 minutes as opposed to only 5 minutes previously. I found out that once the report was submitted to the application server, it would just sit there for several minutes before it would start executing. I later found out that the application server was waiting to communicate with the database server. Once the app server had started to talk to the DB server, this report would actually start executing on the App server and would finish very quickly. The only solution that I have found that will fix this is to include a static IP route for the database server in each of the application servers. This fixes the latency issue. My question is why is this happening and is there a better resolution than using static IP's. The steps I have taken to fix this issue along with our configuration and setup are listed below. Thank you for your help.
Actions Performed:
Disjoined and rejoined all servers from our Domain
Checked all DNS and WINS settings
Tested various settings in JDE.INI for queues and JDENET
Reinstalled networking components on the App servers
Created new versions of the reorder report with different queue assignment
Reinstalled all JDE services on one of the two App servers
Rebuilt one of the two App servers
Hardware:
DB server: HP DL 560 Quad 3.0 GHZ Pentium Xeon, 6GB RAM
Enterprise Server: HP DL 380, Dual 3.2 GHZ Pentium Xeon
2 Application servers: HP DL 380’s, Dual 3.0 GHZ Pentium Xeon’s, 4GB of Ram for each server
Software:
DB: SQL 2000 Enterprise Edition SP3a running on Windows 2000 Advance Server
Enterprise/App servers: Windows 2000 Server SP 4.0 and Windows 2003 Server SP1(on one of the two app servers)
JDE:
ERP 8.0 SP 22