Skip to Content
avatar image
Former Member

Error when try to activate Master Unit on Synchronization Manager

Hello,

I have the following error that appears when I try to activate a Master Unit on the Synchronization Manager:

com.sap.dbtech.jdbc.exceptions.DatabaseException: [-3007]: Invalid sequence of DML and DDL statements

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:308)

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)

The documentation doesn't give much information about the error "-3007: Invalid sequence of DML and DDL statements", it says to repeat the QUERY and FETCH statement. I don't really know what to do, since I'm activating the Unit from the Synchronization Manager GUI.

What could be the problem?

Regards,

Miguel

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 12, 2009 at 03:41 PM

    Hello,

    did you change the database version?

    In thread No replication of data it seems that you already succeeded with replication.

    I would recomment you upgrade the SyncMan and the MaxDB server to the newest 7.6 version.

    Did you use the DBSERVICE user for the SyncManGUI?

    Best Regards

    Wolfgang

    Edited by: Wolfgang Auer on Jun 12, 2009 5:42 PM

    Add comment
    10|10000 characters needed characters exceeded