AW: Problem synchronization after upgrade

"Auer, Wolfgang" <[email protected]> Thu, 7 Jun 2007 08:59:05 +0200
Newsgroups gmane.comp.db.maxdb
Message-ID <[email protected]>
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]


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]