https://connect.hyland.com/t5/nuxeo-forum/data-migrating-from-oracle-to-postgresql/m-p/324140#M11141 <P>It may sound silly, but did you have four rows in document_route_instance in your old (Oracle) database?</P> Thu, 07 Jul 2016 12:09:45 GMT Greg_Drayon 2016-07-07T12:09:45Z https://connect.hyland.com/t5/nuxeo-forum/data-migrating-from-oracle-to-postgresql/m-p/324139#M11140 <P>Hi everyone!</P> <P>I'm troubling with error mentioned in subject. I want to migrate data from repository(oracle) to another repository which use (postgresql). What I did is use ora2pg to dump data from oracle. It worked good I think, the data commited inside postgresql. I pointed postgresql repository xmlx on oracle repository storage. But it's still not working. I mean i don't see any data from oracle repository inside postgresql repository on GUI. But I have this error</P> <PRE><CODE>2016-07-06 14:34:08,834 WARN [localhost-startStop-1] [org.nuxeo.ecm.platform.routing.core.impl.DocumentRoutingTreePersister] More han one DocumentRouteInstanceRoot found: 2016-07-06 14:34:08,835 WARN [localhost-startStop-1] [org.nuxeo.ecm.platform.routing.core.impl.DocumentRoutingTreePersister] - document-route-models-root, /document-route-models-root 2016-07-06 14:34:08,835 WARN [localhost-startStop-1] [org.nuxeo.ecm.platform.routing.core.impl.DocumentRoutingTreePersister] - document-route-models-root, /document-route-models-root 2016-07-06 14:34:09,273 WARN [localhost-startStop-1] [org.nuxeo.ecm.platform.routing.core.impl.DocumentRoutingTreePersister] More han one DocumentRouteInstanceRoot found: 2016-07-06 14:34:09,273 WARN [localhost-startStop-1] [org.nuxeo.ecm.platform.routing.core.impl.DocumentRoutingTreePersister] - document-route-models-root, /document-route-models-root 2016-07-06 14:34:09,273 WARN [localhost-startStop-1] [org.nuxeo.ecm.platform.routing.core.impl.DocumentRoutingTreePersister] - document-route-models-root, /document-route-models-root </CODE></PRE> <P>I checked inside postgresql on table called document_route_instance - it had four rows because of data migration. I deleted all rows from there and after restart nuxeo generated new ones, but error still occurs. I investigated about replication-platform but it looks that is depraceted now :/.</P> <PRE><CODE></CODE></PRE> Wed, 06 Jul 2016 12:45:01 GMT https://connect.hyland.com/t5/nuxeo-forum/data-migrating-from-oracle-to-postgresql/m-p/324139#M11140 __3 2016-07-06T12:45:01Z https://connect.hyland.com/t5/nuxeo-forum/data-migrating-from-oracle-to-postgresql/m-p/324140#M11141 <P>It may sound silly, but did you have four rows in document_route_instance in your old (Oracle) database?</P> Thu, 07 Jul 2016 12:09:45 GMT https://connect.hyland.com/t5/nuxeo-forum/data-migrating-from-oracle-to-postgresql/m-p/324140#M11141 Greg_Drayon 2016-07-07T12:09:45Z https://connect.hyland.com/t5/nuxeo-forum/data-migrating-from-oracle-to-postgresql/m-p/324141#M11142 <P>No, I had two rows which migrated to PostgreSQL.</P> Thu, 07 Jul 2016 14:27:45 GMT https://connect.hyland.com/t5/nuxeo-forum/data-migrating-from-oracle-to-postgresql/m-p/324141#M11142 __3 2016-07-07T14:27:45Z