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. Auer, Wolfgang escribió: > Hello Linos, > > > Can you logon with SQL Studio and see if the DBSERVICE user has a schema > MESSAGESERVICE. > If not it seems that the schema was lost during the upgrade. > > The SyncMan should create the schema MESSAGESERVICE when the MessageHub is > started. > Can you do it manually with CREATE SCHEMA MESSAGESERVICE and check if some > error occurs? > > 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: Mittwoch, 6. Juni 2007 23:51 > An: maxdb@lists.mysql.com > Betreff: Problem synchronization after upgrade > > Hello, > after upgrading my databases creating a kernel path for every one i > have this error when i launch the msgserver, what can be happening? > Thanks in advance. > > > vmware:~# msgserver start > [starting Wed Jun 06 22:41:12 GMT+01:00 2007] Starting server > [starting Wed Jun 06 22:41:12 GMT+01:00 2007] Starting service > com.sap.sdb.msgServer.service.AdminService on port 7220 > [starting Wed Jun 06 22:41:13 GMT+01:00 2007] persistent database.... : > jdbc:sapdb://127.0.0.1/DBMASTER?timeout=0 > [starting Wed Jun 06 22:41:13 GMT+01:00 2007] persistent JDBC driver : > SAP DB package com.sap.dbtech.jdbc, MaxDB JDBC Driver, SAP AG, 7.6.03 > Build 002-000-006-742 (Make-Version: unknown) > [starting Wed Jun 06 22:41:13 GMT+01:00 2007] persistent database user: > "DBSERVICE" > [starting Wed Jun 06 22:41:13 GMT+01:00 2007] transient database.... : > jdbc:transientStorage:// > [starting Wed Jun 06 22:41:13 GMT+01:00 2007] transient JDBC driver : > TransientStorage JDBC Driver, > com.sap.sdb.msgServer.transientStorage.DriverImpl 1.1.04 > creating persistent tables ... > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 15): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 15): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 16): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 16): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 16): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 16): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 16): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 16): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 16): > Unknown schema:MESSAGESERVICE > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 14): > Unknown table name:MSGSERVER_TABLES_VERSION > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 60): > Unknown table name > > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4030] (at 18): > Unknown schema:MESSAGESERVICE > > ... tables created. > [starting Wed Jun 06 22:41:13 GMT+01:00 2007] Message cache: 16000 KB > com.sap.sdb.msgServer.service.ServiceException: Service <MsgServer>: > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 33): > Unknown table name:MSGSERVER_TABLES_VERSION > at > com.sap.sdb.msgServer.service.JmsService.open(JmsService.java:343) > at com.sap.sdb.msgServer.Server.addService(Server.java:429) > at com.sap.sdb.msgServer.Server.<init>(Server.java:314) > at com.sap.sdb.msgServer.Server.main(Server.java:126) > com.sap.sdb.msgServer.service.ServiceException: Service <MsgServer>: > com.sap.dbtech.jdbc.exceptions.DatabaseException: [-4004] (at 33): > Unknown table name:MSGSERVER_TABLES_VERSION > > > > Regards, > Miguel Angel. > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]