Re: AW: AW: Problem synchronization after upgrade

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:[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]