-
Type:
Bug
-
Status: Resolved
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.8.0-HF31, 6.0-HF06, 7.2
-
Tags:
-
Sprint:Sprint RepoTeam 7.1-2
On Oracle if TestSQLBackendSequenceId is run it creates a global temporary table ACLR_MODIFIED with an INT column for HIERARCHY_ID. However the test scripts fail to properly delete it when starting. Then later TestSQLBackend is run with this existing table and insertion of STRING-based ids fails.
org.nuxeo.ecm.core.storage.StorageException: Could not insert: INSERT INTO "HIERARCHY" ("ID", "PARENTID", "POS", "NAME", "ISPROPERTY", "PRIMARYTYPE", "MIXINTYPES", "ISCHECKEDIN", "BASEVERSIONID", "MAJORVERSION", "MINORVERSION", "ISVERSION") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:580)
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.writeCreates(JDBCRowMapper.java:481)
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.write(JDBCRowMapper.java:451)
at org.nuxeo.ecm.core.storage.sql.SoftRefCachingRowMapper.write(SoftRefCachingRowMapper.java:356)
at org.nuxeo.ecm.core.storage.sql.SessionImpl.doFlush(SessionImpl.java:373)
at org.nuxeo.ecm.core.storage.sql.SessionImpl.flush(SessionImpl.java:346)
at org.nuxeo.ecm.core.storage.sql.SessionImpl.save(SessionImpl.java:325)
at org.nuxeo.ecm.core.storage.sql.SessionImpl.computeRootNode(SessionImpl.java:1274)
at org.nuxeo.ecm.core.storage.sql.SessionImpl.<init>(SessionImpl.java:150)
at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.newSession(RepositoryImpl.java:324)
at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:278)
at org.nuxeo.ecm.core.storage.sql.RepositoryImpl.getConnection(RepositoryImpl.java:56)
at org.nuxeo.ecm.core.storage.sql.TestSQLBackend.testRootNode(TestSQLBackend.java:109)
...
Caused by: java.sql.BatchUpdateException: ORA-01722: invalid number
ORA-06512: at "MGTEST.NX_TRIG_HIERARCHY_INSERT", line 2
ORA-04088: error during execution of trigger 'MGTEST.NX_TRIG_HIERARCHY_INSERT'
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10296)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:216)
at org.nuxeo.ecm.core.storage.sql.jdbc.JDBCRowMapper.insertSimpleRows(JDBCRowMapper.java:564)
... 59 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "MGTEST.NX_TRIG_HIERARCHY_INSERT", line 2
ORA-04088: error during execution of trigger 'MGTEST.NX_TRIG_HIERARCHY_INSERT'
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010)
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:10096)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10200)
... 61 more
