 | | | AW: AW: Problem synchronization after upgrade | AW: AW: Problem synchronization after upgrade 2007-06-08 - By Linos
Back
Hello,
i had exactly this parameters in dbservice user but i have deleted it
and recreated with your command to test anyway, i have the same result.
Regards,
Miguel Angel.
Auer, Wolfgang escribi?:
> 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)
|
|
|