paging with sgwt 4.1 fails (but 3.1 works)

[Segmeno]

Dear SmartGWT support, users, developers,

we currently evaluating to upgrade from SmartgGWT 3.1 to 4.1.

I have the following problem and want to kindly ask, to help me with this new "behaviour".

The given code works flawlessly with 3.1:

 tariffModelSelect = new SelectItem("TariffModel", "Tariff Model");
    tariffModelSelect.setValueField("TariffModelID");
    tariffModelSelect.setDisplayField("TariffModelNameAndStatus");
    tariffModelSelect.setOptionDataSource(DataSource.getDataSource("tbTmdTariffModel"));
    final Criteria crit = new Criteria();
    crit.setAttribute("ContractVersionID", parentApp.getContractVersionID());
    crit.setAttribute("TariffModelRoleID", TariffModelRoleType.CONTRACT.getValue());
    tariffModelSelect.setOptionCriteria(crit);
    tariffModelSelect.setOptionOperationId("tariffModelOfContractVersionAndRoleWithNameAndStatus");
    tariffModelSelect.setSortField("TariffModelNameAndStatus");
    tariffModelSelect.setMultiple(Boolean.TRUE);
    tariffModelSelect.setMultipleAppearance(MultipleAppearance.PICKLIST);
    tariffModelSelect.setDefaultToFirstOption(Boolean.TRUE);

tbTmdTariffModel.ds.xml:

 <DataSource ID="tbTmdTariffModel" isPublic="true" serverType="sql" dataSourceVersion="1" dbName="CamMain" schemaName="dbo" dbTable="tbTmdTariffModel" tableName="tbTmdTariffModel">
  <fields>
   <field name="TariffModelID" type="integer" autoGenerated="true" primaryKey="true" />
   <field name="TariffStructureID" type="integer" required="true" />
   <field name="ContractVersionID" type="integer" required="true" />
   <field name="TariffModelName" title="Tariff Model" type="text" required="true" length="100" />
   <field name="TariffModelRoleID" type="integer" required="true" hidden="true" />     
   <field name="CreatedBy" hidden="true" canEdit="false" type="integer" />
   <field name="ModifiedBy" hidden="true" canEdit="false" type="integer" />
   <field name="NumErrors" canEdit="false" type="integer" required="true" />
   <field name="MissingRates" type="integer" customSelectExpression="(select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null)" />
   <field name="CurrentStatus" type="text" customSelectExpression="dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel')" />
   <field name="ExchangeStatus" type="text" customSelectExpression="dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE())" />
   <field name="ExcelCompliance" title="Excel Compliance" type="text" customSelectExpression="(SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID)" />
  </fields>
  <operationBindings>
   <operationBinding operationType="remove" allowMultiUpdate="true">
   </operationBinding>
   <operationBinding operationType="add">
    <values fieldName="CreatedBy" value="$userId" />
    <values fieldName="ModifiedBy" value="$userId" />
   </operationBinding>
   <operationBinding operationType="update">
    <values fieldName="ModifiedBy" value="$userId" />
    <values fieldName="ModifiedAt" value="$currentDate" />
   </operationBinding>
   <operationBinding operationType="fetch" operationId="tariffModelOfContractVersionAndRoleWithNameAndStatus">
    <selectClause>$defaultSelectClause, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus</selectClause>
   </operationBinding>
  </operationBindings>
 </DataSource>

The Version 4.1p generates the following SQL command, which naturally fails:

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.CreatedBy, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1097 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75

As you can see, the ORDER BY at the beginning of the statement is missing a column name.

Can you help with that, so I can push the evaluation any further?

Best Regards,
Christian

[Isomorphic]

Please try with the most recent patched version of 4.1, and remember to always specify your full version.

[Segmeno]

Hello,

for my tests I used the evaluation builds of 4.1p.

First I used the one from 2014-07-29 which had the problem I posted here. But also regularly caused an error accessing the DB.

So I randomly chose the build from 2014-07-06. Which also had the problem I posted here, but at least did not cause the DB access problem.

Now I tried the build from 2014-07-29. Which does not render parts of my application anymore (Firefox 26, Chrome 36.0.1985.125 m), especially the part causing this problem. :-(

Is there any stable build to try?

[Isomorphic]

All builds of 4.1 have to pass a suite of 10s of thousands of automated tests, including tests that ensure product samples are working as expected.

So they are all "stable" by any reasonable definition of that word, and the problems you are reporting with switching versions most likely have to do with botched installation, such as using a mixture of resources across different builds, forgetting to run a GWT compile, or forgetting to clear browser cache.

As far as the original problem happening with the latest patched build, please show the full server log for the request, and remember to always include this (it's required).

[Segmeno]

The described error created with 4.1p_2014-07-24.

The error is caused by HTTP request: /simplex/ascom/sc/IDACall?isc_rpc=1&isc_v=v9.1p_2014-07-24&isc_xhr=1

Please be not confused that the tomcat accesslogger logs this after the error is logged.

INFO  2014-07-31 14:27:24,267 com.ascom.portal.gwt.server.service.WorkflowServiceImpl - AppID 49 resolved status Approved for scope ContractVersion.FinalHoT, but workflow Fluctuation Approval requires: [Draft]
INFO  2014-07-31 14:27:24,267 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' POST 'HTTP/1.1' http /simplex/ascom/workflow.rpc 200 4.024 '380' 465
DEBUG 2014-07-31 14:27:52,800 com.ascom.portal.gwt.client.framework.GridUpdater - registering TariffModel for DataSource tbTmdTariffModel
INFO  2014-07-31 14:27:52,810 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' POST 'HTTP/1.1' http /simplex/ascom/logging.rpc 200 0.010 '285' 12
INFO  2014-07-31 14:27:52,835 SQLDriver - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Executing SQL query on 'CamMain': SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)
DEBUG 2014-07-31 14:27:52,835 SQL - executeSQL: SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1) / null / null
DEBUG 2014-07-31 14:27:53,135 SQL - executeSQL: SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647 / null / null
DEBUG 2014-07-31 14:27:53,175 SQL - executeSQL: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75 / null / null
DEBUG 2014-07-31 14:27:53,485 SQL - executeSQL: SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647 / null / null
DEBUG 2014-07-31 14:27:53,535 SQL - executeSQL: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75 / null / null
WARN  2014-07-31 14:27:53,575 RequestContext - dsRequest.execute() failed: 
java.sql.SQLException: Incorrect syntax near ')'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2992)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2425)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:672)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:2461)
	at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1879)
	at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:444)
	at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:389)
	at com.isomorphic.datasource.DataSource.execute(DataSource.java:1517)
	at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:723)
	at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
	at com.isomorphic.application.AppBase.execute(AppBase.java:491)
	at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2534)
	at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:215)
	at com.ascom.portal.gwt.server.security.SecureIDACall.handleDSRequest(SecureIDACall.java:80)
	at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:172)
	at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:137)
	at com.ascom.portal.gwt.server.security.SecureIDACall.processRequest(SecureIDACall.java:59)
	at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
	at org.apache.catalina.valves.CometConnectionManagerValve.invoke(CometConnectionManagerValve.java:186)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)
DEBUG 2014-07-31 14:27:53,585 com.ascom.portal.gwt.server.security.SecureIDACall - sent DSRequest for: datasource=tbTmdTariffModel, operationType=fetch, criteria={ContractVersionID=1012, TariffModelRoleID=1}
DEBUG 2014-07-31 14:27:53,585 com.ascom.portal.gwt.server.security.SecureIDACall - received list with 0 items (-1 items total)
INFO  2014-07-31 14:27:53,585 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' POST 'HTTP/1.1' http /simplex/ascom/sc/IDACall?isc_rpc=1&isc_v=v9.1p_2014-07-24&isc_xhr=1 200 0.775 '1505' 150
INFO  2014-07-31 14:27:53,785 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' GET 'HTTP/1.1' http /simplex/ascom/sc/skins/Enterprise/images/Dialog/warn.png 304 0.000 '-1' -

[Segmeno]

Using the newer builds I cannot get anywhere ear this, because the GUI fails. I tried to do it several times (hopefully not botching installations). Older versions work fine.

The complete server log can be given, if I am able to upload 779kb in this forum.

[Isomorphic]

As far as checking for botched installs, we provided specific advice in the previous post - please make sure you're following that procedure as you will definitely receive bizarre errors if you are not.

As far as the server log, we need the complete server log for the request, which is generally just a few KB. 779KB sounds like the complete server log from startup, and we did not request this.

As far as the partial log you've posted, it omits several key diagnostics that the framework logs by default. You may have customized your log4j.isc.config.xml file to turn off these diagnostics, but we need them enabled again in order to look into this problem.

Please note for the future that the logs as described above are always needed when asking for help with any kind of server issue.

[Segmeno]

INFO  2014-08-01 08:21:47,517 com.isomorphic.servlet.RequestContext - URL: '/simplex/ascom/logging.rpc', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding header
INFO  2014-08-01 08:21:47,517 com.isomorphic.servlet.RequestContext - URL: '/simplex/ascom/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding header
DEBUG 2014-08-01 08:21:47,518 com.ascom.portal.gwt.client.framework.GridUpdater - registering TariffModel for DataSource tbTmdTariffModel
INFO  2014-08-01 08:21:47,522 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' POST 'HTTP/1.1' http /simplex/ascom/logging.rpc 200 0.006 '285' 12
DEBUG 2014-08-01 08:21:47,536 com.isomorphic.xml.XML - Parsed XML from (in memory stream): 17ms
DEBUG 2014-08-01 08:21:47,541 com.isomorphic.rpc.RPCManager - Processing 1 requests.
DEBUG 2014-08-01 08:21:47,542 com.isomorphic.datasource.DSRequest - Caching instance 464 of DS tbTmdTariffModel from DSRequest.getDataSource()
DEBUG 2014-08-01 08:21:47,542 com.isomorphic.rpc.RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        ContractVersionID:1012,
        TariffModelRoleID:1
    },
    operationConfig:{
        dataSource:"tbTmdTariffModel",
        operationType:"fetch",
        textMatchStyle:"startsWith"
    },
    startRow:0,
    endRow:75,
    sortBy:[
        "TariffModelNameAndStatus"
    ],
    componentId:"isc_PickListMenu_0",
    appID:"builtinApplication",
    operation:"tariffModelOfContractVersionAndRoleWithNameAndStatus",
    oldValues:{
        ContractVersionID:1012,
        TariffModelRoleID:1
    }
}
INFO  2014-08-01 08:21:47,542 com.ascom.portal.gwt.server.security.SecureIDACall - Performing 1 operation(s)
DEBUG 2014-08-01 08:21:47,543 com.isomorphic.datasource.DeclarativeSecurity - Processing security checks for DataSource null, field null
DEBUG 2014-08-01 08:21:47,543 com.isomorphic.datasource.DeclarativeSecurity - DataSource tbTmdTariffModel is not in the pre-checked list, processing...
DEBUG 2014-08-01 08:21:47,543 com.isomorphic.application.AppBase - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] No userTypes defined, allowing anyone access to all operations for this application
DEBUG 2014-08-01 08:21:47,543 com.isomorphic.application.AppBase - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] No public zero-argument method named '_tariffModelOfContractVersionAndRoleWithNameAndStatus' found, performing generic datasource operation
INFO  2014-08-01 08:21:47,544 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Performing fetch operation with
	criteria: {ContractVersionID:1012,TariffModelRoleID:1}	values: {ContractVersionID:1012,TariffModelRoleID:1}
INFO  2014-08-01 08:21:47,547 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] derived query: SELECT $defaultSelectClause, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM $defaultTableClause WHERE $defaultWhereClause
DEBUG 2014-08-01 08:21:47,548 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
DEBUG 2014-08-01 08:21:47,549 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Eval'd row count query: SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)
DEBUG 2014-08-01 08:21:47,549 com.isomorphic.sql.SQLConnectionManager - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Borrowed connection '121761210'
DEBUG 2014-08-01 08:21:47,549 com.isomorphic.sql.SQLDriver - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] About to execute SQL query in 'CamMain' using connection '121761210'
INFO  2014-08-01 08:21:47,549 com.isomorphic.sql.SQLDriver - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Executing SQL query on 'CamMain': SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)
DEBUG 2014-08-01 08:21:47,549 SQL - executeSQL: SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1) / null / null
DEBUG 2014-08-01 08:21:47,595 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] DriverManager fetching connection for CamMain via jdbc url jdbc:jtds:sqlserver://192.168.72.61;databaseName=CamMain_local;language=english;user=sa;password=ascom2001!
DEBUG 2014-08-01 08:21:47,595 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Passing JDBC URL only to getConnection
DEBUG 2014-08-01 08:21:47,849 SQL - executeSQL: SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647 / null / null
DEBUG 2014-08-01 08:21:47,891 com.isomorphic.sql.SQLConnectionManager - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Borrowed UNPOOLED connection '1282563706'
DEBUG 2014-08-01 08:21:47,891 com.isomorphic.sql.SQLServerDriver - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] SQL Server version is '10.50.4000'
DEBUG 2014-08-01 08:21:47,892 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Using SQL Limit query
DEBUG 2014-08-01 08:21:47,893 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] SQL windowed select rows 0->75, result size 75. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75
DEBUG 2014-08-01 08:21:47,893 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] SQL windowed select rows 0->75, result size 75. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75
DEBUG 2014-08-01 08:21:47,894 SQL - executeSQL: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75 / null / null
DEBUG 2014-08-01 08:21:47,944 com.isomorphic.sql.SQLConnectionManager - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] About to close ISCPoolableConnection with hashcode "121761210"
DEBUG 2014-08-01 08:21:47,946 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] DriverManager fetching connection for CamMain via jdbc url jdbc:jtds:sqlserver://192.168.72.61;databaseName=CamMain_local;language=english;user=sa;password=ascom2001!
DEBUG 2014-08-01 08:21:47,946 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Passing JDBC URL only to getConnection
DEBUG 2014-08-01 08:21:48,236 SQL - executeSQL: SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647 / null / null
DEBUG 2014-08-01 08:21:48,279 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] makeObject() created a pooled Connection '1754841803'
DEBUG 2014-08-01 08:21:48,279 SQL - executeSQL: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75 / null / null
WARN  2014-08-01 08:21:48,324 com.isomorphic.servlet.RequestContext - dsRequest.execute() failed: 
java.sql.SQLException: Incorrect syntax near ')'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2992)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2425)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:672)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:2461)
	at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1879)
	at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:444)
	at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:389)
	at com.isomorphic.datasource.DataSource.execute(DataSource.java:1517)
	at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:723)
	at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
	at com.isomorphic.application.AppBase.execute(AppBase.java:491)
	at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2534)
	at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:215)
	at com.ascom.portal.gwt.server.security.SecureIDACall.handleDSRequest(SecureIDACall.java:80)
	at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:172)
	at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:137)
	at com.ascom.portal.gwt.server.security.SecureIDACall.processRequest(SecureIDACall.java:59)
	at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
	at org.apache.catalina.valves.CometConnectionManagerValve.invoke(CometConnectionManagerValve.java:186)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)
DEBUG 2014-08-01 08:21:48,325 com.ascom.portal.gwt.server.security.SecureIDACall - sent DSRequest for: datasource=tbTmdTariffModel, operationType=fetch, criteria={ContractVersionID=1012, TariffModelRoleID=1}
DEBUG 2014-08-01 08:21:48,325 com.ascom.portal.gwt.server.security.SecureIDACall - received list with 0 items (-1 items total)
DEBUG 2014-08-01 08:21:48,325 com.isomorphic.rpc.RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
DEBUG 2014-08-01 08:21:48,326 com.isomorphic.rpc.RPCManager - non-DMI response, dropExtraFields: false
DEBUG 2014-08-01 08:21:48,327 com.isomorphic.sql.SQLDriver - Freeing SQLDriver dbConnection 1754841803
DEBUG 2014-08-01 08:21:48,327 com.isomorphic.sql.SQLConnectionManager - About to close ISCPoolableConnection with hashcode "1754841803"
INFO  2014-08-01 08:21:48,328 com.isomorphic.compression.Compression - /simplex/ascom/sc/IDACall: 162 -> 150 bytes
INFO  2014-08-01 08:21:48,328 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' POST 'HTTP/1.1' http /simplex/ascom/sc/IDACall?isc_rpc=1&isc_v=v9.1p_2014-07-24&isc_xhr=1 200 0.812 '1505' 150
INFO  2014-08-01 08:21:48,587 com.isomorphic.servlet.RequestContext - URL: '/simplex/ascom/sc/skins/Enterprise/images/Dialog/warn.png', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding header
INFO  2014-08-01 08:21:48,590 com.isomorphic.download.Download - done streaming: C:/camtool/apache-tomcat-7.0.40/webapps/simplex/ascom/sc/skins/Enterprise/images/Dialog/warn.png

[Segmeno]

I recreated the error also with your latest build 4.1p 2014-08-01

INFO  2014-08-01 09:29:17,154 com.isomorphic.servlet.RequestContext - URL: '/simplex/ascom/sc/images/top-bar-gradient-medium.gif', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding header
INFO  2014-08-01 09:29:17,154 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' GET 'HTTP/1.1' http /simplex/ascom/sc/images/top-bar-gradient-medium.gif 200 0.010 '-1' 250
INFO  2014-08-01 09:29:21,265 com.isomorphic.servlet.RequestContext - URL: '/simplex/ascom/logging.rpc', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding header
DEBUG 2014-08-01 09:29:21,265 com.ascom.portal.gwt.client.framework.GridUpdater - registering TariffModel for DataSource tbTmdTariffModel
INFO  2014-08-01 09:29:21,265 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' POST 'HTTP/1.1' http /simplex/ascom/logging.rpc 200 0.000 '285' 12
INFO  2014-08-01 09:29:21,265 com.isomorphic.servlet.RequestContext - URL: '/simplex/ascom/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:26.0) Gecko/20100101 Firefox/26.0': Moz (Gecko) with Accept-Encoding header
DEBUG 2014-08-01 09:29:21,275 com.isomorphic.xml.XML - Parsed XML from (in memory stream): 10ms
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.rpc.RPCManager - Processing 1 requests.
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.datasource.DSRequest - Caching instance 464 of DS tbTmdTariffModel from DSRequest.getDataSource()
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.rpc.RPCManager - Request #1 (DSRequest) payload: {
    criteria:{
        ContractVersionID:1012,
        TariffModelRoleID:1
    },
    operationConfig:{
        dataSource:"tbTmdTariffModel",
        operationType:"fetch",
        textMatchStyle:"startsWith"
    },
    startRow:0,
    endRow:75,
    sortBy:[
        "TariffModelNameAndStatus"
    ],
    componentId:"isc_PickListMenu_0",
    appID:"builtinApplication",
    operation:"tariffModelOfContractVersionAndRoleWithNameAndStatus",
    oldValues:{
        ContractVersionID:1012,
        TariffModelRoleID:1
    }
}
INFO  2014-08-01 09:29:21,285 com.ascom.portal.gwt.server.security.SecureIDACall - Performing 1 operation(s)
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.datasource.DeclarativeSecurity - Processing security checks for DataSource null, field null
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.datasource.DeclarativeSecurity - DataSource tbTmdTariffModel is not in the pre-checked list, processing...
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.application.AppBase - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] No userTypes defined, allowing anyone access to all operations for this application
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.application.AppBase - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] No public zero-argument method named '_tariffModelOfContractVersionAndRoleWithNameAndStatus' found, performing generic datasource operation
INFO  2014-08-01 09:29:21,285 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Performing fetch operation with
	criteria: {ContractVersionID:1012,TariffModelRoleID:1}	values: {ContractVersionID:1012,TariffModelRoleID:1}
INFO  2014-08-01 09:29:21,285 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] derived query: SELECT $defaultSelectClause, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM $defaultTableClause WHERE $defaultWhereClause
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Eval'd row count query: SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.sql.SQLConnectionManager - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Borrowed connection '1737979934'
DEBUG 2014-08-01 09:29:21,285 com.isomorphic.sql.SQLDriver - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] About to execute SQL query in 'CamMain' using connection '1737979934'
INFO  2014-08-01 09:29:21,285 com.isomorphic.sql.SQLDriver - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Executing SQL query on 'CamMain': SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)
DEBUG 2014-08-01 09:29:21,285 SQL - executeSQL: SELECT COUNT(*) FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1) / null / null
DEBUG 2014-08-01 09:29:21,316 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] DriverManager fetching connection for CamMain via jdbc url jdbc:jtds:sqlserver://192.168.72.61;databaseName=CamMain_local;language=english;user=sa;password=ascom2001!
DEBUG 2014-08-01 09:29:21,316 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Passing JDBC URL only to getConnection
DEBUG 2014-08-01 09:29:21,506 SQL - executeSQL: SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647 / null / null
DEBUG 2014-08-01 09:29:21,536 com.isomorphic.sql.SQLConnectionManager - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Borrowed UNPOOLED connection '553728004'
DEBUG 2014-08-01 09:29:21,536 com.isomorphic.sql.SQLServerDriver - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] SQL Server version is '10.50.4000'
DEBUG 2014-08-01 09:29:21,536 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Using SQL Limit query
DEBUG 2014-08-01 09:29:21,536 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] SQL windowed select rows 0->75, result size 75. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75
DEBUG 2014-08-01 09:29:21,536 com.isomorphic.sql.SQLDataSource - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] SQL windowed select rows 0->75, result size 75. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75
DEBUG 2014-08-01 09:29:21,536 SQL - executeSQL: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75 / null / null
DEBUG 2014-08-01 09:29:21,566 com.isomorphic.sql.SQLConnectionManager - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] About to close ISCPoolableConnection with hashcode "1737979934"
DEBUG 2014-08-01 09:29:21,566 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] DriverManager fetching connection for CamMain via jdbc url jdbc:jtds:sqlserver://192.168.72.61;databaseName=CamMain_local;language=english;user=sa;password=ascom2001!
DEBUG 2014-08-01 09:29:21,566 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] Passing JDBC URL only to getConnection
DEBUG 2014-08-01 09:29:21,806 SQL - executeSQL: SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647 / null / null
DEBUG 2014-08-01 09:29:21,836 com.isomorphic.sql.PoolableSQLConnectionFactory - [builtinApplication.tariffModelOfContractVersionAndRoleWithNameAndStatus] makeObject() created a pooled Connection '1459920777'
DEBUG 2014-08-01 09:29:21,836 SQL - executeSQL: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY ) AS rowID FROM (SELECT TOP 100 PERCENT  tbTmdTariffModel.TariffModelID, tbTmdTariffModel.TariffStructureID, tbTmdTariffModel.ContractVersionID, tbTmdTariffModel.TariffModelName, tbTmdTariffModel.TariffModelRoleID, tbTmdTariffModel.CreatedBy, tbTmdTariffModel.ModifiedBy, tbTmdTariffModel.NumErrors, (select count(*) from tbTmdLeafProperty lp where lp.TariffModelID = tbTmdTariffModel.TariffModelID and lp.RateID is null) AS MissingRates, dbo.fnGenApprovalStatusCSV(TariffModelID, 'tbTmdTariffModel') AS CurrentStatus, dbo.fnGenGetObjectStatus('EContractTariffModel', TariffModelID, GETDATE()) AS ExchangeStatus, (SELECT Value FROM tbGenAttribute WHERE DataTable = 'tbTmdTariffModel' AND Attribute = 'ExcelCompliance' AND ObjectID = tbTmdTariffModel.TariffModelID) AS ExcelCompliance, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus FROM tbTmdTariffModel WHERE (tbTmdTariffModel.ContractVersionID=1012 AND tbTmdTariffModel.TariffModelRoleID=1)) x) y WHERE y.rowID BETWEEN 1 AND 75 / null / null
WARN  2014-08-01 09:29:21,876 com.isomorphic.servlet.RequestContext - dsRequest.execute() failed: 
java.sql.SQLException: Incorrect syntax near ')'.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2992)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2425)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:672)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427)
	at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
	at com.isomorphic.sql.SQLDataSource.executeWindowedSelect(SQLDataSource.java:2492)
	at com.isomorphic.sql.SQLDataSource.SQLExecute(SQLDataSource.java:1901)
	at com.isomorphic.sql.SQLDataSource.processRequest(SQLDataSource.java:444)
	at com.isomorphic.sql.SQLDataSource.executeFetch(SQLDataSource.java:389)
	at com.isomorphic.datasource.DataSource.execute(DataSource.java:1517)
	at com.isomorphic.application.AppBase.executeDefaultDSOperation(AppBase.java:723)
	at com.isomorphic.application.AppBase.executeAppOperation(AppBase.java:658)
	at com.isomorphic.application.AppBase.execute(AppBase.java:491)
	at com.isomorphic.datasource.DSRequest.execute(DSRequest.java:2534)
	at com.isomorphic.servlet.IDACall.handleDSRequest(IDACall.java:215)
	at com.ascom.portal.gwt.server.security.SecureIDACall.handleDSRequest(SecureIDACall.java:80)
	at com.isomorphic.servlet.IDACall.processRPCTransaction(IDACall.java:172)
	at com.isomorphic.servlet.IDACall.processRequest(IDACall.java:137)
	at com.ascom.portal.gwt.server.security.SecureIDACall.processRequest(SecureIDACall.java:59)
	at com.isomorphic.servlet.IDACall.doPost(IDACall.java:73)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
	at com.isomorphic.servlet.BaseServlet.service(BaseServlet.java:152)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.isomorphic.servlet.CompressionFilter.doFilter(CompressionFilter.java:260)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
	at org.apache.catalina.valves.CometConnectionManagerValve.invoke(CometConnectionManagerValve.java:186)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1008)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:722)
DEBUG 2014-08-01 09:29:21,876 com.ascom.portal.gwt.server.security.SecureIDACall - sent DSRequest for: datasource=tbTmdTariffModel, operationType=fetch, criteria={ContractVersionID=1012, TariffModelRoleID=1}
DEBUG 2014-08-01 09:29:21,876 com.ascom.portal.gwt.server.security.SecureIDACall - received list with 0 items (-1 items total)
DEBUG 2014-08-01 09:29:21,876 com.isomorphic.rpc.RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
DEBUG 2014-08-01 09:29:21,876 com.isomorphic.rpc.RPCManager - non-DMI response, dropExtraFields: false
DEBUG 2014-08-01 09:29:21,876 com.isomorphic.sql.SQLDriver - Freeing SQLDriver dbConnection 1459920777
DEBUG 2014-08-01 09:29:21,876 com.isomorphic.sql.SQLConnectionManager - About to close ISCPoolableConnection with hashcode "1459920777"
INFO  2014-08-01 09:29:21,876 com.isomorphic.compression.Compression - /simplex/ascom/sc/IDACall: 162 -> 150 bytes
INFO  2014-08-01 09:29:21,886 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' POST 'HTTP/1.1' http /simplex/ascom/sc/IDACall?isc_rpc=1&isc_v=v9.1p_2014-08-01&isc_xhr=1 200 0.621 '1505' 150
INFO  2014-08-01 09:29:22,066 com.isomorphic.download.Download - Returning 304: Not modified on conditional get of: C:\camtool\apache-tomcat-7.0.40\webapps\simplex\ascom\sc\skins\Enterprise\images\Dialog\warn.png
INFO  2014-08-01 09:29:22,066 AccessLog - 0:0:0:0:0:0:0:1 'chuebert' GET 'HTTP/1.1' http /simplex/ascom/sc/skins/Enterprise/images/Dialog/warn.png 304 0.000 '-1' -

[Segmeno]

Is there already any news on that issue?

[Isomorphic]

ORDER BY issue you reported is fixed now, you may download next (2014-08-07) nightly build and try it out.

[Isomorphic]

A regression report elsewhere on the forums has uncovered that the fix implemented here was incorrect. In fact, the problem here is a usage error - you are trying to sortBy a non-existent field.

tariffModelSelect.setSortField("TariffModelNameAndStatus");

Note that your DataSource does not have a field called "TariffModelNameAndStatus". A value with that column name does end up in the SQL ResultSet because of your custom selectClause, but that is not the same thing at all. If that used to work in 3.1, that was a bug - we cannot support it going forward because it is just incorrect behavior.

There are a number of "correct" ways you could fix this problem. The best way would be to use a customSelectExpression. Get rid of this custom selectClause:

<selectClause>$defaultSelectClause, tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft') AS TariffModelNameAndStatus</selectClause>

and instead declare a field like this:

<field name="TariffModelNameAndStatus" customSelectExpression="tbTmdTariffModel.TariffModelName + ' - ' + ISNULL(dbo.fnGenGetObjectStatus('TariffModel.VolumeCommitment', tbTmdTariffModel.TariffModelID, null), 'Draft')"/>

If for some reason you don't want to use customSelectExpression, you could leave your custom selectClause in place and declare a read-only field as well:

<field name="TariffModelNameAndStatus" canSave="false" />

Nightly SmartClient builds of 9.1 and greater, and SmartGWT builds of 4.1 and greater, will have this incorrect fix reverted as of tomorrow, February 5th. Therefore, you should fix this problem properly if you intend to use any 4.1 build from that date onwards.

Regards,
Isomorphic Software Support