Details
- 
    Type:Bug 
- 
    Status: Open
- 
    Priority:Major 
- 
    Resolution: Unresolved
- 
    Affects Version/s: sprint 14: 12-05-2012
- 
    Fix Version/s: Web Pages Release
- 
    Component/s: Business Category Service, Business Location Service
- 
    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)