[DEBUG][11/13/2012 16:39:32:186] REQUEST /admintool/sc/skins/Graphite/images/Scrollbar/vscroll_Over_track.png on org.mortbay.jetty.HttpConnection@6804e78a (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:187] Got Session ID 190jffsl0rged from cookie (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:187] sessionManager=org.mortbay.jetty.servlet.HashSessionManager@69107c05 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:187] session=org.mortbay.jetty.servlet.HashSessionManager$Session:190jffsl0rged@456453379 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:187] servlet=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:188] chain=null (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:188] servlet holder=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) === 2012-11-13 16:39:32,190 [.png] INFO Download - Returning 304: Not modified on conditional get of: C:\projects\Tikal-FS\Core\bundle\com.ricoh.mdm.cm.admintool\war\admintool\sc\skins\Graphite\images\Scrollbar\vscroll_Over_track.png [DEBUG][11/13/2012 16:39:32:190] RESPONSE /admintool/sc/skins/Graphite/images/Scrollbar/vscroll_Over_track.png 304 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:217] REQUEST /admintool/sc/skins/Graphite/images/Scrollbar/vthumb_Over_stretch.png on org.mortbay.jetty.HttpConnection@6804e78a (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:217] Got Session ID 190jffsl0rged from cookie (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:217] sessionManager=org.mortbay.jetty.servlet.HashSessionManager@69107c05 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:217] session=org.mortbay.jetty.servlet.HashSessionManager$Session:190jffsl0rged@456453379 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:217] servlet=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:217] chain=null (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:217] servlet holder=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) === 2012-11-13 16:39:32,219 [.png] INFO Download - Returning 304: Not modified on conditional get of: C:\projects\Tikal-FS\Core\bundle\com.ricoh.mdm.cm.admintool\war\admintool\sc\skins\Graphite\images\Scrollbar\vthumb_Over_stretch.png [DEBUG][11/13/2012 16:39:32:219] RESPONSE /admintool/sc/skins/Graphite/images/Scrollbar/vthumb_Over_stretch.png 304 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:220] REQUEST /admintool/sc/skins/Graphite/images/Scrollbar/vthumb_Over_end.png on org.mortbay.jetty.HttpConnection@d030c7c (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:220] Got Session ID 190jffsl0rged from cookie (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:220] sessionManager=org.mortbay.jetty.servlet.HashSessionManager@69107c05 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:220] session=org.mortbay.jetty.servlet.HashSessionManager$Session:190jffsl0rged@456453379 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:221] servlet=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:221] chain=null (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:221] servlet holder=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) === 2012-11-13 16:39:32,222 [.png] INFO Download - Returning 304: Not modified on conditional get of: C:\projects\Tikal-FS\Core\bundle\com.ricoh.mdm.cm.admintool\war\admintool\sc\skins\Graphite\images\Scrollbar\vthumb_Over_end.png [DEBUG][11/13/2012 16:39:32:222] RESPONSE /admintool/sc/skins/Graphite/images/Scrollbar/vthumb_Over_end.png 304 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:227] REQUEST /admintool/sc/skins/Graphite/images/Scrollbar/vthumb_Over_start.png on org.mortbay.jetty.HttpConnection@20c4b5fd (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:227] Got Session ID 190jffsl0rged from cookie (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:227] sessionManager=org.mortbay.jetty.servlet.HashSessionManager@69107c05 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:227] session=org.mortbay.jetty.servlet.HashSessionManager$Session:190jffsl0rged@456453379 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:227] servlet=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:227] chain=null (org.mortbay.log) [DEBUG][11/13/2012 16:39:32:227] servlet holder=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) === 2012-11-13 16:39:32,228 [.png] INFO Download - Returning 304: Not modified on conditional get of: C:\projects\Tikal-FS\Core\bundle\com.ricoh.mdm.cm.admintool\war\admintool\sc\skins\Graphite\images\Scrollbar\vthumb_Over_start.png [DEBUG][11/13/2012 16:39:32:229] RESPONSE /admintool/sc/skins/Graphite/images/Scrollbar/vthumb_Over_start.png 304 (org.mortbay.log) [DEBUG][11/13/2012 16:39:36:106] REQUEST /admintool/sc/IDACall on org.mortbay.jetty.HttpConnection@6804e78a (org.mortbay.log) [DEBUG][11/13/2012 16:39:36:106] Got Session ID 190jffsl0rged from cookie (org.mortbay.log) [DEBUG][11/13/2012 16:39:36:106] sessionManager=org.mortbay.jetty.servlet.HashSessionManager@69107c05 (org.mortbay.log) [DEBUG][11/13/2012 16:39:36:106] session=org.mortbay.jetty.servlet.HashSessionManager$Session:190jffsl0rged@456453379 (org.mortbay.log) [DEBUG][11/13/2012 16:39:36:106] servlet=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) [DEBUG][11/13/2012 16:39:36:107] chain=null (org.mortbay.log) [DEBUG][11/13/2012 16:39:36:107] servlet holder=org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet-1377668766 (org.mortbay.log) === 2012-11-13 16:39:36,107 [hr=1] INFO RequestContext - URL: '/admintool/sc/IDACall', User-Agent: 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20100101 Firefox/16.0': Moz (Gecko) with Accept-Encoding header === 2012-11-13 16:39:36,110 [hr=1] DEBUG XML - Parsed XML from (in memory stream): 3ms === 2012-11-13 16:39:36,112 [hr=1] DEBUG RPCManager - Processing 1 requests. === 2012-11-13 16:39:36,112 [hr=1] DEBUG RPCManager - Request #1 (DSRequest) payload: { criteria:{ _constructor:"AdvancedCriteria", operator:"and", criteria:[ { fieldName:"dev_group_id", operator:"equals", value:0 }, { fieldName:"dev_group_type_id", operator:"equals", value:0 }, { fieldName:"dev_inactiveflag", operator:"equals", value:0 } ] }, operationConfig:{ dataSource:"view_device_by_group", operationType:"fetch", textMatchStyle:"exact" }, startRow:0, endRow:75, sortBy:[ "dev_ipaddress" ], componentId:"isc_DeviceList_0", appID:"builtinApplication", operation:"view_device_by_group_fetch", oldValues:{ _constructor:"AdvancedCriteria", operator:"and", criteria:[ { fieldName:"dev_group_id", operator:"equals", value:0 }, { fieldName:"dev_group_type_id", operator:"equals", value:0 }, { fieldName:"dev_inactiveflag", operator:"equals", value:0 } ] } } [ INFO][11/13/2012 16:39:36:112] operationBinding:{deviceRestricted=true, operationGroup=DeviceBasicRead, operationType=fetch, requiresRole=readonly, serverObject={className=com.ricoh.mdm.cm.admintool.server.datasource.DeviceDSUtil, dropExtraFields=false, lookupStyle=new, methodName=customizeRequest}, whereClause= $defaultWhereClause , orderClause= #if($dsRequest.sortBy) #if($dsRequest.sortBy == "dev_ipaddress") cast(dbo.fnParseString(1,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(2,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(3,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(4,'.',dev_ipaddress) as INT) #else $defaultOrderClause #end #else dev_displayname #end } (com.ricoh.mdm.cm.admintool.server.util.IsomorphicSecurityManager) [ INFO][11/13/2012 16:39:36:113] operationBinding:{deviceRestricted=true, operationGroup=DeviceBasicRead, operationType=fetch, requiresRole=readonly, serverObject={className=com.ricoh.mdm.cm.admintool.server.datasource.DeviceDSUtil, dropExtraFields=false, lookupStyle=new, methodName=customizeRequest}, whereClause= $defaultWhereClause , orderClause= #if($dsRequest.sortBy) #if($dsRequest.sortBy == "dev_ipaddress") cast(dbo.fnParseString(1,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(2,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(3,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(4,'.',dev_ipaddress) as INT) #else $defaultOrderClause #end #else dev_displayname #end } (com.ricoh.mdm.cm.admintool.server.util.IsomorphicSecurityManager) === 2012-11-13 16:39:36,114 [hr=1] DEBUG AppBase - [builtinApplication.view_device_by_group_fetch] No userTypes defined, allowing anyone access to all operations for this application === 2012-11-13 16:39:36,115 [hr=1] DEBUG AppBase - [builtinApplication.view_device_by_group_fetch] No public zero-argument method named '_view_device_by_group_fetch' found, performing generic datasource operation === 2012-11-13 16:39:36,115 [hr=1] INFO SQLDataSource - [builtinApplication.view_device_by_group_fetch] Performing fetch operation with criteria: {criteria:[{fieldName:"dev_group_id",operator:"equals",value:0},{fieldName:"dev_group_type_id",operator:"equals",value:0},{fieldName:"dev_inactiveflag",operator:"equals",value:0}],operator:"and",_constructor:"AdvancedCriteria"} values: {criteria:[{fieldName:"dev_group_id",operator:"equals",value:0},{fieldName:"dev_group_type_id",operator:"equals",value:0},{fieldName:"dev_inactiveflag",operator:"equals",value:0}],operator:"and",_constructor:"AdvancedCriteria"} === 2012-11-13 16:39:36,115 [hr=1] INFO SQLDataSource - [builtinApplication.view_device_by_group_fetch] derived query: SELECT $defaultSelectClause FROM $defaultTableClause WHERE $defaultWhereClause ORDER BY #if($dsRequest.sortBy) #if($dsRequest.sortBy == "dev_ipaddress") cast(dbo.fnParseString(1,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(2,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(3,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(4,'.',dev_ipaddress) as INT) #else $defaultOrderClause #end #else dev_displayname #end === 2012-11-13 16:39:36,118 [hr=1] DEBUG SQLDataSource - [builtinApplication.view_device_by_group_fetch] Executing row count query: SELECT COUNT(*) FROM $defaultTableClause WHERE $defaultWhereClause === 2012-11-13 16:39:36,118 [hr=1] DEBUG SQLDataSource - [builtinApplication.view_device_by_group_fetch] Eval'd row count query: SELECT COUNT(*) FROM view_device_by_group WHERE ('1'='1' AND '1'='1' AND '1'='1') === 2012-11-13 16:39:36,119 [hr=1] DEBUG PoolableSQLConnectionFactory - [builtinApplication.view_device_by_group_fetch] Returning unpooled Connection === 2012-11-13 16:39:36,120 [hr=1] DEBUG SQLTransaction - [builtinApplication.view_device_by_group_fetch] Started new SQLServer transaction "768501656" === 2012-11-13 16:39:36,120 [hr=1] INFO SQLDriver - [builtinApplication.view_device_by_group_fetch] Executing SQL query on 'SQLServer': SELECT COUNT(*) FROM view_device_by_group WHERE ('1'='1' AND '1'='1' AND '1'='1') === 2012-11-13 16:39:36,163 [hr=1] DEBUG PoolableSQLConnectionFactory - [builtinApplication.view_device_by_group_fetch] Returning unpooled Connection === 2012-11-13 16:39:36,164 [hr=1] DEBUG SQLServerDriver - [builtinApplication.view_device_by_group_fetch] SQL Server version is '10.50.2500' === 2012-11-13 16:39:36,164 [hr=1] DEBUG SQLDataSource - [builtinApplication.view_device_by_group_fetch] Using SQL Limit query === 2012-11-13 16:39:36,164 [hr=1] DEBUG SQLDataSource - [builtinApplication.view_device_by_group_fetch] SQL windowed select rows 0->75, result size 75. Query: SELECT * FROM (SELECT *, ROW_NUMBER() OVER (ORDER BY x.dev_ipaddress) AS rowID FROM (SELECT TOP 100 PERCENT view_device_by_group.dev_address, view_device_by_group.dev_displayname, view_device_by_group.dev_id, view_device_by_group.dev_ipaddress FROM view_device_by_group WHERE ('1'='1' AND '1'='1' AND '1'='1') ORDER BY cast(dbo.fnParseString(1,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(2,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(3,'.',dev_ipaddress) as INT), cast(dbo.fnParseString(4,'.',dev_ipaddress) as INT) ) x) y WHERE y.rowID BETWEEN 1 AND 75 === 2012-11-13 16:39:36,720 [hr=1] INFO DSResponse - [builtinApplication.view_device_by_group_fetch] DSResponse: List with 75 items === 2012-11-13 16:39:36,722 [hr=1] DEBUG RPCManager - Content type for RPC transaction: text/plain; charset=UTF-8 === 2012-11-13 16:39:36,722 [hr=1] DEBUG SQLTransaction - Committing SQLServer transaction "768501656" === 2012-11-13 16:39:36,725 [hr=1] DEBUG RPCManager - DMI response, dropExtraFields: false === 2012-11-13 16:39:36,733 [hr=1] DEBUG SQLTransaction - Ending SQLServer transaction "768501656" [DEBUG][11/13/2012 16:39:36:737] RESPONSE /admintool/sc/IDACall 200 (org.mortbay.log)