Manage Email Signatures Centrally - For All Users

pbentley

I've just upgraded to version 4.8.9
When I log on and open Outlook I have no signatures available.
When I check the Status monitor I am listed as a failed user, the reason is stated as Invalid column name 'custom_num2'

Jesper Frier · Last edited by Jesper Frier on Tue Oct 02, 2007 4:37 pm; edited 1 time in total

Please explain how you upgraded and copy your log.

Did you copy and replace your existing Sign.exe?
Which version did you upgrade from?

Bjarne Mess · Posted: Thu Sep 13, 2007 7:30 am Post subject:

Are you the only user that failed?
_________________
</Bjarne> | Test Email Signature | Showcase |

pbentley · Posted: Thu Sep 13, 2007 10:12 am Post subject:

No - everyone who has logged on since the upgrade has failed

Jesper Frier · Posted: Thu Sep 13, 2007 10:30 am Post subject:

Please explain how you upgraded and copy one user log.

Did you copy and replace your existing Sign.exe?
Which version did you upgrade from?

pbentley · Posted: Thu Sep 13, 2007 10:44 am Post subject:

I upgraded as per the instructions on the forum (document called emailsignature) and I did copy the new version of sign.exe

When it failed the first time I noticed that the original uninstall had not removed the c:\Program Files\Office Add-on folder so I uninstalled again. renamed the office add-on folder and then reinstalled.
The problem remained the same

Which log do I need to send you (where do I find it)

I think the previous version I had was 4.2

Jesper Frier · Posted: Thu Sep 13, 2007 11:11 am Post subject: Status Monitor

You find user log in Status Monitor menu. Right click to view log file and copy/paste in your reply.

pbentley · Posted: Thu Sep 13, 2007 12:05 pm Post subject:

there was no user log listed in the status monitor menu and there was no option to view log file (maybe I was looking in the wrong place)

instead I selected the All Users view and then exported to a file

the contents of statusmonitor.txt are as follows

INITIALS MESSAGE CODE RUN_AT OUTLOOK SIG_CODE CAM_CODE RULE
ABANFI Invalid column name 'custom_num2'.. -214721790013/09/2007 09:47:00 0 00
AESPINOZA Invalid column name 'custom_num2'.. -214721790013/09/2007 09:25:00 0 00
ARICHARDS Invalid column name 'custom_num2'.. -214721790013/09/2007 12:16:00 0 00
BFERNANDEZ Invalid column name 'custom_num2'.. -214721790013/09/2007 09:38:00 0 00
CMARTINEZ Invalid column name 'custom_num2'.. -214721790013/09/2007 09:20:00 0 00
DANLANDER OK. 010/09/2007 13:48:00 11 1
FCHAMBERS Invalid column name 'custom_num2'.. -214721790013/09/2007 09:36:00 0 00
JBROCKBANK Invalid column name 'custom_num2'.. -214721790013/09/2007 12:11:00 0 00
JPILLEY Invalid column name 'custom_num2'.. -214721790013/09/2007 08:31:00 0 00
KFORDE OK. 008/09/2007 11:12:00 11 1
KISHIKAWA Invalid column name 'custom_num2'.. -214721790013/09/2007 09:46:00 0 00
KLACEY OK. 011/09/2007 08:48:00 11 3
KWHITE Invalid column name 'custom_num2'.. -214721790013/09/2007 09:20:00 0 00
KWILSON OK. 014/06/2007 17:13:00 11 1
LHUGHES OK. 010/09/2007 09:36:00 11 1
LJACKSON OK. 003/08/2007 09:24:00 11 1
MBIELFELD OK. 010/09/2007 08:52:00 11 3
MFRIGATTI OK. 010/09/2007 10:18:00 11 1
MWHITTY Invalid column name 'custom_num2'.. -214721790013/09/2007 09:43:00 0 00
MWIGNALL OK. 010/09/2007 09:41:00 11 1
NCAUSEY Invalid column name 'custom_num2'.. -214721790013/09/2007 09:30:00 0 00
PBENTLEY Invalid column name 'custom_num2'.. -214721790013/09/2007 09:07:00 0 00
PLANGTON Invalid column name 'custom_num2'.. -214721790013/09/2007 09:10:00 0 00
PSCHOENHOFER OK. 010/09/2007 09:07:00 11 1
RMOLLOY Invalid column name 'custom_num2'.. -214721790013/09/2007 08:35:00 0 00
SCHRISTIE2 OK. 010/09/2007 07:31:00 0 1
SFAY OK. 005/09/2007 17:57:00 11 1
SGOLD Invalid column name 'custom_num2'.. -214721790013/09/2007 09:50:00 0 00
SWAGNER Invalid column name 'custom_num2'.. -214721790013/09/2007 09:16:00 0 00
SWHITING Invalid column name 'custom_num2'.. -214721790013/09/2007 13:00:00 0 00
TKWILSON 3003: No record found matching the user tkwilson, 0, . 307/09/2007 17:28:00 11 1

Jesper Frier · Posted: Thu Sep 13, 2007 12:58 pm Post subject: Debug

Thanks - but it does not provide any answers to your problems :cry:

If no users are registered after runing Sign.exe (with parameter to database), then use below tool to debug client.

Show me how to debug client not visible in Status Monitor.

Bjarne Mess · Posted: Thu Sep 13, 2007 9:01 pm Post subject:

When upgrading from 4.2 it is very likely that there are database issues not solved. We take the discussion off forum and come back with the conclusion.
_________________
</Bjarne> | Test Email Signature | Showcase |

Bjarne Mess

The problem was solved by upgrading to version 4.9.0 and do these changes in the database:

Fields [custom_num1,..,custom_num5] as int NULL and custom_str1,..,custom_str5] nvarchar 100 NULL needed to be created in table lgdaUsers.

Case closed.