Red Gate forums: SQL Source Control 3

RE: Bad performance and incorrectly included items on Get Latest

Evan Moss — Mon, 17 Jun 2013 20:51:38 GMT

Hi sognibene,

We've opened up a ticket for you and will be in contact shortly. In the meantime, you can find the log files for SQL Source control here: YOURDRIVE:\Users\YOURUSERPROFILE\AppData\Local\Red Gate\Logs\SQL Source Control 3

Thanks,
Evan

RE: Unable to connect to TFS 2010 ICredentialsProvider Error?

TimD — Mon, 17 Jun 2013 19:56:46 GMT

i followed these instructions to no avail:
http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Source_Control/KB201301000525

And then ended up changing my windows password (which may have recently expired), and the 'ICredentialsProvider is unset, therefore can't get' error went away.

RE: received the following error message any ideas?

james.billings — Mon, 17 Jun 2013 17:50:53 GMT

Thanks for your post.

I created a very trimmed down view still containing lag/lead based on your example and it seems to work OK based on a quick commit / get to a different database.

What version of SQL Source Control are you working with? Are you able to supply the relevant table definitions needed by your example view so I can come up with a full working example? (please feel free to mail these to support@red-gate.com quoting F0074030 in the subject line if so)

RE: Commit changes - timeout [3.4.4.36]

Anu Deshpande — Mon, 17 Jun 2013 15:31:09 GMT

Thanks for your post.

We are glad that it is working for you now

RE: Bug: Table disappear from the object explorer

jrohatec — Sat, 15 Jun 2013 00:09:44 GMT

Hi,

Here is the brief summary of my settings.

OS: windows 2008R2
SQL: Microsoft SQL 2008
SQL Source Control Installed: 3.4.4.36
SVN: TortoiseSVN 1.7.10

I have a batch file to deploy two different databases and both databases are linked in the shared database development mode. Here is what I have been experienced.

1. First run, there wasn't way detection after the deployment. No blue dots showing on object explorer. Only two green icons are showing for the linked databases and these databases are linked to SVN repository.

2. I tab back and forward between "Setup" and "Commit changes" under SQL Source Control. Then it finds out the pending changes on the first databases as blue dots in tables and stored procedures. Even tough my SQL batch contains the changes of the schema and data for both databases, it picked up and showed blue dots only in the first database. I was able to make the first check in into the first database. but there is no sign or blue dots on the second databases at all.

3. I reboot the server and tried to deploy from the batch file. Now, both databases are showing changes in blue dots. So, I clicked "Commit Changes" tab. Then, all the blue dots are disappeared all of suddent. Never coming back. even though I restarted SSMS or refresh.
Then, I did the same attempt to the 2nd databases to check in and those blue dots are gone again after tab to "Commit Changes".

any ideas????

RE: Commit changes - timeout [3.4.4.36]

jsreynolds1 — Fri, 14 Jun 2013 21:55:15 GMT

Allow me to post my own fix...

I log into the sql server sometimes as a user, the other times as myself (windows auth) which has full server rights.

I'm able to commit using the more restricted user. No idea why, but now I know the fix.

Commit changes - timeout [3.4.4.36]

jsreynolds1 — Fri, 14 Jun 2013 20:58:41 GMT

Hello,

Latest revision has started being problematic on our larger databases, even ones where there are only a few items selected for SVN. Using TortoiseSVN to the same archive produces no issues.

Code:

System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#DNSc(IEnumerable`1 , SqlCommand )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#gJUc(ICollection`1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.#Emb(ICollection`1 , SqlDateTime )
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.ServerParsers.DefaultTraceParser.GetAllEntries(String databaseName)
at #mlhb.#wJ4c.#jiUc(IBoundDatabase )
at #mlhb.#wJ4c.#u3.#jy2b()
at RedGate.SQLSourceControl.Engine.DatabasePolling.DatabasePolling.DatabasePollingManager.RunWithoutBackgroundPolling[T](Func`1 func)
at #mlhb.#wJ4c.#xFV(IBoundDatabase )
at #mlhb.#ny2b.#aQU(ICollection`1 #vfX, DatabaseObjectIdDictionary`1 #xfX, SourceControlOperation #oTc, ICompareDifferences #Ncsc)
at #mlhb.#RLZc.#L8c(SourceControlOperation #oTc, Boolean& #hD3c)
at #mlhb.#CJ4c.#dRi(IDifferenceSelector #xrWb, ICancellableOperationStatus #KHc, IReadOnlySourceControlServerCallBacks #VHc, ToCommitChangeSet& #Ocsc)
at #GWeb.#VXM.#mYM[#NrPb](IBoundDatabase , Func`2 , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector , Action )
at #GWeb.#VXM.#jYM(IBoundDatabase , ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#7Jc(ICancellableOperationStatus , IReadOnlySourceControlServerCallBacks , IDifferenceSelector )
at #GWeb.#4Ec.#y2.#QB7b(ICancellableOperationStatus )
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.#u3.#k5f()
at RedGate.SQLSourceControl.Engine.Cancellables.CancellableOperationBase.InvokeWithTracker(String featureUsageKey, Action action)
at RedGate.SQLSourceControl.Engine.Cancellables.MutexedCancellableOperation`1.Invoke()
at #eEc.#Qlg.Invoke()
at #JLc.#PLc.#Jfb.#EJf()
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.Do(Action , Predicate`1 , Boolean )
at RedGate.SQLSourceControl.Engine.SmartAssembly.ExceptionReporting.ErrorReporterBase.DoWithObviousExceptionsRethrowAll(Action action)
at RedGate.SQLSourceControl.CommonUI.Forms.ErrorDialog.DoWithObviousExceptionsRethrowAll(Action action)
at #JLc.#PLc.#CTc(ICancellableOperation`1 , Object )

Bug: Table disappear from the object explorer

vbogoly — Fri, 14 Jun 2013 20:34:16 GMT

After I made changes in table structure using table designer, table name disappear from the object explorer.

SQL Source Control 3.2.027
SSMS 10.50.2500

Thank you

RE: Repeatedly prompted for password when connecting to TFS

charliekilian — Fri, 14 Jun 2013 15:15:35 GMT

There were credentials stored. I cleared them, but that isn't making any difference. I'll send the newest log files, and a screenshot of the cleared credentials in Windows Credential Manager.

RE: Repeatedly prompted for password when connecting to TFS

andy.campbell.smith — Fri, 14 Jun 2013 14:57:26 GMT

Thanks for the log files - can I get you to check if Windows has any TFS credentials stored in the Windows Credential Manager? If so, can you try clearing those and see if SQL Source Control still prompts you for credentials repeatedly?

RE: Bad performance and incorrectly included items on Get Latest

sognibene — Fri, 14 Jun 2013 13:38:24 GMT

I checked the Migrations tab and there are two scripts listed. Both of them are valid. I looked through all the code in both the SQL files and there were no commands that affected any users.

I hadn't patched SQL compare in a while so I am going to restore a new copy of my database and try again. If I can reproduce the problem is there a log file I can send in that might be helpful?

received the following error message any ideas?

jl45 — Fri, 14 Jun 2013 12:28:30 GMT

only things that stands out about the file in question is that it contains 2012 specific code (LAG and lead function), no other file in the database does.

Errors occurred whilst parsing file C:\Users\jsmith3\AppData\Local\Red Gate\SQL Source Control 3\Transients\pkauocpy.d1y\FU_Catalog\Views\sales.vw_SSRS_overlapping_contracts.sql

'' at line 12, column 7

'' at line 29, column 20

'' at line 29, column 68

'' at line 34, column 38

EDIT: files uploaded here: https://www.dropbox.com/s/jqtvpn56rkpobt9/sales.vw_SSRS_overlapping_contracts.sql

RE: Bad performance and incorrectly included items on Get Latest

David Atkinson — Thu, 13 Jun 2013 22:08:24 GMT

SQL Source Control is apparently trying to pull in a "migration script" as part of the "get latest" operation. Can you visit the Migrations tab and see if there's anything there that shouldn't be? If you find something, try deleting it and trying again. However, it's a little strange that it's apparently not got a valid file name. You could try looking at the migrations folder in source control and seeing if there's anything suspect in there.

Failing this, unlink your database and relink it without setting the migrations folder and try the get latest again.

Migration scripts are used when you want to customize the behavior of SQL Compare's comparison and sychronization engine.

David Atkinson
Red Gate

RE: Repeatedly prompted for password when connecting to TFS

andy.campbell.smith — Thu, 13 Jun 2013 15:28:21 GMT

Could I get you to send in your log files? You can find those in %localappdata%\Red Gate\Logs\SQL Source Control 3\ - if you could send some recent ones to support@red-gate.com and include the ticket number F0073949 that'd be really helpful - we're trying to figure out what might be causing this and the logs would help a lot. Thanks!

Bad performance and incorrectly included items on Get Latest

sognibene — Thu, 13 Jun 2013 14:54:37 GMT

Hello,

I have SQL Source Control 3.4.2.61 running against TFS 2010 and SQL Server 2012 SP1 with the latest CU installed. My SQL Server is local on my workstation (quad core, 14GB RAM) and TFS is on the network.

I am trying to get the latest "Filter" from source control. When I select only the filter and click "Get latest", the SQL Source Control "Retrieving changes from source control" hangs and uses 100% cpu for several minutes.

I then get a "Warnings" dialog that includes among other things a High warning that a deployment script with no name ("") will be used, and then it says it will drop a user and three schemas.

Why would this happen when I am just trying to get the updated filter?

Thanks.

Severity: High
Title: Some of the changes you selected are covered by the migration script ""
This will be used to generate the deployment script.
----------------------------------------------------
Severity: Low
Object: ReportViewer
Title: Dropping a user is a potentially dangerous operation. Dependencies for the ReportViewer user are not selected automatically. If you are sure you want to drop this user please select the objects that belong to this user manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: SQLCop
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the SQLCop schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: [I removed the name here]
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the [I removed the name here] schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------
Severity: Low
Object: tSQLt
Title: Dropping a schema is a potentially dangerous operation. Dependencies for the tSQLt schema are not selected automatically. If you are sure you want to drop this schema please select the objects that belong to this schema manually.
----------------------------------------------------