segovoni / sql-server-demos-ci-cd-pro Goto Github PK

Run docker exec -i $ENV_CONTAINER_ID /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "3uuiCaKxfbForrK" -d AdventureWorks2017 -b < ./unit-test/test-case-try-to-insert-multiple-rows-ordered.sql

(1 rows affected)
.[test try to insert multiple rows ordered] failed: (Failure) Production.usp_Raiserror_SafetyStockLevel_SpyProcedureLog is empty! usp_Raiserror_SafetyStockLevel has not been called!
 
+----------------------+
|Test Execution Summary|
+----------------------+
 
|No|Test Case Name                                                                |Dur(ms)|Result |
+--+------------------------------------------------------------------------------+-------+-------+
|1 |[UnitTestTRProductSafetyStockLevel].[test try to insert multiple rows ordered]|     28|Failure|
----------------------------------------------------------------------------------------
Msg 50000, Level 16, State 10, Server 759433bb986d, Line 1
Test Case Summary: 1 test case(s) executed, 0 succeeded, 0 skipped, 1 failed, 0 errored.
----------------------------------------------------------------------------------------
Error: Process completed with exit code 1.

Run docker exec -i $ENV_CONTAINER_ID /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "3uuiCaKxfbForrK" -Q "RESTORE DATABASE [AdventureWorks2017] FROM DISK = '/adventureworks.bak' WITH MOVE 'AdventureWorks2017' TO '/var/opt/mssql/data/AdventureWorks.mdf', MOVE 'AdventureWorks2017_log' TO '/var/opt/mssql/data/AdventureWorks_log.ldf'"
  docker exec -i $ENV_CONTAINER_ID /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "3uuiCaKxfbForrK" -Q "RESTORE DATABASE [AdventureWorks2017] FROM DISK = '/adventureworks.bak' WITH MOVE 'AdventureWorks2017' TO '/var/opt/mssql/data/AdventureWorks.mdf', MOVE 'AdventureWorks2017_log' TO '/var/opt/mssql/data/AdventureWorks_log.ldf'"
  shell: /usr/bin/bash -e {0}
  env:
    ENV_CONTAINER_ID: dd67b8f47b706d777cbf1189f249c00fcc2c4462679f34253997a26181e7a82c
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login failed for user 'SA'..
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2749.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
Error: Process completed with exit code 1.