Problem starting an Oracle repository

[jsbueno]

Hi,

I am having trouble transfering baseEAP.EAP to a new Oracle 10g repository. EA starts the process, and at about 1/3 of the progress bar, it gives me an "oracle error: table does not  exist". Ad 2/3 othe process it does that again, and crashes.

I am using EA build 832 and Oracle Database 10g Enterprise Edition Release 10.2.0.1.0, and uploading the oracle scirpts with sqlplus "load" option once I log-in the DB.

Has anyone else faced this? What are the possible work-arounds?

[«Midnight»]

On a long shot, make sure you are using the Jet 4.0 driver. This option is on the Tools | Options | General dialog. Remember to exit and restart EA after changing this setting.

If that's not it, try downloading the Jet 4.0 EABase project from the Sparx Resources page.

Finally, if that does not help, send a bug report to Sparx. Use the Report a Bug link below the Support link near the bottom of any forum page, or follow the link near the top of the Registered Users page. Make sure you tell Sparx the version and vendor of every component and driver you use, on both server and client, to communicate with Oracle.

David

[jsbueno]

Just got the very same errors with jet-engine 4 and the new template.

The more I try using EA, the more drawbacks I see.  I am in charge of trying EA and paving out the way for the develoeprs and projects start using it for the projects around here. But things like this are jsut show-stoppers.

[Eve]

Have you followed the instructions at http://www.sparxsystems.com.au/resources/corporate/oracle_instructions.html?

It sounds like you haven't loaded the tables from the script.

[jsbueno]

Indeed.

that was mostly it - the script had been improperly run, and a couple tables where missing.

Of course, a descriptive error message would have spared me sometime on this issue. Also, I could not say that crashing the application is a desired behavior for cases like this.