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