2 exceptions while generating Entity Model with 4.70.37
2 exceptions while generating Entity Model with 4.70.37
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
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
-
- Posts: 43
- Joined: Thu 19 Jun 2008 14:30
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.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
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
-
- Posts: 43
- Joined: Thu 19 Jun 2008 14:30
We've analyzed the errors:
Please check the settings of your server or try to reinstall it.
These are server errors. There is a suggestion that the problem is not in OraDirect .NET, but in Oracle Server.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
Please check the settings of your server or try to reinstall it.
Error
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
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
Exception
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
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
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
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