Custom label name unexpectantly reverts to default value

dist0rti0n · 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.

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?

dist0rti0n · 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

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.

dist0rti0n · 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!!

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.