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