Announcement

**claudiobosticco** · 9 Feb 2017, 03:43

SmartClient Version: SNAPSHOT_v11.1d_2017-02-09/Enterprise Development Only (built 2017-02-09)

Hello, the test case of posts #37 and #42 is fixed.

There are still wrong validation errors for the test cases of posts #36 and #34.

I'll rewrite them in another post.

**claudiobosticco** · 9 Feb 2017, 03:51

SmartClient Version: SNAPSHOT_v11.1d_2017-02-09/Enterprise Development Only (built 2017-02-09)

Chrome on OSX Sierra

(Test case equal to that of post #34)

Please modify the #fetchOperationFS sample like this:

Code:

isc.ListGrid.create({
    ID:"dsListGrid",
    width: "100%",
    height: "100%",
    minFieldWidth:80,
    autoFetchData: true,
    canEdit:true,
    dataSource: "supplyItem"
});

supplyItem.ds.xml :

Code:

<DataSource
    ID="supplyItem"
    serverType="sql"
    tableName="supplyItem"
    titleField="itemName"
    testFileName="/examples/shared/ds/test_data/supplyItem.data.xml"
    dbImportFileName="/examples/shared/ds/test_data/supplyItemLarge.data.xml"
>
    <fields>
        <field name="itemID"      type="sequence" hidden="true"       primaryKey="true"/>
        <field name="itemName"    type="text"     title="Item"        length="128"       required="true"/>
        <field name="SKU"         type="text"     title="SKU"         length="10"        required="true"/>
        <field name="description" type="text"     title="Description" length="2000">
            <validators>
                <validator type="required" dependentFields="category">
                    <applyWhen operator="and">
                        <criteria>
                            <criterion fieldName="category" operator="equals" value="Adding Machine/calculator Roll"/>
                        </criteria>
                    </applyWhen>
                </validator>
            </validators>
        </field>
        <field name="category"    type="text"     title="Category"    length="128"       required="true"
               foreignKey="supplyCategory.categoryName"/>
        <field name="units"       type="enum"     title="Units"       length="5">
            <valueMap>
                <value>Roll</value>
                <value>Ea</value>
                <value>Pkt</value>
                <value>Set</value>
                <value>Tube</value>
                <value>Pad</value>
                <value>Ream</value>
                <value>Tin</value>
                <value>Bag</value>
                <value>Ctn</value>
                <value>Box</value>
            </valueMap>
        </field>
        <field name="unitCost"    type="float"    title="Unit Cost">
            <validators>
                <validator type="required" dependentFields="category">
                    <applyWhen operator="and">
                        <criteria>
                            <criterion fieldName="category" operator="notEqual" value="Adding Machine/calculator Roll"/>
                        </criteria>
                    </applyWhen>
                </validator>
            </validators>
        </field>
        <field name="inStock"   type="boolean"  title="In Stock"/>
        <field name="nextShipment"  type="date" title="Next Shipment"/>
    </fields>
</DataSource>

Then edit the first row, which has category:"Adding Machine/calculator Roll", and delete the unitCost value.
You'll get a server validation error on unitCost, but its validator must be inactive.

server logs:

Code:

 === 2017-02-09 11:50:38,650 [ec-4] INFO  RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36': Safari with Accept-Encoding header
  === 2017-02-09 11:50:38,652 [ec-4] DEBUG XML - Parsed XML from (in memory stream): 1ms
  === 2017-02-09 11:50:38,653 [ec-4] DEBUG RPCManager - Processing 1 requests.
  === 2017-02-09 11:50:38,653 [ec-4] DEBUG RPCManager - Request #1 (DSRequest) payload: {
      criteria:{
          itemID:1
      },
      values:{
          itemID:1,
          unitCost:null
      },
      operationConfig:{
          dataSource:"supplyItem",
          repo:null,
          operationType:"update",
          textMatchStyle:"exact"
      },
      componentId:"dsListGrid",
      appID:"builtinApplication",
      operation:"supplyItem_update",
      oldValues:{
          category:"Adding Machine/calculator Roll",
          itemName:"Adding Machine Roll 57x57mm Standard",
          itemID:1,
          unitCost:0.41,
          SKU:"45300",
          inStock:true,
          units:"Roll"
      }
  }
  === 2017-02-09 11:50:38,653 [ec-4] INFO  IDACall - Performing 1 operation(s)
  === 2017-02-09 11:50:38,653 [ec-4] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
  === 2017-02-09 11:50:38,653 [ec-4] DEBUG DeclarativeSecurity - DataSource supplyItem is not in the pre-checked list, processing...
  === 2017-02-09 11:50:38,654 [ec-4] DEBUG AppBase - [builtinApplication.supplyItem_update] No userTypes defined, allowing anyone access to all operations for this application
  === 2017-02-09 11:50:38,654 [ec-4] DEBUG AppBase - [builtinApplication.supplyItem_update] No public zero-argument method named '_supplyItem_update' found, performing generic datasource operation
  === 2017-02-09 11:50:38,654 [ec-4] DEBUG ValidationContext - [builtinApplication.supplyItem_update] Adding validation errors at path '/supplyItem/unitCost': {errorMessage=Field is required}
  === 2017-02-09 11:50:38,654 [ec-4] INFO  Validation - [builtinApplication.supplyItem_update] Validation error: [
      {
          unitCost:{
              errorMessage:"Field is required"
          }
      }
  ]
  === 2017-02-09 11:50:38,654 [ec-4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
  === 2017-02-09 11:50:38,654 [ec-4] DEBUG RPCManager - non-DMI response, dropExtraFields: false
  === 2017-02-09 11:50:38,655 [ec-4] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 572
  === 2017-02-09 11:50:38,655 [ec-4] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 572
  === 2017-02-09 11:50:38,655 [ec-4] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 572
  === 2017-02-09 11:50:38,655 [ec-4] INFO  Compression - /isomorphic/IDACall: 216 -> 181 bytes

**claudiobosticco** · 9 Feb 2017, 03:57

SmartClient Version: SNAPSHOT_v11.1d_2017-02-09/Enterprise Development Only (built 2017-02-09)

Chrome on OSX Sierra

(Test case equal to that of post #36)

Please modify the #fetchOperationFS sample like this:

Code:

isc.ListGrid.create({
    ID:"dsListGrid", 
    width: "100%",
    height: "100%",
    minFieldWidth:80,
    autoFetchData: true,
    canEdit:true,
    dataSource: "supplyItem" 
});

Code:

<DataSource
    ID="supplyItem"
    serverType="sql"
    tableName="supplyItem"
    titleField="itemName"
    testFileName="/examples/shared/ds/test_data/supplyItem.data.xml"
    dbImportFileName="/examples/shared/ds/test_data/supplyItemLarge.data.xml"
>
    <fields>
        <field name="itemID"      type="sequence" hidden="true"       primaryKey="true"/>
        <field name="itemName"    type="text"     title="Item"        length="128"       required="true"/>
        <field name="SKU"         type="text"     title="SKU"         length="10"        required="true"/>
        <field name="description" type="text"     title="Description" length="2000">
           
        </field>
        <field name="category"    type="text"     title="Category"    length="128"       required="true"
               foreignKey="supplyCategory.categoryName"/>
        <field name="units"       type="enum"     title="Units"       length="5">
            <valueMap>
                <value>Roll</value>
                <value>Ea</value>
                <value>Pkt</value>
                <value>Set</value>
                <value>Tube</value>
                <value>Pad</value>
                <value>Ream</value>
                <value>Tin</value>
                <value>Bag</value>
                <value>Ctn</value>
                <value>Box</value>
            </valueMap>
        </field>
        <field name="unitCost"    type="float"    title="Unit Cost">
            <validators>
                <validator type="required" dependentFields="SKU">
                    <applyWhen operator="and">
                        <criteria>
                            <criterion fieldName="SKU" operator="equals" value="45300"/>
                        </criteria>
                    </applyWhen>
                </validator>
            </validators>
        </field>
        <field name="inStock"   type="boolean"  title="In Stock"/>
        <field name="nextShipment"  type="date" title="Next Shipment"/>
    </fields>
</DataSource>

Edit the first row (SKU=45300) and delete the value in the unitCost column.
You'll get a (client-side) validation error - correct.
Than change the SKU to, say 45301. You'll get a (wrong) server side validation error:

Code:

 === 2017-02-09 11:54:46,805 [ec-2] INFO  RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36': Safari with Accept-Encoding header
  === 2017-02-09 11:54:46,807 [ec-2] DEBUG XML - Parsed XML from (in memory stream): 2ms
  === 2017-02-09 11:54:46,808 [ec-2] DEBUG RPCManager - Processing 1 requests.
  === 2017-02-09 11:54:46,808 [ec-2] DEBUG RPCManager - Request #1 (DSRequest) payload: {
      criteria:{
          itemID:1
      },
      values:{
          itemID:1,
          unitCost:null,
          SKU:"45301"
      },
      operationConfig:{
          dataSource:"supplyItem",
          repo:null,
          operationType:"update",
          textMatchStyle:"exact"
      },
      componentId:"dsListGrid",
      appID:"builtinApplication",
      operation:"supplyItem_update",
      oldValues:{
          category:"Adding Machine/calculator Roll",
          itemName:"Adding Machine Roll 57x57mm Standard",
          itemID:1,
          unitCost:0.41,
          SKU:"45300",
          inStock:true,
          units:"Roll"
      }
  }
  === 2017-02-09 11:54:46,809 [ec-2] INFO  IDACall - Performing 1 operation(s)
  === 2017-02-09 11:54:46,809 [ec-2] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
  === 2017-02-09 11:54:46,809 [ec-2] DEBUG DeclarativeSecurity - DataSource supplyItem is not in the pre-checked list, processing...
  === 2017-02-09 11:54:46,809 [ec-2] DEBUG AppBase - [builtinApplication.supplyItem_update] No userTypes defined, allowing anyone access to all operations for this application
  === 2017-02-09 11:54:46,809 [ec-2] DEBUG AppBase - [builtinApplication.supplyItem_update] No public zero-argument method named '_supplyItem_update' found, performing generic datasource operation
  === 2017-02-09 11:54:46,809 [ec-2] DEBUG ValidationContext - [builtinApplication.supplyItem_update] Adding validation errors at path '/supplyItem/unitCost': {errorMessage=Field is required}
  === 2017-02-09 11:54:46,809 [ec-2] INFO  Validation - [builtinApplication.supplyItem_update] Validation error: [
      {
          unitCost:{
              errorMessage:"Field is required"
          }
      }
  ]
  === 2017-02-09 11:54:46,810 [ec-2] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
  === 2017-02-09 11:54:46,810 [ec-2] DEBUG RPCManager - non-DMI response, dropExtraFields: false
  === 2017-02-09 11:54:46,810 [ec-2] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 572
  === 2017-02-09 11:54:46,810 [ec-2] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 572
  === 2017-02-09 11:54:46,810 [ec-2] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 572
  === 2017-02-09 11:54:46,810 [ec-2] INFO  Compression - /isomorphic/IDACall: 216 -> 181 bytes

**claudiobosticco** · 16 Feb 2017, 01:29

hello, bumping this thread just to know if you succeeded in replicating the bug.

**claudiobosticco** · 20 Feb 2017, 06:01

SmartClient Version: SNAPSHOT_v11.1d_2017-02-20/Enterprise Development Only (built 2017-02-20)

Hello, it seems that something has changed.
#48: seems fixed
#47: there's still the wrong server validation error on unitCost, but this time it's coupled with a correct error on 'description', which was lacking, before.

**claudiobosticco** · 28 Feb 2017, 04:07

Hello, any news on the remaining bug?

**Isomorphic** · 1 Mar 2017, 05:34

OK, we reproduce the problem described in #47 - not sure how that got missed last time because we are using your test cases. Also, we are not aware of any changes made between the 9th and 20th of February that would affect your test case #48. Anyway, we have explicitly tested that both #47 and #48 behave correctly with the fix just applied - will be present in tomorrow's builds of 11.1 / 6.1.

**claudiobosticco** · 1 Mar 2017, 05:49

Originally posted by Isomorphic View Post

Also, we are not aware of any changes made between the 9th and 20th of February that would affect your test case #48.

oh, sorry, I've just re-tested it and actually there isn't that bug with that version....it may be that I've modified the wrong dataSource file.

Originally posted by Isomorphic View Post

Anyway, we have explicitly tested that both #47 and #48 behave correctly with the fix just applied - will be present in tomorrow's builds of 11.1 / 6.1.

ok, waiting for the 02-03 build, thanks

**claudiobosticco** · 2 Mar 2017, 05:42

SmartClient Version: SNAPSHOT_v11.1d_2017-03-02/Enterprise Development Only (built 2017-03-02)

I can confirm that the test case from post #47 is also fixed, thank you very much.

**Blama** · 6 Mar 2017, 07:50

Hi Isomorphic,

I'm currently adding from/to-date-fields where I have a (obvious) dependency between the fields. I copied velocity code I already have in place for a similar use case, but seeing the test cases here it is very clear that this descriptive approach is way nicer. As I suppose that this will be a feature for 6.1p, I wanted to let you know that there is no documentation on it in the docs, currently (see #4). I'm pretty sure that this will be an awesome feature I'll definitely use, so documentation on it is highly appreciated.

Best regards
Blama

**Blama** · 13 Mar 2017, 10:41

Hi Isomorphic,

really bad news. This issue appeared again, this time using v10.1p_2017-03-02.
Did your fix from #32 also make it in 5.1p?

Originally posted by Blama View Post

Hi Isomorphic,
that's great news, thank you. I'll try and then observe if I ever get complaints for that issue again. So feedback might take a while.

Best regards
Blama

**Isomorphic** · 14 Mar 2017, 09:04

Yes, the change was ported back as far as 5.0p, so that is bad news. Looking at how obscure the problem we fixed was, and how perfectly it would have matched your observed pattern of failure, we were very confident that this was the right fix. Is it possible that a simple deployment error means you're using an older version of the JAR file (isomorphic_core_rpc.jar)?

**Blama** · 14 Mar 2017, 09:13

Hi Isomorphic,

unfortunately no. Just got the jar from the server, this is the manifest.mf (I updated yesterday, but there is no reason that I was not using the correct jars before):

Code:

Manifest-Version: 1.0
Isomorphic-SmartClient-Package-Date: 2017-03-11
Isomorphic-SmartClient-Version: v10.1p_2017-03-11PowerEdition
Created-By: 1.8.0_111 (Oracle Corporation)
Implementation-Vendor: Isomorphic Software, Inc.

But it was the 1st time I experienced the bug 1st and not the customer.
I added three entries, then wanted to update one of them, which failed. Adding (a user) is not something I do often, so perhaps it is related to this.
Also, the (wrongly) called validator that blocked the update should also have (wrongly) blocked the 2nd/3rd insert IMHO.
I'll definitely try this again locally, but perhaps this information does already help you.

Best regards
Blama

**Blama** · 14 Mar 2017, 09:47

Hi Isomorphic,

repeating the actions from yesterday did not provoke the validator to be applied.

Best regards
Blama

**claudiobosticco** · 23 Mar 2017, 23:45

SmartClient Version: SNAPSHOT_v11.1d_2017-03-23/Enterprise Development Only (built 2017-03-23)

Chrome on OSX

Hello, I've got another test case where validation fails.

Please use this modified version of supplyItem.ds.xml:

Code:

<DataSource
    ID="supplyItem"
    serverType="sql"
    tableName="supplyItem"
    titleField="itemName"
    testFileName="/examples/shared/ds/test_data/supplyItem.data.xml"
    dbImposrtFileName="/examples/shared/ds/test_data/supplyItemLarge.data.xml"
>
    <fields>
        <field name="itemID"      type="sequence" hidden="true"       primaryKey="true"/>
        <field name="itemName"    type="text"     title="Item"        length="128"       required="true"/>
        <field name="SKU"         type="text"     title="SKU"         length="10"        required="true"/>
        <field name="description" type="text"     title="Description" length="2000">
            <validators>
                 <validator type="required">
                    <applyWhen fieldName="unitCost" operator="isNull"/>
                </validator>
            </validators>
        </field>
        <field name="category"    type="text"     title="Category"    length="128"       required="true"
               foreignKey="supplyCategory.categoryName"/>
        <field name="units"       type="enum"     title="Units"       length="5">
            <valueMap>
                <value>Roll</value>
                <value>Ea</value>
                <value>Pkt</value>
                <value>Set</value>
                <value>Tube</value>
                <value>Pad</value>
                <value>Ream</value>
                <value>Tin</value>
                <value>Bag</value>
                <value>Ctn</value>
                <value>Box</value>
            </valueMap>
        </field>
        <field name="unitCost"    type="float"    title="Unit Cost">
            <validators>
                 <validator type="required">
                    <applyWhen fieldName="description" operator="isNull"/>
                </validator>
            </validators>
        </field>
        <field name="inStock"   type="boolean"  title="In Stock"/>
        <field name="nextShipment"  type="date" title="Next Shipment"/>
    </fields>
</DataSource>

then modify the #fetchOperationFS sample like this:

Code:

isc.ListGrid.create({
    ID:"dsListGrid", 
    width: "100%",
    height: "100%",
    minFieldWidth:80,
    autoFetchData: true,
    dataSource: "supplyItem",
    canEdit: true
});

Then:
1. Edit the first record: type something in the description field, clear the unitCost field, and save.
2. Edit the inStock field: you'll get a (wrong) validation error on the unitCost field.

Tomcat logs:

Code:

 === 2017-03-24 07:36:39,272 [c-17] INFO  RequestContext - URL: '/isomorphic/skins/Tahoe/images/DynamicForm/cb-uncheck-hover.png', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36': Safari with Accept-Encoding header
  === 2017-03-24 07:36:39,275 [c-17] INFO  Download - done streaming: /Users/bosticco/librerie/isc/11.1/SmartClient_SNAPSHOT_v111d_2017-03-23_Enterprise/smartclientSDK/isomorphic/skins/Tahoe/images/DynamicForm/cb-uncheck-hover.png
  === 2017-03-24 07:36:42,274 [c-17] INFO  RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36': Safari with Accept-Encoding header
  === 2017-03-24 07:36:42,276 [c-17] DEBUG XML - Parsed XML from (in memory stream): 1ms
  === 2017-03-24 07:36:42,277 [c-17] DEBUG RPCManager - Processing 1 requests.
  === 2017-03-24 07:36:42,278 [c-17] DEBUG RPCManager - Request #1 (DSRequest) payload: {
      criteria:{
          itemID:1
      },
      values:{
          itemID:1,
          description:"aa",
          unitCost:null
      },
      operationConfig:{
          dataSource:"supplyItem",
          repo:null,
          operationType:"update",
          textMatchStyle:"exact"
      },
      componentId:"dsListGrid",
      appID:"builtinApplication",
      operation:"supplyItem_update",
      oldValues:{
          category:"Adding Machine/calculator Roll",
          itemName:"Adding Machine Roll 57x57mm Standard",
          itemID:1,
          unitCost:1,
          SKU:"45300",
          inStock:false,
          units:"Roll"
      }
  }
  === 2017-03-24 07:36:42,278 [c-17] INFO  IDACall - Performing 1 operation(s)
  === 2017-03-24 07:36:42,278 [c-17] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
  === 2017-03-24 07:36:42,278 [c-17] DEBUG DeclarativeSecurity - DataSource supplyItem is not in the pre-checked list, processing...
  === 2017-03-24 07:36:42,278 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update] No userTypes defined, allowing anyone access to all operations for this application
  === 2017-03-24 07:36:42,278 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update] No public zero-argument method named '_supplyItem_update' found, performing generic datasource operation
  === 2017-03-24 07:36:42,279 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] on field: 'unitCost' for validator type 'required', 'applyWhen' is:
  {
      fieldName:"description",
      operator:"isNull"
  }
  record is:
  {
      itemID:1,
      unitCost:null,
      description:"aa"
  }
  === 2017-03-24 07:36:42,279 [c-17] DEBUG DeclarativeSecurity - [builtinApplication.supplyItem_update] Processing security checks for DataSource null, field null
  === 2017-03-24 07:36:42,279 [c-17] DEBUG DeclarativeSecurity - [builtinApplication.supplyItem_update] Request is not a client request, ignoring security checks.
  === 2017-03-24 07:36:42,279 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
  === 2017-03-24 07:36:42,279 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
  === 2017-03-24 07:36:42,280 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] Performing fetch operation with
      criteria: {itemID:1}    values: {itemID:1}
  === 2017-03-24 07:36:42,280 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
  === 2017-03-24 07:36:42,280 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] 636: Executing SQL query on 'HSQLDB': SELECT supplyItem.itemID, supplyItem.itemName, supplyItem.SKU, supplyItem.description, supplyItem.category, supplyItem.units, supplyItem.unitCost, supplyItem.inStock, supplyItem.nextShipment FROM supplyItem WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:42,280 [c-17] DEBUG SQLConnectionManager - [builtinApplication.supplyItem_update, builtinApplication.null] Borrowed connection '1503373105'
  === 2017-03-24 07:36:42,280 [c-17] INFO  SQLDriver - [builtinApplication.supplyItem_update, builtinApplication.null] Executing SQL query on 'HSQLDB' using connection '1503373105': SELECT supplyItem.itemID, supplyItem.itemName, supplyItem.SKU, supplyItem.description, supplyItem.category, supplyItem.units, supplyItem.unitCost, supplyItem.inStock, supplyItem.nextShipment FROM supplyItem WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:42,281 [c-17] INFO  DSResponse - [builtinApplication.supplyItem_update] DSResponse: List with 1 items
  === 2017-03-24 07:36:42,282 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Record after applying stored values is:
  {
      itemID:1,
      unitCost:null,
      description:"aa"
  }
  === 2017-03-24 07:36:42,282 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Merged conditionRecord is:
  {
      itemName:"Adding Machine Roll 57x57mm Standard",
      category:"Adding Machine/calculator Roll",
      itemID:1,
      unitCost:null,
      description:"aa",
      SKU:"45300",
      inStock:false,
      units:"Roll"
  }
  === 2017-03-24 07:36:42,282 [c-17] INFO  DefaultValidators - [builtinApplication.supplyItem_update] on field: 'unitCost' conditional validator of type 'required' is: inactive
  === 2017-03-24 07:36:42,282 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] on field: 'description' for validator type 'required', 'applyWhen' is:
  {
      fieldName:"unitCost",
      operator:"isNull"
  }
  record is:
  {
      itemID:1,
      unitCost:null,
      description:"aa"
  }
  === 2017-03-24 07:36:42,283 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Record after applying stored values is:
  {
      itemID:1,
      unitCost:null,
      description:"aa"
  }
  === 2017-03-24 07:36:42,283 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Merged conditionRecord is:
  {
      itemName:"Adding Machine Roll 57x57mm Standard",
      category:"Adding Machine/calculator Roll",
      itemID:1,
      unitCost:null,
      description:"aa",
      SKU:"45300",
      inStock:false,
      units:"Roll"
  }
  === 2017-03-24 07:36:42,283 [c-17] INFO  DefaultValidators - [builtinApplication.supplyItem_update] on field: 'description' conditional validator of type 'required' is: active
  === 2017-03-24 07:36:42,283 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update] Performing update operation with
      criteria: {itemID:1}    values: {itemID:1,description:"aa",unitCost:null}
  === 2017-03-24 07:36:42,284 [c-17] DEBUG SQLConnectionManager - [builtinApplication.supplyItem_update] Borrowed connection '366003048'
  === 2017-03-24 07:36:42,284 [c-17] DEBUG SQLTransaction - [builtinApplication.supplyItem_update] Started new HSQLDB transaction "366003048"
  === 2017-03-24 07:36:42,284 [c-17] DEBUG SQLDataSource - [builtinApplication.supplyItem_update] Setting DSRequest as being part of a transaction
  === 2017-03-24 07:36:42,284 [c-17] INFO  SQLDriver - [builtinApplication.supplyItem_update] Executing SQL query on 'HSQLDB' using connection '366003048': UPDATE supplyItem SET description='aa', unitCost=NULL WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:42,284 [c-17] DEBUG SQLDataSource - [builtinApplication.supplyItem_update] update operation affected 1 rows
  === 2017-03-24 07:36:42,284 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update] primaryKeys: {itemID=1}
  === 2017-03-24 07:36:42,284 [c-17] DEBUG DeclarativeSecurity - [builtinApplication.supplyItem_update] Processing security checks for DataSource null, field null
  === 2017-03-24 07:36:42,284 [c-17] DEBUG DeclarativeSecurity - [builtinApplication.supplyItem_update] DataSource supplyItem is not in the pre-checked list, processing...
  === 2017-03-24 07:36:42,285 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
  === 2017-03-24 07:36:42,285 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
  === 2017-03-24 07:36:42,285 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] Performing fetch operation with
      criteria: {itemID:1}    values: {itemID:1}
  === 2017-03-24 07:36:42,285 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
  === 2017-03-24 07:36:42,286 [c-17] DEBUG SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] Using SQL Limit query
  === 2017-03-24 07:36:42,286 [c-17] DEBUG SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] SQL windowed select rows 0->-1, result size 1. Query: SELECT LIMIT 0 1  supplyItem.itemID, supplyItem.itemName, supplyItem.SKU, supplyItem.description, supplyItem.category, supplyItem.units, supplyItem.unitCost, supplyItem.inStock, supplyItem.nextShipment FROM supplyItem WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:42,286 [c-17] DEBUG SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] SQL windowed select rows 0->-1, result size 1. Query: SELECT LIMIT 0 1  supplyItem.itemID, supplyItem.itemName, supplyItem.SKU, supplyItem.description, supplyItem.category, supplyItem.units, supplyItem.unitCost, supplyItem.inStock, supplyItem.nextShipment FROM supplyItem WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:42,286 [c-17] DEBUG SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] Setting DSRequest as being part of a transaction
  === 2017-03-24 07:36:42,286 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] 631: Executing cache sync query on 'HSQLDB': SELECT LIMIT 0 1  supplyItem.itemID, supplyItem.itemName, supplyItem.SKU, supplyItem.description, supplyItem.category, supplyItem.units, supplyItem.unitCost, supplyItem.inStock, supplyItem.nextShipment FROM supplyItem WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:42,286 [c-17] INFO  DSResponse - [builtinApplication.supplyItem_update] DSResponse: List with 1 items
  === 2017-03-24 07:36:42,287 [c-17] INFO  DSResponse - DSResponse: List with 1 items
  === 2017-03-24 07:36:42,287 [c-17] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
  === 2017-03-24 07:36:42,287 [c-17] DEBUG SQLTransaction - Committing HSQLDB transaction "366003048"
  === 2017-03-24 07:36:42,287 [c-17] DEBUG RPCManager - non-DMI response, dropExtraFields: false
  === 2017-03-24 07:36:42,287 [c-17] DEBUG SQLTransaction - getConnection() looked for transactional connection for HSQLDB:  hashcode "366003048"
  === 2017-03-24 07:36:42,287 [c-17] DEBUG SQLTransaction - Ending HSQLDB transaction "366003048"
  === 2017-03-24 07:36:42,287 [c-17] DEBUG SQLConnectionManager - About to close connection with hashcode "366003048"
  === 2017-03-24 07:36:42,287 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 631
  === 2017-03-24 07:36:42,287 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 631
  === 2017-03-24 07:36:42,288 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 631
  === 2017-03-24 07:36:42,288 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 636
  === 2017-03-24 07:36:42,288 [c-17] DEBUG SQLDriver - Freeing SQLDriver dbConnection 1503373105 for SQLDriver instance 108800648
  === 2017-03-24 07:36:42,288 [c-17] DEBUG SQLConnectionManager - About to close connection with hashcode "1503373105"
  === 2017-03-24 07:36:42,288 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 636
  === 2017-03-24 07:36:42,288 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 636
  === 2017-03-24 07:36:42,288 [c-17] INFO  Compression - /isomorphic/IDACall: 313 -> 241 bytes
  === 2017-03-24 07:36:44,791 [c-17] INFO  RequestContext - URL: '/isomorphic/IDACall', User-Agent: 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36': Safari with Accept-Encoding header
  === 2017-03-24 07:36:44,792 [c-17] DEBUG XML - Parsed XML from (in memory stream): 1ms
  === 2017-03-24 07:36:44,793 [c-17] DEBUG RPCManager - Processing 1 requests.
  === 2017-03-24 07:36:44,794 [c-17] DEBUG RPCManager - Request #1 (DSRequest) payload: {
      criteria:{
          itemID:1
      },
      values:{
          itemID:1,
          inStock:true
      },
      operationConfig:{
          dataSource:"supplyItem",
          repo:null,
          operationType:"update",
          textMatchStyle:"exact"
      },
      componentId:"dsListGrid",
      appID:"builtinApplication",
      operation:"supplyItem_update",
      oldValues:{
          category:"Adding Machine/calculator Roll",
          itemName:"Adding Machine Roll 57x57mm Standard",
          itemID:1,
          description:"aa",
          SKU:"45300",
          inStock:false,
          units:"Roll"
      }
  }
  === 2017-03-24 07:36:44,794 [c-17] INFO  IDACall - Performing 1 operation(s)
  === 2017-03-24 07:36:44,794 [c-17] DEBUG DeclarativeSecurity - Processing security checks for DataSource null, field null
  === 2017-03-24 07:36:44,794 [c-17] DEBUG DeclarativeSecurity - DataSource supplyItem is not in the pre-checked list, processing...
  === 2017-03-24 07:36:44,794 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update] No userTypes defined, allowing anyone access to all operations for this application
  === 2017-03-24 07:36:44,794 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update] No public zero-argument method named '_supplyItem_update' found, performing generic datasource operation
  === 2017-03-24 07:36:44,795 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] on field: 'unitCost' for validator type 'required', 'applyWhen' is:
  {
      fieldName:"description",
      operator:"isNull"
  }
  record is:
  {
      itemID:1,
      unitCost:null,
      description:null,
      inStock:true
  }
  === 2017-03-24 07:36:44,795 [c-17] DEBUG DeclarativeSecurity - [builtinApplication.supplyItem_update] Processing security checks for DataSource null, field null
  === 2017-03-24 07:36:44,795 [c-17] DEBUG DeclarativeSecurity - [builtinApplication.supplyItem_update] Request is not a client request, ignoring security checks.
  === 2017-03-24 07:36:44,795 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update, builtinApplication.null] No userTypes defined, allowing anyone access to all operations for this application
  === 2017-03-24 07:36:44,795 [c-17] DEBUG AppBase - [builtinApplication.supplyItem_update, builtinApplication.null] No public zero-argument method named '_null' found, performing generic datasource operation
  === 2017-03-24 07:36:44,795 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] Performing fetch operation with
      criteria: {itemID:1}    values: {itemID:1}
  === 2017-03-24 07:36:44,795 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause
  === 2017-03-24 07:36:44,796 [c-17] INFO  SQLDataSource - [builtinApplication.supplyItem_update, builtinApplication.null] 631: Executing SQL query on 'HSQLDB': SELECT supplyItem.itemID, supplyItem.itemName, supplyItem.SKU, supplyItem.description, supplyItem.category, supplyItem.units, supplyItem.unitCost, supplyItem.inStock, supplyItem.nextShipment FROM supplyItem WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:44,796 [c-17] DEBUG SQLConnectionManager - [builtinApplication.supplyItem_update, builtinApplication.null] Borrowed connection '1503373105'
  === 2017-03-24 07:36:44,796 [c-17] INFO  SQLDriver - [builtinApplication.supplyItem_update, builtinApplication.null] Executing SQL query on 'HSQLDB' using connection '1503373105': SELECT supplyItem.itemID, supplyItem.itemName, supplyItem.SKU, supplyItem.description, supplyItem.category, supplyItem.units, supplyItem.unitCost, supplyItem.inStock, supplyItem.nextShipment FROM supplyItem WHERE (supplyItem.itemID=1)
  === 2017-03-24 07:36:44,797 [c-17] INFO  DSResponse - [builtinApplication.supplyItem_update] DSResponse: List with 1 items
  === 2017-03-24 07:36:44,797 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Record after applying stored values is:
  {
      itemID:1,
      unitCost:null,
      description:null,
      inStock:true
  }
  === 2017-03-24 07:36:44,797 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Merged conditionRecord is:
  {
      itemName:"Adding Machine Roll 57x57mm Standard",
      category:"Adding Machine/calculator Roll",
      itemID:1,
      unitCost:null,
      SKU:"45300",
      description:null,
      inStock:true,
      units:"Roll"
  }
  === 2017-03-24 07:36:44,797 [c-17] INFO  DefaultValidators - [builtinApplication.supplyItem_update] on field: 'unitCost' conditional validator of type 'required' is: active
  === 2017-03-24 07:36:44,798 [c-17] DEBUG ValidationContext - [builtinApplication.supplyItem_update] Adding validation errors at path '/supplyItem/unitCost/unitCost': {errorMessage=Field is required}
  === 2017-03-24 07:36:44,798 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] on field: 'description' for validator type 'required', 'applyWhen' is:
  {
      fieldName:"unitCost",
      operator:"isNull"
  }
  record is:
  {
      itemID:1,
      unitCost:null,
      description:null,
      inStock:true
  }
  === 2017-03-24 07:36:44,798 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Record after applying stored values is:
  {
      itemID:1,
      unitCost:null,
      description:"aa",
      inStock:true
  }
  === 2017-03-24 07:36:44,798 [c-17] DEBUG DefaultValidators - [builtinApplication.supplyItem_update] NOTE: Merged conditionRecord is:
  {
      itemName:"Adding Machine Roll 57x57mm Standard",
      category:"Adding Machine/calculator Roll",
      itemID:1,
      unitCost:null,
      SKU:"45300",
      description:null,
      inStock:true,
      units:"Roll"
  }
  === 2017-03-24 07:36:44,798 [c-17] INFO  DefaultValidators - [builtinApplication.supplyItem_update] on field: 'description' conditional validator of type 'required' is: active
  === 2017-03-24 07:36:44,798 [c-17] INFO  Validation - [builtinApplication.supplyItem_update] Validation error: [
      {
          unitCost:{
              errorMessage:"Field is required"
          }
      }
  ]
  === 2017-03-24 07:36:44,798 [c-17] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8
  === 2017-03-24 07:36:44,798 [c-17] DEBUG RPCManager - non-DMI response, dropExtraFields: false
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 636
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 636
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 636
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 631
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLDriver - Freeing SQLDriver dbConnection 1503373105 for SQLDriver instance 2085409142
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLConnectionManager - About to close connection with hashcode "1503373105"
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 631
  === 2017-03-24 07:36:44,799 [c-17] DEBUG SQLDataSource - About to clear SQLDriver state for DS instance 631
  === 2017-03-24 07:36:44,799 [c-17] INFO  Compression - /isomorphic/IDACall: 216 -> 181 bytes

Announcement

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment