How can we help you today? How can we help you today?
friedrich_eberharter
Activity overview Badges (0) Posts (1) Comments (2)

Comments

Sort by recent activity
Hi Dan, sorry for getting to provide this information: I just upgraded to 7.8.1.19631 (and used the version before until yesterday) on SQL Server 2022 (16.0.1000.6). And I'm also able to create this SP now! It would be kinda strange if I wasn't, because there is no graph function in the code yet. I don't know exactly what I was thinking earlier, but of course I don't need a *.sql file in the working folder if I want to create a new SP. So I started again from scratch and then it worked to commit above attached SP! So we are ready for the next step: I added a query with SHORTEST_PATH at the end of the SP. It's example G from the Microsoft documentation for this function and it's the same type of query we use in the production code. You can find the new SP attached. When I alter the SP in the database, Source Control recognizes the change correctly and I can commit it.  But at the next compare in the tab "Commit" I get the error originally described: [image] [image] Can you replicate that? Best regards, Friedrich / comments
  1. Community
  2. SQL Source Control
  3. Graph Tables not supported? Source Control only shows "error in paring the file"
Hi Dan,sorry for getting to provide this information: I just upgraded to 7.8.1.19631 (and used the version before until yesterday) on SQL Server 2022 (16.0.1000.6).And I'm also able to create this ...
0 votes
Hello Dan, thanks for the quick answer! I was probably a bit hasty with my conclusions, there may not be a lack of general support for the graph feature, but unfortunately I can't save the example code via source control either. Can you include that example code in a SP and then commit it via Source Control? Here's what I tried: I swapped all code in our SP with the setup of the example from microsoft.com - see attached file. (I attached a *.txt file - apparently *.sql is not allowed?!?) I did that both in the database and in the *.sql in my working folder. Then I linked the database to source control (Link to a working folder > Dedicated database), clicked "Commit" and checked the boxe for the new SP. While comparing for changes, I didn't saw the same error as described above, but when trying to commit I got an error at step "Sending files to source control server": Stored Procedures\dbo.InitWayPoint_graph.sql    at RedGate.Vcs.Common.Generic.GenericClient.CheckForUnacknowledgedConflicts(String workingRootPath, GenericCommitPaths paths)    at RedGate.Vcs.Common.Generic.GenericClient.<>c__DisplayClass10_0.<CommitAll>b__0()    at RedGate.Vcs.Common.Generic.GenericClient.WithFilesystemLock(Action action)    at RedGate.Vcs.Common.Generic.GenericClient.CommitAll(String commitMessage, String workingRootPath, GenericCommitPaths paths, IGenericHooks hooks, IReadOnlyGenericCallbacks callBacks, ICancellableOperationStatus status, Action`1 onCommitted)    at RedGate.Vcs.Common.Generic.GenericWorkspaceOperations.<>c__DisplayClass23_0.<ReplaceFolder>b__0()    at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)    at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithStatus(ICancellableOperationStatus status, ICancellable cancellable, Action action)    at RedGate.Vcs.Common.Generic.GenericWorkspaceOperations.WithGenericClientAndHooks(ICancellableOperationStatus status, Action action)    at RedGate.Vcs.Common.Generic.GenericWorkspaceOperations.ReplaceFolder(ICommitLogMessageProvider commitLogMessageProvider, IEnumerable`1 pathsToAdd, IEnumerable`1 pathsToDelete, ConflictAcknowledgements conflictAcknowledgements, Action`1 onCommitted, ICancellableOperationStatus status)    at RedGate.Vcs.Common.Generic.GenericPreparedCommit.<>c__DisplayClass2_0.<GetOperations>b__2(ICancellableOperationStatus s)    at RedGate.Vcs.Common.PreparedCommitBase.<>c__DisplayClass15_0.<CreateNamedOperation>b__0(ICancellableOperationStatus s)    at RedGate.SQLSourceControl.Engine.Utils.Task.NamedOperation.Operation(ICancellableOperationStatus cancellableOperation)    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperation.<Invoke>b__9_0()    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperation.Invoke()    at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithCancel(ICancellableOperationStatus status, ICancellable cancellable, Action action)    at RedGate.SQLSourceControl.Engine.Utils.Task.SharedUtilsUtils.DoActionWithStatus(ICancellableOperationStatus status, ICancellable cancellable, Action action)    at RedGate.SQLSourceControl.Engine.Utils.Task.MultiStepCancellableOperation`1.ExecuteAsOnOperation(ICancellableOperationStatus status)    at RedGate.SQLSourceControl.Engine.Utils.Task.MultiStepCancellableOperationWithPostTask`1.ExecuteAsOnOperation(ICancellableOperationStatus status)    at RedGate.Vcs.Common.PreparedCommitBase.Execute(IReadOnlyFileSet fileSet, ICancellableOperationStatus status)    at RedGate.Vcs.Common.PreparedCommitWithPreTask.Execute(IReadOnlyFileSet fileSet, ICancellableOperationStatus status)    at RedGate.SQLSourceControl.Engine.Diff.ChangeSetOperations.CommitAllOperation.Operation(ICancellableOperationStatus cancellableOperationStatus)    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperation.<Invoke>b__9_0()    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.PerformAction(Action action)    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperationBase.InvokeWithTracker(Action action)    at RedGate.SQLSourceControl.Engine.Utils.Task.CancellableOperation.Invoke()    at RedGate.SQLSourceControl.Engine.Utils.Task.MultiStepCancellableOperation`1.InvokeOperations()    at RedGate.SQLSourceControl.Engine.Utils.Task.MultiStepCancellableOperationWithPostTask`1.InvokeOperations()    at RedGate.SQLSourceControl.Engine.Utils.Task.MultiStepCancellableOperation`1.<>c__DisplayClass0_0.<.ctor>b__0()    at System.Threading.Tasks.Task`1.InnerInvoke()    at System.Threading.Tasks.Task.Execute() I also sent an error report directly from Source control, you may find more information about my problem in that ticket. Thanks in advance! And best regards, Friedrich / comments
  1. Community
  2. SQL Source Control
  3. Graph Tables not supported? Source Control only shows "error in paring the file"
Hello Dan,thanks for the quick answer!I was probably a bit hasty with my conclusions, there may not be a lack of general support for the graph feature, but unfortunately I can't save the example co...
0 votes
Total activity
4
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1