Hi All. I have a user , using Data warehouse Center, who is intermittently getting the below errors:-

Data Warehouse Center Message
---------------------------------------
DWC08410E The agent was unable to execute a Data Warehouse Center program


System Message
-------------------

SQL3081N A communication error has been detected. Communication protocol being used: "*". Communication API being used: "*". Location where the error was detected: "". Communication function detecting the error: "create_agent". Protocol specific error code(s): "54","*","*". SQLSTATE=08001


The UDB version is Work Group 7.2 FP9 on a Win 2000 server.

I think this may be some kind of problem where the DWC is trying to open up a large number of agents but is hitting some kind of limit.

Any help or advice would be greatly appreciated.

Thanks
T Wadey