2012-02-25 06:35:21,326 INFO  [com.thesearchagency.optus.service.sitegeneration.binding.SiteGenerationServiceWSImpl] (http-0.0.0.0-8443-2) SGS: DeploySiteRequest received
2012-02-25 06:35:21,328 WARN  [com.thesearchagency.optus.service.sitegeneration.binding.SiteGenerationServiceWSImpl] (http-0.0.0.0-8443-2) Queueing DeploySiteRequest
2012-02-25 06:35:21,329 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:35:21,329 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:35:21,339 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:35:21,339 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:35:21,346 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:35:21,346 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:35:21,349 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:35:21,349 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:35:21,351 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:35:21,351 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:35:21,354 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:35:21,354 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:35:21,356 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (http-0.0.0.0-8443-2) Executing prepared SQL query
2012-02-25 06:35:21,356 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:35:21,358 INFO  [com.thesearchagency.smb.service.site.binding.SiteServiceEJB] (http-0.0.0.0-8443-2) Inside queueRequest()
2012-02-25 06:35:21,358 INFO  [com.thesearchagency.smb.service.site.component.SiteServiceBD] (http-0.0.0.0-8443-2) Inside queueRequest()
2012-02-25 06:35:21,379 INFO  [com.thesearchagency.smb.service.site.mdb.SiteServiceRequestMDB] (WorkManager(2)-96) Processing Inbound SiteServiceRequest Message
2012-02-25 06:35:21,381 INFO  [com.thesearchagency.smb.service.site.component.SiteServiceBD] (WorkManager(2)-96) Inside generateSite()
2012-02-25 06:35:21,382 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-96) Executing prepared SQL query
2012-02-25 06:35:21,382 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-96) 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:35:21,384 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-96) Executing prepared SQL query
2012-02-25 06:35:21,384 DEBUG [org.springframework.jdbc.core.JdbcTemplate] (WorkManager(2)-96) 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=?]