Datapump Freeze

Datapump Freeze

Post by Radu Colce » Sat, 20 May 2006 15:04:10

dual xeon dualcore x64 2.8
8G Ram
SAN LUN Raid 10 FC
Win 2003 Srv 64
SQL 2005 EE
Developing on the server (Dev srv).

I have 2 packages ( actually more). From Package1 I call Package2. Package 2
has in the control flow :

SQL Task(make clean) -> Dataflow Task -> SQL Task(make something)

The Dataflow Task is quite big but the "flow" is not interrupted (SORT) as
datasources I have some RAW Files and destinations Some SQL2005 Tables (no
table lock).
The package is running fast and OK.

If I run the package alone everything is working good after changing the max
thread from 5 to 12.

If I run the package from the other package some strange things happend:
the dataflow is starting after the "make clean" and after approx 2.5M
records is freezing (4M in total). The next SQL package (make something) is
starting even the dataflow is not finished. The Dataflow is never finishing.
I must stop it manually.

Freezing: 0 disk activities, 0 CPU act, some tasks in the dataflow remains
yellow or white. The max records on the buffers is set to 10000(def.) and
buff size to (10M def.)
The package is not using more than 500-600M RAM.
There are no locking issues.

Anyone have some ideeas?

Thankx in advance,

1. Linux: freeze, reboot, count to 30, freeze, reboot, count to 30, freeze, reboot...

2. PCLinuxOS slopwa "freezes with E17, freezes with KDE, freezes badly with Gnome"

"I have been playing with different DEs on PCLOS these past few weeks.
PCLOS/Xfce has been very stable on my computer. However, adding Gnome,
E17, and KDE had caused the freezing problems to appear on my computer.
The problem is really bad with Gnome and less with KDE. Once I
completely removed all DEs except for Xfce I observed no more problem.

I then decided to give Xbuntu 10.04 a try. Well, with kernel 2.6.31
Xbuntu is very stable. Any kernel after that simply does not work. We
need a good statistician to perform a multivariate analysis to figure
out this problem. Any one out there?"

#899 at

"playing with"?

Well, at least this victim knows exactly what Lunix is good for.

3. Linux crapwa it just keeps freezing, and freezing, and freezing...

4. palm zire 71 froze screen freezes frozen

5. Freezes Freezes Freezes all the time, what to do

6. Linux: freeze, reboot, count to 30, freeze, reboot, count to 30, freeze, reboot...

7. PCLinuxOS: freeze, run, freeze, run, freeze, run... never ending

8. Linux: freeze, reboot, count to 30, freeze, reboot, count to 30, freeze, reboot...

9. Get DTS datapump source columns

10. stop import datapump

11. 10g datapump

12. Datapump requrements

13. Datapump doesn't run because of LCR errors

14. Oracle DataPump

15. IIS DataPump / msolap.asp named pipe transport