All Forums Tools
super25 19 posts Joined 07/11
18 Jun 2012
RDBMS error 2633 Too many load/unload task running

I am getting this error when i try to run a fastload job specifying just 1 session in the script. I know there is a limitation of 30 load jobs on the applicance and so when i checked on viewpoint i found that there are 4 "TPTEXP" jobs running and found more than 300 active sessions o nthe system at that point. This still does not make sense for me with regards to the error because TPTEXport should limitation of 60 though.

THe 4 TTPEXP jobs which i am mentioning here are triggerd through SSIS pacakge (attunity adapter) which would export data from Teradata to SQL Server.

feinholz 1234 posts Joined 05/08
21 Jun 2012

I am not sure what you are asking for here.

The number of load/unload tasks has nothing to do with the number of sessions being used by each job.

Each TPTEXP job will utilize one load/unload task slot.

Each FastLoad job will utilize one load/unload task slot.

If you know for certain that your limitation on your appliance is set to 30, and you get a 2633, then that means you have 30 load/unload jobs running on the system.



You must sign in to leave a comment.