18:37:25,580 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 35 Address: /Optus-SG/SiteGenerationService Encoding: UTF-8 Content-Type: text/xml;charset=UTF-8 Headers: {content-type=[text/xml;charset=UTF-8], host=[localhost:9991], Content-Length=[3326], SOAPAction=["http://www.thesearchagency.com/SiteGenerationService/deploySite"], user-agent=[Jakarta Commons-HttpClient/3.1], accept-encoding=[gzip,deflate], Content-Type=[text/xml;charset=UTF-8]} Payload:
template14 1
CK Testing 005-0000000006 www.cust3-qa-domain.com www.customer-it.com 2000084 NSW3107 1 QA Branch test line1 test line2 test line3 test line4 Sydney NSW AU 2154 true NSW3107 1 011 (444) 555-6666 011 (444) 555-7777 qacampan3 2000084 NSW3107 1 We make house calls Test! Call us now! The QA people 1 1 qatesters@theqapeople.com -------------------------------------- 18:37:25,586 INFO [SiteGenerationServiceWSImpl] SGS: DeploySiteRequest received 18:37:25,586 INFO [AuditorServiceBD] Entering the audit method... 18:37:25,586 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,586 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:37:25,588 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,588 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:37:25,589 DEBUG [JdbcTemplate] Executing prepared SQL update 18:37:25,589 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:37:25,619 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:37:25,620 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:37:25,627 DEBUG [JdbcTemplate] Executing prepared SQL update 18:37:25,627 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:37:25,641 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:37:25,642 INFO [AuditorServiceBD] Exiting the audit method... 18:37:25,645 WARN [SiteGenerationServiceWSImpl] Queueing DeploySiteRequest 18:37:25,645 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,645 DEBUG [JdbcTemplate] 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=?] 18:37:25,647 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,647 DEBUG [JdbcTemplate] Executing prepared SQL statement [select blim.systemBusinessLocationID from optus.businessLocationIDMap blim where blim.businessLocationID=?] 18:37:25,649 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,649 DEBUG [JdbcTemplate] 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=?] 18:37:25,651 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,651 DEBUG [JdbcTemplate] Executing prepared SQL statement [select blim.systemBusinessLocationID from optus.businessLocationIDMap blim where blim.businessLocationID=?] 18:37:25,652 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,652 DEBUG [JdbcTemplate] 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=?] 18:37:25,653 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,653 DEBUG [JdbcTemplate] 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=?] 18:37:25,655 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,655 DEBUG [JdbcTemplate] Executing prepared SQL statement [select blim.systemBusinessLocationID from optus.businessLocationIDMap blim where blim.businessLocationID=?] 18:37:25,656 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,656 DEBUG [JdbcTemplate] 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=?] 18:37:25,657 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,657 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM optus.siteGenerationRegenFlags WHERE customerID=?] 18:37:25,658 INFO [SiteServiceBD] Inside queueRequest() 18:37:25,718 INFO [AuditorServiceBD] Entering the audit method... 18:37:25,718 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,718 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:37:25,721 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,721 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:37:25,722 DEBUG [JdbcTemplate] Executing prepared SQL update 18:37:25,722 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:37:25,724 INFO [SiteServiceRequestMDB] Processing Inbound SiteServiceRequest Message 18:37:25,729 INFO [SiteServiceBD] Inside generateSite() 18:37:25,729 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,729 DEBUG [JdbcTemplate] 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=?] 18:37:25,731 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,731 DEBUG [JdbcTemplate] 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=?] 18:37:25,732 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,732 DEBUG [JdbcTemplate] 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=?] 18:37:25,733 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,733 DEBUG [JdbcTemplate] 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=?] 18:37:25,734 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,734 DEBUG [JdbcTemplate] 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=?] 18:37:25,734 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,734 DEBUG [JdbcTemplate] 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=?] 18:37:25,735 INFO [SiteServiceBD] -=-=-=-=-=-=-= Starting to Process Site Context =-=-=-=-=-=-=-=- 18:37:25,735 INFO [RequestAuditorCP] Entering process(..) 18:37:25,735 INFO [RequestAuditorCP] Exiting process(..) 18:37:25,735 INFO [CustomizationImporterCP] Entering process(..) , Request: com.thesearchagency.core.smb.domain.sitegeneration.messages.DeploySiteRequest@31770d13 , CustomizationService : com.thesearchagency.core.smb.service.customization.component.CustomizationServiceBD@531fbd30 18:37:25,735 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,735 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where customerBpId=?] 18:37:25,740 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,740 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from site where entityID = ? and defaultFlag = ? ] 18:37:25,742 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,742 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from page where entityID = ? and defaultFlag = ? ] 18:37:25,743 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,743 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,744 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,744 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,744 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,744 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,745 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,745 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,746 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,746 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,747 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,747 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,747 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,748 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,748 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,748 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,749 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,749 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,750 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,750 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,751 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,751 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,752 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,752 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,752 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,752 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,753 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,753 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,754 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,754 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,755 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,755 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,756 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,756 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,757 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,757 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,758 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,758 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,758 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,759 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,759 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,759 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,761 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,761 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,762 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,762 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,762 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,762 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,763 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,763 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,772 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,772 DEBUG [JdbcTemplate] 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=?] 18:37:25,781 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,781 DEBUG [JdbcTemplate] 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=?] 18:37:25,782 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,782 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id, customerBpId, dateAssigned, requestData from contentEntityMap where customerBpId=?] 18:37:25,783 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,783 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from site where entityID = ? and defaultFlag = ? ] 18:37:25,784 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,784 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from siteField INNER JOIN (fieldType) ON (fieldType.id = siteField.fieldTypeID) where entityID = ? ] 18:37:25,784 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,784 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from page where entityID = ? and defaultFlag = ? ] 18:37:25,786 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,786 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageField INNER JOIN (fieldType) ON (fieldType.id = pageField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and advertID = ? ] 18:37:25,787 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,787 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,788 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,788 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,788 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,788 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,790 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,790 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,790 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:37:25,791 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:37:25,797 DEBUG [JdbcTemplate] Executing prepared SQL update 18:37:25,797 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:37:25,799 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,799 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageField INNER JOIN (fieldType) ON (fieldType.id = pageField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and advertID = ? ] 18:37:25,801 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,801 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,802 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,802 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,803 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,803 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,803 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,804 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,804 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:37:25,804 INFO [AuditorServiceBD] Exiting the audit method... 18:37:25,805 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 35 Encoding: UTF-8 Content-Type: text/xml Headers: {} Payload:
template141
queued -------------------------------------- 18:37:25,807 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,807 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageField INNER JOIN (fieldType) ON (fieldType.id = pageField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and advertID = ? ] 18:37:25,808 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,808 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,808 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,808 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,809 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,809 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,810 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,810 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,811 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,811 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageField INNER JOIN (fieldType) ON (fieldType.id = pageField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and advertID = ? ] 18:37:25,811 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,811 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,812 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,812 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,813 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,813 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,814 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,814 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,814 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,814 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageField INNER JOIN (fieldType) ON (fieldType.id = pageField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and advertID = ? ] 18:37:25,815 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,815 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopy where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and isDefault = ? ] 18:37:25,816 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,816 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,817 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,817 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,817 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,817 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from pageAdCopyField INNER JOIN (fieldType) ON (fieldType.id = pageAdCopyField.fieldTypeID) where entityID = ? and businessFunctionID = ? and locationID = ? and advertID = ? and pageType = ? and adCopyIndex = ? ] 18:37:25,818 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,818 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,819 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,819 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,821 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,821 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,822 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,822 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,822 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,822 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,823 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,823 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,824 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,824 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,825 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,825 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,826 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,826 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,827 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,827 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,827 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,827 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,828 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,828 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,829 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,829 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,830 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,830 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,831 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,831 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,832 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,832 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,832 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,832 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,833 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,833 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,834 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,834 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraphField INNER JOIN (fieldType) ON (fieldType.id = paragraphField.fieldTypeID) where entityID = ? and pageType = ? and businessFunctionID = ? and locationID = ? and paragraphIndex = ? ] 18:37:25,835 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,835 DEBUG [JdbcTemplate] Executing prepared SQL statement [select * from paragraph where entityID = ? and businessFunctionID = ? and locationID = ? and pageType = ? and defaultFlag = ?] 18:37:25,838 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,838 DEBUG [JdbcTemplate] 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=?] 18:37:25,840 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,841 DEBUG [JdbcTemplate] 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=?] 18:37:25,841 INFO [CustomizationImporterCP] Retrieved the Default and Customized SiteSO objects and set them on the CoreSiteContext object for CustomerId [CK Testing 005-0000000006] 18:37:25,841 INFO [CustomizationImporterCP] Redeploy Site request for CustomerId [CK Testing 005-0000000006] 18:37:25,841 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_HOME 18:37:25,841 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_PRIVACY_POLICY 18:37:25,841 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_SEM 18:37:25,841 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_SEO 18:37:25,842 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_TERMS_AND_AGREEMENTS 18:37:25,842 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_HOME 18:37:25,842 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_PRIVACY_POLICY 18:37:25,842 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_SEM 18:37:25,842 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_SEO 18:37:25,842 INFO [CustomizationImporterCP] Generated uniquePage key :: 2000084_10000_TERMS_AND_AGREEMENTS 18:37:25,842 INFO [CustomizationImporterCP] Exiting process(..) 18:37:25,842 INFO [CustomerSiteImporterCP] Entering CustomerSiteImporter process() 18:37:25,845 INFO [ContentRepositoryServiceImpl] Inside ContentRepositoryServiceImpl Constructor : EntityId [0] BusinessTypeID [0] BusinessLocationID [0] 18:37:25,846 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,846 DEBUG [JdbcTemplate] Executing prepared SQL statement [select id from contentEntityMap where customerBpId=?] 18:37:25,846 INFO [TxConnectionManager] throwable from unregister connection java.lang.IllegalStateException: Trying to return an unknown connection2! org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@6fcd3c53 at org.jboss.resource.connectionmanager.CachedConnectionManager.unregisterConnection(CachedConnectionManager.java:330) at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionClosed(TxConnectionManager.java:720) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.closeHandle(BaseWrapperManagedConnection.java:362) at org.jboss.resource.adapter.jdbc.WrappedConnection.close(WrappedConnection.java:155) at org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:333) at org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:294) at org.springframework.jdbc.datasource.DataSourceUtils$ConnectionSynchronization.beforeCompletion(DataSourceUtils.java:452) at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCompletion(TransactionSynchronizationUtils.java:106) at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCompletion(AbstractPlatformTransactionManager.java:940) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:738) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:374) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy780.findEntityId(Unknown Source) at com.thesearchagency.smb.service.site.component.contextprocessing.CustomerSiteImporterCP.process(CustomerSiteImporterCP.java:53) at com.thesearchagency.smb.service.site.component.SiteServiceBD.generateSite(SiteServiceBD.java:188) at com.thesearchagency.smb.service.site.mdb.SiteServiceRequestMDB.onMessage(SiteServiceRequestMDB.java:54) at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59) at sun.reflect.GeneratedMethodAccessor420.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1940642654.invoke(InvocationContextInterceptor_z_fillMethod_1940642654.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1940642654.invoke(InvocationContextInterceptor_z_setup_1940642654.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:194) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:80) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.mdb.MessagingContainer.localInvoke(MessagingContainer.java:282) at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.delivery(MessageInflowLocalProxy.java:270) at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.invoke(MessageInflowLocalProxy.java:140) at $Proxy432.onMessage(Unknown Source) at org.jboss.resource.adapter.jms.inflow.JmsServerSession.onMessage(JmsServerSession.java:178) at org.jboss.jms.client.container.ClientConsumer.callOnMessageStatic(ClientConsumer.java:160) at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:831) at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect_z_handleRun_1940642654.invoke(SessionAspect_z_handleRun_1940642654.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:170) at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:86) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java) at org.jboss.jms.client.JBossSession.run(JBossSession.java:199) at org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:234) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 18:37:25,847 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,847 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizable_entity WHERE entityId = ? AND type = ? ] 18:37:25,848 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,848 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM static_field WHERE entity_id = ?] 18:37:25,849 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,849 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizable_field WHERE entity_id = ?] 18:37:25,849 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,849 DEBUG [JdbcTemplate] Executing prepared SQL statement [SELECT * FROM customizable_content_field WHERE entity_id = ?] 18:37:25,850 INFO [CustomerSiteImporterCP] Vanity URL is Enabled for EntityId [271] 18:37:25,850 ERROR [SiteServiceBD] Process during context processing step : class com.thesearchagency.smb.service.site.component.contextprocessing.CustomerSiteImporterCP java.lang.StringIndexOutOfBoundsException: String index out of range: 36 at java.lang.String.charAt(String.java:686) at java.util.regex.Matcher.appendReplacement(Matcher.java:711) at java.util.regex.Matcher.replaceAll(Matcher.java:813) at java.lang.String.replaceAll(String.java:2189) at com.thesearchagency.smb.service.site.component.contextprocessing.CustomerSiteImporterCP.formatVanityLink(CustomerSiteImporterCP.java:189) at com.thesearchagency.smb.service.site.component.contextprocessing.CustomerSiteImporterCP.updatePageContext(CustomerSiteImporterCP.java:177) at com.thesearchagency.smb.service.site.component.contextprocessing.CustomerSiteImporterCP.process(CustomerSiteImporterCP.java:64) at com.thesearchagency.smb.service.site.component.SiteServiceBD.generateSite(SiteServiceBD.java:188) at com.thesearchagency.smb.service.site.mdb.SiteServiceRequestMDB.onMessage(SiteServiceRequestMDB.java:54) at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111) at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73) at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59) at sun.reflect.GeneratedMethodAccessor420.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1940642654.invoke(InvocationContextInterceptor_z_fillMethod_1940642654.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88) at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1940642654.invoke(InvocationContextInterceptor_z_setup_1940642654.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126) at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:194) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:80) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.ejb3.mdb.MessagingContainer.localInvoke(MessagingContainer.java:282) at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.delivery(MessageInflowLocalProxy.java:270) at org.jboss.ejb3.mdb.inflow.MessageInflowLocalProxy.invoke(MessageInflowLocalProxy.java:140) at $Proxy432.onMessage(Unknown Source) at org.jboss.resource.adapter.jms.inflow.JmsServerSession.onMessage(JmsServerSession.java:178) at org.jboss.jms.client.container.ClientConsumer.callOnMessageStatic(ClientConsumer.java:160) at org.jboss.jms.client.container.SessionAspect.handleRun(SessionAspect.java:831) at org.jboss.aop.advice.org.jboss.jms.client.container.SessionAspect_z_handleRun_1940642654.invoke(SessionAspect_z_handleRun_1940642654.java) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:170) at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:86) at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102) at org.jboss.jms.client.delegate.ClientSessionDelegate.run(ClientSessionDelegate.java) at org.jboss.jms.client.JBossSession.run(JBossSession.java:199) at org.jboss.resource.adapter.jms.inflow.JmsServerSession.run(JmsServerSession.java:234) at org.jboss.resource.work.WorkWrapper.execute(WorkWrapper.java:205) at org.jboss.util.threadpool.BasicTaskWrapper.run(BasicTaskWrapper.java:260) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 18:37:25,851 INFO [SiteServiceBD] -=-=-=-=-=-=-= Finished Processing Site Context =-=-=-=-=-=-=-=- 18:37:25,852 INFO [AuditorServiceBD] Entering the audit method... 18:37:25,852 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,852 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?] 18:37:25,853 DEBUG [JdbcTemplate] Executing prepared SQL query 18:37:25,853 DEBUG [JdbcTemplate] Executing prepared SQL statement [select actionID, description from action where description = ?] 18:37:25,854 DEBUG [JdbcTemplate] Executing prepared SQL update 18:37:25,854 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into event (sourceID, actionID, customerID, internalRequestID, externalRequestID, eventTime, status) values (?,?,?,?,?,?,?)] 18:37:25,855 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:37:25,855 DEBUG [JdbcTemplate] Executing SQL query [select last_insert_id()] 18:37:25,867 DEBUG [JdbcTemplate] Executing prepared SQL update 18:37:25,867 DEBUG [JdbcTemplate] Executing prepared SQL statement [insert into context (eventID, context) values (?,?)] 18:37:25,868 DEBUG [JdbcTemplate] SQL update affected 1 rows 18:37:25,868 INFO [AuditorServiceBD] Exiting the audit method... 18:37:25,868 INFO [SiteServiceBD] Inside queueResponse() 18:37:25,868 INFO [SiteServiceBD] Site Deployment Status: template14Information: String index out of range: 36 18:37:25,885 INFO [SiteServiceResponseMDB] Processing Outbound SiteServiceResponse Message 18:37:25,888 INFO [CallbackEventAdapterOptus] Sending PublishDeployStatusReq 18:37:25,893 INFO [LoggingInInterceptor] Outbound Message --------------------------- ID: 36 Address: http://50.57.178.209:8080/Optus-CB/OptusCallbackService Encoding: UTF-8 Content-Type: text/xml Headers: {SOAPAction=[""], Accept=[*/*]} Payload:
template141
site_generationCK Testing 005-0000000006return_codefailureInformation: String index out of range: 36 -------------------------------------- 18:37:25,897 INFO [DeployCallbackImpl] Executing operation publishDeployResult 18:37:25,898 INFO [STDOUT] com.thesearchagency.optus.service.callback.service.PublishDeployResultRequest@7f7ae0ed 18:37:25,900 INFO [LoggingInInterceptor] Inbound Message ---------------------------- ID: 36 Response-Code: 200 Encoding: UTF-8 Content-Type: text/xml;charset=UTF-8 Headers: {content-type=[text/xml;charset=UTF-8], Date=[Wed, 02 May 2012 18:37:25 GMT], Content-Length=[417], X-Powered-By=[Servlet 2.5; JBoss-5.0/JBossWeb-2.1], Server=[Apache-Coyote/1.1]} Payload: 5432112345successSome Result Success String... -------------------------------------- 18:37:25,902 DEBUG [CallbackEventAdapterOptus] Received PublishDeployStatusResp. Indicated result: COMPLETED 18:37:25,902 DEBUG [CallbackEventAdapterOptus] Message : String index out of range: 36 18:37:32,850 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : START TIMEOUT 18:37:32,852 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : ENABLED 18:37:32,852 DEBUG [JdbcTemplate] Executing SQL query [select * from callbackEvent] 18:37:32,905 DEBUG [CallbackEventEJBTimer] CallbackEventTimer : END TIMEOUT