1 Reply Latest reply on Jun 6, 2017 2:22 PM by userBDBDMS-Oracle

    Exception syncing a new client with DMS 12c

    Kav

      Hi,

       

      I've just installed DMS 12c and done the initial setup with Oracle Database 12c. I've created users, publications, publication items and subscriptions for the users. After running the setup for the Berkeley DB client for the first time, this error is thrown when running the msync.exe:

       

      -12038 oseException(-12038):

      Server error has occurred (see the cause) <- oseServerError(2000):

      ORA-02291: integrity constraint (MOBILEADMIN3.C$ALL_CLIENT_ITEMSFK) violated - parent key not found

       

      This is the full exception from the DMS admin console's history session:

       

      Sync session exception stack trace:

      java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (MOBILEADMIN3.C$ALL_CLIENT_ITEMSFK) violated - parent key not found

       

       

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)

        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)

        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)

        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)

        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)

        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)

        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)

        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)

        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)

        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3530)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)

        at oracle.lite.sync.Subscription.execPrepUpdate(Subscription.java:7876)

        at oracle.lite.sync.HeliosSession.downloadSubs(HeliosSession.java:6996)

        at oracle.lite.sync.HeliosSession.startSession(HeliosSession.java:5991)

        at oracle.lite.sync.resume.Client$1.run(Client.java:133)

        at oracle.lite.sync.resume.ThreadPool$PoolTask.run(ThreadPool.java:41)

       

      Please help.