What are the challenges you face when working across database platforms? Take the survey
Options

Can you run multiple SA projects in parallel with just 1 license?

TrulsTruls Posts: 1 New member
edited February 17, 2022 2:22PM in SmartAssembly 5
We have five Smart Assembly projects that we run in our continuous delivery pipeline. Recently we tried to speed up the pipeline by parallelizing it, so instead of running the SA projects one after another, we ran them all in parallel. This seems to work until we got random crashes in the pipeline with the following stacktrace:

SmartAssembly has encountered an error while running your project.
  Failed: SmartAssembly.InformationException: Unable to connect to the SQL database:
  'SQL logic error
  table [Builds] already exists'
 
  Connection string:
  Data Source=C:\ProgramData\Red Gate\SmartAssembly 7\SmartAssemblySQLite.db ---> System.Data.SQLite.SQLiteException: SQL logic error
  table [Builds] already exists
     at ..(Exception )
     at ..(Action`1 , )
     at ..()
     at ..(Database , String , Object[] )
     at ?..()
     at ?..()
     --- End of inner exception stack trace ---
     at ..()
     at ..(ProcessingAssemblyHelper , )
     at ..(Func`3 , Configuration , ProcessingAssemblyHelper )
     at SmartAssembly.ProcessingProjectHelper.()
  Please run SmartAssembly in User-Interface mode for more information.


Are there any limitations in Smart Assembly that can cause this exception to happen when we run the projects in parallel?

We are running SA version 7.5.2.4508  which is downloaded and installed as a nuget package.


Sign In or Register to comment.