Author Topic: RuntimeError on data transfer (Read 5817 times)

maisen · « **on:** May 17, 2006, 08:09:04 am »

Hi,
when transfering data from an .eap-file to a oracle 10g database there occurs an runtime-error when the transfer gets to the t_document table.
i have seen the same error discussed in this forum, but the solution to clear our "project discussion forum" will not work because it is empty.
thanx for your help,
maisen

«Midnight» · « **Reply #1 on:** May 17, 2006, 08:36:08 am »

Just to be sure, please create a new empty schema in Oracle 10g, and also make a new EAP file. I suggest downloading one of the empty project files from the Sparx registered user resources page, opening it in EA, and saving it again (to make sure it is current).

Then retry the data transfer operation. See if you successfully get an empty file on the Oracle side.

maisen · « **Reply #2 on:** May 17, 2006, 08:48:46 am »

Hi,
I tested after the failure has occured the same with the eaExample.ear (from the ea-homepage) in the same database schema and it transfered successfully.
then I deleted the tables and constraints with a script again and repeated to transfer our project file and it fails at the same table (t_documents).

«Midnight» · « **Reply #3 on:** May 17, 2006, 09:20:44 am »

How did you create your project file? Did you use the new file wizard?

I've got some misgivings about the wizard, as it seems to embed some surprises in new projects. In at least one case - which I am trying to isolate - these seem to be 'sticky' in the sense that they are difficult or impossible to remove.

If you did create the file this way, find the discussion forum and delete everything by hand. See if that works.

If it does work, you can always open EABase in the installation directory and perform the same surgery. This might clear the problem up. I think I needed to do a Save As into another file name afterwards, then swap files (so my newly saved copy became EABase). Not perfect by far, but it might help.

What version did you first install? I wonder if any of the newer versions had this corrected. If so, the changes might not have come over if you just used the patch file. If that is the case try doing a full install with version 790.

As before, please let us know if any of the above works, or even changes the pattern.

David

maisen · « **Reply #4 on:** May 18, 2006, 01:36:09 am »

Our EA Version is 6.1.787 - Unicode. Presumably we used the wizard to create our project file. We never used the "Project discussion forum", can I however delete something from that category to solve the problem?

«Midnight» · « **Reply #5 on:** May 18, 2006, 04:22:09 am »

Hi again Maisen,

I'm just wondering if the project template could have left anything in the forum by default. While a bit of a guess, it is possible, and there are some other issues relating to these templates that need to be worked out - they are a very new feature.

The problem is that I don't know where to look for these elements. You'll have to take a look through and see if you find anything.

In the meantime, please try downloading an empty EA project from the Sparx site, opening it, and saving it to a new file name. The see if you can transfer the resulting (new) file.

David

SCerda · « **Reply #6 on:** May 18, 2006, 02:42:29 pm »

Hi, I have the same problem, Oracle 9i is our database and is installed in my PC, the process of data tranfer from EA to Oracle 9i is OK. But my developers has errors when they try connect to the database in my PC.

The error is next: Microsoft OLE DB Provider for ODBC Drivers [-2147467259]

Is EA enabled to connect to database in other PC (Server) or just only as local database?

Regards

Sergio

«Midnight» · « **Reply #7 on:** May 19, 2006, 06:36:30 am »

It is designed to connect to either. Do you get a password popup before it fails?

maisen · « **Reply #8 on:** May 22, 2006, 03:31:21 am »

Hi david,
I exported our project with the xmi-interface and imported the files in a new project again. Then the data transfer worked successfully.
Thank you for your helpful hints,
Kind regards
maisen

«Midnight» · « **Reply #9 on:** May 22, 2006, 05:31:22 am »

Good news Maisen,

You certainly worked for it! It might be worth a moment to create an empty template project - with all your corporate default settings, stereotypes, and such - in Oracle. You can then use this as your own 'template' for the future. Of course you will have to test this via the DBMS to DBMS data transfer, but I suspect you'll have far less problem. This might isolate you from small changes in the desktop version, which probably occur continuously as EA evolves.

David

«Midnight» · « **Reply #10 on:** May 22, 2006, 05:31:45 am »

Sergio,

Where are you on this? Have you tried the Oracle-provided OLE DB driver?

David

agonzalez · « **Reply #11 on:** November 16, 2006, 03:31:40 pm »

Hi, I'm trying to consulting a model registered in a repository in Oracle 9i, but i can't acces....

The error is next: Oracle-provided OLE DB [-2147467259]

Does anyone know why this is?

Thanks
Agustin

Sparx Systems Forum

News: