Custom label name unexpectantly reverts to default value

If you are having a problem using Dragnet, post a message here.

Moderator: SourceGear


Posts: 112
Joined: Mon May 01, 2006 10:50 pm
Location: Birmingham, AL
PostPosted: Sat Sep 23, 2006 10:14 am
I've tried changing a custom label in the Database setup screen to a different value. Here's the sql that is exectuted when I hit "update" in dragnet:

Code: Select all
exec spmodifycustomlabel @customid = -1, @label = N'Actual Time', @authuid = 1, @usewithexternalsubmission = 0, @requiredfield = 0


I notice that after my session expires and I log back into dragnet, the value fo the custom label will be set back to the default. Is this a bug or a feature that is disabled until you purcahse licenses of the product?

I was evaluating dragnet for use within our company and would just like to clarify whats going on with this feature.

Thanks.

Posts: 3558
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
PostPosted: Mon Sep 25, 2006 8:35 am
Can you run the following query:
Code: Select all
SELECT * FROM sgdragnet.dbo.customlabels
Do the label values match your changes?

If so, can you restart the Dragnet Web Service - you can do this by "touching" Dragnet's web.config?
Jeff Clausius
SourceGear

Posts: 112
Joined: Mon May 01, 2006 10:50 pm
Location: Birmingham, AL
PostPosted: Mon Sep 25, 2006 9:34 pm
This is the results of the query:

label usewithexternalsubmission requiredfield customid
-------------------------------------------------------------------------------------------------------------------------------- ------------------------- ------------- -----------

(0 row(s) affected)


However, when I viewed the website the custom field labels were still intact.

I recycled the application pool for the web and refreshed the site. The custom labels had returned to their default values.

if i manually insert a record in the custom labels table and recycle the web, then the custom fields will show up on the site.

The results of the query after I do this are:

label usewithexternalsubmission requiredfield customid
-------------------------------------------------------------------------------------------------------------------------------- ------------------------- ------------- -----------
Actual Time 0 0 1

(1 row(s) affected)

Please let me know if there are any other tests I can run.

Thanks

Posts: 3558
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
PostPosted: Tue Sep 26, 2006 8:38 am
Did someone delete these rows directly from the database?

In any case, we'll need to put them back:

Code: Select all
USE sgdragnet
GO

SET IDENTITY_INSERT dbo.customlabels ON

-- default labels for custom column headers Custom1 and Custom2
INSERT INTO dbo.customlabels (label,customid) VALUES ('Custom 1', 1)
INSERT INTO dbo.customlabels (label,customid) VALUES ('Custom 2', 2)
GO

SET IDENTITY_INSERT dbo.customlabels OFF


After the rows are in the database, recycle the Dragnet Web app, and try again.
Jeff Clausius
SourceGear

Posts: 112
Joined: Mon May 01, 2006 10:50 pm
Location: Birmingham, AL
PostPosted: Tue Sep 26, 2006 9:05 pm
That fixed it.

I ran the script, cycled the web, the updated one of the custom fields.

After that, I cycled the app pool one more time and the change to the custom field still stuck.

I never truncated the custom labels table. Perhaps an installation script accidentally deleted them at some point?

Thanks for your help!!

Posts: 3558
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
PostPosted: Wed Sep 27, 2006 7:37 am
I just checked, there's nothing in the scripts that DELETES from customlabels.

If you didn't delete the rows, then you may want to run a consistency check on the database DBCC CHECKDB('sgdragnet') to make sure the database is in working order.
Jeff Clausius
SourceGear

Return to Support (Dragnet)

Who is online

Users browsing this forum: No registered users and 2 guests

cron