The Exclaimer Community

Have installed the trial version and all is working fine and dandy to the Exchange Mailstore but nothing being transferred across to SQL 2005 Express Edition database.

Error received during wizard setup:

Mailbox: Exclaimer Email Archiver Service

Current Operation: Initializing Database...

Status: Terminal Error (Archiver Stopped)

Further Information:

There was an error initializing the database (Error executing SQL statement

------------------------------------------------------------------------------------------------------------------------------

 

 

/*

4. Create new FT fields for FTRecips, FTAttachments and Internetheaders in the MessagesTable

=============================================================================================

*/

------------------------------------------------------------------------------------------------------------------------------

declare @mycursor cursor;

declare @retVal integer

exec sp_help_fulltext_columns_cursor @mycursor output, '[dbo].[Messages]', 'InternetHeaders'

fetch next from @mycursor;

set @retVal = @@fetch_status

if @retVal = -1

begin

exec sp_fulltext_column N'[dbo].[Messages]', N'InternetHeaders', N'add', 0 end close @mycursor deallocate @mycursor

COM Error: 0x80004005 - Unspecified error Unspecified error SQL Error #80004005 Unspecified error

Source: Microsoft OLE DB Provider for SQL Server SQL State:

Native Error: 0

 

during Upgrade to schema 1028 for Exclaimer Email Archive1). Please correct the problem and restart the Exclaimer Email Archiver Service.

Has anyone encountered this issue or know of a fix?

Tried to connect to a SQL 2000 Server instance with the following error:

Mailbox: Exclaimer Email Archiver Service

Current Operation: Initializing Database...

Status: Terminal Error (Archiver Stopped)

Further Information:

There was an error initializing the database (Error executing SQL statement Connect to Database COM Error: 0x80040E4D - IDispatch error #3149 Login failed for user 'QUANTICA\ExArc{189bdf72}'.

SQL Error #80040e4d

Login failed for user 'QUANTICA\ExArc{189bdf72}'.

Source: Microsoft OLE DB Provider for SQL Server SQL State: 42000 Native Error: 18456

 

). Please correct the problem and restart the Exclaimer Email Archiver Service.

Has anyone got any idea how to get around this one?

Regards

Brian Perks

 

Hi Brian,

 

This is a Text index issue. Please restart the services on teh database server and attempt to re-create the databases, or failing that the server itself needs to be restarted.

The issue is that the Full text indexing does not seem to be registered correctly.

 

REgards

RIchard

---

Richard Rae
Exclaimer Support

I'm getting this same error message while attempting to install Archiver (eval). The Exchange server is running SBS 2000, and the DB/Web server is SQL 2000 under Windows 2003.

Looking at the database/tables after the install fails, the full-text index of the Messages table has been correctly made. I've re-applied .NET 2.0, MDAC 2.80, restarted all the services and re-created *and* restarted the server and re-created and I'm still hitting this same "80004005" road-block.

It's annoying as I much prefer Mail Utilities to the previous software we were using (GFI Mail Essentials), and not only because it'll be much cheaper in our environment.

End of the error (it's only the same SQL query as above before):-

COM Error: 0x80004005 - Unspecified error Unspecified error SQL Error #80004005 Unspecified error
Source: Microsoft OLE DB Provider for SQL Server SQL State:
Native Error: 0


 during Upgrade to schema 1028 for Exclaimer Email Archive). Please correct the problem and restart the Exclaimer Email Archiver Service.

EDIT: And I forgot to mention in my original post, when we ran the query (as above) in Query Analyzer (on the server), it completed without issue.

Hi,

I love unspecified errors from SQL. They make troubleshooting so nice!!!

Anyhow the error code is access denied. Can you ensure that the server is set to mix or Windows authentication?

CAn you also check that the Exclaimer archive accounts are registered in the Security context of the database? This is under the security folder.

Regards

Richard

---

Richard Rae
Exclaimer Support

Richard,

Thanks for the response.

Server is set to mixed authentication, and Archiver is using the "sa" account for the connection. I'll try again using Windows Auth just in case.

Looking at Exclaimer specific things in System Manager\Security; there are three "accounts" - the two groups and a single user. All three have "master" as their default database. The two groups have "public" DB Access and no specific Server Access roles, the user has "DBO" on the two Exclaimer tables and "Database Creators" on the Server.

Anything else specific I should set/unset in MSSQL? (And more news when I have it...)

EDIT: No difference running the setup process with Windows Auth over SQL Auth. In further "news", I've attempted the database side of things to three other servers now (all MSSQL 2000, two Windows 2000, the final Windows 2003) and all with exactly the same result - the DB bit fails at what appears to be step 4.:

Mailbox: Exclaimer Email Archiver Service
Current Operation: Initializing Database...
Status: Terminal Error (Archiver Stopped)
Further Information:
There was an error initializing the database (Error executing SQL statement
------------------------------------------------------------------------------------------------------------------------------

/*
	4.	Create new FT fields for FTRecips, FTAttachments and Internetheaders in the MessagesTable
	=============================================================================================
*/
------------------------------------------------------------------------------------------------------------------------------
declare @mycursor cursor;
declare @retVal integer
exec sp_help_fulltext_columns_cursor @mycursor output, '[dbo].[Messages]', 'InternetHeaders'
fetch next from @mycursor;
set @retVal = @@fetch_status
if @retVal = -1
begin
	exec sp_fulltext_column N'[dbo].[Messages]', N'InternetHeaders', N'add', 0 end close @mycursor deallocate @mycursor
COM Error: 0x80004005 - Unspecified error Unspecified error SQL Error #80004005 Unspecified error
Source: Microsoft OLE DB Provider for SQL Server SQL State: 
Native Error: 0

 during Upgrade to schema 1028 for Exclaimer Email Archive). Please correct the problem and restart the Exclaimer Email Archiver Service.

Hi,

looking closer at the script it seems that the fulltext index is not set on the database server. Can you browse through to the database and find the catalogue then rebuild it?

If it gives you an error saying that the service is not available (very likely) then just create a second catalogue and that will kick the first one into life (strange yes I know!!)

Regards

Richard

---

Richard Rae
Exclaimer Support

Well, I've rebuilt the catalogue without error (I added a second catalogue after any way, just in case).

Only problem I have now is that when I start up the Archiver service, status tells there is a stored procedure missing - usp_InsertMessage.

Is there any way to "manually" complete the MS SQL setup? It feels like we're close to fixing this issue for me and I'd really like to see the rest of the archiver in action before my now 25 days of evaluation runs out ;)

Hahahaha... Answering your own queries is what forums are for...

I was "digging around" in the Archiver installation folder when I came across SQLGen.exe - thanks to it's excellent in-line help I figured out pretty quickly how to run it myself, generated the "CREATE" script, then manually ran that (from point 4.) in a series of chunks in Query Analyzer. Short story even shorter, Archiver is passing mail into the DB without issue now (500 in a little over 5 minutes I've been typing this response).

Now to check the webness works... :-) Thanks for all the help Richard.
 

heheh that was going to be my next action.

---

Richard Rae
Exclaimer Support

Hi Richard,

 

One of my customer have such problem and have the same error like below ;

There was an error (Error executing SQL statement
usp_InsertMessage
COM Error: 0x80040E14 - IDispatch error #3092 Could not find server 'EXADSI' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
SQL Error #80040e14
Could not find server 'EXADSI' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Source: Microsoft OLE DB Provider for SQL Server
SQL S

He created a second catalogue but still have the same error. What do you offer ?  

Hi

Please follow the steps in the fourth post of this forum thread:

http://forums.exclaimer.com/forums/thread/1220.aspx

Best Regards

Joshua Clarke

Exclaimer Support

---

Joshua Clarke
Exclaimer Support