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

Error while requesting Business Category and Business Location Service

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: sprint 14: 12-05-2012
    • Fix Version/s: Web Pages Release
    • Labels:
      None
    • Environment:

      Build Details
      MMS Build : smb-ear-1.5.0-SNAPSHOT-p715-t20121205-135843-CI.ear
      Bidmanager Build : tsa-build-bidmgr-2012-11-29-p734-r2803f1af60906a4cace7dfcfcdc1ecd69613e2b0

    • Sprint:
      Sprint 15

      Description

      While executing Business Category Service and Business Location Service, I am getting following error

      Sample Log :

      org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [SELECT * FROM site_generation.customerBAreaBLocationPairs where customerID=?]; Illegal operation on empty result set.; nested exception is java.sql.SQLException: Illegal operation on empty result set.
      at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)

      For detailed Log Please find attachment.

      When I check with the database the table is empty.

      mysql> select * from customerBAreaBLocationPairs ;
      Empty set (0.00 sec)

        Attachments

        1. BussAreaService.txt
          19 kB
          Anil Kumar Halmadgi
        2. BussLocationService.txt
          20 kB
          Anil Kumar Halmadgi

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              anil.kumar Anil Kumar Halmadgi
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: