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

10 posts, 0 answers
  1. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 04 Aug 2011 Link to this post

    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)

  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 04 Aug 2011 Link to this post

    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

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

  3. DevCraft banner
  4. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 05 Aug 2011 Link to this post

    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
  5. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 05 Aug 2011 Link to this post

    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

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get now >>

  6. Nagappan
    Nagappan avatar
    3 posts
    Member since:
    Sep 2014

    Posted 22 Sep 2014 in reply to Thomas Link to this post

    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.
  7. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 23 Sep 2014 Link to this post

    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
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
  8. Nagappan
    Nagappan avatar
    3 posts
    Member since:
    Sep 2014

    Posted 25 Sep 2014 in reply to Ralph Waldenmaier Link to this post

    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
  9. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 26 Sep 2014 Link to this post

    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
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
  10. Nagappan
    Nagappan avatar
    3 posts
    Member since:
    Sep 2014

    Posted 29 Sep 2014 in reply to Ralph Waldenmaier Link to this post

    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.
  11. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 30 Sep 2014 Link to this post

    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
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
Back to Top
DevCraft banner