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]
