How can we help you today? How can we help you today?
dkekish

Activity overview

Latest activity by dkekish

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
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
Get around error Invalid access to memory location.
I'm suddenly getting Invalid access to memory location. when trying to commit to my local git repository.  Anyone have any ideas?
3 followers 3 comments 0 votes
SQL Format on a merge statement with multiple case statements
Looking for a way to alter the format style to correctly layout what amounts to multiple case statements in a sql merge statement,  for example:MERGE targetTable AS t    USING sourceTable AS s    O...
2 followers 2 comments 0 votes
Git and Shared model
Can we please get the ability to push to a remote repository using Git for a Shared Development Model. It works just fine in a dedicated model, but the option appears to be removed for shared.
1 follower 1 comment 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
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
Missing Git Push Option?
Hi, Just trying out the source control before we introduce it to the team, and while I can link to a local git repo cloned from a remote repository, I can't find a way to push the changes to the c...
2 followers 2 comments 0 votes