1 Reply Latest reply on Aug 20, 2019 12:34 PM by Philip Stoyanov-Oracle

    Errors after cloning physical model from 11g to 12cR2

    Günter

      Hi,

      changed my physical model(Generated by Oracle SQL Developer Data Modeler 4.1.5.907)

        from 11g to 12cR2, after creating a new 12cR2 physical model and cloning it from 11g physical model, i deleted the 11g physical model.

      Now i'm experience some problems:

      • the new 12cR2 physical model is not opened automatically, still i ask to do so, but i can open it manually(dmd_open.local exists)
      • i changed my preferences "Default RDBMS Type" and "Default RDBMS Site" to "Oracle Database 12cR2" but at DDL generation "DDL File Editor" still defaults to "Oracle Database 11g"
      • "Logging Page" and "External log" show me some errors

      Regards Günter

       

      Java(TM) Platform1.8.0_161
      Oracle IDE19.2.0.182.1216

       

      Logging Page:

      SEVERE 278 1 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.getURL(NbEditorContainer.java:1019)

      SEVERE 277 28111 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.getURL(NbEditorContainer.java:1019)

      SEVERE 271 242 oracle.dbtools.crest.util.logging.Logger Can not extract object properties: D:\SVN\GLOB-DB\translations\trunk\structure\datamodels\TLS\rel\51483596-7C8E7441BAEA\subviews\48D85C00-F9D8-EF74-8438-7A82465447FC.xml

      SEVERE 269 377180 oracle.ide.panels.MDDPanel Exception exiting traversable oracle.dbtools.crest.fcp.preferences.ModelPP[,0,0,675x600,layout=java.awt.GridBagLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=9,maximumSize=,minimumSize=,preferredSize=]

      SEVERE 268 13 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.getURL(NbEditorContainer.java:1019)

      SEVERE 267 210355 oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1 null at com.oracle.jdeveloper.nbwindowsystem.NbEditorContainer.getURL(NbEditorContainer.java:1019)

       

      External Log:

      2019-08-14 10:19:49 INFO - Oracle SQL Developer Data Modeler 19.2.0.182.1216

      2019-08-14 10:30:25 SEVERE - Can not extract object properties: D:\SVN\GLOB-DB\translations\trunk\structure\datamodels\TLS\rel\51483596-7C8E7441BAEA\subviews\48D85C00-F9D8-EF74-8438-7A82465447FC.xml

      oracle.xml.parser.v2.XMLParseException; lineNumber: 4; columnNumber: 110; Expected name instead of  .

      at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:326)

      at oracle.xml.parser.v2.XMLReader.scanNameChars(XMLReader.java:1313)

      at oracle.xml.parser.v2.XMLReader.scanQName(XMLReader.java:2211)

      at oracle.xml.parser.v2.XMLReader.getEntity(XMLReader.java:2668)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttrEntityRef(NonValidatingParser.java:2013)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttrValue(NonValidatingParser.java:1999)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttr(NonValidatingParser.java:1878)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttributes(NonValidatingParser.java:1810)

      at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1647)

      at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:471)

      at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:417)

      at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:251)

      at oracle.xml.jaxp.JXDocumentBuilder.parse(JXDocumentBuilder.java:175)

      at oracle.dbtools.crest.model.metadata.SVNDMPropertiesManager.extractObjectPropertiesFromLocalDiagramsFile(SVNDMPropertiesManager.java:752)

      at oracle.dbtools.crest.model.metadata.SVNDMPropertiesManager.extractObjectPropertiesFromLocalFile(SVNDMPropertiesManager.java:609)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNClientHelper.convertToStorableObjectStatusesSVN(SVNClientHelper.java:2302)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNClientHelper.getStatuses(SVNClientHelper.java:1567)

      at oracle.dbtools.crest.fcp.vcs.DataModelerChangesTimerTask.findChanges(DataModelerChangesTimerTask.java:256)

      at oracle.dbtools.crest.fcp.vcs.DataModelerChangesTimerTask.run(DataModelerChangesTimerTask.java:137)

      at java.util.TimerThread.mainLoop(Timer.java:555)

      at java.util.TimerThread.run(Timer.java:505)

      2019-08-14 10:30:25 SEVERE - Can not extract object properties: D:\SVN\GLOB-DB\translations\trunk\structure\datamodels\TLS\rel\51483596-7C8E7441BAEA\subviews\48D85C00-F9D8-EF74-8438-7A82465447FC.xml

      oracle.xml.parser.v2.XMLParseException; lineNumber: 4; columnNumber: 110; Expected name instead of  .

      at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:326)

      at oracle.xml.parser.v2.XMLReader.scanNameChars(XMLReader.java:1313)

      at oracle.xml.parser.v2.XMLReader.scanQName(XMLReader.java:2211)

      at oracle.xml.parser.v2.XMLReader.getEntity(XMLReader.java:2668)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttrEntityRef(NonValidatingParser.java:2013)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttrValue(NonValidatingParser.java:1999)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttr(NonValidatingParser.java:1878)

      at oracle.xml.parser.v2.NonValidatingParser.parseAttributes(NonValidatingParser.java:1810)

      at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1647)

      at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:471)

      at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:417)

      at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:251)

      at oracle.xml.jaxp.JXDocumentBuilder.parse(JXDocumentBuilder.java:175)

      at oracle.dbtools.crest.model.metadata.SVNDMPropertiesManager.extractObjectPropertiesFromLocalDiagramsFile(SVNDMPropertiesManager.java:752)

      at oracle.dbtools.crest.model.metadata.SVNDMPropertiesManager.extractObjectPropertiesFromLocalFile(SVNDMPropertiesManager.java:609)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNClientHelper.convertToStorableObjectStatusesSVN(SVNClientHelper.java:2302)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNClientHelper.getStatuses(SVNClientHelper.java:1567)

      at oracle.dbtools.crest.fcp.vcs.DataModelerChangesTimerTask.findChanges(DataModelerChangesTimerTask.java:256)

      at oracle.dbtools.crest.fcp.vcs.DataModelerChangesTimerTask.run(DataModelerChangesTimerTask.java:137)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNUnversionedFilesChangeList$UnversionedDataModelerChangesTimerTask.run(SVNUnversionedFilesChangeList.java:63)

      at java.util.TimerThread.mainLoop(Timer.java:555)

      at java.util.TimerThread.run(Timer.java:505)

      2019-08-14 10:30:26 WARNING - doStatus

      org.tigris.subversion.svnclientadapter.SVNClientException: org.tigris.subversion.javahl.ClientException: svn: E235000: Assertion failure in class 'org.tmatesoft.svn.core.internal.db.SVNSqlJetDb' (file SVNSqlJetDb.java) in method 'commit' on line 244: no opened transactions

      at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getStatus(AbstractJhlClientAdapter.java:539)

      at org.tigris.subversion.svnclientadapter.svnkit.SvnKitClientAdapter.getStatus(SvnKitClientAdapter.java:144)

      at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getStatus(AbstractJhlClientAdapter.java:489)

      at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getSingleStatus(AbstractJhlClientAdapter.java:480)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNClientHelper.getSingleStatusLocal(SVNClientHelper.java:501)

      at oracle.dbtools.crest.fcp.vcs.StorableObjectStatus.getStorableObjectNameForMissing(StorableObjectStatus.java:568)

      at oracle.dbtools.crest.fcp.vcs.StorableObjectStatus.getStorableObjectName(StorableObjectStatus.java:487)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNClientHelper.convertToStorableObjectStatusesSVN(SVNClientHelper.java:2368)

      at oracle.dbtools.crest.fcp.vcs.svn.SVNClientHelper.getStatuses(SVNClientHelper.java:1567)

      at oracle.dbtools.crest.fcp.vcs.DataModelerChangesTimerTask.findChanges(DataModelerChangesTimerTask.java:256)

      at oracle.dbtools.crest.fcp.vcs.DataModelerChangesTimerTask.run(DataModelerChangesTimerTask.java:137)

      at java.util.TimerThread.mainLoop(Timer.java:555)

      at java.util.TimerThread.run(Timer.java:505)

      Caused by: org.tigris.subversion.javahl.ClientException: svn: E235000: Assertion failure in class 'org.tmatesoft.svn.core.internal.db.SVNSqlJetDb' (file SVNSqlJetDb.java) in method 'commit' on line 244: no opened transactions

      at org.tigris.subversion.javahl.JavaHLObjectFactory.throwException(JavaHLObjectFactory.java:785)

      at org.tmatesoft.svn.core.javahl.SVNClientImpl.throwException(SVNClientImpl.java:1897)

      at org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java:305)

      at org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java:283)

      at org.tigris.subversion.svnclientadapter.javahl.AbstractJhlClientAdapter.getStatus(AbstractJhlClientAdapter.java:525)

      ... 12 more

      Caused by: org.tmatesoft.svn.core.SVNException: svn: E235000: Assertion failure in class 'org.tmatesoft.svn.core.internal.db.SVNSqlJetDb' (file SVNSqlJetDb.java) in method 'commit' on line 244: no opened transactions

      at org.tmatesoft.svn.core.internal.wc.SVNErrorManager.error(SVNErrorManager.java:64)

      at org.tmatesoft.svn.core.internal.wc.SVNErrorManager.error(SVNErrorManager.java:51)

      at org.tmatesoft.svn.core.internal.wc.SVNErrorManager.assertionFailure(SVNErrorManager.java:140)

      at org.tmatesoft.svn.core.internal.db.SVNSqlJetDb.commit(SVNSqlJetDb.java:244)

      at org.tmatesoft.svn.core.internal.db.SVNSqlJetStatement.reset(SVNSqlJetStatement.java:80)

      at org.tmatesoft.svn.core.internal.db.SVNSqlJetTableStatement.reset(SVNSqlJetTableStatement.java:92)

      at org.tmatesoft.svn.core.internal.db.SVNSqlJetSelectStatement.reset(SVNSqlJetSelectStatement.java:329)

      at org.tmatesoft.svn.core.internal.db.SVNSqlJetDb.getStatement(SVNSqlJetDb.java:161)

      at org.tmatesoft.svn.core.internal.wc17.db.SVNWCDb.readInfo(SVNWCDb.java:3683)

      at org.tmatesoft.svn.core.internal.wc17.db.SVNWCDb.readInfo(SVNWCDb.java:3535)

      at org.tmatesoft.svn.core.internal.wc17.SVNStatusEditor17.readInfo(SVNStatusEditor17.java:570)

      at org.tmatesoft.svn.core.internal.wc17.SVNStatusEditor17.walkStatus(SVNStatusEditor17.java:613)

      at org.tmatesoft.svn.core.internal.wc2.ng.SvnNgGetStatus.run(SvnNgGetStatus.java:128)

      at org.tmatesoft.svn.core.internal.wc2.ng.SvnNgGetStatus.run(SvnNgGetStatus.java:27)

      at org.tmatesoft.svn.core.internal.wc2.ng.SvnNgOperationRunner.run(SvnNgOperationRunner.java:20)

      at org.tmatesoft.svn.core.internal.wc2.SvnOperationRunner.run(SvnOperationRunner.java:21)

      at org.tmatesoft.svn.core.wc2.SvnOperationFactory.run(SvnOperationFactory.java:1235)

      at org.tmatesoft.svn.core.wc2.SvnOperation.run(SvnOperation.java:294)

      at org.tmatesoft.svn.core.wc.SVNStatusClient.doStatus(SVNStatusClient.java:363)

      at org.tmatesoft.svn.core.javahl.SVNClientImpl.status(SVNClientImpl.java:301)

      ... 14 more

        • 1. Re: Errors after cloning physical model from 11g to 12cR2
          Philip Stoyanov-Oracle

          Hi Günter,

           

          2019-08-14 10:30:25 SEVERE - Can not extract object properties: D:\SVN\GLOB-DB\translations\trunk\structure\datamodels\TLS\rel\51483596-7C8E7441BAEA\subviews\48D85C00-F9D8-EF74-8438-7A82465447FC.xml

          oracle.xml.parser.v2.XMLParseException; lineNumber: 4; columnNumber: 110; Expected name instead of

          that speaks about merge conflict and XML file is not valid anymore - you need to resolve that conflict.

           

          On the second error - try to cleanup working copy (from team menu).

           

          Philip