2 exceptions while generating Entity Model with 4.70.37

2 exceptions while generating Entity Model with 4.70.37

Postby SCHRANK » Mon 30 Jun 2008 11:01

Today I unistalled the old and installed the new version of OraDirect.NET 4.70.37.
Now i get two horrible exceptions and can't add any db object to the model.

First Exception:

Error 1 An error occurred while reading from the store provider's data reader. See the inner exception for details.
ORA-01114: EA-Fehler beim Schreiben von Block in die Datei 201 (Block Nr. 643623)
ORA-27072: Datei-I/O-Fehler
Additional information: 4
Additional information: 643623
Additional information: 90112
ORA-01114: EA-Fehler beim Schreiben von Block in die Datei 201 (Block Nr. 643623)
ORA-27072: Datei-I/O-Fehler
Additional information: 4
Additional information: 643623
Additional information: 90112

Second Exception:

Added connection string to App.Config
ERROR: Unable to generate model due to the following exception: The store metadata has not been generated yet, please call GenerateStoreMetadata() first.
Loading metadata from database took 00:00:06.9533837
Generating model took 00:00:06.0491174
Writing out edmx file took 00:00:00.0471364
Added connection string to App.Config
SCHRANK
 
Posts: 6
Joined: Thu 05 Jun 2008 12:42

Postby anton.connect » Tue 01 Jul 2008 11:22

Try to generate your model once more.
If it does not help, please send the script of your data base to reproduce the situation to antonc*devart*com.

Regards,
Anton
anton.connect
 
Posts: 43
Joined: Thu 19 Jun 2008 14:30

Postby SCHRANK » Tue 01 Jul 2008 15:24

anton.connect wrote:Try to generate your model once more.
If it does not help, please send the script of your data base to reproduce the situation to antonc*devart*com.

Regards,
Anton


Same issues again and again. I'm sorry but db is to complex to send only a script. I'm desperate because i wanna use OraDirect.net. I should have positive results because our company is evaluating new products.

On a other db I got a similar error:


Error 1
An error occurred while reading from the store provider's data reader. See the inner exception for details.
ORA-01114: IO error writing block to file 201 (block # 220968)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 220968
Additional information: 114688
ORA-01114: IO error writing block to file 201 (block # 220968)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 220968
Additional information: 114688
SCHRANK
 
Posts: 6
Joined: Thu 05 Jun 2008 12:42

Postby anton.connect » Wed 02 Jul 2008 09:28

We've analyzed the errors:

ORA-01114: IO error writing block to file 201 (block # 220968)
ORA-27072: File I/O error
Linux Error: 2: No such file or directory


These are server errors. There is a suggestion that the problem is not in OraDirect .NET, but in Oracle Server.
Please check the settings of your server or try to reinstall it.
anton.connect
 
Posts: 43
Joined: Thu 19 Jun 2008 14:30

Error

Postby vandero » Mon 11 Aug 2008 14:25

I also have the same error as stated above.
I downloaded version 4.7 of OraDirect.NET.

Exception details:
Added connection string to App.Config
ERROR: Unable to generate model due to the following exception: The store metadata has not been generated yet, please call GenerateStoreMetadata() first.
Loading metadata from database took 00:00:18.1711988
Generating model took 00:00:27.7971091
Writing out edmx file took 00:00:00.1172459
Added connection string to App.Config

It seems that I don't get this error when I try to add a view from the Oracle database to the model. When I try a table or stored procedure I always get this error.

I'm in the process of evaluating this product so urgent help is needed with this problem.

Thanks
Robin
vandero
 
Posts: 3
Joined: Mon 11 Aug 2008 14:22

Postby AndreyR » Mon 11 Aug 2008 15:07

Please send us the script of your database objects (andreyr * devart * com).
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Exception

Postby vandero » Tue 12 Aug 2008 13:57

Andrey,

In the mean time I found another post on the forum that explained that the problem that I'm experiencing is due to the fact that the database has too many tables for the wizard to cope with.

I then tried with a user that only had a couple of tables and this seems to work. However, now I'm experiencing problems with the generation of stored procedures.

Do you have an idea when the problem with a database with hundreds of tables would be resolved?

Thanks
Robin
vandero
 
Posts: 3
Joined: Mon 11 Aug 2008 14:22

Postby AndreyR » Wed 13 Aug 2008 07:09

We have improved our support of stored procedures. This fix will be available in the upcoming build.

We are still working on the problem with large schemas.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Shalex » Thu 11 Sep 2008 12:24

The latest build of OraDirect .NET version 4.75.42 is available. Its performance is much better when working with large schemas.
You can download it from http://www.devart.com/oranet/download.html or from Registered Users' Area (for the Subscription program members only).

More about the new release: http://devart.com/forums/viewtopic.php?t=12859
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle