How can we help you today? How can we help you today?
dkekish
Activity overview Badges (0) Posts (4) Comments (3)

Comments

Sort by recent activity
I see some messages in the log like this 2023-04-26 06:28:02.391 -04:00|Warning|RedGate.SQLSourceControl.Engine.CompareEngineImpl.CompareLogger|106| Synchronization Warning High::One of the fields [Oracle].[ColumnData].[TSQL_StageColumnInfo] and [Oracle].[ColumnData].[TSQL_StageColumnInfo] are computed - computed columns cannot be compared when one of the data sources is a scripts folder.. 2023-04-26 06:54:05.963 -04:00|Warning|RedGate.SQLSourceControl.Engine.Diff.ObjectExplorerState.DatabaseObjectCollection|20| Object [DatabaseObjectId: Name=pr_RebuildTableScripts, Owner=dbo, ObjectType=Stored Procedure] was in state "New" has changed by "New", that doesn't make sense 2023-04-26 09:30:34.509 -04:00|Warning|RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy|100| An exception occurred whilst building from a parent; this exception has been given to SSMS for it to handle System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)    at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)    at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)    at System.Data.SqlClient.SqlDataReader.Read()    at Microsoft.SqlServer.Management.Smo.DataProvider.ReadInternal()    at Microsoft.SqlServer.Management.Smo.DataProvider.Read()    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Read(Object[]& values)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(IList`1 targetList, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)    at RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy.Build(IList`1 nodes, INodeInformation source, INavigableItem parent, IFilterProvider filter) ClientConnectionId:980a1e6e-890e-4da9-8c91-ab32a23db622 Error Number:1222,State:51,Class:16 2023-04-26 10:01:26.843 -04:00|Warning|RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy|10| An exception occurred whilst building from a parent; this exception has been given to SSMS for it to handle System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)    at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)    at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)    at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)    at System.Data.SqlClient.SqlDataReader.Read()    at Microsoft.SqlServer.Management.Smo.DataProvider.ReadInternal()    at Microsoft.SqlServer.Management.Smo.DataProvider.Read()    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Read(Object[]& values)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)    at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(IList`1 targetList, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)    at RedGate.SQLSourceControl.Ssms.Shared.QueryProviderProxy.Build(IList`1 nodes, INodeInformation source, INavigableItem parent, IFilterProvider filter) ClientConnectionId:fbe567c5-fa62-4a84-83f1-e9a11c60b079 Error Number:1222,State:51,Class:16 2023-04-26 10:23:39.940 -04:00|Warning|RedGate.SQLSourceControl.Engine.CompareEngineImpl.CompareLogger|133| AddDependencyStack: failed to resolve dependency from [Oracle].[ColumnData] The dependency error at the bottom is a long list of dependency issues, all about 1 ms apart. The next time I tried to use the plugin, it was all good again, is this possibly an issue on the server that was just not expected? / comments
  1. Community
  2. SQL Source Control
  3. Get around error Invalid access to memory location.
I see some messages in the log like this2023-04-26 06:28:02.391 -04:00|Warning|RedGate.SQLSourceControl.Engine.CompareEngineImpl.CompareLogger|106| Synchronization Warning High::One of the fields [...
0 votes
its worse if you have multiple case statements, then you end up with CASE                 WHEN s.COL1= '' THEN                     NULL                 ELSE                     s.Col1             END, CASE                      WHEN s.Col2= '' THEN                          NULL                      ELSE                          s.Col2                  END, CASE                           WHEN s.Col3 = '' THEN                               NULL                           ELSE                               s.Col3                       END / comments
  1. Community
  2. SQL Prompt
  3. SQL Format on a merge statement with multiple case statements
its worse if you have multiple case statements, then you end up withCASE                WHEN s.COL1= '' THEN                    NULL                ELSE                    s.Col1            END, CA...
0 votes
I solved it actually, turns out you need an origin/master branch in the remote repository before you can push to it. Once you have that, you can push/pull with no issues. Hope that helps someone else -Dave / comments
  1. Community
  2. SQL Source Control Previous Versions
  3. Missing Git Push Option?
I solved it actually, turns out you need an origin/master branch in the remote repository before you can push to it. Once you have that, you can push/pull with no issues. Hope that helps someone...
0 votes
Total activity
10
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
3