Home Dashboard Directory Help
Search

SSDT Projects Fail to Build in Parallel by jhess001


Status: 

Closed
 as Won't Fix Help for as Won't Fix


3
0
Sign in
to vote
Type: Bug
ID: 775643
Opened: 1/2/2013 3:00:31 PM
Access Restriction: Public
0
Workaround(s)
view
2
User(s) can reproduce this bug

Description

When I build two of our SSDT projects in parallel I get a failed build. If I set BuildInParallel="false" then everything is groovy.

"c:\TeamProjects\Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj" (default target) (8) ->
(SqlBuild target) ->
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(4
65,5): error MSB4018: The "SqlBuildTask" task failed unexpectedly.\r [c:\TeamProjects\Development\Main\Source\Dat
abase\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018: System.ObjectDisposedException: Store must be open for this operation.\r [c:\TeamProjects\Dev
elopment\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at System.IO.IsolatedStorage.IsolatedStorageFileStream..ctor(String path, FileMode mode, F
ileAccess access, FileShare share, Int32 bufferSize, IsolatedStorageFile isf)\r [c:\TeamProjects\Development\Main
\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.PackagingUtilities.SafeIsolatedStorageFileStream..ctor(String
path, FileMode mode, FileAccess access, FileShare share, ReliableIsolatedStorageFileFolder folder)\r [c:\TeamProj
ects\Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.PackagingUtilities.CreateUserScopedIsolatedStorageFileStreamWi
thRandomName(Int32 retryCount, String& fileName)\r [c:\TeamProjects\Development\Main\Source\Database\Source\ISMIS
\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.SparseMemoryStream.SwitchModeIfNecessary()\r [c:\TeamProjects\
Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.SparseMemoryStream.Write(Byte[] buffer, Int32 offset, Int32 co
unt)\r [c:\TeamProjects\Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.DeflateEmulationTransform.Decompress(Stream source, Stream sin
k)\r [c:\TeamProjects\Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.CompressEmulationStream..ctor(Stream baseStream, Stream tempSt
ream, Int64 position, IDeflateTransform transformer)\r [c:\TeamProjects\Development\Main\Source\Database\Source\I
SMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.CompressStream.ChangeMode(Mode newMode)\r [c:\TeamProjects\Dev
elopment\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Packaging.CompressStream.Seek(Int64 offset, SeekOrigin origin)\r [c:\Tea
mProjects\Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Zip.ProgressiveCrcCalculatingStream.Seek(Int64 offset, SeekOrigin origin
)\r [c:\TeamProjects\Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets(465
,5): error MSB4018:    at MS.Internal.IO.Zip.ZipIOModeEnforcingStream.Read(Byte[] buffer, Int32 offset, Int32 cou
nt)\r [c:\TeamProjects\Development\Main\Source\Database\Source\ISMIS\ISMIS.sqlproj]
Details
Sign in to post a comment.
Posted by Microsoft on 1/17/2013 at 10:26 AM
We understand the issue and is under consideration.
Posted by Tim Cromarty on 1/15/2013 at 2:37 PM
I am also seeing the same error:

C:\Program Files (x86)\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets (465): The "SqlBuildTask" task failed unexpectedly.
System.ObjectDisposedException: Store must be open for this operation.
at System.IO.IsolatedStorage.IsolatedStorageFileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, IsolatedStorageFile isf)
at System.IO.IsolatedStorage.IsolatedStorageFileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, IsolatedStorageFile isf)
at MS.Internal.IO.Packaging.PackagingUtilities.SafeIsolatedStorageFileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, ReliableIsolatedStorageFileFolder folder)
at MS.Internal.IO.Packaging.PackagingUtilities.CreateUserScopedIsolatedStorageFileStreamWithRandomName(Int32 retryCount, String& fileName)
at MS.Internal.IO.Packaging.SparseMemoryStream.EnsureIsolatedStoreStream()
at MS.Internal.IO.Packaging.SparseMemoryStream.SwitchModeIfNecessary()
at MS.Internal.IO.Packaging.DeflateEmulationTransform.Decompress(Stream source, Stream sink)
at MS.Internal.IO.Packaging.CompressEmulationStream..ctor(Stream baseStream, Stream tempStream, Int64 position, IDeflateTransform transformer)
at MS.Internal.IO.Packaging.CompressStream.ChangeMode(Mode newMode)
at MS.Internal.IO.Packaging.CompressStream.Seek(Int64 offset, SeekOrigin origin)
at MS.Internal.IO.Zip.ZipIOModeEnforcingStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.IO.StreamReader.ReadBuffer(Char[] userBuffer, Int32 userOffset, Int32 desiredChars, Boolean& readToUserBuffer)
at System.IO.StreamReader.Read(Char[] buffer, Int32 index, Int32 count)
at System.Xml.XmlTextReaderImpl.ReadData()
at System.Xml.XmlTextReaderImpl..ctor(String url, TextReader input, XmlNameTable nt)
at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.CreateXmlReader(TextReader input)
at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.LoadExternals(TextReader input, String fileName, String logicalSourceName, IList`1 externalPartsSubstitution, Boolean suppressErrorsForMissingDependencies)
at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.AddReference(CustomSchemaData customData)
at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlSchemaModel.OnCustomDataAdded(CustomSchemaData customData)
at Microsoft.Data.Tools.Schema.SchemaModel.DataSchemaModel.AddCustomData(CustomSchemaData customData, Boolean raiseEvents)
at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlModelBuilder.Add(CustomSchemaData customSchemaData)
at Microsoft.Data.Tools.Schema.SchemaModel.ModelBuilder.AddOrUpdate(CustomSchemaData customSchemaData)
at Microsoft.Data.Tools.Schema.Sql.Build.SqlTaskHost.AddOrUpdate(CustomSchemaData customSchemaData)
at Microsoft.Data.Tools.Schema.Tasks.Sql.TaskHostLoader.ProcessReferences(TaskLoggingHelper providedLogger, SqlTaskHost host, ErrorManager errors)
at Microsoft.Data.Tools.Schema.Tasks.Sql.TaskHostLoader.LoadImpl(ITaskHost providedHost, TaskLoggingHelper providedLogger, Boolean runAllBuildTimeValidationRules)
at Microsoft.Data.Tools.Schema.Tasks.Sql.TaskHostLoader.Load(ITaskHost providedHost, TaskLoggingHelper providedLogger, Boolean runAllBuildTimeValidationRules)
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteLoadTaskHostStep()
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteStep(Func`1 step)
at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.Execute()
at Microsoft.Build.BackEnd.TaskExecutionHost.Microsoft.Build.BackEnd.ITaskExecutionHost.Execute()
at Microsoft.Build.BackEnd.TaskBuilder.<ExecuteInstantiatedTask>d__20.MoveNext()
Posted by jhess001 on 1/3/2013 at 5:10 PM
The project that I get this error on has a database reference to a dacpac too.
Posted by olegmkr on 1/3/2013 at 2:08 PM
Hi,

I have similar problem. I create two simple projects with one shared database reference to \\XXX\Shr.dacpac. If I build in parallel I gave this error too, If I build first and after second - ok.
Sign in to post a workaround.