cancel
Showing results for 
Search instead for 
Did you mean: 

Replication Exec service initialization failed. The database could not be initialized.

agricus
Level 2
I search the forum and connot find anything related to this issue.
 
I have Replication Exec 3.1 SP1 HotFix 7 on all the servers that does replication
 
The RSA on my RMS server failed to start since last week, it had work previously.  The error I am getting is
 
In Application Log
Event: ID 1030
Source:  Replication Exec RSA
Description: Replication Exec service initialization failed. : Initialization failed. : The database could not be initialized.
 
In System Log
Event ID 7024
Source: Service Control Manager
Description: The Replication Service Agent service terminated with service-specific error 8201 (0x2009).
 
RSA trace log:
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Starting...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Allocated a valid ODBC environment, about to initialize ODBC/SQL states...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: About to make the first connection (with retry logic)...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Made the the first connection, testing...
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS] RMSDB::RMSDB: Failed to get a valid Connection object!
Thu Dec 06 08:50:00 2007-0x00000fe8 [DBMS]  -103: 28000: [Sybase][ODBC Driver][Adaptive Server Anywhere]Invalid user authorization specification: Invalid user ID or password
Thu Dec 06 08:50:01 2007-0x00000fe8 [DBMS] RmsStoreInit: About to validate the RMSDB instance...
Thu Dec 06 08:50:01 2007-0x00000fe8 [DBMS] RmsStoreInit: Failed to get a valid RSA database instance! Wrong ODBC version?
Thu Dec 06 08:50:01 2007-0x00000fe8 [JCD] JcdDeinitialize
 
I have tried remove the rsa.db  rsa.log and do a repair installation and also remove the ODBC connection for RSA and have the repair installation recreated.  I tested the RSA connection in the DataSource and it tested succesfuly.
 
 
Has anyone encounter this issue before?
 
Your help is appreciated.
2 REPLIES 2

MKnoll
Level 3
Have you tried to fix the databases?
 
From a command prompt try "rxdbvalidate -vf RMS" once it runs do "rxdbvalidate -vf RSA"

agricus
Level 2
I appreciate the reply,
 
I tried both command both give me ***SQL error: Invalid user ID or password
rxdbvalidate: Error unloading 'C:\Program Files\Veritas\Replication Exec\Database\rsa.db': General Failure
 
I got this type of error on both RSA and RSM.  I deleted the RSA db and the ODBC connection and do a repair error still exist.
 
 
I appreciate any input