Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
mysql openssl Question
ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
Update one field with more fields from another table
Getting Identity after INSERT
ERROR 2002: Can 't connect to local MySQL server through socket
mysql test 4 1 fails with the gis test
MySQL Cluster Software
Downgrade Mysql from 4 to 3 23
Mysql 4 0 Oracle Stored Procedure Trigger Conversion
Can 't access mysql after kernel upgrade
Executing MySQL Commands From Within C Program
Comparing and writing out BLOBS
Preventing Duplicate Entries
FULLTEXT query format question
Strange behavior, Table Level Permission
Does the binary log enabling affect the MySQL performances?
mysql:it 's a db not a dbms how it 's possible?!
mysql have same function mthod as Oracle decode()
 
AW: Problem synchronization after upgrade

AW: Problem synchronization after upgrade

2007-06-07       - By Auer, Wolfgang

 Back
Reply:     1     2  

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: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: Mittwoch, 6. Juni 2007 23:51
An: maxdb@(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/maxdb?unsub=wolfgang.auer@(protected)


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=mysql@(protected)