Manage Email Signatures centrally from your Desktop - For All Users

lgladki · Posted: Mon Mar 29, 2010 1:33 pm Post subject: Method '~' of object '~' failed

Hi, everything was working fine till today suddenly signatures stopped working on 2 accounts. Both users are showing the same error message in log:

---------------- eMailSignature LOG file -------------------
- Started at 26/03/2010 08:56:58
- sign.exe version 7.0.4 has been run for this user.
------------------------------------------------------------

Connection string to settings database:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\tsnas03\share\emailSigsV2\settings.mdb
User: kansarah (kansarah)
26/03/2010 08:57:01 License Key valid for version 7.0. Standard Edition licensed. License issued to Draycir for 25 users.

------------------- Signatures to deploy: -------------------
Default signature: Draycir Standard
Reply/forward signature: Standard reply
Signatures to deploy: Draycir Standard,Standard reply
Deployment ID: 1

Deployment type: Default signatures for all apply.
-------------------------------------------------------------
Office version 2007 detected.
There will be deployed 2 signatures.
All existing signatures have been deleted

-> Signature Draycir Standard in htm format (26/03/2010 08:57:02)
Number of parameters in signature: 6
Data will be read from Active Directory
3001: , -2147016646, Method '~' of object '~' failed

-> Signature Standard reply in htm format (26/03/2010 08:57:04)
Number of parameters in signature: 6
Data will be read from Active Directory
3001: , -2147016646, Method '~' of object '~' failed
-------------- eMailSignature END LOG file -----------------
- Finalised at 26/03/2010 08:57:05
------------------------------------------------------------
Status: 3001: , -2147016646, Method '~' of object '~' failed
-------------- eMailSignature END LOG file -----------------
- Finalised at 26/03/2010 08:57:05
------------------------------------------------------------
Status: 3001: , -2147016646, Method '~' of object '~' failed

I have no idea what is wrong, can you help?

Jesper Frier

Either users are no longer logged on to your domain - Or users have corrupt MDAC windows component.

Try and ask users to logon on another PC which is OK in your Status Monitor?
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

lgladki · Posted: Thu Apr 08, 2010 3:11 pm Post subject:

Thanks for reply,

I've logged into different machine, still doesn't work...

Jesper Frier

Please ZIP your database (\\tsnas03\share\emailSigsV2\settings.mdb) and forward to support (support@brandedmails.com).

Then we'll get back to you.
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

Jesper Frier

Settings DB repaired in MS Access and returned.

If your DB gets corrupted frequently, then consider using MS SQL Express or MS SQL Server database.

OK now?

Idea

Click Compact and Restore Settings Database and you are able to quickly restore OK database without accessing Access:

_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

lgladki · Posted: Fri Apr 09, 2010 10:39 am Post subject:

Im afraid not, but now the error is different. Actually it looks like everything is OK in status monitor, but when I want to check my logs I can only see ################. In the Last Run column it shows 06/07/2009.

All other accounts seem to run fine. I guess Im the only unlucky one, all software seem to not like me lately Sad

Jesper Frier · Posted: Fri Apr 09, 2010 11:50 am Post subject:

Please try and run Sign.exe locally and see if this updates your Status Monitor:

Cockpit > Setup > Test in Outlook

Do you see anything in your Log File and is date/time updated?
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

lgladki · Posted: Fri Apr 09, 2010 12:10 pm Post subject:

I run sign.exe from software, using "test in Outlook" command and manually both on my machine and in shared folder but still no change and the date still shows 06/07/2009

Jesper Frier · Posted: Fri Apr 09, 2010 1:21 pm Post subject:

Please check permissions on the net share holding settings.mdb (\\tsnas03\share\emailSigsV2\settings.mdb):

>>> Read/Write/Update for all users accessing the database.
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

lgladki · Posted: Fri Apr 09, 2010 1:28 pm Post subject:

all users have correct permissions

lgladki · Posted: Fri Apr 09, 2010 2:02 pm Post subject:

a quick update, apparently all accounts are being excluded from signature update. Its like sign.exe is not doing anything.

Jesper Frier · Posted: Fri Apr 09, 2010 4:33 pm Post subject:

We don't know if the problem is permissions or missing execution of Sign.exe during logon.

Please copy your database to a local folder on your PC.
Then connect to it in your Cockpit and run sign.exe (again within your Cockpit).

This should definitely update your Status Monitor. Then we take it from there ...
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

lgladki · Posted: Mon Apr 12, 2010 9:11 am Post subject:

While connecting the database locally I've run "check settings database consistency" with following results:
Cheking table campaign - OK
Cheking table categories - OK
Cheking table disclaimer - OK
Cheking table general - OK
Cheking table License - OK
Cheking table livemessage - OK
Cheking table lgdaCampaignGroups - OK
Cheking table lgdaDefault - OK
Cheking table lgdaGroups - OK
Cheking table lgdaNoUsers - OK
Cheking table lgdaUsers - No value given for one or more required parameters.
Cheking table licenseGroups - OK
Cheking table OWA - OK
Cheking table pictures - OK
Cheking table Preview - ERROR: Please check this table for required columns/existence
Cheking table rootcontext - OK
Cheking table settings - OK
Cheking table stationery - OK
Cheking table lgdaCollect - OK
Cheking table lgdaOWA - ERROR: Please check table 'lgdaOWA' for required columns/existence
Cheking table settingsLegal - ERROR: Please check table 'settingsLegal' for required columns/existence
Cheking table users - ERROR: Please check table 'users' for required columns/existence

Are you sure you sent me the corrected file? Confused

I run the sign.exe anyway, but it didn't update the log.

Jesper Frier · Posted: Mon Apr 12, 2010 11:03 am Post subject:

My mistake ... I assumed you upgraded your database to version 7.

Your database is not upgraded to version 7.
All tables must be OK after upgrading as shown in video in link below.

How to upgrade from version 5.
_________________
</Jesper> | Manage Email Signatures from your Desktop | Test Email Signature in All In-boxes | Email Signature Showcase

lgladki · Posted: Tue Apr 13, 2010 10:14 am Post subject:

I've updated database and after activating it with ver7 key it gets back to giving me the "Method '~' of object '~' failed" error.

I used raw settings.mdb file that comes in the package and got the same results.

Sign.exe is 7.0.0.4