Skip to Content
0
Former Member
Apr 23, 2009 at 06:54 PM

Missing privilege:NO TRIGGERS FOR REPLICATION USER

42 Views

Hello,

I'm configuring the Synchronization Manager following the steps on the SAP MaxDB Library 7.6. I've done every step until the activation of the Replication Units, where the Synchronization Manager GUI give me the following error:

+Create MaxDB Trigger

com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5001]: Missing privilege:NO TRIGGERS FOR REPLICATION USER

at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:65)

at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:1061)

at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:689)

at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:563)

at com.sap.dbtech.jdbc.StatementSapDB.sendCommand(StatementSapDB.java:855)

at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:919)

at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:266)

at com.sap.dbtech.jdbc.StatementSapDB.execute(StatementSapDB.java:234)

at com.sap.dbtech.jdbc.trace.Statement.execute(Statement.java:79)

at com.sap.sdb.syncMan.util.SQLBuilder.markMaxDBTableForRep(SQLBuilder.java:301)

at com.sap.sdb.syncMan.design.DesignSQLLayer.installTableOfParticipant(DesignSQLLayer.java:2427)

at com.sap.sdb.syncMan.design.DesignSQLLayer.installReplicationUnit(DesignSQLLayer.java:1493)

at com.sap.sdb.syncMan.gui.jface_controls.UnitControl.internalActivateParticipant(UnitControl.java:1165)

at com.sap.sdb.syncMan.gui.jface_controls.UnitControl.internalActivateSelectedParticipant(UnitControl.java:1067)

at com.sap.sdb.syncMan.gui.jface_controls.UnitControl.access$000(UnitControl.java:98)

at com.sap.sdb.syncMan.gui.jface_controls.UnitControl$WorkerThread.run(UnitControl.java:125)+

Question:

1. What privilege should I give to the Synchronization User? It's already a DBA user.

2. Could it be a library problem?. According to the documentation installed with the application, the Mysql connector jdbc should be used instead of the sapdbc.jar; but doing this the Synchronization Manager GUI doesn't start.

Regards!

MY