2012-02-25 06:29:37,563 INFO  [com.thesearchagency.optus.service.sitegeneration.binding.SiteGenerationServiceWSImpl] (http-0.0.0.0-8443-2) SGS: DeploySiteRequest received
2012-02-25 06:29:37,566 WARN  [com.thesearchagency.optus.service.sitegeneration.binding.SiteGenerationServiceWSImpl] (http-0.0.0.0-8443-2) Queueing DeploySiteRequest
2012-02-25 06:29:37,567 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:29:37,567 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL statement [select blim.systemBusinessLocationID from optus.businessLocationIDMap blim where blim.businessLocationID=?]
2012-02-25 06:29:37,575 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:29:37,575 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
2012-02-25 06:29:37,581 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:29:37,581 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL statement [select blim.systemBusinessLocationID from optus.businessLocationIDMap blim where blim.businessLocationID=?]
2012-02-25 06:29:37,585 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:29:37,585 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
2012-02-25 06:29:37,586 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:29:37,587 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL statement [select blim.systemBusinessLocationID from optus.businessLocationIDMap blim where blim.businessLocationID=?]
2012-02-25 06:29:37,589 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:29:37,589 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
2012-02-25 06:29:37,591 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:29:37,591 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL statement [SELECT * FROM optus.siteGenerationRegenFlags WHERE customerID=?]
2012-02-25 06:29:37,592 INFO  [com.thesearchagency.smb.service.site.binding.SiteServiceEJB] (http-0.0.0.0-8443-2) Inside queueRequest()
2012-02-25 06:29:37,592 INFO  [com.thesearchagency.smb.service.site.component.SiteServiceBD] (http-0.0.0.0-8443-2) Inside queueRequest()
2012-02-25 06:29:37,622 INFO  [com.thesearchagency.smb.service.site.mdb.SiteServiceRequestMDB] (WorkManager(2)-94) Processing Inbound SiteServiceRequest Message
2012-02-25 06:29:37,624 INFO  [com.thesearchagency.smb.service.site.component.SiteServiceBD] (WorkManager(2)-94) Inside generateSite()
2012-02-25 06:29:37,624 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-94) Executing prepared SQL query
2012-02-25 06:29:37,624 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-94) Executing prepared SQL statement [select bl.id, bl.description, bl.shortDescription, bl.status, bl.useSEDefinedTargets, bl.usePointRadiusTargets, bl.isSellable, blt.type, blm.parentBusinessLocationID from businessLocations bl left join businessLocationMap blm on blm.childBusinessLocationID = bl.id join businessLocationTypes blt on blt.id = bl.businessLocationTypeID where bl.id=?]
2012-02-25 06:29:37,627 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-94) Executing prepared SQL query
2012-02-25 06:29:37,627 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-94) Executing prepared SQL statement [select ba.id, ba.description, ba.status, bcam.businessCategoryID from businessAreas ba left join businessCategoryAreaMap bcam on bcam.businessAreaID=ba.id where ba.id=?]