a sp has 300+rows, returns Error SQL72045: Script execution error.
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 20/100
Research direction
Start with the supplied CREATE PROCEDURE [integration].[AutoMerge] script and the sqlpackage failure output. Reproduce the deployment using the SQL script and capture the complete procedure and environment details; done means identifying a minimal reproducible cause for SQL72045 and documenting or validating the resulting fix.
Written by the indexing model from the issue text.
Description
Error SQL72045: Script execution error. The executed script:
CREATE PROCEDURE [integration].[AutoMerge]
@Source NVARCHAR (255), @Target NVARCHAR (255), @UsingIndex NVARCHAR (255)=NULL, @Mode INT=1, @IncludeColumns NVARCHAR (MAX)=NULL, @ExcludeColumns NVARCHAR (MAX)=NULL, @SkipMissingSourceColumns BIT=0, @TruncateSourceAfterMerge BIT=0, @Debug BIT=0
AS
BEGIN
SET NOCOUNT ON;
SET XACT_ABORT ON;
DECLARE @NewLine AS NCHAR (1) = char(13);
DECLARE @Identation AS NVARCHAR (32) = '';
DECLARE @SourceSchema AS sysname = isnull(parsename(@Source, 2), schema_name()), @SourceTable AS sysname = parsename(@Source, 1), @TargetSchema AS sysname = isnull(parsename(@Target, 2), schema_name()), @TargetTable AS sysname = parsename(@Target, 1), @IndexId AS INT;
DECLARE @Columns TABLE (
ColId INT ,
ColumnName sysname ,
TypeName sysname ,
Bytes SMALLINT);
DECLARE @MatchColumns AS TABLE (
ColId INT ,
ColumnName sysname);
DECLARE @SourceColumns TABLE (
ColumnName sysname);
DECLARE
Time elapsed 0:00:57.34
Error: The process 'sqlpackage' failed with exit code 1
- Dominant language
- TypeScript
- Stars
- 142
- Forks
- 73
- Avg merge
- 9d 18h
- Merged PRs (30d)
- 2
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Azure/sql-action
-
need-to-triage
Difficulty 1/5 Under an hour Newbie friendliness 62/100
Azure/sql-action#247 ·
-
need-to-triage
Difficulty 3/5 1-2 days Newbie friendliness 65/100
Azure/sql-action#282 ·
-
bug
Azure/sql-action#267 · 1 assignee ·
-
need-to-triage
Difficulty 3/5 1-2 days Newbie friendliness 45/100
Azure/sql-action#262 · 1 comment ·
-
need-to-triage
Difficulty 3/5 1-2 days Newbie friendliness 35/100
Azure/sql-action#261 ·
All issues in Azure/sql-action
Similar issues
-
VerificationGate: ATTRIBUTION quote guard never matches a normal quotation (\b around the quote) Open
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
danielmiessler/LifeOS#2234 ·
-
T: Bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
-
Difficulty 1/5 Under an hour Newbie friendliness 85/100
-
Mend: dependency security vulnerability untriaged
Difficulty 2/5 1-3 hours Newbie friendliness 70/100