2 exceptions while generating Entity Model with 4.70.37

SCHRANK · Post by **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

anton.connect · Post by **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

SCHRANK · Post by **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

anton.connect · Post by **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.

vandero · Post by **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

AndreyR · Post by **AndreyR** » Mon 11 Aug 2008 15:07

Please send us the script of your database objects (andreyr * devart * com).

vandero · Post by **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

AndreyR · Post by **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.

Shalex · Post by **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