Isomorphic,
Following is the code I use to create the comboboxitem:
dS.XML file:
Logs:
I can see lot of queries being fired very rapidly and they are same. Can you explain this behavior please.
version: SC_SNAPSHOT-2011-11-03/EVAL Deployment 2011-11-03
It happens with 2.5 release version too
browser Chrome 15.0.874.106 m
Thanks.
Following is the code I use to create the comboboxitem:
Code:
SelectItem filteredSelect = new SelectItem("filteredSelect"); filteredSelect.setOptionDataSource(DataSource.get("dateRange")); filteredSelect.setTitle("From"); // filteredSelect.setOptionOperationId("year"); filteredSelect.setDisplayField("YEAR_NUM"); filteredSelect.setValueField("YEAR_NUM"); filteredSelect.setPickListWidth(150); filteredSelect.setDefaultToFirstOption(true); filteredSelect.setColSpan(1); // filteredSelect.setAutoFetchData(true);
Code:
<DataSource ID="dateRange" table="CLIENT_VALID_DATES" serverType="sql" dbName="Oracle" showPrompt="false" qualifyColumnNames="false"> <fields> <field name="CLIENT_ID" type="number" required="false" title="CLIENT_ID"/> <field name="YEAR_NUM" type="number" required="true" title="YEAR_NUM"/> <field name="MONTH_NUM" type="number" required="false" title="MONTH_NUM"/> <field name="MONTH_SHORT_NAME" type="text" required="false" title="MONTH_SHORT_NAME"/> <field name="MONTH_ID" type="number" required="false" title="MONTH_ID"/> <field name="QUARTER_ID" type="number" required="false" title="QUARTER_ID"/> <field name="PRODUCT_ID" type="text" required="false" title="PRODUCT_ID"/> </fields> <operationBindings> <operationBinding operationType="fetch"> <selectClause> year_num </selectClause> <tableClause> CLIENT_VALID_DATES </tableClause> <whereClause> client_id=99 and gds_id=1 and product_id='NA_ADB' </whereClause> </operationBinding> </operationBindings> </DataSource>
Code:
=== 2011-11-10 05:21:39,691 [l0-6] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:549 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:549 } } === 2011-11-10 05:21:39,720 [l0-6] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:39,736 [l0-6] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:39,737 [l0-6] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:39,737 [l0-6] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:549} values: {__gwt_ObjectId:549} === 2011-11-10 05:21:39,751 [l0-6] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:39,928 [l0-6] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:39,929 [l0-6] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:40,138 [l0-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Initializing SQL config for 'Oracle' from system config - using DataSource: oracle.jdbc.pool.OracleDataSource === 2011-11-10 05:21:41,364 [l0-1] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:41,368 [l0-1] DEBUG XML - Parsed XML from (in memory stream): 3ms === 2011-11-10 05:21:41,379 [l0-1] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:41,380 [l0-1] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:679 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:679 } } === 2011-11-10 05:21:41,381 [l0-1] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:41,381 [l0-1] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:41,382 [l0-1] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:41,382 [l0-1] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:679} values: {__gwt_ObjectId:679} === 2011-11-10 05:21:41,383 [l0-1] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,384 [l0-1] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,384 [l0-1] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,497 [l0-4] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:41,522 [l0-4] DEBUG XML - Parsed XML from (in memory stream): 3ms === 2011-11-10 05:21:41,525 [l0-4] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:41,526 [l0-4] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:683 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:683 } } === 2011-11-10 05:21:41,526 [l0-4] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:41,527 [l0-4] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:41,527 [l0-4] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:41,527 [l0-4] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:683} values: {__gwt_ObjectId:683} === 2011-11-10 05:21:41,527 [l0-4] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,528 [l0-4] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,528 [l0-4] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,590 [l0-5] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:41,594 [l0-5] DEBUG XML - Parsed XML from (in memory stream): 2ms === 2011-11-10 05:21:41,597 [l0-5] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:41,598 [l0-5] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:687 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:687 } } === 2011-11-10 05:21:41,599 [l0-5] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:41,599 [l0-5] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:41,599 [l0-5] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:41,599 [l0-5] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:687} values: {__gwt_ObjectId:687} === 2011-11-10 05:21:41,600 [l0-5] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,600 [l0-5] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,601 [l0-5] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,736 [l0-3] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:41,742 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 3ms === 2011-11-10 05:21:41,748 [l0-3] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:41,750 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:691 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:691 } } === 2011-11-10 05:21:41,750 [l0-3] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:41,750 [l0-3] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:41,750 [l0-3] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:41,750 [l0-3] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:691} values: {__gwt_ObjectId:691} === 2011-11-10 05:21:41,751 [l0-3] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,751 [l0-3] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:41,752 [l0-3] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:42,073 [l0-7] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:42,078 [l0-7] DEBUG XML - Parsed XML from (in memory stream): 4ms === 2011-11-10 05:21:42,081 [l0-7] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:42,082 [l0-7] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:695 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:695 } } === 2011-11-10 05:21:42,082 [l0-7] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:42,083 [l0-7] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:42,083 [l0-7] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:42,083 [l0-7] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:695} values: {__gwt_ObjectId:695} === 2011-11-10 05:21:42,083 [l0-7] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:42,084 [l0-7] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:42,084 [l0-7] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:43,877 [l0-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:44,138 [l0-1] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:44,315 [l0-4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:44,374 [l0-5] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:44,560 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:44,679 [l0-6] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:44,734 [l0-1] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:44,890 [l0-7] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:44,909 [l0-4] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:44,969 [l0-5] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:45,155 [l0-3] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:45,334 [l0-1] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:45,334 [l0-6] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:45,487 [l0-7] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:45,504 [l0-4] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:45,564 [l0-5] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:45,748 [l0-3] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,040 [l0-6] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:46,082 [l0-7] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,100 [l0-4] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:46,159 [l0-5] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:46,343 [l0-3] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:46,478 [l0-1] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:46,543 [l0-6] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2011-11-10 05:21:46,544 [l0-6] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2011-11-10 05:21:46,545 [l0-5] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2011-11-10 05:21:46,546 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2011-11-10 05:21:46,563 [l0-4] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2011-11-10 05:21:46,566 [l0-4] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2011-11-10 05:21:46,569 [l0-5] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:46,573 [l0-5] DEBUG XML - Parsed XML from (in memory stream): 3ms === 2011-11-10 05:21:46,575 [l0-5] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:46,577 [l0-5] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:699 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:699 } } === 2011-11-10 05:21:46,577 [l0-5] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:46,577 [l0-5] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:46,577 [l0-5] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:46,577 [l0-5] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:699} values: {__gwt_ObjectId:699} === 2011-11-10 05:21:46,578 [l0-5] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,578 [l0-5] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,578 [l0-5] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,584 [l0-6] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:46,589 [l0-6] DEBUG XML - Parsed XML from (in memory stream): 4ms === 2011-11-10 05:21:46,591 [l0-6] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:46,593 [l0-6] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:703 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:703 } } === 2011-11-10 05:21:46,593 [l0-6] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:46,593 [l0-6] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:46,593 [l0-6] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:46,593 [l0-6] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:703} values: {__gwt_ObjectId:703} === 2011-11-10 05:21:46,594 [l0-6] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,594 [l0-6] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,594 [l0-6] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,606 [l0-4] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:46,610 [l0-4] DEBUG XML - Parsed XML from (in memory stream): 3ms === 2011-11-10 05:21:46,612 [l0-4] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:46,614 [l0-4] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:707 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:707 } } === 2011-11-10 05:21:46,615 [l0-4] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:46,615 [l0-4] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:46,615 [l0-4] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:46,615 [l0-4] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:707} values: {__gwt_ObjectId:707} === 2011-11-10 05:21:46,616 [l0-4] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,616 [l0-4] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,616 [l0-4] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,648 [l0-3] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2011-11-10 05:21:46,649 [l0-3] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2011-11-10 05:21:46,654 [l0-3] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:46,682 [l0-7] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:46,687 [l0-3] DEBUG XML - Parsed XML from (in memory stream): 3ms === 2011-11-10 05:21:46,690 [l0-3] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:46,691 [l0-3] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:711 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:711 } } === 2011-11-10 05:21:46,691 [l0-3] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:46,691 [l0-3] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:46,692 [l0-3] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:46,692 [l0-3] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:711} values: {__gwt_ObjectId:711} === 2011-11-10 05:21:46,692 [l0-3] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,693 [l0-3] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,693 [l0-3] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,783 [l0-1] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2011-11-10 05:21:46,784 [l0-1] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2011-11-10 05:21:46,822 [l0-1] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:46,827 [l0-1] DEBUG XML - Parsed XML from (in memory stream): 4ms === 2011-11-10 05:21:46,829 [l0-1] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:46,830 [l0-1] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:715 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:715 } } === 2011-11-10 05:21:46,830 [l0-1] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:46,831 [l0-1] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:46,831 [l0-1] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:46,831 [l0-1] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:715} values: {__gwt_ObjectId:715} === 2011-11-10 05:21:46,831 [l0-1] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,832 [l0-1] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:46,832 [l0-1] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:47,006 [l0-7] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2011-11-10 05:21:47,007 [l0-7] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2011-11-10 05:21:47,022 [l0-7] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:47,027 [l0-7] DEBUG XML - Parsed XML from (in memory stream): 4ms === 2011-11-10 05:21:47,030 [l0-7] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:47,031 [l0-7] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:719 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:719 } } === 2011-11-10 05:21:47,031 [l0-7] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:47,032 [l0-7] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:47,032 [l0-7] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:47,032 [l0-7] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:719} values: {__gwt_ObjectId:719} === 2011-11-10 05:21:47,032 [l0-7] INFO SQLDataSource - [builtinApplication.dateRange_fetch] derived query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:47,033 [l0-7] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Executing row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:47,033 [l0-7] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] Eval'd row count query: SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:49,308 [l0-5] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:49,335 [l0-6] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:49,368 [l0-4] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:49,449 [l0-3] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:49,558 [l0-1] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:49,772 [l0-7] DEBUG PoolableSQLConnectionFactory - [builtinApplication.dateRange_fetch] Returning pooled Connection === 2011-11-10 05:21:49,902 [l0-5] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:49,930 [l0-6] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:49,964 [l0-4] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,043 [l0-3] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,155 [l0-1] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,367 [l0-7] INFO SQLDriver - [builtinApplication.dateRange_fetch] Executing SQL query on 'Oracle': SELECT COUNT(*) FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,498 [l0-5] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,528 [l0-6] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,563 [l0-4] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,638 [l0-3] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,747 [l0-1] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:50,966 [l0-7] DEBUG SQLDataSource - [builtinApplication.dateRange_fetch] JDBC driver windowed select rows 0->75, result size 75. Query: SELECT year_num FROM CLIENT_VALID_DATES WHERE client_id=99 and gds_id=1 and product_id='NA_ADB' === 2011-11-10 05:21:51,097 [l0-5] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:51,130 [l0-6] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:51,177 [l0-4] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:51,245 [l0-3] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:51,346 [l0-1] INFO DSResponse - [builtinApplication.dateRange_fetch] DSResponse: List with 25 items === 2011-11-10 05:21:51,409 [l0-5] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2011-11-10 05:21:51,411 [l0-5] DEBUG RPCManager - non-DMI response, dropExtraFields: false === 2011-11-10 05:21:51,429 [l0-5] INFO RequestContext - URL: '/MarketIntelligence/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.106 Safari/535.2': Safari with Accept-Encoding header === 2011-11-10 05:21:51,436 [l0-5] DEBUG XML - Parsed XML from (in memory stream): 4ms === 2011-11-10 05:21:51,439 [l0-5] DEBUG RPCManager - Processing 1 requests. === 2011-11-10 05:21:51,441 [l0-5] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ __gwt_ObjectId:723 }, operationConfig:{ dataSource:"dateRange", operationType:"fetch", textMatchStyle:"startsWith" }, startRow:0, endRow:75, componentId:"isc_PickListMenu_0", appID:"builtinApplication", operation:"dateRange_fetch", oldValues:{ __gwt_ObjectId:723 } } === 2011-11-10 05:21:51,441 [l0-5] INFO IDACall - Performing 1 operation(s) === 2011-11-10 05:21:51,441 [l0-5] DEBUG AppBase - [builtinApplication.dateRange_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2011-11-10 05:21:51,442 [l0-5] DEBUG AppBase - [builtinApplication.dateRange_fetch] No public zero-argument method named '_dateRange_fetch' found, performing generic datasource operation === 2011-11-10 05:21:51,442 [l0-5] INFO SQLDataSource - [builtinApplication.dateRange_fetch] Performing fetch operation with criteria: {__gwt_ObjectId:723} values: {__gwt_ObjectId:723}
version: SC_SNAPSHOT-2011-11-03/EVAL Deployment 2011-11-03
It happens with 2.5 release version too
browser Chrome 15.0.874.106 m
Thanks.
Comment