Re: AW: Problem synchronization after upgrade
Linos <[email protected]> Thu, 07 Jun 2007 17:27:54 +0200
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] > 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]