cancel
Showing results for 
Search instead for 
Did you mean: 

Data migrating from oracle to postgresql

__3
Confirmed Champ
Confirmed Champ

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 :/.

2 REPLIES 2

Greg_Drayon
Star Contributor
Star Contributor

It may sound silly, but did you have four rows in document_route_instance in your old (Oracle) database?

__3
Confirmed Champ
Confirmed Champ

No, I had two rows which migrated to PostgreSQL.

Getting started

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.