This is a migrated thread and some comments may be shown as answers.

Telerik ORM with sql server 2012

5 Answers 169 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Chinthaka
Top achievements
Rank 1
Chinthaka asked on 16 Nov 2012, 01:07 PM
In development we use Telerik-OpenAccess-ORM-2011.2.713.3 and sql server 2008 R2,
Its working fine,
but we want to host the product with sql server 2012,
But it gives an error and not working in all domain models.
saying invalid sql version
we run the telerik patch for 2012 but no luck yet..

is anyone can help??

5 Answers, 1 is accepted

Sort by
0
Ady
Telerik team
answered on 20 Nov 2012, 02:50 PM
Hello Chinthaka,

Can you provide me with more information about the error you get? When do you get this error - runtime or designtime? What is the exception message and call stack? Can you provide the exact steps to reproduce this exception?

Greetings,
Ady
the Telerik team
Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
0
Chinthaka
Top achievements
Rank 1
answered on 21 Nov 2012, 05:20 AM
Hi Ady thanx for the reply
   I'm getting a run time error.
Telerik.OpenAccess.Exceptions.MetadataException was unhandled
  Message=The metadata for field '_gUOrderID' of class 'OpenAccessModel1.Ord_OrderHeader' cannot be initialized: SQLDriver not initialized with server version.
  Source=Telerik.OpenAccess
  CanRetry=true
  ClassName=OpenAccessModel1.Ord_OrderHeader
  Column=0
  ErrorId=0
  FieldName=_gUOrderID
  IsWarning=false
  Line=0
  StackTrace:
       at Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e)
       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.PersistenceManagerFactoryImp..ctor(PropertySet properties, Object classloader)
       at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.getPersistenceManagerFactory(PropertySet props)
       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.GetObjectScope(TransactionProvider provider)
       at Telerik.OpenAccess.Database.GetObjectScope(TransactionProvider provider)
       at Telerik.OpenAccess.OpenAccessContextBase.GetScope()
       at Telerik.OpenAccess.OpenAccessContext.GetAll[T]()
       at OpenAccessModel1.EntitiesModel.get_Ord_OrderHeaders() in E:\New Folder\local\TESTORM\ConsoleApplication1\OpenAccessModel1\EntitiesModel.cs:line 55
       at ConsoleApplication1.testCls.testmethod(Decimal GUOrder) in E:\New Folder\local\TESTORM\ConsoleApplication1\ConsoleApplication1\testCls.cs:line 14
       at ConsoleApplication1.Program.Main(String[] args) in E:\New Folder\local\TESTORM\ConsoleApplication1\ConsoleApplication1\Program.cs:line 15
       at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
       at System.AppDomain.nExecuteAssembly(RuntimeAssembly assembly, String[] args)
       at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
       at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
       at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading.ThreadHelper.ThreadStart()
  InnerException: System.InvalidOperationException
       Message=SQLDriver not initialized with server version.
       Source=Telerik.OpenAccess.Runtime
       StackTrace:
            at OpenAccessRuntime.Relational.sql.SqlDriver.get_ExtensionName()
            at OpenAccessRuntime.Relational.RelationalMetaDataBuilder.findMatchingJdbcColumn(DataObjectsExtension[] nested)
            at OpenAccessRuntime.Relational.RelationalMetaDataBuilder.createColumn(DataObjectsExtension[] nested, String fieldName, Class javaType, String oType, Boolean secondaryTable)
            at OpenAccessRuntime.Relational.RelationalMetaDataBuilder.createJdbcSimpleField(FieldMetaData fmd)
            at OpenAccessRuntime.Relational.RelationalMetaDataBuilder.createJdbcField(FieldMetaData fmd, Boolean quietParam)
       InnerException:
0
Ady
Telerik team
answered on 23 Nov 2012, 10:17 AM
Hello Chinthaka,

 As mentioned in a previous post you need to download the latest version of the product and not the SDK. Do let me know if that helps

All the best,
Ady
the Telerik team
Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
0
Chinthaka
Top achievements
Rank 1
answered on 23 Nov 2012, 10:26 AM
Hi ady,
            Thanx for the help, Its working now in the development machines.

        still we are having a problem with the servers , where we host our application, we installed the latest what you mentioned.then it search for the earlier dlls.look like we need to host again a newer build version,
any way thanks for the help.


0
Ivailo
Telerik team
answered on 27 Nov 2012, 01:36 PM
Hello Chinthaka,

Just one detail about upgrading your deployment servers. You have to build again your applications using the new OpenAccess assemblies, but you don't have to install OpenAccess on the actual servers.

Here you can find more information about updating the assemblies and you can also take a look at this article for some deployment advises.

Let us know if you have any questions.
 

Greetings,
Ivailo
the Telerik team
Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
Tags
Databases and Data Types
Asked by
Chinthaka
Top achievements
Rank 1
Answers by
Ady
Telerik team
Chinthaka
Top achievements
Rank 1
Ivailo
Telerik team
Share this question
or