Error in SoriaCarRental Web Application in Data Access, formerly OpenAccess ORM Getting Started

inanc

17 posts

Member since:
Mar 2009

Posted 03 Dec 2009 Link to this post

We have bought newest version of OpenAccess ORM last week.Version 2009.3.1119.2. I am working on Windows 7.
I've download the c# version of Sofia Car Rental application form your code library. I 've created the related database by using the db script supplied by you in the code package.

But it is impossible to see the application runnig. I ve an error like:
Exception of type 'Telerik.OpenAccess.SPI.Util.QueryExceptionHelper' was thrown. I've looked everywhere. I found a forum topic sent on May 5. It says that:

The problem occurs because the RadGrid is always reporting null as old values per default. This leads to a comparison from null to "" which is false and generates the exception. This has been fixed now.

To get a working application immediately you should specify ConvertEmptyStringToNull=false in all your editable grid columns.

<telerik:GridBoundColumn DataField="Name" HeaderText="Name"
SortExpression="Name" UniqueName="Name" ConvertEmptyStringToNull=false>
</telerik:GridBoundColumn>

But that was not worked for me..any idea?

inanc

17 posts

Member since:
Mar 2009

Posted 03 Dec 2009 Link to this post

And same error with Northwind Database

Exception of type 'Telerik.OpenAccess.SPI.Util.QueryExceptionHelper' was thrown.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Telerik.OpenAccess.SPI.Util.QueryExceptionHelper: Exception of type 'Telerik.OpenAccess.SPI.Util.QueryExceptionHelper' was thrown.

Source Error:


            Line 34:         ddlCategory.DataTextField = "CategoryName";
Line 35:         ddlCategory.DataValueField = "CategoryID";
Line 36: ddlCategory.DataBind();Line 37:       }
Line 38:     }

Source File: C:\Users\iakcan.TSE\Desktop\OpenAccessCourseware_Projects\OpenAccessProjects\3_OpenAccessInApplications\3_MyWebApp\Default.aspx.cs Line: 36

Stack Trace:


            [QueryExceptionHelper: Exception of type 'Telerik.OpenAccess.SPI.Util.QueryExceptionHelper' was thrown.]

[QueryException: line 1:1: unexpected token: ["DEFINE",<42>,line=1,col=1]
Original Query: DEFINE EXTENT xt FOR Model.Category; SELECT * FROM xt AS this]
   Telerik.OpenAccess.SPI.Backends.ThrowException(Exception e) +28
   Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +34
   OpenAccessRuntime.storagemanager.logging.LoggingStorageManager.compileQuery(ImmutableQueryDetails query) +239
   OpenAccessRuntime.DataObjects.OpenAccessQueryImp.compile() +106
   Telerik.OpenAccess.RT.QueryImpl.Compile() +34
   Telerik.OpenAccess.RT.QueryImpl.Execute(Object[] args) +91
   Telerik.OpenAccess.RT.DataSource.OpenAccessDataSourceView.ExecuteOqlQuery(IQuery oqlQuery, Object[] queryArguments, Int32 startRowIndex, Int32 maximumRows) +136
   Telerik.OpenAccess.RT.DataSource.OpenAccessDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1206
   System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +95
   System.Web.UI.WebControls.ListControl.PerformSelect() +34
   System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
   MyWebApp._Default.Page_Load(Object sender, EventArgs e) in C:\Users\iakcan.TSE\Desktop\OpenAccessCourseware_Projects\OpenAccessProjects\3_OpenAccessInApplications\3_MyWebApp\Default.aspx.cs:36
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Same error observed in both 32 bit XP and 64 bit Windows 7.
Any clue?
Thanks

inanc

17 posts

Member since:
Mar 2009

Posted 03 Dec 2009 Link to this post

There is nobody having the same problem? I did not even try to code something related with my own job. These were both from Telerik's getting started samples and unfortunately none of them seem to be working.

I could not get started to work with OA for three days. OA did not made life much easier for me.
THESE ARE GETTING STARTED samples by Telerik! No idea?

PetarP

Admin

754 posts

Posted 04 Dec 2009 Link to this post

Hello inanc,

We downloaded the sample from our Code library and checked it carefully. Everything is working fine on our side. Are you sure you did not change something in the project after you download it? Maybe you have modified the database? The option for converting EmptyStringToNull you mentioned in one of your previous posts is used to specify how an empty string on the database will be treated. Can you please open a support ticket and attach your database and your project so that we can locate the problem and assist you in the best possible way as we are not able to reproduce it. Thank you in advance for your cooperation.

Best wishes,
Petar
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

inanc

17 posts

Member since:
Mar 2009

Posted 12 Dec 2009 Link to this post

Finally, after struggling desperately for 2 weeks, I found the reason.

I am using windows 7 X64. I tried every operating sistem including 2003 server , XP X64,XP X32, Vista..
It says always the same stupid thing:

Exception of type 'Telerik.OpenAccess.SPI.Util.QueryExceptionHelper' was thrown.

And at the end one night at 03:00 I tried another combination.Everybody can use that ORM, why can't only I? At least telerik says :
We have no problem at our side. Everything is working like a well lubricated old tick tack clock!
I tried to change my regional settings for Windows 7 (X64) from Control Panel. I set datetime, money and number formats for English (United States). And I did not touch anything else! Just rebuilt the solution..and It works! Finally I could see the products of Northwind DB on my screen!But when I set region and language format back to Turkish, I see the same stupid error:

Exception of type 'Telerik.OpenAccess.SPI.Util.QueryExceptionHelper' was thrown.

The reason is horrible! This is telerik like 'This is Sparta!'. How could it be?
Dear Telerik team! How could it be? This is not subsonic for free! This is a telerik premium bunch for $1300!
How could it be? It took 15 days to understand what is going on! And now I wonder if I can use that ORM in my country with my regional settings for Turkish..

Can I use telerik ORM with my regional settings for Turkish please? Can I please?

Telerik ORM really made my last two weeks.Thank you!

PetarP

Admin

754 posts

Posted 14 Dec 2009 Link to this post

Hello inanc,

We are terribly sorry for your bad start. Currently we have some problems with the globalization settings but I can assure you that we are working as we speak on solving them.

We, at Telerik, are always trying to provide the best products, as well as top notch support for You, our customers. That is why we are really upset with this issue and we will address it with highest priority. You are right that problems like this should never happen in Telerik's product and we will do our best to reassure that such issues will never arise again.

Please find your Telerik Points updated for bringing those issues to our attention.

Sincerely yours,
Petar
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.