Custom label name unexpectantly reverts to default value

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

Moderator: SourceGear

Locked
dist0rti0n
Posts: 112
Joined: Mon May 01, 2006 10:50 pm
Location: Birmingham, AL

Custom label name unexpectantly reverts to default value

Post by dist0rti0n » 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.

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » 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

dist0rti0n
Posts: 112
Joined: Mon May 01, 2006 10:50 pm
Location: Birmingham, AL

Post by dist0rti0n » 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

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » 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

dist0rti0n
Posts: 112
Joined: Mon May 01, 2006 10:50 pm
Location: Birmingham, AL

Post by dist0rti0n » 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!!

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » 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

Locked