4474.1 Axapta crashes when processing huge amounts of data in project module

4474.1 Axapta crashes when processing huge amounts of data in project module

Post by Ymt1MjAwM » Wed, 27 Apr 2005 07:10:11

When creating a project invoice with more then 10000 saleslines, axapta crashes
in the method which calculates the salestotals. This method is simular as clicking on the button totals in the invoice proposal. This only happens when we create a huge number of saleslines in het invoice proposal. With small amouts it works fine.

We tested this on 2-tier and 3-tier setup.
The server is a big mother so tat should not be the problem. We are running a MSSQL 2000 DB.

Any help would be great, because not being able to invoice is a major worry for customers.


technet.navision.com Posting date: Friday, July 26, 200

technet.navision.com Posting path: Navision Axapta/Technology (Ax)/Performance

1. Processes using HUGE amount of "Private Bytes" (aka VM Size)

2. A single HTTPD process taking up huge amounts of Memory

I have a Dual Xeon server with 2 gigs of ram running Linux Red Hat 9
with Apache/1.3.33. I am the only one using the server and all of my
scripting is done with PHP 4.3. There is a 30 second time limit on all
PHP scripts.

There is an HTTPD process taking up huge amounts of RAM (usually about
1.6G) . It causes server load to increase greatly. I switched to a
Dual Xeon to handle the load, because it was crashing my P4 system
every day or two. Now the Dual Xeon can ride it out. The process
will usually come back to normal within about 5 hours.

During this period 1 of the processors in TOP is 100% occupied.
Although the there is nothing within the process list showing any
substantial usage. Even the httpd process consuming all of the memory
has a low processor usage. Maybe the processor is just busy swapping
memory or something?

I have combed through my error_log carefully and fixed every last
problem. I run "lsof -p PID" on the process and see a number of files
open, but none of them have anything in common with 1 particular
script. That makes sense since this httpd process may be serving
hundreds of different requests. I have also run "lsof -n -T -w -i
tcp:80" thinking maybe I could find an IP address associated with the
httpd process and correlate it to the access log. However the process
ID running out of control never has an IP address associated with it.

Does anyone have any recommendations how to troubleshoot this problem
further? I might need to wait a few days for the problem to come back


3. Process-1 writes data into Shared memory; It crashes; Can process-2 later read that data?

4. Copying Huge Amount - crash on .ocx .inf files

5. Huge amount of data in TreeView

6. Huge Amount of Outgoing Data

7. Importing a huge amount of data

8. huge amount of data in a control

9. Need Help On Best Querying ( is LINQ work with Huge amount of data ..)

10. Display (huge amount) data in intensity graph

11. Memory management in Common Lisp: huge copious amounts of data

12. The huge amount response data problem

13. Manage huge amount of data

14. Huge amount of data going up!

15. PC sending out huge amounts of data: help