#1  
Old 20th June 2011, 11:54 PM
David Guest
 
Posts: n/a
Default Possible Problem ....

I am developing a simple ado.net asp.net webapplication with the most
current version of Delphi Prism.

In my development VM, the project is working perfectly.

In my production environment, it fails with the following NXServer Log
Entry:

Time: [351785703] 6/20/2011 7:03:01 AM
ExceptionInfo: nil
Exception: EnxInternalSQLException
Message: Syntax error at line 1 pos 1: #B, #I, #L, #OPT, #S, #T, #V,
'(', ';', <eof>, <identifier>, <quoted_name>, <quoted_temp_name>, ALTER,
ASSERT, BEGIN, CALL, CLOSE, COMMIT, CREATE, DECLARE, DELETE, DISABLE,
DROP, ENABLE, EXECUTE, FETCH, IF, INSERT, ITERATE, LEAVE, LOGMESSAGE,
OPEN, REPEAT, RETURN, ROLLBACK, SELECT, SET, SIGNAL, START, TABLE, TRY,
UPDATE, USE or WHILE expected: %
Filesize: 7772672
Filedate: 2011-01-26 14:28:00
Computer: PDCNEXUSDBS1
User: nexusdb
ThreadID: 4240
ProcessID: 2424
Version: 3.07
Client: D:\Nexusdb\Bin\nxServer.Exe;Size:7772672;Date:2011-01-26
14:28:00;Computer:PDCNEXUSDBS1;User:nexusdb
SessionID: 928213328
Connected From: 127.0.0.1:2000
Query:
%23T+10000%0a%0d+SELECT+*+FROM+%22BedTypes%22%0d%0 aorder+by+%22Model%22

--------------------------------------------------------------
Callstack (Frames):
[006EC661] nxsqlEngine.TnxSqlStatement.sqsParseQuery (Line 786,
"nxSqlEngine.pas")
[006EBC7F] nxsqlEngine.TnxSqlStatement.ssPrepare (Line 615,
"nxSqlEngine.pas")
[00621CB9] nxsrServerEngine.TnxServerDatabase.sdStatementExec Direct
(Line 5794, "nxsrServerEngine.pas")
[00623AD5] nxsrServerEngine.TnxServerDatabase.StatementExecDi rect (Line
6518, "nxsrServerEngine.pas")
[008329A2]
nxchCommandHandler.TnxServerCommandHandler.nmDatab aseStatementExecDirect
(Line 4432, "nxchCommandHandler.pas")
[0081FB35] nxchCommandHandler.TnxServerCommandHandler.bchProc ess (Line
609, "nxchCommandHandler.pas")
[005508AA] nxllTransport.TnxBaseTransport.btProcess (Line 1815,
"nxllTransport.pas")
[006469A2]
nxptBasePooledTransport.TnxBasePooledTransport.btP ayloadReceived (Line
3019, "nxptBasePooledTransport.pas")
[0064666B]
nxptBasePooledTransport.TnxBasePooledTransport.btM essageReceived (Line
2901, "nxptBasePooledTransport.pas")
[0064E34D] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed
(Line 632, "nxtwWinsockTransport.pas")
[0064E2B4] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed
(Line 611, "nxtwWinsockTransport.pas")
[0064466A] nxptBasePooledTransport.TnxBaseServerThread.InnerE xecute
(Line 2052, "nxptBasePooledTransport.pas")
[0054C81C] nxllThread.TnxInitThread.DoExecute (Line 643, "nxllThread.pas")
[0054C5B3] nxllThread.TnxThread.Execute (Line 447, "nxllThread.pas")
[004605A6] Classes.ThreadProc
[00407DB8] System.ThreadWrapper
================================================== ============

The SQL statement involved is very simple: Select * from Bedtypes

The only difference between the two systems is that I am running the
nxserver 3.08 in my development VM and 3.07 in my production computer.

The Webapplication is compiled. Although it was compiled in Oxygene, I
changed the language in the aspx pages to C# because I do not have the
oxidizer command line compiler installed properly on the development
computer. However, that should not make any diffference, in that the
webapplication is pre compiled.

thanks for any help and insight...
  #2  
Old 21st June 2011, 12:23 AM
David Guest
 
Posts: n/a
Default Re: Possible Problem ....

Here is the message I get in my browser when the error occurs:

Server Error in '/' Application.

Error: Error: NexusDB: <unnamed TnxQuery instance>: Query preparation
failed:
Syntax error at line 1 pos 1: #B, #I, #L, #OPT, #S, #T, #V, '(', ';',
<eof>, <identifier>, <quoted_name>, <quoted_temp_name>, ALTER, ASSERT,
BEGIN, CALL, CLOSE, COMMIT, CREATE, DECLARE, DELETE, DISABLE, DROP,
ENABLE, EXECUTE, FETCH, IF, INSERT, ITERATE, LEAVE, LOGMESSAGE, OPEN,
REPEAT, RETURN, ROLLBACK, SELECT, SET, SIGNAL, START, TABLE, TRY,
UPDATE, USE or WHILE expected: %

[$3CA0/15520]

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: System.Exception: Error: Error: NexusDB: <unnamed
TnxQuery instance>: Query preparation failed:
Syntax error at line 1 pos 1: #B, #I, #L, #OPT, #S, #T, #V, '(', ';',
<eof>, <identifier>, <quoted_name>, <quoted_temp_name>, ALTER, ASSERT,
BEGIN, CALL, CLOSE, COMMIT, CREATE, DECLARE, DELETE, DISABLE, DROP,
ENABLE, EXECUTE, FETCH, IF, INSERT, ITERATE, LEAVE, LOGMESSAGE, OPEN,
REPEAT, RETURN, ROLLBACK, SELECT, SET, SIGNAL, START, TABLE, TRY,
UPDATE, USE or WHILE expected: %

[$3CA0/15520]

Source Error:

An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:


[Exception: Error: Error: NexusDB: <unnamed TnxQuery instance>: Query
preparation failed:
Syntax error at line 1 pos 1: #B, #I, #L, #OPT, #S, #T, #V, '(', ';',
<eof>, <identifier>, <quoted_name>, <quoted_temp_name>, ALTER, ASSERT,
BEGIN, CALL, CLOSE, COMMIT, CREATE, DECLARE, DELETE, DISABLE, DROP,
ENABLE, EXECUTE, FETCH, IF, INSERT, ITERATE, LEAVE, LOGMESSAGE, OPEN,
REPEAT, RETURN, ROLLBACK, SELECT, SET, SIGNAL, START, TABLE, TRY,
UPDATE, USE or WHILE expected: %

[$3CA0/15520]]
NexusDB.ADOProvider.NxDatasetProxy.Execute(Int64 nxStatementID,
String sCmd, Int32 TimeOut, NxDataset& resultset, Boolean readBlobs,
UInt32 BufferSize, NxParameterCollection& parameters, NxBaseConnection
conn) +294
NexusDB.ADOProvider.NxCommand.InternalExecuteReade r(CommandBehavior
behavior) +626
NexusDB.ADOProvider.NxCommand.ExecuteDbDataReader( CommandBehavior
behavior) +54

System.Data.Common.DbCommand.System.Data.IDbComman d.ExecuteReader(CommandBehavior
behavior) +10
System.Data.Common.DbDataAdapter.FillInternal(Data Set dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +143
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +140
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String
srcTable) +91

System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectArguments
arguments) +1515
System.Web.UI.DataSourceView.Select(DataSourceSele ctArguments
arguments, DataSourceViewSelectCallback callback) +17
DevExpress.Web.ASPxClasses.Internal.DataHelper.Per formSelect() +207
DevExpress.Web.ASPxGridView.GridViewDataHelper.Per formSelect() +302
DevExpress.Web.ASPxClasses.Internal.DataContainer. PerformSelect() +135
DevExpress.Web.ASPxClasses.ASPxDataWebControlBase. DataBindCore() +15
DevExpress.Web.ASPxClasses.ASPxDataWebControlBase. DataBindInternal()
+111
DevExpress.Web.ASPxClasses.ASPxWebControl.DataBind () +40
DevExpress.Web.ASPxGridView.ASPxGridView.DataBind( ) +178

DevExpress.Web.ASPxClasses.Internal.DataHelperBase .EnsureDataBound(Boolean
ensureChildControls) +98
DevExpress.Web.ASPxClasses.Internal.DataContainer. EnsureDataBound() +140

DevExpress.Web.ASPxClasses.ASPxDataWebControlBase. OnPreRender(EventArgs
e) +22
System.Web.UI.Control.PreRenderRecursiveInternal() +134
System.Web.UI.Control.PreRenderRecursiveInternal() +204
System.Web.UI.Control.PreRenderRecursiveInternal() +204
System.Web.UI.Control.PreRenderRecursiveInternal() +204
System.Web.UI.Control.PreRenderRecursiveInternal() +204
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6878

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET
Version:4.0.30319.1
  #3  
Old 21st June 2011, 01:14 AM
John Turner
 
Posts: n/a
Default Re: Possible Problem ....

David,

I wonder if Hannes is back yet.

John
> I am developing a simple ado.net asp.net webapplication with the most
> current version of Delphi Prism.
>
> In my development VM, the project is working perfectly.
>
> In my production environment, it fails with the following NXServer Log
> Entry:
>
> Time: [351785703] 6/20/2011 7:03:01 AM
> ExceptionInfo: nil
> Exception: EnxInternalSQLException
> Message: Syntax error at line 1 pos 1: #B, #I, #L, #OPT, #S, #T, #V,
> '(', ';', <eof>, <identifier>, <quoted_name>, <quoted_temp_name>, ALTER,
> ASSERT, BEGIN, CALL, CLOSE, COMMIT, CREATE, DECLARE, DELETE, DISABLE,
> DROP, ENABLE, EXECUTE, FETCH, IF, INSERT, ITERATE, LEAVE, LOGMESSAGE,
> OPEN, REPEAT, RETURN, ROLLBACK, SELECT, SET, SIGNAL, START, TABLE, TRY,
> UPDATE, USE or WHILE expected: %
> Filesize: 7772672
> Filedate: 2011-01-26 14:28:00
> Computer: PDCNEXUSDBS1
> User: nexusdb
> ThreadID: 4240
> ProcessID: 2424
> Version: 3.07
> Client: D:\Nexusdb\Bin\nxServer.Exe;Size:7772672;Date:2011-01-26
> 14:28:00;Computer:PDCNEXUSDBS1;User:nexusdb
> SessionID: 928213328
> Connected From: 127.0.0.1:2000
> Query:
> %23T+10000%0a%0d+SELECT+*+FROM+%22BedTypes%22%0d%0 aorder+by+%22Model%22
>
> --------------------------------------------------------------
> Callstack (Frames):
> [006EC661] nxsqlEngine.TnxSqlStatement.sqsParseQuery (Line 786,
> "nxSqlEngine.pas")
> [006EBC7F] nxsqlEngine.TnxSqlStatement.ssPrepare (Line 615,
> "nxSqlEngine.pas")
> [00621CB9] nxsrServerEngine.TnxServerDatabase.sdStatementExec Direct
> (Line 5794, "nxsrServerEngine.pas")
> [00623AD5] nxsrServerEngine.TnxServerDatabase.StatementExecDi rect (Line
> 6518, "nxsrServerEngine.pas")
> [008329A2]
> nxchCommandHandler.TnxServerCommandHandler.nmDatab aseStatementExecDirect
> (Line 4432, "nxchCommandHandler.pas")
> [0081FB35] nxchCommandHandler.TnxServerCommandHandler.bchProc ess (Line
> 609, "nxchCommandHandler.pas")
> [005508AA] nxllTransport.TnxBaseTransport.btProcess (Line 1815,
> "nxllTransport.pas")
> [006469A2]
> nxptBasePooledTransport.TnxBasePooledTransport.btP ayloadReceived (Line
> 3019, "nxptBasePooledTransport.pas")
> [0064666B]
> nxptBasePooledTransport.TnxBasePooledTransport.btM essageReceived (Line
> 2901, "nxptBasePooledTransport.pas")
> [0064E34D] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed
> (Line 632, "nxtwWinsockTransport.pas")
> [0064E2B4] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed
> (Line 611, "nxtwWinsockTransport.pas")
> [0064466A] nxptBasePooledTransport.TnxBaseServerThread.InnerE xecute
> (Line 2052, "nxptBasePooledTransport.pas")
> [0054C81C] nxllThread.TnxInitThread.DoExecute (Line 643, "nxllThread.pas")
> [0054C5B3] nxllThread.TnxThread.Execute (Line 447, "nxllThread.pas")
> [004605A6] Classes.ThreadProc
> [00407DB8] System.ThreadWrapper
> ================================================== ============
>
> The SQL statement involved is very simple: Select * from Bedtypes
>
> The only difference between the two systems is that I am running the
> nxserver 3.08 in my development VM and 3.07 in my production computer.
>
> The Webapplication is compiled. Although it was compiled in Oxygene, I
> changed the language in the aspx pages to C# because I do not have the
> oxidizer command line compiler installed properly on the development
> computer. However, that should not make any diffference, in that the
> webapplication is pre compiled.
>
> thanks for any help and insight...


  #4  
Old 21st June 2011, 02:19 AM
David Guest
 
Posts: n/a
Default Re: Possible Problem ....

On 6/20/2011 9:14 AM, John Turner wrote:
> David,
>
> I wonder if Hannes is back yet.
>
> John
>> I am developing a simple ado.net asp.net webapplication with the most
>> current version of Delphi Prism.
>>
>> In my development VM, the project is working perfectly.
>>
>> In my production environment, it fails with the following NXServer Log
>> Entry:
>>
>> Time: [351785703] 6/20/2011 7:03:01 AM
>> ExceptionInfo: nil
>> Exception: EnxInternalSQLException
>> Message: Syntax error at line 1 pos 1: #B, #I, #L, #OPT, #S, #T, #V,
>> '(', ';', <eof>, <identifier>, <quoted_name>, <quoted_temp_name>, ALTER,
>> ASSERT, BEGIN, CALL, CLOSE, COMMIT, CREATE, DECLARE, DELETE, DISABLE,
>> DROP, ENABLE, EXECUTE, FETCH, IF, INSERT, ITERATE, LEAVE, LOGMESSAGE,
>> OPEN, REPEAT, RETURN, ROLLBACK, SELECT, SET, SIGNAL, START, TABLE, TRY,
>> UPDATE, USE or WHILE expected: %
>> Filesize: 7772672
>> Filedate: 2011-01-26 14:28:00
>> Computer: PDCNEXUSDBS1
>> User: nexusdb
>> ThreadID: 4240
>> ProcessID: 2424
>> Version: 3.07
>> Client: D:\Nexusdb\Bin\nxServer.Exe;Size:7772672;Date:2011-01-26
>> 14:28:00;Computer:PDCNEXUSDBS1;User:nexusdb
>> SessionID: 928213328
>> Connected From: 127.0.0.1:2000
>> Query:
>> %23T+10000%0a%0d+SELECT+*+FROM+%22BedTypes%22%0d%0 aorder+by+%22Model%22
>>
>> --------------------------------------------------------------
>> Callstack (Frames):
>> [006EC661] nxsqlEngine.TnxSqlStatement.sqsParseQuery (Line 786,
>> "nxSqlEngine.pas")
>> [006EBC7F] nxsqlEngine.TnxSqlStatement.ssPrepare (Line 615,
>> "nxSqlEngine.pas")
>> [00621CB9] nxsrServerEngine.TnxServerDatabase.sdStatementExec Direct
>> (Line 5794, "nxsrServerEngine.pas")
>> [00623AD5] nxsrServerEngine.TnxServerDatabase.StatementExecDi rect (Line
>> 6518, "nxsrServerEngine.pas")
>> [008329A2]
>> nxchCommandHandler.TnxServerCommandHandler.nmDatab aseStatementExecDirect
>> (Line 4432, "nxchCommandHandler.pas")
>> [0081FB35] nxchCommandHandler.TnxServerCommandHandler.bchProc ess (Line
>> 609, "nxchCommandHandler.pas")
>> [005508AA] nxllTransport.TnxBaseTransport.btProcess (Line 1815,
>> "nxllTransport.pas")
>> [006469A2]
>> nxptBasePooledTransport.TnxBasePooledTransport.btP ayloadReceived (Line
>> 3019, "nxptBasePooledTransport.pas")
>> [0064666B]
>> nxptBasePooledTransport.TnxBasePooledTransport.btM essageReceived (Line
>> 2901, "nxptBasePooledTransport.pas")
>> [0064E34D] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed
>> (Line 632, "nxtwWinsockTransport.pas")
>> [0064E2B4] nxtwWinsockTransport.TnxWinsockServerConnection.Io Completed
>> (Line 611, "nxtwWinsockTransport.pas")
>> [0064466A] nxptBasePooledTransport.TnxBaseServerThread.InnerE xecute
>> (Line 2052, "nxptBasePooledTransport.pas")
>> [0054C81C] nxllThread.TnxInitThread.DoExecute (Line 643,
>> "nxllThread.pas")
>> [0054C5B3] nxllThread.TnxThread.Execute (Line 447, "nxllThread.pas")
>> [004605A6] Classes.ThreadProc
>> [00407DB8] System.ThreadWrapper
>> ================================================== ============
>>
>> The SQL statement involved is very simple: Select * from Bedtypes
>>
>> The only difference between the two systems is that I am running the
>> nxserver 3.08 in my development VM and 3.07 in my production computer.
>>
>> The Webapplication is compiled. Although it was compiled in Oxygene, I
>> changed the language in the aspx pages to C# because I do not have the
>> oxidizer command line compiler installed properly on the development
>> computer. However, that should not make any diffference, in that the
>> webapplication is pre compiled.
>>
>> thanks for any help and insight...

>



Perhaps Eivind might be able to provide some insight....if Hannes is not
back at work ....
  #5  
Old 21st June 2011, 04:02 AM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Possible Problem ....

David Guest wrote:

> I am developing a simple ado.net asp.net webapplication with the most current
> version of Delphi Prism.
>
> In my development VM, the project is working perfectly.


> Query: %23T+10000%0a%0d+SELECT+*+FROM+%22BedTypes%22%0d%0 aorder+by+%22Model%22


That does NOT look like a valid SQL query to me.

Somewhere along the way the query gets mangled as if it was part of a URL.
  #6  
Old 21st June 2011, 05:32 AM
David Guest
 
Posts: n/a
Default Re: Possible Problem ....

On 6/20/2011 12:02 PM, Thorsten Engler [NDA] wrote:
> David Guest wrote:
>
>> I am developing a simple ado.net asp.net webapplication with the most current
>> version of Delphi Prism.
>>
>> In my development VM, the project is working perfectly.

>
>> Query: %23T+10000%0a%0d+SELECT+*+FROM+%22BedTypes%22%0d%0 aorder+by+%22Model%22

>
> That does NOT look like a valid SQL query to me.
>
> Somewhere along the way the query gets mangled as if it was part of a URL.



The ascii puncuation characters, # and " are shown as a % followed by
the ascii value.

In the source, the sql is

#T 10000 Select * from "Bedtypes" order by "Model"

which, as I said works just fine in the test VM....

baffled...
  #7  
Old 21st June 2011, 05:42 AM
David Guest
 
Posts: n/a
Default Re: Possible Problem ....

Here is the aspx definition of the select command:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$
ConnectionStrings:BedInventoryConnectionString %>"
ProviderName="<%$
ConnectionStrings:BedInventoryConnectionString.Pro viderName %>"
SelectCommand="SELECT * FROM &quot;BedTypes&quot;
order by &quot;Model&quot;"></asp:SqlDataSource>

I don't know where the #T 10000 comes from. I don't know how to specify
or kill the timeout interval for an ADO.NET inquiry....

  #8  
Old 21st June 2011, 01:21 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Possible Problem ....

David Guest wrote:

> The ascii puncuation characters, # and " are shown as a % followed by the
> ascii value.
>
> In the source, the sql is
>
> #T 10000 Select * from "Bedtypes" order by "Model"
>
> which, as I said works just fine in the test VM....
>
> baffled...


The string, as displayed under "Query:" is what arrived at the SQL engine.

The SQL engine is not designed to handle URL encoded query string.

As I stated before: Somewhere between your source and the SQL engine, the
string is being URL encoded. Obviously that gives the SQL parser a severe case
of indigestion.

If that is a problem somewhere in our code or in your code I can't say at the
moment. Hannes will probably need to have a look at this.
  #9  
Old 22nd June 2011, 11:15 PM
David Guest
 
Posts: n/a
Default Re: Possible Problem ....

On 6/20/2011 9:21 PM, Thorsten Engler [NDA] wrote:
> David Guest wrote:
>
>> The ascii puncuation characters, # and " are shown as a % followed by the
>> ascii value.
>>
>> In the source, the sql is
>>
>> #T 10000 Select * from "Bedtypes" order by "Model"
>>
>> which, as I said works just fine in the test VM....
>>
>> baffled...

>
> The string, as displayed under "Query:" is what arrived at the SQL engine.
>
> The SQL engine is not designed to handle URL encoded query string.
>
> As I stated before: Somewhere between your source and the SQL engine, the
> string is being URL encoded. Obviously that gives the SQL parser a severe case
> of indigestion.
>
> If that is a problem somewhere in our code or in your code I can't say at the
> moment. Hannes will probably need to have a look at this.

When is Hannes returning?
  #10  
Old 22nd June 2011, 11:41 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Possible Problem ....

David Guest wrote:

> > If that is a problem somewhere in our code or in your code I can't say at
> > the moment. Hannes will probably need to have a look at this.

> When is Hannes returning?


What do you mean with returning?


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +11. The time now is 07:51 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.