 | | | WG: AW: Problem synchronization after upgrade | WG: AW: Problem synchronization after upgrade 2007-06-08 - By Auer, Wolfgang
Back
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:wolfgang.auer@(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:info@(protected)]
Gesendet: Donnerstag, 7. Juni 2007 17:28
An: Auer, Wolfgang
Cc: maxdb@(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/maxdb?unsub=mysql@(protected)
|
|
|