Red Gate forums :: View topic - Changed by "Unknown" when using Changelog
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

Changed by "Unknown" when using Changelog

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
aj131x



Joined: 10 May 2013
Posts: 1

PostPosted: Fri May 10, 2013 12:16 pm    Post subject: Changed by "Unknown" when using Changelog Reply with quote

We are using SSC v3.3.1 in shared developer mode with SVN and have the changelog db set up to track who changed what.

But even though the RG_AllObjects table contains an entry for a modification to an object (table) and the correct username indicating who modified it, the "commit changes" tab shows the object as changed by "unknown".

It would appear that until we commit this object, whatever further changes we do to this object will not cause the "unknown" to be replaced with a username.

What we are finding is that many of our uncommited changes eventually end up with "unknown" against them as further modifications are made to the original object in areas that SSC does not currently support in change logging.

For example, a straight table creation will initially correctly show the user who created the table but a subsequent addition of a default constraint will cause the username to be replaced by unknown in the commit changes window (although the username will remain in the changelog table). All further table schema changes will not alter this situation until after the object is commited to our source control system (svn).

Could you explain this behaviour and specifically why when the username is corrrectly stored in the change log db, it is not appearing in the commit changes window? Thanks.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 921
Location: Red Gate Software

PostPosted: Tue May 14, 2013 4:08 pm    Post subject: Reply with quote

Hi

Thank you for your forum post. I have created a support call for you, call reference is F0072780. From your post and I quote:
Quote:

For example, a straight table creation will initially correctly show the user who created the table but a subsequent addition of a default constraint will cause the username to be replaced by unknown in the commit changes window (although the username will remain in the changelog table). All further table schema changes will not alter this situation until after the object is commited to our source control system (svn).

It looks simple enough to generate a reproduction, I will update this post when I have completed my investigation or require further information from you.

If you have any further information that you think maybe useful to me, please update this forum topic.
Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
eddie davis



Joined: 14 Jun 2006
Posts: 921
Location: Red Gate Software

PostPosted: Wed May 15, 2013 3:32 pm    Post subject: Reply with quote

Using V3.4.0.103 of SQL Source Control I am unable to reproduce the error you have reported.

I simply created a table and committed the change. My account name appears in the Changed by column.

Altered the table I just created and added a Primary Key Constraint. When through the process to commit the change and again by account name is listed in the Changed By column.

So I can try to reproduce the error, can you please send an e-mail to Support@red-gate.com with your call reference number F0072780 in the subject field of the e-mail. Please include the table script and alteration that you made, the contents of your RedGate_SQLSourceControl_Engine_EngineOptions.xml and any screen shots you can produce showing the fault symptoms.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
instalectual



Joined: 04 Sep 2013
Posts: 10
Location: United States

PostPosted: Wed Sep 04, 2013 7:51 pm    Post subject: Reply with quote

I'm not sure if this was ever resolved but I am able to reproduce this issue using SQL Source Control 3.4.9.265.

I have created my own DB for tracking changes and modified the appropriate xml config file. The changes are being logged correctly and everything works for the most part except for a similar condition as the OP.

I created a new stored procedure and the change appears on the commit tab with my username and is in change log. I did not commit the change and made a subsequent modification to the new procedure. This change also appears in the change log with my username but after refreshing the commit tab now shows changed by as 'Unknown' in grey text. I was able to reproduce this behavior with several procs.

-Daniel
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group