[MRM-657] 'ORA-00910: specified length too long for its datatype' Error when clicking on searched artifact.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.0
• Environment: Oracle 10g 10.2.0.3.0 on Sun Solaris Sparc 64
• Assignee: Unassigned
• Reporter: Mick Knutson
• Created: 16/Jan/08 09:57
• Updated: 23/Feb/10 02:45
• Resolved: 23/Feb/10 02:45

Description

When I do a search for an artifact, then I get the results, I then get this error:

javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : ORA-00910: specified length too long for its datatype

java.sql.SQLException: ORA-00910: specified length too long for its datatype

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:703)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1196)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1804)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:570)
at org.jpox.store.rdbms.table.AbstractTable.create(AbstractTable.java:297)
at org.jpox.store.rdbms.table.AbstractTable.exists(AbstractTable.java:341)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3052)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
at org.jpox.AbstractPersistenceManager.newObjectIdInstance(AbstractPersistenceManager.java:2377)
at org.apache.maven.archiva.database.jdo.JdoAccess.getObjectById(JdoAccess.java:429)
at org.apache.maven.archiva.database.jdo.JdoProjectModelDAO.getProjectModel(JdoProjectModelDAO.java:74)
at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.getProjectModel(DefaultRepositoryBrowsing.java:281)
at org.apache.maven.archiva.database.browsing.DefaultRepositoryBrowsing.selectVersion(DefaultRepositoryBrowsing.java:127)
at org.apache.maven.archiva.web.action.ShowArtifactAction.artifact(ShowArtifactAction.java:105)

Now this does not come up like with continuum (at start up):
http://jira.codehaus.org/browse/CONTINUUM-1622

So Archiva runs, but not when I try to search.

Issue Links

• is superceded by: MRM-1025 remove the archiva database