Manage Email Signatures Centrally - For All Users

mlouie · Just can't stay away Joined: 19 Jul 2007 Posts: 50

I just upgraded from 5.0 to 5.5 and am seeing the following error on some of the users in the diagnostics screen:

No value given for one or more required parameters.

Jesper Frier · Posted: Thu Jun 25, 2009 5:46 am Post subject:

Please post log file.
_________________
</Jesper> | Test Email Signature | Showcase |

mlouie · Just can't stay away Joined: 19 Jul 2007 Posts: 50

Here is the log file. If I need to upgrade the settings db, how do I do that?

---------------- eMailSignature LOG file -------------------
- Started at 6/24/2009 3:10:03 PM
- sign.exe version 5.5.0 has been run for this user.
------------------------------------------------------------

Connection string to settings database:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\topaz\signatures$\settings.mdb
6/24/2009 3:10:03 PM Begin finding user DN
User path: LDAP://DC=transzap,DC=com
6/24/2009 3:10:03 PM End Finddistinguishedname
User: mlouie (CN=Margaret Auld-Louie,OU=IT,OU=Denver Users,DC=transzap,DC=com)
-------------- eMailSignature END LOG file -----------------
- Finalised at 6/24/2009 3:10:03 PM
------------------------------------------------------------
Status: No value given for one or more required parameters.
select vcf from lgdaUsers where [init]='MLOUIE'
-> You are running an old version of the settingsdatabase. Please upgrade it. Field 'vcf' not found in lgdaUsers.
-------------- eMailSignature END LOG file -----------------
- Finalised at 6/24/2009 3:10:03 PM
------------------------------------------------------------
Status: No value given for one or more required parameters.

Bjarne Mess · Posted: Sun Jul 12, 2009 7:21 pm Post subject:

This is faiely simple. Please create a col in the table lgdaUsers called vcf and of type ntext. Then you'll do just fine.

Cheers.

mlouie · Just can't stay away Joined: 19 Jul 2007 Posts: 50

There is no "ntext" type so I chose "text". I think it's working OK now. I used myself as a test case and it successfully deployed signatures to me.

Bjarne Mess · Posted: Tue Jul 14, 2009 10:26 am Post subject:

That is also OK. The type depends if you are using Access or SQL. It works in eiter case.