Xtensive.Orm.SyntaxErrorException:

Error 'SyntaxError' while executing query 'SELECT [a].[Id], 160 AS [TypeId], [a].[Code], [a].[MainMacro], [a].[Salutation.Id], [a].[AgeSalutation.Id], [a].[Title.Id], [a].[SalutationTitleRuleType.Id], [a].[IsUserValue], [a].[IsDeleted] FROM [SalutationTitleRule] [a];\r\nSELECT [a].[CultureName], [a].[Target.Id], [a].[TypeId], [a].[Macro] FROM (SELECT [b].[CultureName], [b].[Target.Id], 161 AS [TypeId], [b].[Macro] FROM [SalutationTitleRuleLocalization] [b]) [a] WHERE ([a].[CultureName] = @p0_0_0_0 AND [a].[Target.Id] = @p0_0_0_1); [p0_0_0_0='en-US';p0_0_0_1='874']'. Original message: There was an error parsing the query. [ Token line number = 2,Token line offset = 1,Token in error = SELECT ]

StackTrace:

  • System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
  • System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
  • System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
  • System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
  • System.Data.Common.DbCommand.ExecuteReader()
  • Xtensive.Storage.Providers.Sql.Driver.ExecuteReader(Session session, DbCommand command)

The exception occurs only with SqlServerCe-Provider (not Memory- or SqlServer-Provider)

Kind Regards

asked Jun 01 '11 at 06:29

TeaMan's gravatar image

TeaMan
140141418

Hello Teaman,

Am I right saying that the error was absent in 4.4 build 7249?

(Jun 01 '11 at 07:18) Dmitri Maximov Dmitri%20Maximov's gravatar image

Hello Dmitri,

yes, there was no error in 4.4 build 7249.

(Jun 01 '11 at 07:48) TeaMan TeaMan's gravatar image

According to the exception text, the provider tries executing 2 statements in a batch, but SQL Server CE doesn't support such a feature. I'll investigate the reasons of that behavior, fix it and notify when I'm done.

(Jun 01 '11 at 08:03) Dmitri Maximov Dmitri%20Maximov's gravatar image

One Answer:

Teaman,

Try using nightly build 7589, the binaries are available on the website.

answered Jun 07 '11 at 09:16

Dmitri%20Maximov's gravatar image

Dmitri Maximov
22111211

Hello Dmitri,

thanks a lot for the quick upgrade. The error is gone.

(Jun 08 '11 at 06:24) TeaMan TeaMan's gravatar image

Hello Teaman,

Thanks for confirming this. Now I'm secure =)

(Jun 08 '11 at 06:26) Dmitri Maximov Dmitri%20Maximov's gravatar image
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!
toggle preview

powered by OSQA