Skip to content

Error MSB4018: System.NullReferenceException for an OpenJson operation #420

New issue
New issue
Closed
Closed
Error MSB4018: System.NullReferenceException for an OpenJson operation#420
Assignees
llali
Labels
bugSomething isn't workingfixed-pending-releaseFix in upcoming release
Milestone
162.3
@madjar4-cssmb

Description

@madjar4-cssmb
madjar4-cssmb
opened on Mar 6, 2024
  • SqlPackage or DacFx Version: 162.2.111.2
  • .NET Framework (Windows-only) or .NET Core: 8.0.101
  • Environment (local platform and source/target platforms): Windows

Steps to Reproduce:

  1. Create a new Sql Project with Azure Data Studio. SqlProj used:
<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build">
  <Sdk Name="Microsoft.Build.Sql" Version="0.1.15-preview" />
  <PropertyGroup>
    <Name>OpenJsonTest</Name>
    <ProjectGuid>{2A961354-6F37-4615-A1B0-2BDACBC71F34}</ProjectGuid>
    <DSP>Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider</DSP>
    <ModelCollation>1033, CI</ModelCollation>
  </PropertyGroup>
  <Target Name="BeforeBuild">
    <Delete Files="$(BaseIntermediateOutputPath)\project.assets.json" />
  </Target>
</Project>
  1. Create a stored procedure in dbo/StoredProcedures.
  2. Use the following parameters and body for the stored procedure:
CREATE PROCEDURE [dbo].[TestSP]
  @someJson Nvarchar(max)
AS
  DECLARE @someId INT = (
    SELECT Query.SomeId FROM
    (
      SELECT * FROM OPENJSON(@someJson)
      WITH( 
        ArrayItems nvarchar(max) '$.SomeArray' as json
        )
      CROSS APPLY OPENJSON(ArrayItems)
      WITH(				
        SomeId INT 'strict $.IdOfSorts'
        ,NoOfThings INT 'strict $.NoOfThings'				
      ) Je				
      WHERE Je.NoOfThings = 0
    )Query	
  )
RETURN 0
  1. Build either with the Azure Data Studio or with dotnet build (with or without /p:NetCoreBuild=true).
  2. Result: the build fails with the following output (sorry for the partial french in the output).
	[ Build ]
    > "C:\\Program Files\\dotnet\\dotnet.exe"  build "c:\\SomePath\\OpenJsonTest\\OpenJsonTest.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\\Users\\USER\\.azuredatastudio\\extensions\\microsoft.sql-database-projects-1.4.2\\BuildDirectory"
    stdout: Version MSBuild 17.8.3+195e7f5a3 pour .NET
    stdout: 
    stdout:   Identification des projets à restaurer...
    stdout: 
    stdout:   Tous les projets sont à jour pour la restauration.
    stdout: 
    stdout:   Creating a model to represent the project...
    stdout: 
    stdout:   Loading project references...
    stdout: 
    stdout:   Loading project files...
    stdout: 
    stdout: C:\REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.15-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(544,5): warning : Exception has been thrown by the target of an invocation. [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: 
    stdout: C:\REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.15-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(544,5): error MSB4181: la tâche "SqlBuildTask" a retourné false mais n'a pas journalisé d'erreur. [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: 
    stdout: 
    stdout: 
    stdout: ÉCHEC de la build.
    stdout: 
    stdout: C:\REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.15-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(544,5): warning : Exception has been thrown by the target of an invocation. [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: C:\REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.15-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(544,5): error MSB4181: la tâche "SqlBuildTask" a retourné false mais n'a pas journalisé d'erreur. [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout:     1 Avertissement(s)
    stdout:     1 Erreur(s)
    stdout: 
    stdout: 
    stdout: Temps écoulé 00:00:01.31
    stdout: 
    >>> "C:\\Program Files\\dotnet\\dotnet.exe"  build "c:\\SomePath\\OpenJsonTest\\OpenJsonTest.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\\Users\\USER\\.azuredatastudio\\extensions\\microsoft.sql-database-projects-1.4.2\\BuildDirectory"    … exited with code: 1
	>>> "C:\\Program Files\\dotnet\\dotnet.exe"  build "c:\\SomePath\\OpenJsonTest\\OpenJsonTest.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\\Users\\USER\\.azuredatastudio\\extensions\\microsoft.sql-database-projects-1.4.2\\BuildDirectory"   … errored out: Process exited with code 1

Did this occur in prior versions? If not - which version(s) did it work in?
Yes, in the following verions:

0.1.13-preview

The error is much more comprhensive:

	[ Build ]
    > "C:\\Program Files\\dotnet\\dotnet.exe"  build "c:\\SomePath\\OpenJsonTest\\OpenJsonTest.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\\Users\\USER\\.azuredatastudio\\extensions\\microsoft.sql-database-projects-1.4.2\\BuildDirectory"
    stdout: Version MSBuild 17.8.3+195e7f5a3 pour .NET
    stdout: 
    stdout:   Identification des projets à restaurer...
    stdout: 
    stdout:   Restauration effectuée de c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj (en 152 ms).
    stdout: 
    stdout:   Creating a model to represent the project...
    stdout: 
    stdout:   Loading project references...
    stdout: 
    stdout:   Loading project files...
    stdout: 
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: Échec inattendu de la tâche "SqlBuildTask". [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018: System.NullReferenceException->Microsoft.Build.Framework.BuildException.GenericBuildTransferredException: Object reference not set to an instance of an object. [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlElementDescriptor.GetHashCode(SqlElementDescriptor obj) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlPotentialElementDescriptor.GetHashCode(SqlPotentialElementDescriptor obj) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlPotentialElementDescriptorComparer.GetHashCode(SqlPotentialElementDescriptor obj) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at System.Collections.Generic.HashSet`1.AddIfNotPresent(T value, Int32& location) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at System.Collections.Generic.HashSet`1.Add(T item) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlAmbiguousRelationshipRecyclerKey.CreateSqlAmbiguousRelationshipRecyclerKeyInstance(IModelElement modelElement, ModelRelationshipClass relationshipClass, IList`1 descriptors, IEnumerable`1 annotationDescriptors, ModelCollationComparer comparer, ModelSchema modelSchema) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlModelBuilderSchemaAnalyzer.IdentifiedAmbiguousRelationship(TSqlFragment fragment, SqlElementDescriptor leftHandSide, ModelRelationshipClass relationshipClass, IEnumerable`1 ambigousRightHandSide, IEnumerable`1 annotationDescriptors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.DecoratableSchemaAnalyzer.IdentifiedAmbiguousRelationship(TSqlFragment fragment, SqlElementDescriptor leftHandSide, ModelRelationshipClass relationshipClass, IEnumerable`1 ambigousRightHandSide, IEnumerable`1 annotations) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SchemaAnalyzers.DependencyTracker.VisitAmbiguousFragment(TSqlFragment fragment, IEnumerable`1 possibilities) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SqlInterpretationVisitor.VisitResolvedDescriptor(SqlSchemaAnalyzer analyzer, ResolvedDescriptor descriptor, Boolean createRelationship) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SqlInterpretationVisitor.VisitResolvedDescriptor(ResolvedDescriptor descriptor, Boolean createRelationship) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SelectColumnInterpretationVisitor90.HandleSelectColumnColumn(SelectElement node, String alias, IList`1 identifiers, ColumnType columnType) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SelectColumnInterpretationVisitor90.ExplicitVisit(SelectStarExpression node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.SelectStarExpression.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlInterpretationUtils.InterpretSelectColumn(SelectElement node, SqlSchemaAnalyzer analyzer, SqlInterpretationContext context, SqlColumnResolver columnResolver, Boolean enabledDeleted, Boolean enableInserted, List`1 errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlInterpretationUtils.InterpretSelectColumn(SelectElement node, SqlSchemaAnalyzer analyzer, SqlInterpretationContext context, SqlColumnResolver columnResolver, List`1 errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QuerySpecificationInterpretationVisitor90.ExplicitVisit(SelectStarExpression node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.SelectStarExpression.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QuerySpecificationInterpretationVisitor90.ExplicitVisit(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QuerySpecificationInterpretationVisitor110.ExplicitVisit(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QueryExpressionInterpretationVisitor.InterpretQuery(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QueryExpressionInterpretationVisitor.ExplicitVisit(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.QueryDerivedTable.AcceptChildren(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(QueryDerivedTable node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.QueryDerivedTable.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.TableSourceInterpretationVisitor90.ExplicitVisit(QueryDerivedTable node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.QueryDerivedTable.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlInterpretationUtils.InterpretTableSource(TableReference node, SqlSchemaAnalyzer analyzer, SqlInterpretationContext context, SqlColumnResolver columnResolver, List`1 errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlInterpretationUtils.InterpretFromClause(FromClause fromClause, SqlSchemaAnalyzer analyzer, SqlInterpretationContext context, SqlColumnResolver columnResolver, List`1 errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QuerySpecificationInterpretationVisitor90.ExplicitVisit(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QuerySpecificationInterpretationVisitor110.ExplicitVisit(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QueryExpressionInterpretationVisitor.InterpretQuery(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QueryExpressionInterpretationVisitor.ExplicitVisit(QuerySpecification node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.QuerySpecification.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.QueryExpressionInterpretationVisitor.ExplicitVisit(ScalarSubquery node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.ScalarSubquery.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.DmlCommonPhrasesInterpretationVisitor90.ExplicitVisit(ScalarSubquery node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.ScalarSubquery.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlInterpretationUtils.InterpretDmlCommonPhrase(TSqlFragment node, SqlSchemaAnalyzer analyzer, SqlInterpretationContext context, SqlColumnResolver columnResolver, List`1 errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlInterpretationUtils.InterpretDmlCommonPhrase(TSqlFragment node, SqlSchemaAnalyzer analyzer, SqlInterpretationContext context, List`1 errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.DynamicTableInterpretationVisitor.Visit(DeclareVariableElement node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(DeclareVariableElement node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.DeclareVariableElement.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.DeclareVariableStatement.AcceptChildren(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.DynamicTableInterpretationVisitor.ExplicitVisit(DeclareVariableStatement node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.DeclareVariableStatement.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.DynamicTableInterpretationVisitor.Process(TSqlFragment node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.DynamicTableInterpretationVisitor.Process(TSqlFragment node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SubroutineInterpretationVisitor.ExplicitVisit(StatementList node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.StatementList.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.CreateProcedureStatement.AcceptChildren(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragmentVisitor.ExplicitVisit(CreateProcedureStatement node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.ProcedureStatementInterpretationVisitor.ExplicitVisit(CreateProcedureStatement node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.CreateProcedureStatement.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SqlInterpretationVisitor.InterpretWithoutBeginEndDdl(TSqlFragment node, SqlInterpretationVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SqlInterpretationVisitor.InterpretDdlWithNewVisitor(TSqlFragment node, SqlInterpretationVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.InterpretationVisitors.SqlInterpretationVisitor90.ExplicitVisit(CreateProcedureStatement node) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.SqlServer.TransactSql.ScriptDom.CreateProcedureStatement.Accept(TSqlFragmentVisitor visitor) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.Sql150Interpreter.InterpretImpl(TSqlFragment fragment, SqlSchemaAnalyzer analyzer, IList`1& errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlInterpreter.Interpret(TSqlStatement statement, SqlSchemaAnalyzer analyzer, IList`1& errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlModelBuilder.InterpretTSqlScript(String filename, TSqlScript script, NecessaryOptions parsedMetadata, IList`1 parseErrors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlModelBuilder.ParseAndInterpret(String filename, TextReader objectsSource, IDictionary`2 metadata) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlModelBuilder.AddObjects(String cacheIdentifier, TextReader script, IDictionary`2 metadata) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.SchemaModel.ModelBuilder.AddOrUpdateObjects(ScriptHandle script) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.Build.ModelBuilderJob.BatchLoadOrUpdate(ModelBuilder mb, IList`1 scripts, Int32 index, Int32 count, List`1& processedCacheIds, Exception& handledEx) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Sql.Build.SqlTaskHost.Add(IList`1 sourceScripts) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Tasks.Sql.TaskHostLoader.LoadSourceFiles(TaskLoggingHelper providedLogger, SqlTaskHost host, ErrorManager errors) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Tasks.Sql.TaskHostLoader.LoadImpl(ITaskHost providedHost, TaskLoggingHelper providedLogger) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Tasks.Sql.TaskHostLoader.Load(ITaskHost providedHost, TaskLoggingHelper providedLogger) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteLoadTaskHostStep() [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteStep(Func`1 step) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Tasks.Sql.SqlBuildTask.ExecuteTask() [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Data.Tools.Schema.Tasks.Sql.DataTask.Execute() [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout: REPLACED_USER_PATH\.nuget\packages\microsoft.build.sql\0.1.12-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(542,5): error MSB4018:    at Microsoft.Build.CommandLine.OutOfProcTaskAppDomainWrapperBase.InstantiateAndExecuteTask(IBuildEngine oopTaskHostNode, LoadedType taskType, String taskName, String taskLocation, String taskFile, Int32 taskLine, Int32 taskColumn, IDictionary`2 taskParams) [c:\SomePath\OpenJsonTest\OpenJsonTest.sqlproj]
    stdout:     0 Avertissement(s)
    stdout:     1 Erreur(s)
    stdout: 
    stdout: 
    stdout: Temps écoulé 00:00:01.33
    stdout: 
    >>> "C:\\Program Files\\dotnet\\dotnet.exe"  build "c:\\SomePath\\OpenJsonTest\\OpenJsonTest.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\\Users\\USER\\.azuredatastudio\\extensions\\microsoft.sql-database-projects-1.4.2\\BuildDirectory"    … exited with code: 1
	>>> "C:\\Program Files\\dotnet\\dotnet.exe"  build "c:\\SomePath\\OpenJsonTest\\OpenJsonTest.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\\Users\\USER\\.azuredatastudio\\extensions\\microsoft.sql-database-projects-1.4.2\\BuildDirectory"   … errored out: Process exited with code 1

Note for the behavior with Visual Studio 2022 and classic sqlproj

Don't know if this will help, but before trying the package reference approach documented above, I was importing the data base with SSDT in Visual Studio 2022. Pretty much the same behavior was happening. Visual Studio was opened, got a NullReferenceException, restarted and went back to the error. A nice loop.

(Azure Data Studio)

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingfixed-pending-releaseFix in upcoming release

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions