2 Replies Latest reply: Aug 20, 2013 5:32 AM by user13430807 RSS

    4.0 EA1 Error during setting up reporting schema

    user13430807


      Hello,

       

      during creation of the reporting schema the following error window pops-up:

      Error occured while creating Reporting Schema. See the log file for details.

       

      The log file contains the following information:

      2013-08-20 09:20:00,036 [Thread-57] ERROR SchemaFactory - SchemaFactory create
      java.sql.SQLException: ORA-01450: maximum key length (3118) exceeded

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
      at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
      at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315)
      at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1890)
      at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
      at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
      at oracle.dbtools.crest.exports.reports.SchemaFactory.createSchema(Unknown Source)
      at oracle.dbtools.crest.exports.reports.ReportsHandler.checkDB(Unknown Source)
      at oracle.dbtools.crest.exports.reports.ReportsHandler.export(Unknown Source)
      at oracle.dbtools.crest.swingui.ControllerApplication$ExportToReportsSchema$1.run(Unknown Source)

       

      Build: 4.0.0.816

      Joop

        • 1. Re: 4.0 EA1 Error during setting up reporting schema
          Dimitar Slavov-Oracle

          Hi,

           

           

          This exception is thrown by index creation and basically it depends on database db_block_size parameter.

          What you can do is setup the reporting repository from DM 3.3. After that run manually /datamodeler/reports/DMRS_Upgrade_Script_DM3.3_DM4.0.sql against the database. One (probably DESIGNS__IDX) of the index creation statements will fail. We'll fix the message in the log file with the exact index name.

           

          Thanks for reporting the issue

          • 2. Re: 4.0 EA1 Error during setting up reporting schema
            user13430807

            Hello,

             

            The upgrade scripts fail as you said:

             

            Error starting at line : 11 in command -

            CREATE INDEX DESIGNS__IDX ON DMRS_DESIGNS (DESIGN_ID, DESIGN_OVID, DESIGN_NAME, VERSION_COMMENTS, DATE_PUBLISHED) NOLOGGING

            Error at Command Line : 11 Column : 30

            Error report -

            SQL Error: ORA-01450: maximum key length (3118) exceeded

            01450. 00000 -  "maximum key length (%s) exceeded"

            *Cause:   

            *Action:

             

            Joop