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

CustomerDataService: getDomainName is unable to retrieve domain name associated with a customer

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.1.1
    • Fix Version/s: 1.1.1
    • Component/s: None
    • Labels:
      None
    • Environment:

      SMB Server: optus-qa-smb1 (50.57.178.209)

      SMB Services Build: optus-ear-1.1.1-SNAPSHOT-p78-t20120215-144058-CI.ear

      Description

      Pre-Requisites:

      1. Deployed a site for customer "customer1".

      2. The deployment is successful and can see the site structure at /var/www/html/customer-sites/c/u/www.cust1-qa-domain.com on hosting server.

      Steps

      1. Execute getDomainName method of CustomerDataService (CDS) for above deployed customer "customer1"

      Expected Result:

      The domain name associated with the customer must be successfully returned.

      Actual Result:

      The method fails to return the domain name associated with the customer. Observed following error in the log file.

      07:39:21,563 INFO [CustomerDataService] Request received for domain name

      07:39:21,564 DEBUG [JdbcTemplate] Executing prepared SQL query

      07:39:21,564 DEBUG [JdbcTemplate] Executing prepared SQL statement [select customerId,hostingServerID,domain,dateAssigned,status from hostingAssignments where customerId = ? ]

      07:39:21,565 ERROR [HostingServiceBD] Error reading hosting record for : customer1

      com.thesearchagency.core.smb.dao.hosting.HostingRecordException: No HostingRecord exists for customerID customer1.

      Note:

      The BusinessLocations and BusinessAreas are successfully returned for the same customer.

        Attachments

          Activity

            People

            • Assignee:
              kyle.bober kyle.bober
              Reporter:
              gurpreet.singh Gurpreet Singh
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: