- Posts: 110
- Thank you received: 0
Agent - Package 'Connection is busy with results for another command' when user logs on
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
9 years 9 months ago #9165
by brillsupport
Agent - Package 'Connection is busy with results for another command' when user logs on was created 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.
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.
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 110
- Thank you received: 0
9 years 9 months ago #9166
by brillsupport
Replied by brillsupport on topic Agent - Package 'Connection is busy with results for another command' when user logs on
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.
9 years 9 months ago #9167
by admin
Mike
ETL Architect
Replied by admin on topic Agent - Package 'Connection is busy with results for another command' when user logs on
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
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.
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 110
- Thank you received: 0
9 years 9 months ago #9169
by brillsupport
Replied by brillsupport on topic Agent - Package 'Connection is busy with results for another command' when user logs on
It is just one package not in parallel.
Please Log in or Create an account to join the conversation.
- brillsupport
- Topic Author
- Offline
- Premium Member
-
Less
More
- Posts: 110
- Thank you received: 0
9 years 9 months ago #9170
by brillsupport
Replied by brillsupport on topic Agent - Package 'Connection is busy with results for another command' when user logs on
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.
9 years 9 months ago #9171
by admin
Mike
ETL Architect
Replied by admin on topic Agent - Package 'Connection is busy with results for another command' when user logs on
You have to stop the agent first before installing the agent
Peter
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.