Problem with Deploy (Silverlight + WCF Ria Services + Win 7 32bit + ODTwithODAC112021 + Telerik ORM + Oracle Database)

[Carlos]

Hi there,

I don't know what to do anymore, any help would be much appreciated:

I've tried to deploy an aplication that I'm developing and got some problems in the access to the DataBase.

I've installed a new and clean Windows 7 32-bit OS.
Then installed IIS 7.5, followed by Microsoft .NET Framework 4.0 and WebDeploymentTool 2.1.
After that, I've installed ORACLE Client and WCF Drivers (ODTwithODAC112021).
The silverlight application was working, but I had no data was presented in my application.
I've installed then the WCF Ria Services Server Install.. no success added...
then I've reinstalled ORACLE Client and WCF Drivers (ODTwithODAC112021) with no positive results either...
I went checking the Windows Event Log and saw some DLL missing related errors (can't recall specifically)..
After I've copied some Dll's to my application bin directory I've got 2 erros and 1 warning:

First ERROR
WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/63835064
 Exception: System.ServiceModel.ServiceActivationException: The service '/SGA/Services/SGA-Web-SGADomainContext.svc' cannot be activated due to an exception during compilation.  The exception message is: RIA code generation failed to construct OpenAccess context: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn). ---> System.Exception: RIA code generation failed to construct OpenAccess context: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn) ---> Telerik.OpenAccess.Exceptions.DataStoreException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn) ---> Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.ExceptionWrapper.Throw()
   at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
   at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init()
   at OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet props)
   at Telerik.OpenAccess.RT.Helper.getPersistenceManagerFactory(PropertySet props)
   at Telerik.OpenAccess.RT.DatabaseAdapter.AssertPersistenceManagerFactory(String usr, String password, Boolean open)
   at Telerik.OpenAccess.RT.DatabaseAdapter.Telerik.OpenAccess.SPI.IDatabaseAdapter.GetMetaData()
   at Telerik.OpenAccess.Database.get_MetaData()
   at Telerik.OpenAccess.OpenAccessContextBase.get_Metadata()
   at Telerik.OpenAccess.Ria.OpenAccessTypeDescriptionContext..ctor(Type dataContextType)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.FindContext(Type t)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.FindContext(Type t)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.get_TypeDescriptionContext()
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.get_TypeDescriptionContext()
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.GetTypeDescriptor(Type objectType, ICustomTypeDescriptor parent)
   at System.ServiceModel.DomainServices.Server.DomainTypeDescriptionProvider.GetTypeDescriptor(Type objectType, Object instance)
   at System.ComponentModel.TypeDescriptor.TypeDescriptionNode.DefaultTypeDescriptor.System.ComponentModel.ICustomTypeDescriptor.GetProperties()
   at System.ComponentModel.TypeDescriptor.GetProperties(Type componentType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddEntityType(Type entityType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddQueryMethod(DomainOperationEntry method)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.Initialize()
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.CreateDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.<>c__DisplayClass8.<GetDescription>b__7(Type type)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.GetDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHost..ctor(Type domainServiceType, Uri[] baseAddresses)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHostFactory.CreateServiceHost(Type serviceType, Uri[] baseAddresses)
   at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   --- End of inner exception stack trace ---
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath)
 Process Name: w3wp
 Process ID: 3292

Second ERROR
WebHost failed to process a request.
 Sender Information: System.ServiceModel.Activation.HostedHttpRequestAsyncResult/14044043
 Exception: System.ServiceModel.ServiceActivationException: The service '/SGA/Services/SGA-Web-SGADomainContext.svc' cannot be activated due to an exception during compilation.  The exception message is: RIA code generation failed to construct OpenAccess context: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn). ---> System.Exception: RIA code generation failed to construct OpenAccess context: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn) ---> Telerik.OpenAccess.Exceptions.DataStoreException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn) ---> Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.ExceptionWrapper.Throw()
   at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
   at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init()
   at OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet props)
   at Telerik.OpenAccess.RT.Helper.getPersistenceManagerFactory(PropertySet props)
   at Telerik.OpenAccess.RT.DatabaseAdapter.AssertPersistenceManagerFactory(String usr, String password, Boolean open)
   at Telerik.OpenAccess.RT.DatabaseAdapter.Telerik.OpenAccess.SPI.IDatabaseAdapter.GetMetaData()
   at Telerik.OpenAccess.Database.get_MetaData()
   at Telerik.OpenAccess.OpenAccessContextBase.get_Metadata()
   at Telerik.OpenAccess.Ria.OpenAccessTypeDescriptionContext..ctor(Type dataContextType)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.FindContext(Type t)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.FindContext(Type t)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.get_TypeDescriptionContext()
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.get_TypeDescriptionContext()
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.GetTypeDescriptor(Type objectType, ICustomTypeDescriptor parent)
   at System.ServiceModel.DomainServices.Server.DomainTypeDescriptionProvider.GetTypeDescriptor(Type objectType, Object instance)
   at System.ComponentModel.TypeDescriptor.TypeDescriptionNode.DefaultTypeDescriptor.System.ComponentModel.ICustomTypeDescriptor.GetProperties()
   at System.ComponentModel.TypeDescriptor.GetProperties(Type componentType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddEntityType(Type entityType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddQueryMethod(DomainOperationEntry method)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.Initialize()
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.CreateDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.<>c__DisplayClass8.<GetDescription>b__7(Type type)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.GetDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHost..ctor(Type domainServiceType, Uri[] baseAddresses)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHostFactory.CreateServiceHost(Type serviceType, Uri[] baseAddresses)
   at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)
   --- End of inner exception stack trace ---
   at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
   at System.ServiceModel.Activation.HostedHttpRequestAsyncResult.End(IAsyncResult result)
 Process Name: w3wp
 Process ID: 3292

The Warning
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 04-08-2011 18:08:21
Event time (UTC): 04-08-2011 17:08:21
Event ID: c55e66f68dd74ce89b553f7675630aea
Event sequence: 10
Event occurrence: 1
Event detail code: 0
 
Application information:
    Application domain: /LM/W3SVC/1/ROOT/SGA-1-129569512970800781
    Trust level: Full
    Application Virtual Path: /SGA
    Application Path: C:\inetpub\wwwroot\SGA\
    Machine name: WIN7PRO-SAMPAIO
 
Process information:
    Process ID: 3292
    Process name: w3wp.exe
    Account name: IIS APPPOOL\ASP.NET v4.0
 
Exception information:
    Exception type: Exception
    Exception message: RIA code generation failed to construct OpenAccess context: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.get_TypeDescriptionContext()
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.GetTypeDescriptor(Type objectType, ICustomTypeDescriptor parent)
   at System.ServiceModel.DomainServices.Server.DomainTypeDescriptionProvider.GetTypeDescriptor(Type objectType, Object instance)
   at System.ComponentModel.TypeDescriptor.TypeDescriptionNode.DefaultTypeDescriptor.System.ComponentModel.ICustomTypeDescriptor.GetProperties()
   at System.ComponentModel.TypeDescriptor.GetProperties(Type componentType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddEntityType(Type entityType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddQueryMethod(DomainOperationEntry method)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.Initialize()
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.CreateDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.<>c__DisplayClass8.<GetDescription>b__7(Type type)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.GetDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHost..ctor(Type domainServiceType, Uri[] baseAddresses)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHostFactory.CreateServiceHost(Type serviceType, Uri[] baseAddresses)
   at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)

Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriverException: Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Types.OracleDecimal' threw an exception. ---> Oracle.DataAccess.Types.OracleTypeException: ORA-22062:
   at Oracle.DataAccess.Types.OracleDecimal.GetMaxValue()
   at Oracle.DataAccess.Types.OracleDecimal..cctor()
   --- End of inner exception stack trace ---
   --- End of inner exception stack trace ---
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, RuntimeType declaringType, Boolean& domainInitialized)
   at System.Reflection.RtFieldInfo.InternalGetValue(Object obj, Boolean doVisibilityCheck, Boolean doCheckConsistency)
   at System.Reflection.RtFieldInfo.GetValue(Object obj)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.OracleODPFactory.AssureDriverUsable(DbProviderFactory f)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactoryByName(String backend)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   --- End of inner exception stack trace ---
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn)
   at Telerik.OpenAccess.RT.ExceptionWrapper.Throw()
   at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL()
   at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init()
   at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init()
   at OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet props)
   at Telerik.OpenAccess.RT.Helper.getPersistenceManagerFactory(PropertySet props)
   at Telerik.OpenAccess.RT.DatabaseAdapter.AssertPersistenceManagerFactory(String usr, String password, Boolean open)
   at Telerik.OpenAccess.RT.DatabaseAdapter.Telerik.OpenAccess.SPI.IDatabaseAdapter.GetMetaData()
   at Telerik.OpenAccess.Database.get_MetaData()
   at Telerik.OpenAccess.OpenAccessContextBase.get_Metadata()
   at Telerik.OpenAccess.Ria.OpenAccessTypeDescriptionContext..ctor(Type dataContextType)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.FindContext(Type t)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.FindContext(Type t)
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.get_TypeDescriptionContext()

Database driver installation problem: Cannot use factory for oracle. Exception has been thrown by the target of an invocation.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.GetFactory(ConnectionString cs, Boolean err)
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps)
   at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, Driver& driver, Connection& conn)

Exception has been thrown by the target of an invocation.
   at System.RuntimeFieldHandle.GetValue(RtFieldInfo field, Object instance, RuntimeType fieldType, R

 
 
Request information:
    Request URL: http://localhost/SGA/Services/SGA-Web-SGADomainContext.svc/binary/GetTiposNotificacaos?mostraSistemaNOK=true
    Request path: /SGA/Services/SGA-Web-SGADomainContext.svc/binary/GetTiposNotificacaos
    User host address: ::1
    User:  
    Is authenticated: False
    Authentication Type:  
    Thread account name: IIS APPPOOL\ASP.NET v4.0
 
Thread information:
    Thread ID: 3
    Thread account name: IIS APPPOOL\ASP.NET v4.0
    Is impersonating: False
    Stack trace:    at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.get_TypeDescriptionContext()
   at Telerik.OpenAccess.Ria.OpenAccessDomainServiceDescriptionProvider.GetTypeDescriptor(Type objectType, ICustomTypeDescriptor parent)
   at System.ServiceModel.DomainServices.Server.DomainTypeDescriptionProvider.GetTypeDescriptor(Type objectType, Object instance)
   at System.ComponentModel.TypeDescriptor.TypeDescriptionNode.DefaultTypeDescriptor.System.ComponentModel.ICustomTypeDescriptor.GetProperties()
   at System.ComponentModel.TypeDescriptor.GetProperties(Type componentType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddEntityType(Type entityType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.AddQueryMethod(DomainOperationEntry method)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.Initialize()
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.CreateDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.<>c__DisplayClass8.<GetDescription>b__7(Type type)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at System.ServiceModel.DomainServices.Server.DomainServiceDescription.GetDescription(Type domainServiceType)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHost..ctor(Type domainServiceType, Uri[] baseAddresses)
   at System.ServiceModel.DomainServices.Hosting.DomainServiceHostFactory.CreateServiceHost(Type serviceType, Uri[] baseAddresses)
   at System.ServiceModel.Activation.ServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(String normalizedVirtualPath)
   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath)

[Thomas]

Hi Carlos,

I think this could be due to different language/locale settings. The original exception comes from Oracle, where the number "9.9999999999999999999999999999999999999E+125" is tried to be interpreted by the Oracle runtime. Maybe it does not understand the . dot in it: ORA-22062 is thrown.

So, please verify that such locale / language settings are correct+consistent.

Greetings,
Thomas
the Telerik team

[Carlos]

Hi Thomas,

Fisrt of all, thanks for you fast answer!

I went checking the configurations and I think it's has no problem... the OS is in english but the local settings are Portugal.

Please check the attached image file.

Regards
Carlos Sampaio

[Thomas]

Hi Carlos,

yes, but see, the decimal symbol is set to , ; but the hard coded value uses a . as decimal separator.
 Anyways, I've tried to force the same settings here (using pl-PL as CultureInfo), but this had no effect.
Therefore I would like to propose that you hard link against the Oracle.DataAccess assembly and access the Oracle.DataAccess.Types.OracleDecimal.MaxValue.ToString() and see what happens. This will initialize the type or cause the same failure. Please notify me about the outcome.

Regards,
Thomas
the Telerik team

[Nagappan]

Hello Thomas,

We have been facing the error 1 described in the above post( OA 22062) and we are getting this particular issue whenever we try to do reverse mapping using Telerik OpenAccess from Visual Studio. There hasn't been any changes in the oracle side as well.

The steps that we follow are: Select Telerik window from visual studio and navigate to OpenAccess -->Reverse Mapping after selecting he config file.

Could you please look into this and help us with this issue. Thanks.

[Ralph Waldenmaier]

Hi Nagappan,
The ORA-22062 indicates that you have a 'NLS_NUMERIC_CHARACTERS' setting that will not pass our internal checks when we validate the validity of the Oracle drivers.

You can change the setting on the database or on your local machine in the environment variables. Please see this link for more details. The needed setting is ',.'.

See the following example of how to change this in the environment variables.

set nls_numeric_characters=',.'

Alternatively, you can also change this in the database if possible.

I hope this information is helpful for you.
Do come back in case you need further assistance.


Regards,
Ralph Waldenmaier
Telerik

 

 

[Nagappan]

Help Ralph,


we did the changes in both the places, in environment as well as in db, but we are still facing the same problem. This problem has come up recently and the application was working fine till now. Could you please suggest some ways out of it.

Thanks,
Nagappan

[Ralph Waldenmaier]

Hi Nagappan,
Have there been any other changes in your environment that could be related to this? New Oracle driver installation for instance?
Have you restarted your machine after setting the environment variables to ensure they are in place?
Can you provide more details about the NLS settings you are using? Which version of Telerik Data Access are you using? This would help us to reproduce this.

I am looking forward to hearing from you.

Regards,
Ralph Waldenmaier
Telerik

 

 

[Nagappan]

Hello Ralph,

Yes, we restarted the system after changing the environment variables. It dint work out.

Recently, Oracle Developer Tools 12.X has been installed in our system. Do you think that would have created the problem?

The version of Telerik OpenAccess that we are using is 2011.2

Here are the NLS setting of the Database that we are currently using

NLS_CALENDAR GREGORIAN
NLS_CHARACTERSET AL32UTF8
NLS_COMP BINARY
NLS_CURRENCY ?
NLS_DATE_FORMAT DD.MM.RR
NLS_DATE_LANGUAGE GERMAN
NLS_DUAL_CURRENCY ?
NLS_ISO_CURRENCY GERMANY
NLS_LANGUAGE GERMAN
NLS_LENGTH_SEMANTICS CHAR
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_NCHAR_CONV_EXCP FALSE
NLS_NUMERIC_CHARACTERS ,.
NLS_RDBMS_VERSION 11.2.0.3.0
NLS_SORT GERMAN
NLS_TERRITORY GERMANY
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF
NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR

Hope it helps.
​

[Ralph Waldenmaier]

Hi Nagappan,
Thank you for providing these details.
Based on them I have tried to reproduce the issue on my site with exactly the same NLS settings as provided but I was not able to reproduce the reported issue.

The only difference I see for the moment is that I was using the latest version of Telerik Data Access.
Is it possible for you to give the latest version a try and see if the issues still exists after the upgrade?

Hope this helps.
Feel free to ask in case you have any other question.

Regards,
Ralph Waldenmaier
Telerik