Build fails

[rgknp]

Thanks for this awesome repo. I forked the repo so I can set my Azure creds and try the CI Github Action.
I am able to build sqlproj locally ( using VS Code with SQL Database Project extn).
However when I run Ci action it fails in the dotnet-data-build action. Can you please suggest what am I doing wrong?

Run dotnet build src//*.sqlproj
dotnet build src//*.sqlproj
/p:NetCoreBuild=true
/p:NETCoreTargetsPath=/usr/share/azuredatastudio/resources/app/extensions/mssql/sqltoolsservice/Linux/3.0.0-release.110
/p:Configuration=Release
/p:OutputPath=$PWD/$ARTIFACTS_PATH

PACKAGE_NAME=$(find $ARTIFACTS_PATH -name '*.dacpac' -exec basename *** ;)
echo "::debug::The following package(s) have been built: $PACKAGE_NAME"
echo "::set-output name=packagename::$PACKAGE_NAME"
shell: /usr/bin/bash --noprofile --norc -e -o pipefail 0
env:
ARTIFACTS_PATH: build
PROFILE_PATH: profiles
ENVIRONMENT_PREFIX: dev
Microsoft (R) Build Engine version 17.2.0+41abc5629 for .NET
Copyright (C) Microsoft Corporation. All rights reserved.

Determining projects to restore...
Restored /home/runner/work/synapse-cicd/synapse-cicd/src/AdventureWorks/AdventureWorks.sqlproj (in 1.5 sec).
Creating a model to represent the project...
/usr/share/azuredatastudio/resources/app/extensions/mssql/sqltoolsservice/Linux/3.0.0-release.110/Microsoft.Data.Tools.Schema.SqlTasks.targets(586,5): error MSB4181: The "SqlBuildTask" task returned false but did not log an error. [/home/runner/work/synapse-cicd/synapse-cicd/src/AdventureWorks/AdventureWorks.sqlproj]

Build FAILED.

/usr/share/azuredatastudio/resources/app/extensions/mssql/sqltoolsservice/Linux/3.0.0-release.110/Microsoft.Data.Tools.Schema.SqlTasks.targets(586,5): error MSB4181: The "SqlBuildTask" task returned false but did not log an error. [/home/runner/work/synapse-cicd/synapse-cicd/src/AdventureWorks/AdventureWorks.sqlproj]
0 Warning(s)
1 Error(s)

Time Elapsed 00:00:08.87
Error: Process completed with exit code 1.

[santiagxf]

Hi @rgknp! Thanks for reporting the issue. I think the problem may be related to the fact that the repository uses dotnet core 5, which has been retired from support in favor of version 6. Let me investigate which is the best way to upgrade this project.

[rgknp]

Thanks @santiagxf for getting back. Let me know if I can contribute in anyway to get this going.