Uploaded image for project: 'AdMaxLocal'
  1. AdMaxLocal
  2. AML-840

Paging seems to be listing 10 items per page even if there should be only 1.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Aquidneck
    • Component/s: None
    • Labels:
      None
    • Environment:

      SAPI 255 UI 255.

    • Sprint:
      Sprint 13

      Description

      I have 11 orders in the system. When I click the paging button, I get 11-20 of 20. I'm expecting only 1 order on the next page 11-11 of 11. See screenshot. Note this doesn't seem to be happening in DEMO.

      Tomcat Log:

      2012-11-16 16:48:39,573-6922153 [http-8080-9] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - handleMessage
      2012-11-16 16:48:39,573-6922153 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Received query string: q=ORDER%20BY%20state%20DESC%2CmodificationDate%20DESC%2Cname%20DESC%20LIMIT%2010%2C10
      2012-11-16 16:48:39,573-6922153 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Extracted parameters:

      {q=[ORDER%20BY%20state%20DESC%2CmodificationDate%20DESC%2Cname%20DESC%20LIMIT%2010%2C10]}

      2012-11-16 16:48:39,573-6922153 [http-8080-9] DEBUG com.thesearchagency.sapi.security.TokenParsingInterceptor - Using context from header: X-TSA-Authenticate
      2012-11-16 16:48:39,573-6922153 [http-8080-9] DEBUG com.thesearchagency.security.TokenizedSecurityContext - Token:O2MGGEVXQN4XTAHFFBP4GE75ANMIESIS4XDNZRGYZXPKPNUOIR4EN4XGDOEWUWIANAW6E627DJYSEGRF4A5FLODVMDVTT26DDCFQDQUMALSQGSXAZN6P3QENXWJ6JMGMQY7I4NHUQUCZBFEM2XZPGJD7YVUQ45IOHPFTSVHTSO3WH3FHFUQ5Z26R3CKGL2EY
      2012-11-16 16:48:39,575-6922155 [http-8080-9] INFO com.thesearchagency.sapi.security.TokenParsingInterceptor - Adding (token 4405114222613849:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:

      {realm=com.reseller1}) context to message
      2012-11-16 16:48:39,580-6922160 [http-8080-9] INFO com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - handleMessage
      2012-11-16 16:48:39,580-6922160 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - resource: public javax.ws.rs.core.Response com.thesearchagency.sapi.services.order.OrderService.getOrders(com.thesearchagency.query.dml.Select)
      2012-11-16 16:48:39,580-6922160 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Excuting getOrders
      2012-11-16 16:48:39,580-6922160 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Checking for execute permissions on SAPI:com.thesearchagency.sapi.services.order.OrderService.getOrders
      2012-11-16 16:48:39,580-6922160 [http-8080-9] DEBUG com.thesearchagency.sapi.security.PermissionsCheckingInterceptor - Getting connection for com_thesearchagency_saas_core_services_security_manager_TSASecurityManager
      2012-11-16 16:48:39,625-6922205 [http-8080-9] INFO jdbc.sqltiming - SELECT users.email,users.realm_id,users.id,users.salt,users.password FROM users WHERE users.id='273c4aab-e844-42d1-8c5a-2063ca535bba'
      {executed in 1 msec}
      2012-11-16 16:48:39,625-6922205 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.security.manager.TSASecurityManager - Attempting to get permissions for principal 273c4aab-e844-42d1-8c5a-2063ca535bba
      2012-11-16 16:48:39,626-6922206 [http-8080-9] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
      AND `type`='U' {executed in 1 msec}
      2012-11-16 16:48:39,626-6922206 [http-8080-9] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
      AND `type`='U' {executed in 0 msec}
      2012-11-16 16:48:39,627-6922207 [http-8080-9] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='273c4aab-e844-42d1-8c5a-2063ca535bba'
      AND `type`='U' {executed in 0 msec}
      2012-11-16 16:48:39,628-6922208 [http-8080-9] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
      FROM roles WHERE roles.id IN ('8a7ab076-822b-4053-9f7a-8fe4ddd9ff31') {executed in 1 msec}
      2012-11-16 16:48:39,629-6922209 [http-8080-9] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
      AND `type`='R' {executed in 1 msec}
      2012-11-16 16:48:39,630-6922210 [http-8080-9] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
      AND `type`='R' {executed in 1 msec}
      2012-11-16 16:48:39,630-6922210 [http-8080-9] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
      AND `type`='R' {executed in 0 msec}
      2012-11-16 16:48:39,631-6922211 [http-8080-9] INFO jdbc.sqltiming - SELECT groups.name,groups.active,groups.description,groups.type,groups.created_by,groups.created_on,groups.realm_id,groups.modified_on,groups.id,groups.modified_by,groups.display
      FROM groups WHERE groups.id IN ('2a6fd615-07c0-4420-b6e5-524ac0360ccf','4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59')
      {executed in 1 msec}
      2012-11-16 16:48:39,632-6922212 [http-8080-9] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
      AND `type`='G' {executed in 1 msec}
      2012-11-16 16:48:39,633-6922213 [http-8080-9] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
      AND `type`='G' {executed in 1 msec}
      2012-11-16 16:48:39,633-6922213 [http-8080-9] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='2a6fd615-07c0-4420-b6e5-524ac0360ccf'
      AND `type`='G' {executed in 0 msec}
      2012-11-16 16:48:39,634-6922214 [http-8080-9] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
      FROM roles WHERE roles.id IN ('8a7ab076-822b-4053-9f7a-8fe4ddd9ff31') {executed in 0 msec}
      2012-11-16 16:48:39,636-6922216 [http-8080-9] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
      AND `type`='R' {executed in 2 msec}
      2012-11-16 16:48:39,636-6922216 [http-8080-9] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
      AND `type`='R' {executed in 0 msec}
      2012-11-16 16:48:39,637-6922217 [http-8080-9] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='8a7ab076-822b-4053-9f7a-8fe4ddd9ff31'
      AND `type`='R' {executed in 1 msec}
      2012-11-16 16:48:39,638-6922218 [http-8080-9] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
      AND `type`='G' {executed in 1 msec}
      2012-11-16 16:48:39,638-6922218 [http-8080-9] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
      AND `type`='G' {executed in 0 msec}
      2012-11-16 16:48:39,639-6922219 [http-8080-9] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='4cdb43c1-bf60-4a59-8cdb-43c1bf60ea59'
      AND `type`='G' {executed in 0 msec}
      2012-11-16 16:48:39,640-6922220 [http-8080-9] INFO jdbc.sqltiming - SELECT roles.name,roles.active,roles.description,roles.type,roles.created_by,roles.created_on,roles.realm_id,roles.modified_on,roles.id,roles.modified_by,roles.display
      FROM roles WHERE roles.id IN ('183219bc-0a71-4e4d-9232-dafc1fb09c1f') {executed in 1 msec}
      2012-11-16 16:48:39,641-6922221 [http-8080-9] INFO jdbc.sqltiming - SELECT `permission` from `assigned_permissions` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
      AND `type`='R' {executed in 1 msec}
      2012-11-16 16:48:39,641-6922221 [http-8080-9] INFO jdbc.sqltiming - SELECT `role` FROM `assigned_roles` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
      AND `type`='R' {executed in 0 msec}
      2012-11-16 16:48:39,642-6922222 [http-8080-9] INFO jdbc.sqltiming - SELECT `group` FROM `assigned_members` WHERE `principal`='183219bc-0a71-4e4d-9232-dafc1fb09c1f'
      AND `type`='R' {executed in 0 msec}
      2012-11-16 16:48:39,643-6922223 [http-8080-9] INFO jdbc.sqltiming - SELECT permissions.name,permissions.active,permissions.data,permissions.description,permissions.type,permissions.created_by,permissions.created_on,permissions.realm_id,permissions.modified_on,permissions.id,permissions.modified_by
      FROM permissions WHERE permissions.id IN ('b59fa344-7ae0-47ec-a5a3-dd8e51caac9d','04518081-0906-4c0e-8fb4-e279b50b4829')
      {executed in 1 msec}
      2012-11-16 16:48:39,643-6922223 [http-8080-9] INFO com.thesearchagency.saas.core.services.security.manager.TSASecurityManager - matching 'SAPI:execute:com.thesearchagency.sapi.services.order.OrderService.getOrders'.matches('.:.:.*') -> true
      2012-11-16 16:48:39,644-6922224 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- Beginning request conversion ----------
      2012-11-16 16:48:39,644-6922224 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found security context for 273c4aab-e844-42d1-8c5a-2063ca535bba
      2012-11-16 16:48:39,644-6922224 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Found tokenized security context: (token 4405114222613849:[e042e3b8-b281-4851-a76d-acfabb994dec, 273c4aab-e844-42d1-8c5a-2063ca535bba]:{realm=com.reseller1}

      )
      2012-11-16 16:48:39,644-6922224 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - ------------------- End request conversion ----------
      2012-11-16 16:48:39,644-6922224 [http-8080-9] DEBUG com.thesearchagency.sapi.jaxrs.providers.JAXRSContextProvider - Getting request context for 273c4aab-e844-42d1-8c5a-2063ca535bba in realm com.reseller1
      2012-11-16 16:48:39,644-6922224 [http-8080-9] DEBUG com.thesearchagency.util.PropertiesPropertySetFactory - Property set for settings/com.reseller1.properties is {}
      2012-11-16 16:48:39,656-6922236 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex - Search returned 11 results
      2012-11-16 16:48:39,657-6922237 [http-8080-9] DEBUG com.thesearchagency.saas.core.services.search.internal.ElasticSearchIndex - 10 matches have been identified

        Attachments

          Activity

            People

            • Assignee:
              todd.orr Todd Orr (Inactive)
              Reporter:
              jeff.brown Jeff Brown (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: