Data migrating from oracle to postgresql
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-06-2016 08:45 AM
Hi everyone!
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
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
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 :/.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2016 08:09 AM
It may sound silly, but did you have four rows in document_route_instance in your old (Oracle) database?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2016 10:27 AM
No, I had two rows which migrated to PostgreSQL.
