This discussion is archived
2 Replies Latest reply: Aug 20, 2013 3:32 AM by user13430807 RSS

4.0 EA1 Error during setting up reporting schema

user13430807 Explorer
Currently Being Moderated


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 Journeyer
    Currently Being Moderated

    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 Explorer
    Currently Being Moderated

    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points