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.