EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

some errors during migration with runMTK.sh  XML

Forum Index » Postgres Plus Advanced Server
Author Message
jpsebasti

New member

Joined: 25 Apr 2013 16:02:57
Messages: 2
Offline

All,

Don't know if this is the right forum but I will start here. We are running latest version of edb.
I'm trying to migrate a schema from Oracle to edb.

I setup the tookit.properties file to connect to the Oracle database and the edb database.
I run the Migration Tookit with:
./runMTK.sh -dropSchema true confluence

(I am running on RedHat Linux)

The Oracle tables migrate successfully but when it tries to load Large Objects into the edb database from Oracle
I get the following errors. I'm not sure what kind of permissions I need on the pg_class edb table.


Loading Large Objects into table: ATTACHMENTDATA ...
Error Loading Data into Table: ATTACHMENTDATA: ERROR: permission denied for relation pg_class
Loading Large Objects into table: BANDANA ...
Error Loading Data into Table: BANDANA: ERROR: permission denied for relation pg_class
Loading Large Objects into table: BODYCONTENT ...
Error Loading Data into Table: BODYCONTENT: ERROR: permission denied for relation pg_class
Loading Large Objects into table: CONTENT ...
Error Loading Data into Table: CONTENT: ERROR: permission denied for relation pg_class
Loading Large Objects into table: DECORATOR ...
Error Loading Data into Table: DECORATOR: ERROR: permission denied for relation pg_class
Loading Large Objects into table: DRAFT ...
Error Loading Data into Table: DRAFT: ERROR: permission denied for relation pg_class
Loading Large Objects into table: KEYSTORE ...
Error Loading Data into Table: KEYSTORE: ERROR: permission denied for relation pg_class
Loading Large Objects into table: OS_PROPERTYENTRY ...
Error Loading Data into Table: OS_PROPERTYENTRY: ERROR: permission denied for relation pg_class
Loading Large Objects into table: PAGETEMPLATES ...
Error Loading Data into Table: PAGETEMPLATES: ERROR: permission denied for relation pg_class
Loading Large Objects into table: PLUGINDATA ...
Error Loading Data into Table: PLUGINDATA: ERROR: permission denied for relation pg_class
Loading Large Objects into table: SPACEGROUPS ...
Error Loading Data into Table: SPACEGROUPS: ERROR: permission denied for relation pg_class
Data Load Summary: Total Time (sec): 4.347 Total Rows: 15935 Total Size(MB): 1.505


I'm not seeing any hits on the web or on the forums on this kind of error.
Any ideas?
jpsebasti

New member

Joined: 25 Apr 2013 16:02:57
Messages: 2
Offline

I should also indicate that if I use the edb-psql client software to connect to the database as use confluence (this is the user/role in the edb database that I am trying to migrate into), I can query pg_class table without any problem. So I know that confluence role has at least select privileges on pg_class.
ma.lie

New member

Joined: 5 Jun 2013 04:41:04
Messages: 1
Offline

I also got these error,I think maybe they are caused by blob type ,I check my error table find they also have it,after migrating I will try it and confirm ,now i am migrating~
 
Forum Index » Postgres Plus Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team