Hello, you should create the DBSERVICE user with this SQL: create user dbservice password secret dba not exclusive replication
The DBSERVICE user needs to be DBA and have the replication privilege. regards Wolfgang Wolfgang Auer Developer MaxDB&liveCache SAP AG mailto:[EMAIL PROTECTED] http://www.sap.com Sitz der Gesellschaft/Registered Office: Walldorf, Germany Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Léo Apotheker (stellvertretender Sprecher/Deputy CEO), Werner Brandt, Claus Heinrich, Gerhard Oswald, Peter Zencke Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: Hasso Plattner Registergericht/Commercial Register Mannheim No HRB 350269 Diese E-Mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese E-Mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe der E-Mail ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene E-Mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed, or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying, or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation. -----Ursprüngliche Nachricht----- Von: Linos [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 7. Juni 2007 17:28 An: Auer, Wolfgang Cc: [email protected] Betreff: Re: AW: Problem synchronization after upgrade Hello Wolfgang, i have lost the user dbservice in the upgrade in the two databases (dbmaster and dbclient), i had recreated the account as resource and i had the error i sent yesterday, today i have upgraded the account to dba perm (after see that in sql studio i cant create schema like resource user) and now the msgserver start, but when i try to launch syncservice i see this error: vmware:~# syncservice start -d dbmaster INFO: connecting to database "dbmaster" at "127.0.0.1" ... INFO: ... done. ------------------------------------------------------------------------------------- ----------------------------- PARAMETER CONFIGURATION (BRIEF) ----------------------- parameter name parameter value configured by ------------------------------------------------------------------------------------- transient false internal default jdbc_driver com.sap.dbtech.jdbc.DriverSapDB internal default database_host 127.0.0.1 syncmanacc database_name dbmaster syncmanacc user DBSERVICE syncmanacc password <password not shown> syncmanacc config null NOT CONFIGURED msgserver_host 127.0.0.1 internal default msgserver_port 7222 internal default units false internal default exit_timeout 0 internal default logfile null NOT CONFIGURED ------------------------- END OF PARAMETER CONFIGURATION ---------------------------- ------------------------------------------------------------------------------------- capture, consumption INFO: starting administration thread at port 7224 ... INFO: ... done. SQLException -4004: [-4004] (at 279): Unknown table name:REPLICATION_UNITS: 42000 java.lang.IllegalStateException: ConsumptionManager singleton not created. I have logged dbmaster database with dbservice user in sqlstudio and i see MESSAGESERVICE scheme, but i cant find Replication_units table. Regards, Miguel Angel. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
