Agent - Package 'Connection is busy with results for another command' when user logs on

More
9 years 9 months ago #9165 by brillsupport
We are running Advanced ETL Processor Ent 5.7.6.11 on Windows Server 2003 SP2 and are running in to a bit of an issue. I can register an agent and get it to run a package from the schedule, but when a user logs on the package records an error. It shows as running in the monitor, but no longer continues creating files.

The exection log shows

Error 12/9/2013 10:02:42 AM Change of H Queue Status failed
Error 12/9/2013 10:02:42 AM Connection is busy with results for another command

I looked around and found others with similar issues where you mentioned to use nocount on. Could this be the problem or is it linked to me logging in?

Not sure if it's relevant, but I receive a warning in Application Log stating:

"CN=<username>,OU=Users,OU=<company>,DC=ad,DC=<company>,DC=com from a different forest logged onto this machine. Cross Forest Group Policy processing is disabled and loopback processing has been enforced in this forest for this user account."

Where i replaced some of the names with variables.

When I log on I can check agent status and the heart beat bill update. The monitor shows the package still executing which is an issue as it won't start the package again.

Please Log in or Create an account to join the conversation.

More
9 years 9 months ago #9166 by brillsupport
I should also mention, this issue does not happen when I stay logged in and run it manually from the package screen (not using the agent.)

Please Log in or Create an account to join the conversation.

More
9 years 9 months ago #9167 by admin
Are you running tasks in parallel?

One of our customers had simular issues and I believe we have resolved the issue in the latest release

www.etl-tools.com/forum/visual-importer/...onitor-actions-panel

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 9 months ago #9169 by brillsupport

Please Log in or Create an account to join the conversation.

More
9 years 9 months ago #9170 by brillsupport
I could try the updated version, but I would rather not since it will require a restart on a server that is used for other uses.

Please Log in or Create an account to join the conversation.

More
9 years 9 months ago #9171 by admin
You have to stop the agent first before installing the agent

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.