0 Replies Latest reply: Apr 25, 2014 1:48 PM by Cliff Mack RSS

    Installing Unit Test repository

    Cliff Mack

      Ver 4.0.1.14

      Build MAIN-14.48

      Windows 7 64bit

      Oracle 11.2.0.1 EE (same box)

       

       

      Getting an error when installing the unit repository that leaves SQLDev in a state where you can neither use it or delete (I wound up just dropping the UT_% tables).

       

      After the 2 roles are created, grants given, and synonym created, it must go into a DDL script which is where I get the error popup:

       

      Error occured whilst processing script: SQLException  (misspelling Oracle's not mine     ).

       

      This leaves my Unit Test view window (left pane) as:

      Unit Tests - TESTDB (Admin) (User)

        -- Not connected to a repository

       

      When I click on Tools ==> Unit Test ==> Deselect Current Repository

      it works

       

      but when trying to re-connect I get:

      No Repository was found on the selected connection.

      Would you like to create one now?

      Yes   No

       

      Of course, I select Yes

       

      Which is when I get

      Error occured whilst processing script:

      Error starting at line: 9 in command -

      CREATE TABLE "UT_LOOKUP_CATEGORIES"

       

      you get the idea.... I'm stuck in this loop where I can't use it or really delete or recreate it which leads me to drop the tables and try again

      ..... which isn't working either.

       

      Thanks,

      Cliff