Book a Demo

Author Topic: Error transferring .EAP to Oracle repository ...  (Read 2872 times)

psm

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Error transferring .EAP to Oracle repository ...
« on: May 16, 2007, 11:04:48 pm »
Hi,

I have problem when transferring our .EAP file to newly created Oracle repository. When using "Project transfer", I get several oracle errors "ORA-01031 Insufficient privileges" after creating table "usystables". The same happens even if I try to transfer EAExample.eap or other simple examples..

After the transfer, it is possible to open the model elements from the repository, however I cannot create a new one - I got error "ORA-02289 sequence does not exist".

Do you have any idea what is the problem? Is it that the user which is transferring the project to repository has no privileges for creating new Oracle sequences? (so maybe "GRANT CREATE SEQUENCE TO ... could help...??).

I would like to know what has to be set up in Oracle before asking our DBA specialist to do it (as I have no DBA privileges..).

Thank you very much,
P.

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: Error transferring .EAP to Oracle repository .
« Reply #1 on: May 17, 2007, 01:04:51 pm »
The Project Transfer process creates sequences on the fly, so you will need "GRANT CREATE SEQUENCE TO ...  ".