Error when try to activate Master Unit on Synchronization Manager

[Former Member]

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

[Former Member]

Hello,

did you change the database version?

In thread 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