Error during sql data deployment - connection already open.


Author
Message
Alan Jones
Alan Jones
StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)StrataFrame Beginner (13 reputation)
Group: StrataFrame Users
Posts: 7, Visits: 32
While trying to deploy data, we are getting a successful meta-data deployment.
However, during the data deployment phase we are erroring with the generic sql connection is already open. 

Within our code prior we are able to open and close the sql connection fine, but once it gets to the data deployment phase in the DBEngine it fails.  We have a couple of machines this works fine on, but there are a couple that just won't work.

Any thoughts as to what might be causing this? 
Trent Taylor
Trent Taylor
StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
I assume that you are deplying manually using th DatabaseMigrator class...this is the only time that I have seen this before.  But in this case, it is really simple to fix.  Just dispose of the DatabaseMigrator class and re-create it between the meta-data deployment and the data deployment and it will resolve the issue.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search