we are trying to migrate old olite mobile server to new DMS by using JavaDB. got exceptions when use pure java sync as following:
it appears to me one internal meta table failed to create which is called "OSE$ITR001"."OSE$TABLES" which ITR001 was the mobile user.
but strange thing was I found the table "OSE$TABLES" in user schema which is "ITR001"
Did someone ever use opensync before? can help me out. thank you
24-02-2020 14:55:35.403 FINE T01 oracle.opensync.plugins.javadb.JavadbDB.<init>(Unknown Source) Creating 'default'
24-02-2020 14:55:35.418 INFO T01 oracle.opensync.plugins.javadb.JavadbPlugin.getDBParameters(Unknown Source) Attempting to connect with user='ITR001' pwd='*'
24-02-2020 14:55:35.418 FINEST T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCFactory.<init>(Unknown Source) enter...
24-02-2020 14:55:35.653 INFO T01 oracle.opensync.plugins.javadb.JavadbDB.<init>(Unknown Source) Creating connection to jdbc:derby:javadb\ITR00*
24-02-2020 14:55:36.684 INFO T01 oracle.opensync.plugins.javadb.JavadbDB.recover(Unknown Source) Initial boot of database 'default'
24-02-2020 14:55:36.684 FINEST T01 oracle.opensync.plugins.javadb.JavadbDB.recover(Unknown Source) loadSnapshots() failed with Schema 'OSE$ITR001' does not exist
24-02-2020 14:55:36.715 FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.beginTransaction(Unknown Source) mode=EXCLUSIVE on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)
24-02-2020 14:55:36.715 FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.executeUpdate(Unknown Source) ac:CREATE TABLE "OSE$TRSEQ" (PUBID INTEGER PRIMARY KEY, TRSEQ INTEGER) false on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)
24-02-2020 14:55:36.762 FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.commit(Unknown Source) on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)
24-02-2020 14:55:36.762 FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.beginTransaction(Unknown Source) mode=EXCLUSIVE on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)
24-02-2020 14:55:36.762 FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.executeUpdate(Unknown Source) ac:CREATE TABLE "OSE$ITR001"."OSE$TABLES" (ID INTEGER PRIMARY KEY, PUBID INTEGER, NAME VARCHAR(32672), COLS VARCHAR(32672), ATTRS BLOB, FLAGS INTEGER, CREATE_CC BLOB, DROP_CC BLOB, DIRTY_STATE VARCHAR(32672)) false on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)
24-02-2020 14:55:36.809 FINE T01 oracle.opensync.db.jdbc.javadb.JavadbJDBCConnection.commit(Unknown Source) on org.apache.derby.impl.jdbc.EmbedConnection@1594873248 (XID = 169), (SESSIONID = 1), (DATABASE = javadb\ITR001\default), (DRDAID = null)
24-02-2020 14:55:36.950 SEVERE T01 oracle.opensync.plugins.javadb.JavadbDB.<init>(Unknown Source) Exception in JavadbDB construction: java.sql.SQLSyntaxErrorException: Table/View 'OSE$ITR001.OSE$TRSEQ' does not exist.