Hi,
We are trying to migrate our Nuxeo 5.1.6 from File-based (data and blobs are
stored in file system) to database-based (Oracle 10g) with externalBlobs. We
exported the data with nxshell successfully, but nxshell import always fails
with "failed to write bundle: xxxx" error. See below for the error stacktrace.
I think that "bundle" data with id de0c7fc3-abf9-495d-aa57-b31846f7fc57 (in
JCR_DEFAULT_BUNDLE) is keeping info of all the folders we've created under root
workspace, until it built up to 4000 bytes. But the data field in
JCR_DEFAULT_BUNDLE table is of "BLOB" type, and should not have limit on the
data length.
Is it caused by some kind of driver or wrong settings? Please help.
-----
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
org.apache.jackrabbit.core.state.ItemStateException. message: failed to write
bundle: de0c7fc3-abf9-495d-aa57-b31846f7fc57
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:945)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.putBundle(AbstractBundlePersistenceManager.java:693)
at
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.store(AbstractBundlePersistenceManager.java:634)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.store(BundleDbPersistenceManager.java:485)
at
org.apache.jackrabbit.core.state.SharedItemStateManager$Update.end(SharedItemStateManager.java:688)
at
org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:855)
at
org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:326)
at
org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:313)
at
org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:302)
at
org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:306)
at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1240)
... 41 more
Caused by: org.nuxeo.ecm.core.api.WrappedException: Exception:
java.sql.SQLException. message: ORA-01461: can bind a LONG value only for
insert into a LONG column
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Protocol.java:955)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2053)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:656)
at
org.apache.jackrabbit.core.persistence.bundle.BundleDbPersistenceManager.storeBundle(BundleDbPersistenceManager.java:941)
... 51 more
Thank you for your reply in advanced.
- Carol
--
Posted by "carolsun" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread:
<http://www.nuxeo.org/discussions/thread.jspa?threadID=2504#6883>
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
