Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

SQL(already a open data reader associated) error when trying to create advertisement item

Created: 17 Apr 2012 | 2 comments

Hi all,

I am using Altiris ASDK (vbs).

I am trying to create an advertisement item so that my package can be advertised and i can see the status of the task. But i am getting following error when i try calling createAdvertisementEX( ) method.

"   Altiris.NS.Exception.AeXException - Unable to create the advertisement item -> System.InvalidOperationException: There is already an open DataReader associated with this command and must be closed first  "

Restarting SQL service succeeded only once but afterwards, restarting the computer or SQL server nothing helped.

Would really appreciate any help and suggestions,


Comments 2 CommentsJump to latest comment

umibau's picture

Hi everyone

just an update for others who happen to read the post.

I couldn't find any solution to solve the problem, actually there are couple of suggestions if you google but nothing worked for me. so i reinstalled the SQL database and configured it to work with Altiris console. As a result the error was gone.

best regards


ShenoyS's picture

I see the same issue, and breaking my heads to get it resolved. This would save a lots of effort here if we can automate the process of creating advertisement. Any experts out there to help us??